![[en]](../inc/lang/en.gif)
Sujet n°101 -
Database format
- par bodiccea le 16/01/2017 10:39
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...
Réponse n° 1
- par favdb le 16/01/2017 14:05
Sorry, the database is a standard one, but not well know, it is a H2database
Réponse n° 2
- par bodiccea le 16/01/2017 14:42
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)...
Réponse n° 3
- par favdb le 16/01/2017 15:59
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.
Réponse n° 4
- par bodiccea le 16/01/2017 16:17
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 
I will surely find a way to script the backup the DB properly.
Réponse n° 5
- par favdb le 16/01/2017 23:45
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.
© 2004-2015 
