PostgreSQL is great also in terms of cluster management for scalability and replication. Futhermore it has great algorithms for server- and session-level caching for performance.
Well it’s a shame but at the same time it’s a strong illustration of why we need to give careful consideration to how sustainable a project is before using it in production apps. If 90% of development is coming from salaried dev’s eating through a pile of VC money and project has no reasonable monetization strategy …
I found the former while looking at datomic and the ideas of event sourcing. Couchdb is interesting having recently just release 2.0
However I think that the database free architecture is a really interesting idea and I would be interested in hearing anymore real world stories of deploying something like that.
I was using CouchDb in my javascript POC implementation of ibgib, because it integrated very nicely with PouchDb on the client side. Both were very nice document storage dbs. CouchDb, being written in Erlang, was actually one of the things that led me to Erlang and ultimately here to Elixir!
I had also previously used eventstore, and it was a very powerful, highly optimized event sourcing back end. I was not savvy enough to get it set up consistently on a Windows server at the time though. Perhaps it is easier now, plus I’m (slightly) more used to linux.
Interestingly, this thread has helped me realize that ibgib’s current approach has properties very similar to a mix of event sourcing, neo4j, IPFS, and “functional” code-as-data. But I digress.
Both CouchDb and EventStore were great tools in my (non-production) experience.
The talks by Greg Young on CQRS are good that’s how I found EventStore but the thought of having infra. type stuff running on windows or depending on Mono I find very unappealing.
From my pov right now, there is only a couple one i would use at work
Postgres is my default for anything Relational. Stable, move fast without breaking thing, quite well.
I have to deal with a tons of Time Series (both for metrics and for market data) so Influx did quite a splash. It is only nearly the only one in that are sadly
For KV, Riak is still rock solid, have great CRDT and works well, with good doc. But you need to read it to have proper conf.
no database? i use quite a lot of ETS, CSV, etc etc
Rethink is on my list of distribute document DB, but to be honest, i still need to find a good one…
Datomic is still around and saying “use me use me” but i still have to have a need for it…