3 ms·
SQLite is a Tcl library. All of its type flexibility is meant to work with limited friction in that ecosystem. In Tcl every object type has a binary and string
by kevin_thibedeau 4y ago
SQLite is a Tcl library. All of its type flexibility is meant to work with limited friction in that ecosystem. In Tcl every object type has a binary and string representation and can be freely converted.
- blacksqr 4y agoAlso, I believe one of SQLite's original design goals was Postgres compatibility. So a lot of the games SQLite plays with type notations and coercions are intended to make it possible for SQL code written for Postgres to run with SQLite, to the greatest extent possible given Sqlite's underlying architecture.