4 ms·
On a related note (and this seems a good forum to ask), are there any typed databases available similar to sqlite?
by 14113 9y ago
On a related note (and this seems a good forum to ask), are there any typed databases available similar to sqlite?
- oblio 9y agoWhat do you mean by typed? :-?
- striking 9y agoSQLite will ignore most type information, instead choosing to focus on "type affinity": https://www.sqlite.org/datatype3.html https://www.sqlite.org/datatype3.html
- etatoby 9y agoI 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?
- herge 9y agoI'd just write protobuf "blobs" or other serialization format n in an sqlite text column. If you need to query across the typed data, you could build an index in another column from the data in your protobuf blob.
- biokoda 9y agoYes SQLite with type check constraints.
- 14113 9y agoCould you expand on this? I've not come across this before, and I'd be very interested in using it, if it's easy...
- doozy 9y agoSAP (formerly Sybase) SQL Anywhere