Обсуждение: How to embed postgresql?

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.

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

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.