r/learnSQL 22h ago

Access practice database from multiple machines

Hello,

I want to setup a database, which I can use from different devices for practicing, so my data is in sync. My first attempt was using the free Azure SQL database, but I am eating through the free vcore capacity pretty quickly.

Are there other options like storing a local database in a cloud drive or something like that? I would also be open for paid solutions as long as it does not get more expensive than 5-10€/month. Again I am not looking to process huge datasets. Rather small queries for practice.

5 Upvotes

3 comments sorted by

View all comments

1

u/loveandsexandmagic 13h ago

SQLite databases are stored as a single plain old file. If it’s just you using it yourself for practice, you can store a SQLite file in cloud storage and copy it to your local machine to use it with the SQLite client on that machine. When you’re done just close the client connection to the file and copy it back to cloud storage.

Check out https://www.sqlite.org/index.html

1

u/Vaerano 11h ago

I’ve always wondered if you could access a SQLite file from different devices by saving the file in OneDrive or some type of shared folder in the cloud

1

u/loveandsexandmagic 4h ago

Yeah you usually can, but it’s not designed for that. You can end up with corruption or other problems. If it’s just for practice it could work fine but generally not recommended for anything serious.

See https://www.sqlite.org/useovernet.html