Thats true and we have.
With the amount of data we need to handle and the queries we need to
execute the postgresql database is way better suited for our needs.
SQLite do not have the functions we need anyways.
It is also quite crash resistant with the WAL implementation.
We still create the datafiles on raid devices and only keep the
binaries on a DiskOnModule device.
Cheers,
Henrik
15 dec 2006 kl. 13:49 skrev Ragnar:
On fös, 2006-12-15 at 11:41 +0100, Henrik Zagerholm wrote:
Hello list,
I'm working on a project which tries to run postgre as a embedded
database.
I'm know looking at start up scripts and initdb scripts.
What are the necessary files for running initdb and running postgres
as an embedded database?
All binary files and their deps are already fixed so the question is
more related to files like postgres.bki and such.
I think you should first figure out if postgres is suitable as
an embedded database. (depends on what exactly you mean by
an embedded database of course).
Postgres has been designed as a server, and lots of
implementation details might not make sense in an embedded
context. you might be better served by SQLite, or some other
such library.
gnari
---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
