SQLite's File Format

Re:SQLite's File Format by Dwedit on Sunday September 07, 2025 @12:47PM (#45159799)

My only question is if you really need a prefix before every value to say what type it is.

[ Parent | on HN ]

Re:SQLite's File Format by lawrencejgd on Sunday September 07, 2025 @04:32PM (#45161862)

Any field in SQLite can contain any type, even if the schema says that a field should be INTEGER, it could have a TEXT, so it's necessary to specify what's the type of every single value

[ Parent | on HN ]

Re:SQLite's File Format by maxbond on Monday September 08, 2025 @12:37PM (#45170439)

Indeed, unless it's a strict table, you can put gibberish in the type field (or forego giving a column a type altogether).

[ Parent | on HN ]