Help - User help - Database format

Count of members 23 members
Connected : (nobody)
Snif !!!
 

Help - Help
User help - User help

active  Topic # 101

16/01/2017 10:39
by 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...
Post an answer Top  

Answer n° 1
--------
16/01/2017 14:05
by favdb

favdb

Administrator
Administrator
Administrator
Administrator


Sorry, the database is a standard one, but not well know, it is a H2database
Post an answer Top  
Answer n° 2
--------
16/01/2017 14:42
by bodiccea

bodiccea

visitor

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)...
Post an answer Top  
Answer n° 3
--------
16/01/2017 15:59
by favdb

favdb

Administrator
Administrator
Administrator
Administrator


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.
Post an answer Top  
Answer n° 4
--------
16/01/2017 16:17
by bodiccea

bodiccea

visitor

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.
Post an answer Top  
Answer n° 5
--------
16/01/2017 23:45
by favdb

favdb

Administrator
Administrator
Administrator
Administrator


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.
Post an answer Top  
active topic active   closed topic closed   Important! Important!   New New message
Correct Correct message   Close Close topic   Make sticky Make sticky  
Forum Topic  Help