I would like to know if SQLite is a DBMS in the strict sense?
(1) By anonymous on 2024-06-20 13:23:57 [link] [source]
I argue with people about this, and try to prove to them that SQLite is not a DBMS, but a file format and a driver that can handle it.
(2) By Gunter Hick (gunter_hick) on 2024-06-20 13:58:44 in reply to 1 [link] [source]
Please give your definiton of DBMS and what you mean by "strict sense".
(3) By Stephan Beal (stephan) on 2024-06-20 14:00:58 in reply to 1 [link] [source]
SQLite is not a DBMS, but a file format and a driver that can handle it.
You've come to the wrong place to argue that particular position ;).
The distinction between "a file format and a driver that can handle it" and a client/server DBMS is meaningless, given that a DBMS server is exactly that: a driver for handling the content one or more files (the exact number being an implementation detail which the client-level code knows nothing at all about). The fact that a client/server connects over a network socket is largely irrelevant to the interface (with the exception that such a connection does change how it can be used, e.g. MySQL's over-the-wire format does not support running nested prepared statements in nested loops (or it didn't the last time i iused its C API)).
What makes a DBMS a DBMS is not how it stores its data, but the feature set it provides. If your argument is that sqlite does not provide a comparable (not necessary identical) feature set to client/server DBMS's, that's a difficult argument to accept without concrete data to back it up.
(4) By punkish on 2024-06-20 16:03:12 in reply to 1 [link] [source]
Every software ever invented is nothing but a file format and a driver that can handle it. Argue away…
(5) By anonymous on 2024-06-20 18:23:49 in reply to 1 [link] [source]
Are SQL standards requires explicit client-server socket architecture from implementer at all?
(6) By Kees Nuyt (knu) on 2024-06-20 23:31:20 in reply to 5 [link] [source]
No, they do not. It also does not tell anything about the file format / backing store.
The standards just describe the language (SQL) to express the data model (relations) and relational algebra to manipulate that data.
(7) By Aask (AAsk1902) on 2024-06-21 03:53:34 in reply to 1 [source]
- SQLite3.EXE is a library that empowers you to collect/store data that can be retrieved, deleted, amended, backed up in several ways.
- SQLite3.EXE creates databases whose information can be queried in the most standard way - S(tructured) Q(uery) L(anguage).
- So far, it is just like MSSQL, Oracle etc. Moreover, just as MSSQL, ORACLE, SQLite has its own quirks and its own dialect of SQL.
In my mind, the question (Whether SQLite is an DBMS) does not even arise. Obviously it does in yours: I think you are snared by file format. Every application has its own bespoke file format.
(8) By cj (sqlitening) on 2024-06-21 04:12:51 in reply to 1 [link] [source]
(9) By Larry Brasfield (larrybr) on 2024-06-21 05:34:56 in reply to 7 [link] [source]
Obviously it does in yours ...
Perhaps, if post #1 is not an instance of trolling.
I would caution people who take that post seriously that trolls seek attention and controversy. It is generally best to deprive them of such.
(10) By Simon Slavin (slavin) on 2024-06-21 14:49:09 in reply to 1 [link] [source]
There is no set definition for "DBMS". Look it up in five places and you get five different definitions.
We don't know what you mean by "DBMS in the stricted sense".
Define your terms and we can answer your question. But if you define your terms you won't need us, because you'll be able to answer your question yourself.
(11) By jose isaias cabrera (jicman) on 2024-06-21 16:10:15 in reply to 10 [link] [source]
But if you define your terms you won't need us, because you'll be able to answer your question yourself.
:-)