3 ms·
I didn't know SQLite was dynamically typed. That's a strange choice for a database, to say the least. I would look into Berkeley DB (BDB) which is one of the m
by etatoby 9y ago
I didn't know SQLite was dynamically typed. That's a strange choice for a database, to say the least.
I would look into Berkeley DB (BDB) which is one of the most widely-used embedded databases, albeit not a SQL-based one. Otherwise take a look at the list of embedded databases on Wikipedia: https://en.wikipedia.org/wiki/Embedded_database https://en.wikipedia.org/wiki/Embedded_database
- herge 9y agoBerkley DB just stores byte arrays, so it is not 'typed' either.
- cat199 9y agoInitially (v < 3), all data fields in sqlite were text internally - type information was accepted for SQL compatibility, but ignored. This is actually an improvement. I'm not sure of the rationale; perhaps it's easier to keep the code / database files portable amongst different systems this way, and since it was designed for embedded use, many systems (and thus incompatibilites) were envisioned?