Hi,

I need a very simple and lightweight 'database' that has to run in windows
2003, and i need to interface it with my own applications (written in C++).

Ive used SQLite before, but this is both abit overkill on some issues, and
on other issues it really doesnt meet the requirements,

What i need is, a DB that:

1. Can be accessed from several applications at the same time
2. Fast and easy storage
3. Fast lookup for reading values

Its applications that runs realtime, and in effect what i want to do is to
save all the logentries into the database, then from another
platform/application located outside, i will do all the analasis (here i
might port the DB im after into somekind of SQL database for optimal use).

But i dont need all the fancy SQL stuff for my need, it could be nice with
some basic features, but the most important thing is speed and concurrent
connections (without any waiting).

What would you suggest ? is there something available for free or would you
recommend that you make it yourself (maybe memorymapped files or similar) -
and if you do, do you have any direction you can guide me in ?

Thanks,

On 16.01.2007 04:39 Niel Darren wrote:
Even though you say, you don't need the fancy SQL stuff, take a look at
Firebird (www.firebirdsql.org). It's footprint is very small, is has a
server and embedded mode. As you have concurrent access I think you
should take concurrency "control" into your list of requirements. Which
is handled by Firebird as well, having a full transactional model
(including MVCC, thus readers never block writers and writers never
block readers)

Thomas

"Niel Darren" <nods (AT) pszzxasm (DOT) co.uk> wrote:




Your requirements below tell us that SQLite is *_not_* overkill.



Then you need an RDBMS with multi-user concurrent access. SQLite,
AFAIK, does not support this!


Take a look at Firebird and/or PostgreSQL.



See above.



Take a look at Chris Browne's db pages - there maybe some in memory db
that serves your needs.



Paul...



--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 10.2.0.1 (Express Edition)
Interbase 6.0.2.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.