Re: 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(at)gmail(dot)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(at)gmail(dot)com
To: pgsql-hackers(at)postgresql(dot)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(at)hotmail(dot)com
To: suanic(at)gmail(dot)com; pgsql-hackers(at)postgresql(dot)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(at)gmail(dot)com
To: pgsql-hackers(at)postgresql(dot)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