Dose SoloLearn support not in memory sqllite database? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Dose SoloLearn support not in memory sqllite database?

I want make some projects with sqlite3. Can I save my slqlite3 database in a different file to open it in future? I know, I can do it im memory by just says ":memory:" for database, but I want to save it in a different file. Also can I upload and download it? If yes, how?

22nd May 2021, 5:34 AM
Deyzze
Deyzze - avatar
2 Answers
+ 2
however, you cannot save file permanently on sololearn: neither through code (file will only live during the script execution), nor by uploading to sololearn servers... anyway, I have not tried, but I guess you could upload /download / access a file elsewhere on the cloud... if your host provider allow that and you think that you doesn't risk to compromize your account security (in short, I would only do it if I'm sure to keep my code private, and I trust enough the privacy provided by sololearn -- meaning I doesn't really advise to do so ;P)
22nd May 2021, 5:52 AM
visph
visph - avatar
+ 1
You can try by hosting a remote MySQL server. Then use that databases in your code to store and read data. If you want a free option, I have one but as visph told, you have to compromise with security.
22nd May 2021, 8:31 AM
AKSHAY🇮🇳
AKSHAY🇮🇳 - avatar