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: 14271 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: Tue Nov 04 09:13:32 CET 2025 
 Total time taken to generate the page: 0.00325 seconds 
 |