Best Way to Store Data

[AidenTheTechBoy]

I have been looking around recently for different ways to store lots of data in a way similar to the way MySQL does. I am, however, trying to avoid using MySQL for a few reasons (mainly the large file size and demanding load), and I am wondering: Is there a different way to store large amounts of data?

I really love the idea of using SQLite, but have been unable to get any part of it to work. I have looked into the code for essentialmode, but have been unable to figure out any way to properly implement such code. I have also looked into JSON, but have not found any logical way to do this.

If anyone has any resources or suggestions that would help me figure this out, it would be much appreciated. I have seen a lack of standalone database scripts and think it would believe it would be cool to do this.

[ChristopherM]

It all depends on what you are storing and how you want to retrieve it. I talked about it a little while back, here’s a snippet:

On another topic

This version of the resource relied on a MySQL Database to deliver the position and values of the Call-Points (or pull-stations as it was called in that version) and Control Panels. The data was pulled from the database, and then values such as the current NUI screen value of the control panel, and pull status of call-points was passed back to the server. The reason I stopped using the DB, and something you should keep in-mind before starting, is that I simply didn’t need it. The advantage of using a MySQL DB is that it allows you to effectively store and retrieve information across sessions (i.e. a server running, server shut down, server running again), which can not be done by simply storing data in local variables (hopefully I don’t need to explain why that’s not possible :P). In my case, I only pieces of information that were actually being updated, were reset every session anyway, back to their default state I’ve since replaced the entire need for MySQL DB with JSON files, which you don’t even need to if you don’t plan on storing data across sessions, you can just as easily use tables.

All that being said, if you need to store, retive, and manipulate values across sessions, then MySQL is a perfectly valid option; if you don’t need to , there are numerous alternatives you can look into.

If you explain a little more as to what you’re trying to achive, I can give you some more specifics as to the best way to achive it

[AidenTheTechBoy]

I’m working on a zombie survival server that is being created from the ground-up. I mainly need the data storage to store the players stats (hunger, thirst, etc), vehicles, weapon loadouts, level, etc.

[ChristopherM]

In which case MySQL probably would best option. MySQL does not need to be intensive, you just need to be careful with how you apply it.

For starters, have you looked at the MySQL resource? If so, were you having any particular issues with it?

brouznouf/fivem-mysql-async

[JustAnotherDEV]

JSON Format ^

[d0p3t]

You should think about what data you need to query when choosing a storage type. I think you are unsure whether you should use a relational DB or flat storage (like SQLite, JSON, MongoDB or so).

Have a look at DynamoDB’s documentation. It has a very good section explaining the key differences and when to choose what. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-general-nosql-design.html#bp-general-nosql-design-vs-relational

For your use case a flat storage might be a good idea considering your data is tied to just one “entity” (the player). If you are going to mess with trading items/vehicles/weapons or any other sort of data exchange between players, perhaps you want more flexible storage in form of a relational DB (MySQL, PostgreSQL, your choice).

[AidenTheTechBoy]

Thank all you guys for the help! I think I’m going to try using a flat storage option first, most likely JSON because I would like to use SQLite (mainly for the better reliability) but I cannot figure out how to do it. From what I could find, essentialmode actually writes and compiles binaries in C (which is a language I’m unfamiliar with), and even knowing that I have no idea how they got it to work with FiveM.