Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSql Doubts

PostgreSql Doubts

From
aluka raju
Date:
Hello ,

1) We are building an application where it needs a SQL engine to process the data. We are evaluating whether to use postgreSQL along with the foreign data wrappers. Can you please help us in letting know if postgreSQL can be used in embedded mode.  

2) We want to have SQLEngine component also embedded into our application.

please help me.


Thanks & Regards,
aluka

Re: PostgreSql Doubts

From
"David G. Johnston"
Date:
On Fri, May 20, 2016 at 7:17 AM, aluka raju <alukaraju2894@gmail.com> wrote:
Hello ,

1) We are building an application where it needs a SQL engine to process the data. We are evaluating whether to use postgreSQL along with the foreign data wrappers. Can you please help us in letting know if postgreSQL can be used in embedded mode.  

2) We want to have SQLEngine component also embedded into our application.

please help me.


​PostgreSQL is a standalone server - it cannot be embedded.

I don't understand #2 (what is SQLEngine?) but I suspect the above answer covers it as well.

David J.
​
 

Re: PostgreSql Doubts

From
"David G. Johnston"
Date:
On Fri, May 20, 2016 at 9:06 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, May 20, 2016 at 7:17 AM, aluka raju <alukaraju2894@gmail.com> wrote:
Hello ,

1) We are building an application where it needs a SQL engine to process the data. We are evaluating whether to use postgreSQL along with the foreign data wrappers. Can you please help us in letting know if postgreSQL can be used in embedded mode.  

2) We want to have SQLEngine component also embedded into our application.

please help me.


​PostgreSQL is a standalone server - it cannot be embedded.

I don't understand #2 (what is SQLEngine?) but I suspect the above answer covers it as well.


​Apparently there is even an FAQ entry for this...


David J.
​
 

Re: PostgreSql Doubts

From
John McKown
Date:
On Fri, May 20, 2016 at 6:17 AM, aluka raju <alukaraju2894@gmail.com> wrote:
Hello ,

1) We are building an application where it needs a SQL engine to process the data. We are evaluating whether to use postgreSQL along with the foreign data wrappers. Can you please help us in letting know if postgreSQL can be used in embedded mode.  

2) We want to have SQLEngine component also embedded into our application.

please help me.

​Abandon trying to use PostgreSQL if you need an embedded SQL language. I, personally, would suggest either SQLite (https://www.sqlite.org) or FireBird SQL (www.firebirdsql.org). 

SQLite uses SQL which rather easy, but with its own peculiarities. It's main excellence is that it is indeed "lite" as in "not adding a lot of code to your project". The author is brilliant and takes a _very_ active role in supporting it. The license is basically "do whatever you want with the code" because he's donated to the "Public Domain" (not copyrighted it in any way). You can use it on Linux, Windows, and Mac OSX.

I don't know much about FireBird. I (not a lawyer) think it has a very good license. One interesting thing is that it says that it can run as a "server", like PostgreSQL, or "embedded", like SQLite. But I can't really figure out how the "embedded" is actually "embedded". 

Personally, despite some strange details (such as not enforcing data types, e.g. you can INSERT a string value into a column defined as NUMERIC), I think that SQLite is likely your best option. If you go to the web page mentioned previously and sign up for the "sqlite-users" forum, you'll get a good idea of how community minded the people using SQLite are. I think there are some very intelligent, articulate, and _nice_ people over there (unlike some forums I've been on).

 


Thanks & Regards,
aluka



--
The unfacts, did we have them, are too imprecisely few to warrant our certitude.

Maranatha! <><
John McKown

Re: PostgreSql Doubts

From
George Neuner
Date:
On Fri, 20 May 2016 09:19:08 -0500, John McKown
<john.archie.mckown@gmail.com> wrote:

>I don't know much about FireBird. I (not a lawyer) think it has a very good
>license. One interesting thing is that it says that it can run as a
>"server", like PostgreSQL, or "embedded", like SQLite. But I can't really
>figure out how the "embedded" is actually "embedded".

Firebird is available as a DLL on Windows and Linux.

http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/ufb-cs-embedded.html


George