Hacker News Reader

Comment by 14113 | Hacker News Reader

On a related note (and this seems a good forum to ask), are there any typed databases available similar to sqlite?

I'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.

What do you mean by typed? :-?

SQLite will ignore most type information, instead choosing to focus on "type affinity": https://www.sqlite.org/datatype3.html

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

Initially (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?

Berkley DB just stores byte arrays, so it is not 'typed' either.

Yes SQLite with type check constraints.

Could you expand on this? I've not come across this before, and I'd be very interested in using it, if it's easy...

SAP (formerly Sybase) SQL Anywhere

Reply on news.ycombinator.com