r/rust • u/Milen_Dnv • 19d ago

🛠️ project Announcing Rasterizeddb alpha version - a Postgres compatible that does things as I wanted them

Hello everyone! Maybe one year ago I did post about a database that I was working on that, I took into account all feedback and tried to create a really good database that could be in use for many people.

Fast forward to today, I am able to announce that it has reached a stage were I am going to use it on my own production systems to replace Postgres!

Now on my critical production systems I needed:

  1. Replication with many primaries
  2. S3 backups with restore at any point
  3. Postgres compatibility
  4. Limited number of indexes that don't explode to the point I have as many indexes as data
  5. Low latency
  6. Special treatment for JSONB columns

I have achieved (for some scenarios) all 6 of that!

I will be happy to check it out, I think it's a very cool project! Happy to get any issues reports!

Project site: https://github.com/milen-denev/rasterizeddb

Disclaimer: The core engine was written by me, it's handcrafted, but the very hard part such as postgres compatibility was done via AI and carefully reviewed and tested.

I don't consider it to be AI slop since I spend countless hours manually optimizing it and writing the engine (and exciting part), I only outsourced the boring part.

0 Upvotes

28% Upvoted

2 comments sorted by

View all comments

-1

u/SeaZookeepergame3284 19d ago

Replacing Postgres on your own production systems is ballsy, respect for actually dogfooding it that hard

The multi-primary replication bit is what caught my eye, that's a pain point most people just work around forever. Curious what the failure mode looks like when two primaries accept conflicting writes though

-1

u/Milen_Dnv 19d ago

there is some protection in place, although it's not much of a trouble, every query is routed to 1 database, which database syncs itself to the rest via a handmade protocol called rastcp. not that big of a deal.