Thread: 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
Hotmail® has ever-growing storage! Don’t worry about storage limits. Check it out.
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.
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
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Verdana;}
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
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.
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
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.