Looking for practical help /guidance on how to setup a self hosted bun-sqlite production app | Bun | Page 1

spice patrol Jul 12, 2024, 11:21 PM

#

So basically I understand Sqlite and I can work with an in memory Sqlite database but I don't understand how it works for production and would appreciate it if anyone could offer advice or point me to a tutorial as so far I can't find anything explaining how this works and LLM's can't seem to explain it well.

I fundamentally don't understand like where to store / create the DB, how I update it if I have to, do I have to?

Sorry if this all sounds pretty dumb I'm just not sure of what I don't know and having a hard time figuring it all out

queen pelican Jul 13, 2024, 12:23 AM

#

spice patrol So basically I understand Sqlite and I can work with an in memory Sqlite databas...

I guess you can create a SQLite db on disk or embed in your app executable
Maybe you should have a backup system as well in case something goes wrong

spice patrol Jul 13, 2024, 5:24 PM

#

How would that look like though? Is it something like this:

project/database.sqlite
project/application
project/backup.db

I'm not sure how the embed one works either and don't really understand how updates would work with that

queen pelican Jul 13, 2024, 5:32 PM

#

spice patrol How would that look like though? Is it something like this: ```ts project/databa...

idk lol
You can embed a sqlite db with your executable with a single import

#Looking for practical help /guidance on how to setup a self hosted bun-sqlite production app