SQLlite support

[loprima-l]

Do you know if there's a way to export the schema from an SQLlite database ?
Thank you :3

[makaroni4]

Hey @loprima-l 👋

I believe there is, yes!

You can see all SQLite tables using sqlite_schema table:

SELECT * FROM sqlite_schema;

You can either scrape the output or at least get all table names and then inspect each table separately using the PRAGMA function:

PRAGMA table_info(users)

@loprima-l are you up for a challenge to write an adapter? 😊

You'd need to write a script that generates a custom schema CSV file similar to this one: https://github.com/sqlhabit/sql_schema_visualizer/blob/main/schema.csv.template (need to have these columns: "table_schema","table_name","column_name","data_type","ordinal_position")