search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.43k stars 291 forks source link

Increase SQLite Version #1353

Open pkkid opened 6 days ago

pkkid commented 6 days ago

Currently it looks like SQL Tools uses SQLite v3.39.3 which is about two years old. I'm hitting some errors using features in SQL Tools that are not available in the version of SQLite available from this extension.

In my specific case, I am using ORDER BY in an aggregate function on an SQLite View. I can not even open SQLTools with my database as it breaks trying to read the view. This functionality was added in SQLite v3.44.0.

Is there a way to use a higher version of SQLite, or a local version of sqlite3 rather than the bundled version?

RandomFractals commented 7 hours ago

@pkkid You can try our SQLite Pro Tools driver. It uses node-sqlite3 v5.1.6 and might work with more recent sqlite files and versions. SQLite Pro Tools also provide advanced shortcut commands and SQLite DB views.