 | |
#1
 
| |||
| |||
|
Re: Which database shall I use? -
07-07-2003
, 04:37 PM
|
I want to develop (in C++) a small single-user, but multithreaded application, for which I'm looking for a database to use. The application shall run with Windows AND Linux. To avoid incompabilities and to ensure easy installation, the db must NOT run it's own process or be a server app. It should be linked directly to my application (e.g. like c-tree in former times). Locking mechanisms aren't required, since this takes place on a logical level. But evaluating SQL-Expressions has to be possible (KO). Of course it should be really stable and any commit/rollback mechanisms would be welcome. Since I do not know yet if I'll sell my app or make it a shareware program, at least the development phase should be possible without having to pay for the db. Later, when going on the market, the price should be low (say max. 500 Dollar/Euros). I know, these are many wants and musts - but does anyone can make some recommendations? Thanks in advance! Otto |
#2
| |||
| |||
|
|
I want to develop (in C++) a small single-user, but multithreaded application, for which I'm looking for a database to use. The application shall run with Windows AND Linux. To avoid incompabilities and to ensure easy installation, the db must NOT run it's own process or be a server app. It should be linked directly to my application (e.g. like c-tree in former times). Locking mechanisms aren't required, since this takes place on a logical level. But evaluating SQL-Expressions has to be possible (KO). Of course it should be really stable and any commit/rollback mechanisms would be welcome. Since I do not know yet if I'll sell my app or make it a shareware program, at least the development phase should be possible without having to pay for the db. Later, when going on the market, the price should be low (say max. 500 Dollar/Euros). I know, these are many wants and musts - but does anyone can make some recommendations? |
requirement, it looks like a good match. Do you really need dynamic ad-hoc
queries
in your application? The Berkeley DB method calls allow you to express SQL
statements
directly in your application without the overhead of a query parser,
optimizer and executor.
For applications that are looking for high performance, small footprint,
embeddable
DBMS library at a very low TCO, Berkeley DB is hard to beat.
Dave
#3
| |||
| |||
|
|
It should be linked directly to my application (e.g. like c-tree in former times). |
consider c-tree?
#4
| |||
| |||
|
|
Otto, In case you havn't been keeping up with the evolution of c-tree, please allow me to update you that FairCom's c-tree Plus product now has a full SQL interface available as part of our client/server version. While the default operational model for the c-treeSQL Server is a two tier solution (meaning you would link your application with a client side communication library that then talks to the c-treeSQL Server binary executable) there is a c-tree Server SDK that can allow you to implement your application, or portions of your application directly within the c-treeSQL Server (providing the direct link capability you expressed below). Another approach would be for you to use the c-tree native C++ API for your core application (this will provide the best performance) and then provide SQL interface through the stand-alone ODBC Driver. Both of these options provide support for commit/rollback mechanisms. I hope this helps... Randal |
Hi Randall,
thanks for your answer.
"Many" years ago I used c-tree and I was always impressed by its stability.
It was very fast and having the (really good and clear programmed) source
code was great. So, consequently I looked at the Faircom site before
posting.
This was devastating. I knew that c-tree would be expensive, but demanding
additionally runtime fees now (PER YEAR!!!) made me looking for alternative
products very soon. I still don't believe it.
My app shall be low-priced but wide spreaded. I can't afford paying any
runtime fees (or whatsoever they call it). And besides: it's really much
too much. AND IMAGINE: YEARLY FEES! I still can't believe it.
So - unfortunately they are out of the question. It's a pity, but they
pushed too hard, even for a former highly pleased faircom user.
Otto
#5
| |||
| |||
|
|
In article <Xns93AE745E79E7DOttoHundtPostfach201 (AT) 62 (DOT) 153.159.134>, Otto Hundt <postfach201010 (AT) gmx (DOT) de> wrote: It should be linked directly to my application (e.g. like c-tree in former times). Is it your desire to not have to pay for the db that makes you not consider c-tree? |
I have to work to earn money for me and my family. Paying the db developers
for their work would only be ok. So, it would be ok, if it would cost a
reasonable price (appr. <= 500-800 (MAX!, depending on the included tools)
Euros/Dollars). But since my application will be single user and small, I
don't see any reasons to pay additionally per installation license fees.
Please read my answer to Randal also.
Greetings
Otto
#6
| |||
| |||
|
|
One option would be Berkeley DB (www.sleepycat.com). Apart from the SQL requirement, it looks like a good match. Do you really need dynamic ad-hoc queries in your application? The Berkeley DB method calls allow you to express SQL statements directly in your application without the overhead of a query parser, optimizer and executor. For applications that are looking for high performance, small footprint, embeddable DBMS library at a very low TCO, Berkeley DB is hard to beat. Dave |
Hi Dave!
Thank you very much for you answer. This sounds very good, especially the
non-parser SQL statements stuff. I surely will take a look at it.
Rudi
#7
| |||
| |||
|
|
I want to develop (in C++) a small single-user, but multithreaded application, for which I'm looking for a database to use. The application shall run with Windows AND Linux. To avoid incompabilities and to ensure easy installation, the db must NOT run it's own process or be a server app. It should be linked directly to my application (e.g. like c-tree in former times). Locking mechanisms aren't required, since this takes place on a logical level. But evaluating SQL-Expressions has to be possible (KO). Of course it should be really stable and any commit/rollback mechanisms would be welcome. Since I do not know yet if I'll sell my app or make it a shareware program, at least the development phase should be possible without having to pay for the db. Later, when going on the market, the price should be low (say max. 500 Dollar/Euros). I know, these are many wants and musts - but does anyone can make some recommendations? Thanks in advance! Otto |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.