You are here :   Home » Forum » General discussion » Database format
 
Cleaning up the forum

All posts prior to 9/19/2016 have been deleted.

Forum - General discussion - Database format

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

Forum - Forum
General discussion - General discussion

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



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



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



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



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



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  Forum 



You are here :   Home » Forum » General discussion » Database format
 
 
 
Webmaster - Infos
Preferences

Connect again :
Your user name :
Your password