TLDR;
- I built a SQLite explorer VS code with Vue/Vite. Code lives in sqlite-explorer
- For now, you can only build locally, for you OS and install. I have not been able to publish to the VScode marketplace: the UX sucks and I have reached out to support
I read the "Your First Extension" guide on GH for building extensions and for the life of me, couldn't understand why they still use Yeoman 😅.
Tried using it as-is but found myself raw dogging plain JS, with `getElementById` everywhere.
So I scaffolded a new vue project, built the different views, then went back to reading GH docs on extension. (Vue related code in webview)
Turns out (one of)the key files for an extension is the `src/extension.ts` file.
The rest is history.
Took me a bit longer than I'd anticipated and (disclaimer), I used Claude to help debug some issues I was having with `better-sqlite3` and packaging for different OS.
(I've tested only on MacOS and it *works well 😅. I'll appreciate testers on different OS)
Before someone asked,
- I know there's SQLite Viewer but you need a Pro account to edit/modify data
- Using Tableplus means I have to keep going back and forth between it and vscode.
- I finally learned how to build a vscode extension with the tools I already know and use: Vue
I have a tremendous respect for some of the people creating very complex vscode extensions; building thing that supports multi OS is a pain in the behind.
Anyway, I'll post an update here if I ever succeed to publish it in the extension marketplace.
The code is not perfect and I'll appreciate CONSTRUCTIVE feedback, if you're so inclined.
Happy Vueing