0
I’m doing a mobile app project. Using Python and Kivy. My project has three main classes to save in a database (it’s a ticket selling app): Tickets, Events and Users.
Searching, I saw that JSON is quite easy to work at first, and it is recommended in the Kivy documentation as one of the usual methods of data permanence.
But I had some doubts (which, unfortunately, I could not remedy in simple research or documentation). The main one: is it feasible to keep JSON as my database? Whereas the app can grow in numbers.
Should I make a JSON file for each class ? (one for users, one for tickets and one for events)
That’s it. If you have any reading recommendations that can clear up those doubts for me, I really appreciate it. I’m starting with the 3 technologies, this should justify the simple doubts.
Thanks for your attention.
JSON is a mere format specification. Database is data stored somewhere (regardless of format, there is the question of storage); It would be nice if you [Dit] and explain better the relationship you want between the two things to be easier to understand the problem in fact. A JSON alone cannot be a Database.
– Bacco
I don’t know how to edit this to improve understanding. But I think you’ve helped me. JSON so it’s just a format? What technology could I use along with it then to have a functional database ?
– Giovane Machado
You need to record the data somewhere. If it is Python and will store locally (on the device that runs the application itself), it has Sqlite, which is powerful and super light.
– Bacco
I intend to write the data not-locally, after all they will be the same for several users. I’m still not able to understand the truth. The relationship between JSON and the databases, I thought it was a way to store the data good enough for what I want.
– Giovane Machado
In this case JSON can be a format to "chat" with the remote server, where it will run DB. http://json.org - there the application will decode JSON and perform operations on a DB.
– Bacco
I think I understand. Can you recommend me some tool so to use as the remote server where will run my DB? Or what would be the next step in my study
– Giovane Machado
It would be nice to search the site itself, and a peek at the related items next to it: https://answall.com/q/272434/70
– Bacco
I’ve been working on a project that resembles what you were looking for, a JSON-based database. JSON is a file format that refers to a javascript object (Javascript Object Notation). In python we have "Dict" which resembles an object in JS, but with differences. Instead of creating a DB based on JSON, I did something more similar to Dict syntax. I created my own syntax to differentiate the data when editing manually, but it’s very functional and practical. If you want to follow the project or give some suggestion, follow the link
– HidekiHrk