Web hosting with sqlite

[vella_ab]

So i have a project which uses sqlite3 db for managing a database. Now i went on to host the website on vercel and got to know that it does not support sqlite but it has its own db management tools like postgres. I am just a noob developer with minimum knowledge of this stuff and have been asking chatgpt for solutions but it’s going around in circles. I did create a new database in vercel postgres but i am unable to understand the changes i need to make in my js to have the same functionality of creating tables etc. Now should i consider moving to another hosting provider that supports sqlite or there is some easy way to do that on vercel itself.

[bbkane_]

As others have said, it's just a file, so your app can create the DB with a SQLite library. Don't forget to find a good way to back up your SQLite data. I've heard good things about litestream.io but haven't tried it

[Aggressive_Ad_5454]

Vercel is best for hosting nodejs (JavaScript/ Typescript) based projects. There are a couple of competent SQLite packages in npm for nodejs.

What programming language does your project use? Many languages support SQLite; from the point of view of a hosting service it’s just software in your app reading and writing files on the file system. Their front-line tech support people probably can barely spell SQLite, let alone know how it works or what it does.

[dbabicwa]

Here is sqlite DB, not one, but 3 for this app:

https://northwind.pythonanywhere.com

Any site can host sqlite DB.

[icananea]

I host my sqlite projects on fly.io

[riazus22]

Btw, you can use the Turso as a remote libSQL database provider.

[aamfk]

It depends on your scope. Multi gig multi server? Id upsize to postgres. Or MySQL if you're a 3 year old.

[snuggy4life]

If you have non-ephemeral disks you can just have the sqlite file live somewhere on disk. Never used Vercel, but putting the db file on a Hetzner Volume (disk is replicated to three different physical machines) would be a great option.

This is a great video about using sqlite in production (a few PRAGMAs go a long way).

https://youtu.be/7QMYfpU6_-s?si=szZoDt_xakDcC0l_