RubyFlow The Ruby and Rails community linklog

×

The Ruby and Rails community linklog

Made a library? Written a blog post? Found a useful tutorial? Share it with the Ruby community here or just enjoy what everyone else has found!

A new database for Rails

Over the past eight months, I’ve been building BicDB, a Rust-based database with PostgreSQL-compatible interfaces, full-text search, vectors, queues, and more. I relied heavily on AI coding agents (Claude and OpenAI), alongside roughly 1,200 hours of my own time.

It’s now powering our applications, including a search engine with over 2 billion documents. We also switched our Gitlab server to BicDB.

It’s still in beta, but it’s been quite a journey. I’d love to hear what fellow Ruby developers think, especially about using it with Rails.

https://github.com/nikoma/bicdb

Comments

It seems good judging by the documentation, but as a system engineer, i would like to see a side-by-side feaure comparison with PostgreSQL (like: schema/database handling capabilities, HA capabilities, internal/external authentication, transaction-handling, locks, external plugin compatibility, protection from serving same data folder parallel, security in different aspects, etc) along with some writing about data migration from PostgreSQL.

Also, I noticed there is no mention about a configuration file. Parameterising a software purely from command line switches could sound fun first, but operating it could be a nightmare, especially a handover: you have to read all the switches in a not-really-readable format (or you have to format it yourself). And yes, you can ask AI, but if an AI misses to mention just one switch you maybe loose a critical info about the service. A configuration file however is readable for both AI and humans and can be easily carried over to multiple servers. You can also even comment it.

It would be also nice to have a writing about how you plan to run it in production environment? In Docker? It can run natively? Does it support Kubernetes-like environments?

And yeah, I understand this is an ongoing project. But these documentations could either as a foundation for future development (by defining some goals) and a real comparison for people coming from PostgreSQL.

Hi Gabor Garami! Thanks for taking the time to look into BicDB and for the excellent suggestions!

I’ve now added a PostgreSQL feature and operations comparison, a migration guide, production deployment documentation, and TOML configuration support with validation and running-config drift detection.

The documentation also clearly identifies what’s not yet supported or production-qualified.

https://github.com/nikoma/bicdb#coming-from-postgresql

I’d love to hear what you think!

Post a comment

You can use basic HTML markup (e.g. <a>) or Markdown.

As you are not logged in, you will be
directed via GitHub to signup or sign in