Hacker News new | ask | show | jobs
by Confiks 2766 days ago
I was wondering, quite unrelated to the article, if anyone knows if CockroachDB would be suited for small databases (and comparably modest computing/memory resources). I very much like its distributed properties, but only have a simple table of usernames and corresponding cryptographic material. Is CRDB easy to run and manage?
3 comments

We have clients using CRDB in pretty constrained environments, and they use it primarily because of the easy administration. I think you'll find it easier to use than a MySQL or Postgres, for example.
I would expect your use case would be better suited by use just using postgres. However if you do need to scale to the point where you'd need to distribute your database and take advantage of CRDB's capabilities, it uses the Postgres protocol, so you most likely can just migrate your data and use the same code.
Sqlite would be my first recommendation, unless you need client/server access.
I think the GP's stated need for replication would preclude SQLite unless one's willing to write one's own replication system.
Where's the stated need for replication?
"I very much like its distributed properties"