Hacker News Reader

Comment by catmanjan | Hacker News Reader

Interesting, what is considered newsql? Postgres?

I am not a fan of this buzzword (and indeed buzzwords in general, the comment above was intending to make fun of HSBC IT for even failing at the buzzword game), but the notion of NewSQL was roughly to keep the relational model and consistency guarantees of traditional SQL databases, but also have horizontal scalability in line with NoSQL databases. DBs like VoltDB and Spanner come to mind as examples -- here are two relevant blog posts from those teams:

VoltDB: https://www.voltdb.com/blog/2016/09/nosql-vs-newsql-whats-di...

Spanner: https://cloud.google.com/blog/products/gcp/from-nosql-to-new...

No."Horizontally-scalable" SQL like CockroachDB, TiDB, Google's Spanner or YugabyteDB are examples of NewSQL, Postgres would be "OldSQL" if you will.

PostgreSQL still the best sql though :-)

SQLite is the hottest new thing on the block.

Huh? SQLite is nearly 20 years old, and is only intended for small scale use.

It was intended as a joke in context, but I believe SQLite is far more capable than most will give it credit for. This is especially true for applications which you only ever intend to run on a single logical machine. But, even for those applications requiring multiple nodes, it can still be a powerful tool if you assume clustering & replication duty in your application logic.

For any use case, SQLite is one of the best ways to persist structured data to local disk.

Oh, I agree about its utility, and use it myself. It seems like a different category of tool than the other DBs under discussion, though.

SQLite is incredible, especially for embedded applications. It's one of those perfectly-scoped tiny pieces of software that consistently makes my heart sing.

I try to use sqlite for all projects until i cant.

Its a little scary how much it can actually handle, and how lazy and sub optimal it is to reach for a "real" sql server before you need it.

Having the database as a simple file right next to yoyr application is incredibly convenient not to mention how brain dead things like backups are to grok.

Tidb, cockroachdb maybe?

Reply on news.ycombinator.com