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