Aide - Aide à l'utilisation - Database format

Nombre de membres 94 membres
Connectés : ( personne )
Snif !!!
 

Aide - Aide
Aide à l'utilisation - Aide à l'utilisation

actif  Sujet n° 101

le 16/01/2017 10:39
par bodiccea

bodiccea



The ".db" looks like a ostorybok private format. It would be nice to have a standard DB, such as sqlite. It would be useful for scripting backups, dumps, etc...
Poster une réponse Haut  

Réponse n° 1
--------
le 16/01/2017 14:05
par favdb

favdb

Administrateur
Administrateur
Administrateur
Administrateur


Sorry, the database is a standard one, but not well know, it is a H2database
Poster une réponse Haut  
Réponse n° 2
--------
le 16/01/2017 14:42
par bodiccea

bodiccea

visiteur

OK. Difficult to guess, as "file foo.db" does not recognize it (quite unusual, first time in 2 years this command fails for me).

Your DB choice after all, you had surely good reasons.

My 2 ¥:
Difficult to access it beside Java, however, it is somehow locked to a single language (I mean compared to other DB, which could allow C, python, perl, etc)...
Poster une réponse Haut  
Réponse n° 3
--------
le 16/01/2017 15:59
par favdb

favdb

Administrateur
Administrateur
Administrateur
Administrateur


H2database was not my choice, but that of Martin Munstum who is the original developer of StoryBook.

Regarding Java, it was precisely because StoryBook was written in Java that I chose it. This choice seems to me to make it easier to distribute and install on different platforms.
Poster une réponse Haut  
Réponse n° 4
--------
le 16/01/2017 16:17
par bodiccea

bodiccea

visiteur

As I said: you chose it...

Easier, I don't know. An h2.jar or an XX.jar are still just libs, none is easier than the other for distribution, as long as the underlying DB is stable and use-able.

The only difference is the resulting DB: Either locked to one language, or not.

But what is done is done, it is not so important smile
I will surely find a way to script the backup the DB properly.
Poster une réponse Haut  
Réponse n° 5
--------
le 16/01/2017 23:45
par favdb

favdb

Administrateur
Administrateur
Administrateur
Administrateur


The lib is h2-1.4.189.jar, try to export to sql format. Then check the sql file exported, it's a simple text file. Perhaps it can work with other database system.
Poster une réponse Haut  
actif sujet actif   clos sujet clos   Important! Important!   Nouveau Nouveau message
Rectifier Rectifier message   Clôturer Clôturer sujet   Remonter Remonter  
Catégories de discussion  Aide