SQLite Schema Discovery about sea-schema HOT 5 CLOSED

No, we should not write a custom SQL parser

I guess this may help?

https://stackoverflow.com/questions/604939/how-can-i-get-the-list-of-a-columns-in-a-table-for-a-sqlite-database

from sea-schema.

No, we should not write a custom SQL parser

I guess this may help?

https://stackoverflow.com/questions/604939/how-can-i-get-the-list-of-a-columns-in-a-table-for-a-sqlite-database

Yes, we could use a combination of SQLite pragma statements for

1. Getting column info: https://www.sqlite.org/pragma.html#pragma_table_info

2. Getting foreign key info: https://www.sqlite.org/pragma.html#pragma_foreign_key_list

3. Getting index & primary key info: https://www.sqlite.org/pragma.html#pragma_index_list

from sea-schema.

Hey @charleschege, just a quick check, are you taking this issue?

from sea-schema.

Hi @billy1624 I am working on it

from sea-schema.

Thanks!! Do ping me if you need any help, either here or Discord, both fine.

from sea-schema.