berkeleyDB and sql engine, which one is better ?

linuxbenz · 09-24-2005, 10:29 AM

I am thinking to establish a database one my system to handle a bunch of article and papers. However, I am very doubt in choosing the database.

I am very appriaciate BerkeleyDB, as it's standalone(running without server) and a very basic software for linux, as well. However, query with regular expression is complicated for BerkeleyDB.

Could someone give me some ideas ? thanks!

spooon · 09-25-2005, 04:46 AM

SQL is for relational databases; while BerkeleyDB uses a key-value structure.

yogeshm02 · 09-25-2005, 08:03 AM

Not sure i will help you, but you can use SQLite from http://www.sqlite.org, which is a standalone, embedable, and SQL-compatiable.

(EDIT: Soory, misread you post)

linuxbenz · 09-26-2005, 09:32 AM

Quote:

Originally posted by yogeshm02
Not sure i will help you, but you can use SQLite from http://www.sqlite.org, which is a standalone, embedable, and SQL-compatiable.

(EDIT: Soory, misread you post)

sqlite is really a good choice. However, it is not very well documentated.

yogeshm02 · 09-26-2005, 11:41 AM

I am using sqlite3 and i do not have any complaints about its documentation. (Can you tell me what part of documentation is not satisfying you, perhaps i may be of some help to you.)