Minimum Viable VueJS SQLite Capacitor app?

[mccabeservant]

I'm having a lot of difficulty understanding how to get a basic SQLite Capacitor project off the ground, and would appreciate any clear and succinct assistance anyone could provide!

My goal is to make a Capacitor app using VueJS that has a web, Android, and iOS version. In Android and iOS, it will have a SQLite database. It will not have a SQLite DB in the web version, but the web version will appear to do all the same things the Android and iOS versions do. Android and iOS will additionally store data in their local SQLite DB so that they can work offline.

I don't want to install any unnecessary libraries at all.

While I've done lots of work in ECMA5, and in jQuery, and in Cordova, I've never done any production work in VueJS or Capacitor. I've only taken some basic tutorials so that I have a very vague idea of what I'm doing.

My initial expectation was that there would be a SQLite Capacitor library out there somewhere with simple, clear instructions, first for installation (which I expected to be something like "cd into your existing Capacitor project and run these two commands in your terminal"), and second for usage. For usage I was expecting about 6 lines of code...

1. Some kind of import line
2. Some kind of DB Connection creation line
3. Some kind of SQL INSERT line
4. Some kind of SQL SELECT query line
5. Some kind of parse-the-returned-data line
6. Some kind of Connection-close line

Instead, I can't find anything simple, meaningful, and clear that I can actually start with.

Is there a Minimum Viable Product version of what I'm looking for somewhere?

Am I expecting too much?

I initially just tried the basic installation instructions here, but once I supposedly had it installed into my simple HelloWorld Capacitor app, I had no idea what to do next!
https://github.com/capacitor-community/sqlite

I've found this, which is an entire sample project with tons of files and libraries, some of which I suspect I don't need. What's more, I don't know how to make a website out of it. It only comes with Android, iOS, and Electron, not web. And I don't even want Electron. Within all these piles of files and libraries is probably the few simple lines of code I want, but I can't figure out where to start!
https://github.com/jepiqueau/blog-tutorials-apps/tree/main/SQLite/Part-2/ionic7-vue-sqlite-app

I also found this sample code, which I can get to work on the web, but not in Android. I don't need SQL storage on the web, so that's not a lot of help for me. Also, it too has tons of files and libraries, and I am unable to discern what's necessary and what's not. Not to mention it claims to be "Not Updated," whatever that means!
https://github.com/jepiqueau/vue-sqlite-app

It would be soooooooo great if there were some kind of quickstart guide, with simple install instructions, no extra libraries, and the 6 lines of code I need to get everything up-and-running!

I would appreciate any guidance anyone could offer a simpleton like myself! Thanks in advance!

[mccabeservant]

I used Claude AI and it was very helpful.