[centimeter]

I love SQLite's software model (embeddable library rather than a separate binary), but I often sorely miss the rich data model provided by postgres. I miss things like strong type checking, special types to represent times/coordinates/etc., and advanced index types like GiST indices.

[hagibborim]

How close does DuckDB get to fulfilling your needs?

[centimeter]

Doesn’t look like it has rich types or advanced indices.