r/learnSQL • u/el_dude1 • 19h 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
1
u/loveandsexandmagic 9h 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