How to embed postgresql?
Dears,
How to embed postgresql if possible?
In our Java application solution, we need an embedded database. Berkeley DB
can not meet our reqirements in performance and license, so we wish to port
postgresql as embedded database.
Architecture: Java -> JNI -> the API is wrapped from Plan/Executor modules
What's the feasibility? If it's possible, look for your coaching!
Many thanks!
Bruce
On Tue, Jun 16, 2009 at 12:13 AM, Bruce YUAN<suanic@gmail.com> wrote:
How to embed postgresql if possible?
See http://wiki.postgresql.org/wiki/Todo#Features_We_Do_Not_Want
...Robert
On 6/15/09 9:13 PM, Bruce YUAN wrote:
Dears,
How to embed postgresql if possible?
In our Java application solution, we need an embedded database. Berkeley
DB can not meet our reqirements in performance and license, so we wish
to port postgresql as embedded database.
Architecture: Java -> JNI -> the API is wrapped from Plan/Executor modules
What's the feasibility? If it's possible, look for your coaching!
PostgreSQL is an enterprise database, not an embedded database.
I suggest that you check out two other databases:
1. SQLite
2. Apache Derby
... either of which should suit your needs better than PostgreSQL.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
If you are working with Java, it is better for you to check "H2 database", we also have Java application and until recently we worked with Postgres, few month ago we replaced it with H2.
Regards
Dror
Date: Tue, 16 Jun 2009 12:13:38 +0800
Subject: [HACKERS] How to embed postgresql?
From: suanic@gmail.com
To: pgsql-hackers@postgresql.org
Dears,
How to embed postgresql if possible?
In our Java application solution, we need an embedded database. Berkeley DB can not meet our reqirements in performance and license, so we wish to port postgresql as embedded database.
Architecture: Java -> JNI -> the API is wrapped from Plan/Executor modules
What's the feasibility? If it's possible, look for your coaching!
Many thanks!
Bruce
_________________________________________________________________
Hotmail® has ever-growing storage! Don’t worry about storage limits.
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009
In addition to my last comment, if you are looking fior real embedded database then Postgress does not fit your needs unless you would like to work with it as Server mode.
With H2 (or Derby) you can work in Server mode or in embbedded mode and both are much suitable for Java applications.
Regards
Dror
From: dror_b@hotmail.com
To: suanic@gmail.com; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] How to embed postgresql?
Date: Tue, 16 Jun 2009 05:56:09 +0000
If you are working with Java, it is better for you to check "H2 database", we also have Java application and until recently we worked with Postgres, few month ago we replaced it with H2.
Regards
Dror
Date: Tue, 16 Jun 2009 12:13:38 +0800
Subject: [HACKERS] How to embed postgresql?
From: suanic@gmail.com
To: pgsql-hackers@postgresql.org
Dears,
How to embed postgresql if possible?
In our Java application solution, we need an embedded database. Berkeley DB can not meet our reqirements in performance and license, so we wish to port postgresql as embedded database.
Architecture: Java -> JNI -> the API is wrapped from Plan/Executor modules
What's the feasibility? If it's possible, look for your coaching!
Many thanks!
Bruce
Hotmail® has ever-growing storage! Don’t worry about storage limits. Check it out.
_________________________________________________________________
Lauren found her dream laptop. Find the PC that’s right for you.
http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290