Hacker News new | ask | show | jobs
by cyclotron3k 1087 days ago
I've heard it said that the best no-sql database is Postgres
2 comments

The real point of NoSQL is to enable horizontal scaling, which is probably irrelevant to the author's use case.
Id say the point of nosql is rather "the right tool for the job".

You can use an SQL db engine as a kv-store, but you can probably make a more efficient kv-store if you do not have the SQL constraints.

(Oth SQL engines are pretty efficient for lots of use cases these days)

Another example where SQL may not be the right choice is time series or graph DBs.

Postgres might even be a more efficient KV store than Mongo, just not as scalable beyond a single machine.
i.e. the best no-sql is sql!