2 ms·
SQLite is not uncommon in web applications. It isn't just found in phone apps and OSs. It works pretty well for tasks that are primarily read heavy and is a lo
by dspillett 5y ago
SQLite is not uncommon in web applications. It isn't just found in phone apps and OSs.
It works pretty well for tasks that are primarily read heavy and is a lot lighter doing so than the common non-nosql alternatives (SQL Server, postgres, mariadb/mysql, ...). For applications that need good performance in the presence of much writing, particularly where concurrent writes might be desirable, it is far less ideal though.
- jrochkind1 5y agoI think you can just just refer to "non-nosql" as... sql! :)
- dspillett 5y ago"nosql" tends to mean more than simply not SQL. Often not any sort of relational structure and related querying methods, for instance, so "not nosql" is not the same set of things as "SQL".
- jrochkind1 5y agoAnd yet notably all the examples you listed are sql...
- dspillett 5y agoAnd yet, you know that isn't the point and are just trying to have the last word. SQL is not the only structured query language and SQL-queried databases are not the only relational databases. It just happens that the subset of database services that are not nosql and commonly “compete” with sqlite as a relational database mostly happen to use some variant for SQL.