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

Question

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

Answer 1

If you like python you can use Sqlite3 with a simple import.

Answer 2

You may consider the 3 big players — Google's Firebase, Amazon RDS & Microsoft's Azure Storage. 😉

Answer 3

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.

Answer 4

Props to MLab and Mongodb also, great if you want to use NodeJS.
Available on AWS or Google Cloud

https://mlab.com/

Answer 5

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.

Answer 6

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!!👌👌👌

Answer 7

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

Answer 8

Google product(s) ie... cloud, drive, and so on...
And there are many other ~

Answer 9

use firebase it's more easier 🎉

Answer 10

Alan Carreño Fiestas maybe this will help you
https://www.hostinger.com/tutorials/difference-between-mysql-and-sql-server

Answer 11

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

Answer 12

https://www.sqlite.org/index.html sqlite could be a good alternative

Answer 13

yeah.. Google's firebase is a best option.

Answer 14

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

Answer 15

I would.like.to know is it possible to access.firebase.in.China ?

Answer 16

You don't want to install my sql just make free online database...

you can provide 400 free databases in infinityfree.net

Answer 17

Очень много базы данных
sqlite больше для больших текстов подходит...
mongodb & mysql для больших по проектированию возможностей баз,
mssql Где уже можно в кластеры объединять базы клонировать и т.д.

Answer 18

json is the way to do that..

Answer 19

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

Answer 20

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.