3 ms·
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-----
by Izkata 7y ago
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
- bane 7y agoWhy, 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?