How can I store and retrieve the data without using MySql ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 48

How can I store and retrieve the data without using MySql ?

Because I don't like to install MySql in my system. Is there any online database to store the data ?

7th May 2018, 10:27 AM
sachin billav
sachin billav - avatar
60 Answers
+ 29
If you like python you can use Sqlite3 with a simple import.
12th May 2018, 4:03 PM
Robert Robinson
Robert Robinson - avatar
+ 27
You may consider the 3 big players — Google's Firebase, Amazon RDS & Microsoft's Azure Storage. 😉
12th May 2018, 3:06 PM
Zephyr Koo
Zephyr Koo - avatar
+ 25
I use mlab a remote database for testing and learning, which provides a free 500 mb of online storage as a mongoDB ( its a NoSQL DB ) it's very easy to use and setup as well., basically mlab provides database-as-a-service , just sign up here https://mlab.com/ and for a short demo tutorial https://www.youtube.com/watch?v=ySFXduSdpxs ( start from 1:52 ) firebase is also a much easier option and it provides ton of features.
12th May 2018, 4:19 PM
Morpheus
Morpheus - avatar
+ 24
Props to MLab and Mongodb also, great if you want to use NodeJS. Available on AWS or Google Cloud https://mlab.com/
12th May 2018, 4:47 PM
Mike Choy
Mike Choy - avatar
+ 18
sachin billav Hmmm... I'm curious about the background for asking this question. While there are several options to consider, it really depends on the reasons you want to avoid installing MySQL on your local system. This really isn't an ideal development setup for so many reasons. Before going down the path of remote database dev setup, consider some of the follow up questions you may not have yet anticipated. Does this concern apply only to MySQL or to any database? How large do you expect your database to get during development? How many database calls to you plan to make? Will this database be used exclusively for development purposes? How frequent do you anticipate making database changes? Do you plan on running migration scripts over time? If so, will you be running those migration scripts from your local machine or on the remote server? Will you be executing mostly stored procedures or inline SQL from your local code? How fast is your internet connection? Will latency from making remote database calls from your local machine be an issue during development? Most of all, let me know what your concerns are for installing a database in your local system. Perhaps I can help address those issues before you go down a less preferred path with a dev setup using remote hosted database.
13th May 2018, 7:48 AM
David Carroll
David Carroll - avatar
+ 15
Bro U can easily Access on the net 😄😄 And I am Sharing Some Links of the websites with u 1.) https://paiza.io/en/languages/mysql 2.)Google You can login and can access it Free https://cloud.google.com/sql/ 3.) Microsoft https://azure.microsoft.com/en-in/services/storage/ Or many more....! My SQL is aOpen Source Software and You can access it anywhere on internet!!👌👌👌
12th May 2018, 3:30 PM
Brijesh B
Brijesh B - avatar
+ 11
If you don't want to install, then try your experiments online with a free hosting or install a local web server like xampp or wamp to have it installed with PHP
12th May 2018, 3:37 PM
Siddharth Saraf
+ 10
Google product(s) ie... cloud, drive, and so on... And there are many other ~
12th May 2018, 10:07 PM
BroFar
BroFar - avatar
+ 10
use firebase it's more easier 🎉
13th May 2018, 4:18 AM
Shane Umayanga
Shane Umayanga - avatar
+ 8
You can use IndexedDB. You can find out more about it on MDN. It is a persistent local storage solution. https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API/Using_IndexedDB
16th May 2018, 5:17 AM
Paul K Sadler
Paul K Sadler - avatar
+ 7
https://www.sqlite.org/index.html sqlite could be a good alternative
12th May 2018, 3:08 PM
Fredelig
Fredelig - avatar
+ 7
yeah.. Google's firebase is a best option.
12th May 2018, 3:12 PM
Gaurav bhojwani
Gaurav bhojwani - avatar
+ 7
Fire base, MongoDB... etc The data is in form of JSON. Alternatively, you could build a simple Rest API that has multiple end points to PUT, GET, POST & DELETE your data. Look into things like the Django Rest Framework (DRF) and any other serializers you might land on as alternatives to DRF
12th May 2018, 3:56 PM
AGMeteor✔
AGMeteor✔ - avatar
+ 7
I would.like.to know is it possible to access.firebase.in.China ?
12th May 2018, 5:03 PM
KEvin Lau
KEvin Lau - avatar
+ 7
You don't want to install my sql just make free online database... you can provide 400 free databases in infinityfree.net
13th May 2018, 2:05 AM
DarkZeus
DarkZeus - avatar
+ 7
Очень много базы данных sqlite больше для больших текстов подходит... mongodb & mysql для больших по проектированию возможностей баз, mssql Где уже можно в кластеры объединять базы клонировать и т.д.
13th May 2018, 3:46 AM
Deadbeat
+ 6
json is the way to do that..
12th May 2018, 5:16 PM
Shaharia samir
Shaharia samir - avatar
+ 6
1- Use other databases 2- Put your data in a simple file (binary or text) 3- Google spread sheets has an easy to use api that you can use to feed data
12th May 2018, 7:18 PM
VcC
VcC - avatar
+ 6
store it in a file as an array if you are using php then retrieve by trying to open the file using php fopen() then read it using fread(). however get yous details stored in array then ech it as $array[’0'], $array[’1'] and so on.
12th May 2018, 9:02 PM
Dennis Chibueze