PostgreSql Doubts

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.
​

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...

https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F

David J.
​

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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general