sleepycat db VS MySQL or postgres
feld at feld.me
Tue Jul 2 11:55:40 UTC 2013
On Tue, 02 Jul 2013 05:45:47 -0500, Ivan Voras <ivoras at freebsd.org> wrote:
> Well, this is essentially a bikeshed thread... so why not chip in
I disagree; all of these databases have distinctly different uses.
MySQL/PostgreSQL: pick your poison. Relational databases. Will you have
multiple users connecting to the database? Will there be lots of updates
to the data? These are what you want. If you care about data integrity,
I'd choose Postgres.
SQLite: Do you want a relational database without needing a daemon to be
running and will only have a single user/process accessing the database at
one time? This is what you want.
NoSQL: Do you want to dabble with the mess that is NoSQL so you can build
your "cloud"? Don't care if other nodes aren't guaranteed to get the
latest copy of the data? This is what you want.
SleepyCat/BerkleyDB: Is your data WORM? (Write Once Read Many) If so, this
is *ABSOLUTELY* what you want.
If twitter was built upon a WORM database instead of MySQL they could host
the entirety of twitter on a handful of servers instead of the gross
MySQL+Cassandra mess they're fighting with today.
More information about the freebsd-questions