Hello Community,
I’m looking to self host a SQLite file in my Google drive. After looking around for possible ways to do this and I like the path of using the Github file called SQL.js . I’ve scanned the file many times through VirusTotal (A Google owned file scanner) they seem to be trusted on platforms and other forums, but I can’t find much Data on using it with GAS. Has anyone ran this program before and attached it to their GAS I’ve read it is possible, but don’t want to run any programs until I know it can be done and is trusted by other users before I try and use it. (SQL.js is stated to allow javascript to interact with SQL)
I have seen possible uses of working with Google Colab and using python to do the job, but I would really like the GAS approach as this would allow me to easily interact with SQLite through an app?
The goal is to not connect the SQLite to the app but have it be the store for data. the data would transfer down via app script calls and populate in a separate sheet.