News for hackers. Stuff that matters.

A comment on SQLite Is Serverless. Parent comment

Re:SQLite Is Serverless by Izkata on Sunday January 26, 2020 @08:19PM (#22156127)
The impression given here is that you only use it as a dumb store of data. My experience is that it's more like:

  file-format:<------------------------x------>:DBMS
[ Parent | on HN ]
Re:SQLite Is Serverless by bane on Sunday January 26, 2020 @08:37PM (#22156204)
Why, because it offers SQL support? That just makes it a relational database that supports SQL. MS Access supports SQL.

If you were to draw up a feature list of Oracle, PostgreSQL, MS SQL and SQLite, SQLite would have almost none of the features of any of the actual RDBMSs.

Here's some examples from MS SQL:

- Support to PMEM devices and bypassing OS storage mechanisms for optimal file read/write access

- Availability Groups and synchronous replica pairs

- Users and permissions

- Secure Enclaves

- Certificate management functionality

- BI tools

- Database tuning advisor

- Machine Learning services

- Service Broker

- Replication services

- Analysis Services

- Reporting services

- Notification services

- Integration services

and so on.

Draw up a set of features for JSON files and jq and compare to SQLite. Is it closer to MS SQL or JSON?

[ Parent | on HN ]