Home » Community » Coffee corner » Good way to manage data without a database ? (Give me your knowledge !)
Re: Good way to manage data without a database ? [message #51326 is a reply to message #51318] |
Wed, 06 March 2019 13:30  |
 |
mirek
Messages: 14257 Registered: November 2005
|
Ultimate Member |
|
|
Novo wrote on Tue, 05 March 2019 18:05Xemuth wrote on Tue, 05 March 2019 07:23
And, if one of best way is storing data into Xml/Json, do you know if Upp have a Mechanism allow us to retrieve some
particulare data really quickly from this XML like an sql requete would do on a classic database ?
IMHO, if your data has a fixed structure, then the best way to store data is a database. It can be an embedded database like Sqlite or FirebirdSQL.
If your data is read-only or has no structure, then XML or JSON should be your choice.
If you have a lot of data, you can store it in a multi-stream bz2 archive similar to Wikipedia dump.
In case you are not using a database you'll need to implement a simple one by yourself. This is not that difficult because you can create all needed indices in memory and serialize them in binary/XML/JSON format. It is very easy to serialize/deserialize data in Upp.
Hope this helps.
Originally I was opposed to the idea, but I am on participating on development of very large application which stores a very large (10GB is not uncommon) and very complex projects simply by using U++ binary serialization as single file. Despite my reservations, it works pretty good. Surprisingly, no problems with format compatibility between versions. And superfast too... 
Mirek
[Updated on: Wed, 06 March 2019 13:31] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Sat May 10 21:17:26 CEST 2025
Total time taken to generate the page: 0.02380 seconds
|