mathaou / termdbms

A TUI for viewing and editing database files.
MIT License
1.7k stars 36 forks source link

Fails to view SQLite databases containing STRICT tables #27

Closed climbTheStairs closed 1 year ago

climbTheStairs commented 2 years ago

If I create a STRICT table in a SQLite database:

CREATE TABLE user(id INTEGER, username TEXT) STRICT;

then try to open it with termdbms, I receive the following error:

database disk image is malformed: malformed database schema (user) - near "STRICT": syntax error (11)
mathaou commented 1 year ago

I believe this is a limitation of the SQLite driver I'm using. I opted to go with 100% Go for portability reasons, but there's a C driver that is likely more up to date on all the syntax.