Hi,
It’s been a looonggg time since I’ve posted anything here.
I have a website (pollapp.ml), and it uses JSON for a database structure.
Should I convert it to MySQL, or is JSON good enough…
Hi,
It’s been a looonggg time since I’ve posted anything here.
I have a website (pollapp.ml), and it uses JSON for a database structure.
Should I convert it to MySQL, or is JSON good enough…
If this file will exceed 10mb, then you will be better off using MySQL
alright, thanks
Using JSON to store data of your website can work, but there are a lot of caveats you need to be aware of:
Using JSON to store data works fine if the data is never changed by users, and the amount of data is fairly small.
MySQL is purpose built as a database, which a simple file is not, so it doesn’t suffer from any of these issues.
And if you feel a JSON file is a bit too simple and MySQL is a bit too complex, you could also consider using SQLite, which is also a SQL database, but stored as a single file (but with proper write locking, schemas, indexing, etc.)
Thank you!
I have decided to move to MySQL, since it is more convenient…
This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.