Thread: embedded postgresql

embedded postgresql

From
jini us
Date:
Hi,

I am starting a new project where I intend to use
embedded database server in my win32 application.
I intend to use VC++ microsoft studio 6.0 as my
development environment.

The postgres.org website seems to be catering for
people with all sorts of requirements and platforms.

1. Where can I find the binary distribution so that I
can  use postgres server as an embedded database.
I assume it is a .dll

2. Also I would like to have the documentation which
shows how to start & stop the server programmatically
and execute sql, to create a database, use select
insert , update etc.

3. Is it correct that I do not have to pay any user
licences.
Postgres is free not only for development but also I
can include it in my software package.

Thanks.








________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql

From
"Joshua D. Drake"
Date:
jini us wrote:

>Hi,
>
>I am starting a new project where I intend to use
>embedded database server in my win32 application.
>I intend to use VC++ microsoft studio 6.0 as my
>development environment.
>
>The postgres.org website seems to be catering for
>people with all sorts of requirements and platforms.
>
>1. Where can I find the binary distribution so that I
>can  use postgres server as an embedded database.
>I assume it is a .dll
>
>
No... PostgreSQL is a database server, thus you connect to it via TCP/IP
or domain sockets (preferrably TCP/IP).

Also an emulation layer such as Cygwin will be required to use PostgreSQL
on Windows.

>2. Also I would like to have the documentation which
>shows how to start & stop the server programmatically
>and execute sql, to create a database, use select
>insert , update etc.
>
>
>
www.postgresql.org click on docs.


>3. Is it correct that I do not have to pay any user
>licences.
>Postgres is free not only for development but also I
>can include it in my software package.
>
>
>
Yes that is correct.


>Thanks.
>
>
>
>
>
>
>
>
>________________________________________________________________________
>Want to chat instantly with your online friends?  Get the FREE Yahoo!
>Messenger http://mail.messenger.yahoo.co.uk
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org



Re: embedded postgresql

From
jini us
Date:
It is a shame that postgres is not available as an
embedded server unlike mysql database server which
comes in the form of a dll.

However with mysql licence I would have to pay $10,000
if I wish to include it in mysql as an embedded server
in my app.

mysql database server is also a TCP/IP socket server
whether embedded or otherwise.

 --- "Joshua D. Drake" <jd@commandprompt.com> wrote: >
jini us wrote:
>
> >Hi,
> >
> >I am starting a new project where I intend to use
> >embedded database server in my win32 application.
> >I intend to use VC++ microsoft studio 6.0 as my
> >development environment.
> >
> >The postgres.org website seems to be catering for
> >people with all sorts of requirements and
> platforms.
> >
> >1. Where can I find the binary distribution so that
> I
> >can  use postgres server as an embedded database.
> >I assume it is a .dll
> >
> >
> No... PostgreSQL is a database server, thus you
> connect to it via TCP/IP
> or domain sockets (preferrably TCP/IP).
>
> Also an emulation layer such as Cygwin will be
> required to use PostgreSQL
> on Windows.
>
> >2. Also I would like to have the documentation
> which
> >shows how to start & stop the server
> programmatically
> >and execute sql, to create a database, use select
> >insert , update etc.
> >
> >
> >
> www.postgresql.org click on docs.
>
>
> >3. Is it correct that I do not have to pay any user
> >licences.
> >Postgres is free not only for development but also
> I
> >can include it in my software package.
> >
> >
> >
> Yes that is correct.
>
>
> >Thanks.
> >
> >
> >
> >
> >
> >
> >
> >
>
>________________________________________________________________________
> >Want to chat instantly with your online friends?
> Get the FREE Yahoo!
> >Messenger http://mail.messenger.yahoo.co.uk
> >
> >---------------------------(end of
> broadcast)---------------------------
> >TIP 8: explain analyze is your friend
> >
> >
>
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL -
> S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and
> dedicated hosting.
> +1-503-222-2783 - jd@commandprompt.com -
> http://www.commandprompt.com
> Editor-N-Chief - PostgreSQl.Org -
> http://www.postgresql.org
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql

From
"Joshua D. Drake"
Date:
Hello,

   Are you sure you are not thinking of just the libpq.dll? That would allow
linking to PostgreSQL via C/C++ etc?

Sincerely,

Joshua Drake

jini us wrote:

>It is a shame that postgres is not available as an
>embedded server unlike mysql database server which
>comes in the form of a dll.
>
>However with mysql licence I would have to pay $10,000
>if I wish to include it in mysql as an embedded server
>in my app.
>
>mysql database server is also a TCP/IP socket server
>whether embedded or otherwise.
>
> --- "Joshua D. Drake" <jd@commandprompt.com> wrote: >
>jini us wrote:
>
>
>>>Hi,
>>>
>>>I am starting a new project where I intend to use
>>>embedded database server in my win32 application.
>>>I intend to use VC++ microsoft studio 6.0 as my
>>>development environment.
>>>
>>>The postgres.org website seems to be catering for
>>>people with all sorts of requirements and
>>>
>>>
>>platforms.
>>
>>
>>>1. Where can I find the binary distribution so that
>>>
>>>
>>I
>>
>>
>>>can  use postgres server as an embedded database.
>>>I assume it is a .dll
>>>
>>>
>>>
>>>
>>No... PostgreSQL is a database server, thus you
>>connect to it via TCP/IP
>>or domain sockets (preferrably TCP/IP).
>>
>>Also an emulation layer such as Cygwin will be
>>required to use PostgreSQL
>>on Windows.
>>
>>
>>
>>>2. Also I would like to have the documentation
>>>
>>>
>>which
>>
>>
>>>shows how to start & stop the server
>>>
>>>
>>programmatically
>>
>>
>>>and execute sql, to create a database, use select
>>>insert , update etc.
>>>
>>>
>>>
>>>
>>>
>>www.postgresql.org click on docs.
>>
>>
>>
>>
>>>3. Is it correct that I do not have to pay any user
>>>licences.
>>>Postgres is free not only for development but also
>>>
>>>
>>I
>>
>>
>>>can include it in my software package.
>>>
>>>
>>>
>>>
>>>
>>Yes that is correct.
>>
>>
>>
>>
>>>Thanks.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>________________________________________________________________________
>>
>>
>>>Want to chat instantly with your online friends?
>>>
>>>
>>Get the FREE Yahoo!
>>
>>
>>>Messenger http://mail.messenger.yahoo.co.uk
>>>
>>>---------------------------(end of
>>>
>>>
>>broadcast)---------------------------
>>
>>
>>>TIP 8: explain analyze is your friend
>>>
>>>
>>>
>>>
>>--
>>Command Prompt, Inc., home of Mammoth PostgreSQL -
>>S/ODBC and S/JDBC
>>Postgresql support, programming shared hosting and
>>dedicated hosting.
>>+1-503-222-2783 - jd@commandprompt.com -
>>http://www.commandprompt.com
>>Editor-N-Chief - PostgreSQl.Org -
>>http://www.postgresql.org
>>
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>
>________________________________________________________________________
>Want to chat instantly with your online friends?  Get the FREE Yahoo!
>Messenger http://mail.messenger.yahoo.co.uk
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org



Re: embedded postgresql

From
"scott.marlowe"
Date:
On Thu, 13 Nov 2003, jini us wrote:

> Hi,
>
> I am starting a new project where I intend to use
> embedded database server in my win32 application.
> I intend to use VC++ microsoft studio 6.0 as my
> development environment.
>
> The postgres.org website seems to be catering for
> people with all sorts of requirements and platforms.
>
> 1. Where can I find the binary distribution so that I
> can  use postgres server as an embedded database.
> I assume it is a .dll

If you truly want to embed a database in your program, you probably don't
want postgresql, as it is massive overkill for an embedded database.

Look at SQLite:  http://www.sqlite.org/

> 3. Is it correct that I do not have to pay any user
> licences.
> Postgres is free not only for development but also I
> can include it in my software package.

Correct, postgresql is free as in speech, and free as in beer, and free as
in "the village bicycle".


Re: embedded postgresql

From
jini us
Date:
 
if libpq.dll contains the server and I can call the functions
to start and stop programmatically.
Then I could use Postgres as an embedded  database sever in my application.
That way I include libpq.dll in my software package for deployment
with installshield.
 
So when the user starts my application I would start the database server, then stop it programmatically when the user stops using the application.
I would obviously need some functionality so that I can programmatically
configure which disk I would use to create the database. 
 
I am hoping to be able to create the database on a virtual drive / network drive programmatically from my application.
That is to say when you are running windows your local disk drives are usually C: or D:
However you may also  have virtual network drives  mapped like X: Y: Z:.
These drives are obviously connected physically on another machine
but you are acessing it via the network card/cable etc.
 
 
 
 
 

"Joshua D. Drake" <jd@commandprompt.com> wrote:
Hello,

Are you sure you are not thinking of just the libpq.dll? That would allow
linking to PostgreSQL via C/C++ etc?

Sincerely,

Joshua Drake

jini us wrote:

>It is a shame that postgres is not available as an
>embedded server unlike mysql database server which
>comes in the form of a dll.
>
>However with mysql licence I would have to pay $10,000
>if I wish to include it in mysql as an embedded server
>in my app.
>
>mysql database server is also a TCP/IP socket server
>whether embedded or otherwise.
>
> --- "Joshua D. Drake" wrote: >
>jini us wrote:
>
>
>>>Hi,
>>>
>>>I am starting a new project where I intend to use
>>>embedded database server in my win32 application.
>>> ;I intend to use VC++ microsoft studio 6.0 as my
>>>development environment.
>>>
>>>The postgres.org website seems to be catering for
>>>people with all sorts of requirements and
>>>
>>>
>>platforms.
>>
>>
>>>1. Where can I find the binary distribution so that
>>>
>>>
>>I
>>
>>
>>>can use postgres server as an embedded database.
>>>I assume it is a .dll
>>>
>>>
>>>
>>>
>>No... PostgreSQL is a database server, thus you
>>connect to it via TCP/IP
>>or domain sockets (preferrably TCP/IP).
>>
>>Also an emulation layer such as Cygwin will be
>>required to use PostgreSQL
>>on Windows.
>>
>>
>>
>>>2. Also I would like to have the documentation
>>>
>>>
>>which
>>
>>
>>>shows how to start & stop the server
>>>
>>>
>>programmatically
>>
>>
>>>and execute sql, to create a database, use select
>>>insert , update etc.
>>>
>>>
>>>
>>>
>>>
>>www.postgresql.org click on docs.
>>
>>
>>
>>
>>>3. Is it correct that I do not have to pay any user
>>>licences.
>>>Postgres is free not only for development but also
>>>
>>>
>>I
>>
>>
>>>can include it in my software package.
>>>
>>>
>>>
>>>
>>>
>>Yes that is correct.
>>
>>
>>
>>
>>>Thanks.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>________________________________________________________________________
>>
>>
>>>Want to chat instantly with your online friends?
>>>
>>>
>>Get the FREE Yahoo!
>>
>>
>>>Messenger http://mail.messenger.yahoo.co.uk
>>>
>>>---------------------------(end of
>>>
>>>
>>broadcast)---------------------------
>>
>>
>>>TIP 8: explain analyze is your friend
>>>
>>>
>>>
>>>
>>--
>>Command Prompt, Inc., home of Mammoth PostgreSQL -
>>S/ODBC and S/JDBC
>>Postgresql support, programming shared hosting and
>>dedicated hosting.
>>+1-503-222-2783 - jd@commandprompt.com -
>>http://www.commandprompt.com
>>Editor-N-Chief - PostgreSQl.Org -
>>http://www.postgresql.org
>>
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>
>________________________________________________________________________
>Want to chat instantly with your online friends? Get the FREE Yahoo!
>Messenger http://mail.messenger.yahoo.co.uk
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org


Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger

Re: embedded postgresql

From
"scott.marlowe"
Date:
On Thu, 13 Nov 2003, jini us wrote:

>
> if libpq.dll contains the server and I can call the functions
> to start and stop programmatically.
> Then I could use Postgres as an embedded  database sever in my application.
> That way I include libpq.dll in my software package for deployment
> with installshield.
>
> So when the user starts my application I would start the database server, then stop it programmatically when the user
stopsusing the application. 
> I would obviously need some functionality so that I can programmatically
> configure which disk I would use to create the database.
>
> I am hoping to be able to create the database on a virtual drive / network drive programmatically from my
application.
> That is to say when you are running windows your local disk drives are usually C: or D:
> However you may also  have virtual network drives  mapped like X: Y: Z:.
> These drives are obviously connected physically on another machine
> but you are acessing it via the network card/cable etc.

No, the libpq.dll is just the connection library.  You need to have an
actual database up and running to connect to to use it.

How much memory do you have?  Are you on nvram, which has limited write
lifetime?  Postgresql loves to write to the storage medium, and will
likely wear out a memory stick before too long.  How much transaction
capability etc. do you need in an embedded app?  Postgresql is so heavily
optimized for transactions and parallel access safeness that you'll be
paying a huge performance and memory usage penalty.

Using Postgresql as an "embedded" database is stuffing a rather large load
into a rather small sack usually.


Re: embedded postgresql + C++ IDE

From
jini us
Date:
Anybody knows of a c++ IDE, similar to Microsoft
studio but free.
Also good C++ site where I can pick up free
components.

Thanks.

 --- "scott.marlowe" <scott.marlowe@ihs.com> wrote: >
On Thu, 13 Nov 2003, jini us wrote:
>
> >
> > if libpq.dll contains the server and I can call
> the functions
> > to start and stop programmatically.
> > Then I could use Postgres as an embedded  database
> sever in my application.
> > That way I include libpq.dll in my software
> package for deployment
> > with installshield.
> >
> > So when the user starts my application I would
> start the database server, then stop it
> programmatically when the user stops using the
> application.
> > I would obviously need some functionality so that
> I can programmatically
> > configure which disk I would use to create the
> database.
> >
> > I am hoping to be able to create the database on a
> virtual drive / network drive programmatically from
> my application.
> > That is to say when you are running windows your
> local disk drives are usually C: or D:
> > However you may also  have virtual network drives
> mapped like X: Y: Z:.
> > These drives are obviously connected physically on
> another machine
> > but you are acessing it via the network card/cable
> etc.
>
> No, the libpq.dll is just the connection library.
> You need to have an
> actual database up and running to connect to to use
> it.
>
> How much memory do you have?  Are you on nvram,
> which has limited write
> lifetime?  Postgresql loves to write to the storage
> medium, and will
> likely wear out a memory stick before too long.  How
> much transaction
> capability etc. do you need in an embedded app?
> Postgresql is so heavily
> optimized for transactions and parallel access
> safeness that you'll be
> paying a huge performance and memory usage penalty.
>
> Using Postgresql as an "embedded" database is
> stuffing a rather large load
> into a rather small sack usually.
>

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql + C++ IDE

From
Mike Mascari
Date:
jini us wrote:

> Anybody knows of a c++ IDE, similar to Microsoft
> studio but free.
> Also good C++ site where I can pick up free
> components.

I've never used it but if download statistics is correlated in any way
to quality Dev-C++ is one of the top downloads on sourceforge:

http://sourceforge.net/projects/dev-cpp/

Mike Mascari
mascarm@mascari.com





Re: embedded postgresql + C++ IDE

From
jini us
Date:
I have just downloaded that one.
It doesn't any features for designing GUI forms.
It is just a project manager.


 --- Mike Mascari <mascarm@mascari.com> wrote: > jini
us wrote:
>
> > Anybody knows of a c++ IDE, similar to Microsoft
> > studio but free.
> > Also good C++ site where I can pick up free
> > components.
>
> I've never used it but if download statistics is
> correlated in any way
> to quality Dev-C++ is one of the top downloads on
> sourceforge:
>
> http://sourceforge.net/projects/dev-cpp/
>
> Mike Mascari
> mascarm@mascari.com
>
>
>
>

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql + C++ IDE

From
"BARTKO, Zoltan"
Date:
Have you ever tried KDevelop (www.kdevelop.org)? it is part of KDE
(www.kde.org), the newest version is going to be realesed very soon, but KDE
3.2 beta 1 was released already, get the tarballs from the above mentionned
address. I like it a lot, but you should check it out, if it suits your
needs.

Cheers,

Zoltan

----- Original Message -----
From: "jini us" <jiniusuk@yahoo.co.uk>
To: "Mike Mascari" <mascarm@mascari.com>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, November 14, 2003 4:28 AM
Subject: Re: [GENERAL] embedded postgresql + C++ IDE


>
> I have just downloaded that one.
> It doesn't any features for designing GUI forms.
> It is just a project manager.
>
>
>  --- Mike Mascari <mascarm@mascari.com> wrote: > jini
> us wrote:
> >
> > > Anybody knows of a c++ IDE, similar to Microsoft
> > > studio but free.
> > > Also good C++ site where I can pick up free
> > > components.
> >
> > I've never used it but if download statistics is
> > correlated in any way
> > to quality Dev-C++ is one of the top downloads on
> > sourceforge:
> >
> > http://sourceforge.net/projects/dev-cpp/
> >
> > Mike Mascari
> > mascarm@mascari.com
> >
> >
> >
> >
>
> ________________________________________________________________________
> Want to chat instantly with your online friends?  Get the FREE Yahoo!
> Messenger http://mail.messenger.yahoo.co.uk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>


Re: embedded postgresql + C++ IDE

From
jini us
Date:
I was looking at the screen shots and the screen shots
do not show any features for GUI  drag + drop
development.

Does it have a GUI drag + drop for drawing windows
components ?


 --- "BARTKO, Zoltan" <bartko.zoltan@pobox.sk> wrote:
> Have you ever tried KDevelop (www.kdevelop.org)? it
> is part of KDE
> (www.kde.org), the newest version is going to be
> realesed very soon, but KDE
> 3.2 beta 1 was released already, get the tarballs
> from the above mentionned
> address. I like it a lot, but you should check it
> out, if it suits your
> needs.
>
> Cheers,
>
> Zoltan
>
> ----- Original Message -----
> From: "jini us" <jiniusuk@yahoo.co.uk>
> To: "Mike Mascari" <mascarm@mascari.com>
> Cc: <pgsql-general@postgresql.org>
> Sent: Friday, November 14, 2003 4:28 AM
> Subject: Re: [GENERAL] embedded postgresql + C++ IDE
>
>
> >
> > I have just downloaded that one.
> > It doesn't any features for designing GUI forms.
> > It is just a project manager.
> >
> >
> >  --- Mike Mascari <mascarm@mascari.com> wrote: >
> jini
> > us wrote:
> > >
> > > > Anybody knows of a c++ IDE, similar to
> Microsoft
> > > > studio but free.
> > > > Also good C++ site where I can pick up free
> > > > components.
> > >
> > > I've never used it but if download statistics is
> > > correlated in any way
> > > to quality Dev-C++ is one of the top downloads
> on
> > > sourceforge:
> > >
> > > http://sourceforge.net/projects/dev-cpp/
> > >
> > > Mike Mascari
> > > mascarm@mascari.com
> > >
> > >
> > >
> > >
> >
> >
>
________________________________________________________________________
> > Want to chat instantly with your online friends?
> Get the FREE Yahoo!
> > Messenger http://mail.messenger.yahoo.co.uk
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql + C++ IDE

From
Shridhar Daithankar
Date:
On Friday 14 November 2003 18:47, jini us wrote:
> I was looking at the screen shots and the screen shots
> do not show any features for GUI  drag + drop
> development.
>
> Does it have a GUI drag + drop for drawing windows
> components ?

Yes. It has Qt designer which supports custom KDE widgets but two things.

1. This discussion is offtopic on this list.
2. I don't know how many people use DnD to design GUIs. Qt offers so much
control that it is rather tempting to do GUI in text editor.

 Shridhar


Re: embedded postgresql + C++ IDE

From
"Joshua D. Drake"
Date:
If you are using Linux for development, you can use QTDesigner or any
number of GTK based tools.

jini us wrote:

>I was looking at the screen shots and the screen shots
>do not show any features for GUI  drag + drop
>development.
>
>Does it have a GUI drag + drop for drawing windows
>components ?
>
>
> --- "BARTKO, Zoltan" <bartko.zoltan@pobox.sk> wrote:
>
>
>>Have you ever tried KDevelop (www.kdevelop.org)? it
>>is part of KDE
>>(www.kde.org), the newest version is going to be
>>realesed very soon, but KDE
>>3.2 beta 1 was released already, get the tarballs
>>from the above mentionned
>>address. I like it a lot, but you should check it
>>out, if it suits your
>>needs.
>>
>>Cheers,
>>
>>Zoltan
>>
>>----- Original Message -----
>>From: "jini us" <jiniusuk@yahoo.co.uk>
>>To: "Mike Mascari" <mascarm@mascari.com>
>>Cc: <pgsql-general@postgresql.org>
>>Sent: Friday, November 14, 2003 4:28 AM
>>Subject: Re: [GENERAL] embedded postgresql + C++ IDE
>>
>>
>>
>>
>>>I have just downloaded that one.
>>>It doesn't any features for designing GUI forms.
>>>It is just a project manager.
>>>
>>>
>>> --- Mike Mascari <mascarm@mascari.com> wrote: >
>>>
>>>
>>jini
>>
>>
>>>us wrote:
>>>
>>>
>>>>>Anybody knows of a c++ IDE, similar to
>>>>>
>>>>>
>>Microsoft
>>
>>
>>>>>studio but free.
>>>>>Also good C++ site where I can pick up free
>>>>>components.
>>>>>
>>>>>
>>>>I've never used it but if download statistics is
>>>>correlated in any way
>>>>to quality Dev-C++ is one of the top downloads
>>>>
>>>>
>>on
>>
>>
>>>>sourceforge:
>>>>
>>>>http://sourceforge.net/projects/dev-cpp/
>>>>
>>>>Mike Mascari
>>>>mascarm@mascari.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>________________________________________________________________________
>
>
>>>Want to chat instantly with your online friends?
>>>
>>>
>>Get the FREE Yahoo!
>>
>>
>>>Messenger http://mail.messenger.yahoo.co.uk
>>>
>>>---------------------------(end of
>>>
>>>
>>broadcast)---------------------------
>>
>>
>>>TIP 6: Have you searched our list archives?
>>>
>>>               http://archives.postgresql.org
>>>
>>>
>>>
>>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>
>________________________________________________________________________
>Want to chat instantly with your online friends?  Get the FREE Yahoo!
>Messenger http://mail.messenger.yahoo.co.uk
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL.Org - Editor-N-Chief - http://www.postgresql.org



Re: embedded postgresql

From
Christopher Browne
Date:
jiniusuk@yahoo.co.uk (jini us) writes:
> So when the user starts my application I would start the database
> server, then stop it programmatically when the user stops using the
> application.

> I would obviously need some functionality so that I can programmatically
> configure which disk I would use to create the database. 

It is not necessary for PostgreSQL to be a "DLL" in order to all of do
these things.

Your application can configure where the database server is supposed
to find its data, and spawn the database server.

This came up a while back on the GnuCash discussion list, and I
described how you'd start up a 'pseudo-embedded' instance of
PostgreSQL:

<http://www.gnucash.org/pipermail/gnucash-devel/2003-June/009418.html>

Code to initialize and start up the database:
-----------------------------------------------------------------------
mkdir("~/GnuCash/DB");
system("initdb -d ~/GnuCash/DB");
[dribble a few changes into ~/GnuCash/DB/{pg_hba|postgres}.conf,
   notably turning on TCP/IP, picking a port #, probably not too
   much else...]
system("pg_ctl -D ~/GnuCash/DB start");
-----------------------------------------------------------------------

Code to stop it upon exiting the application:
-----------------------------------------------------------------------
system("pg_ctl -D ~/GnuCash/DB stop");
-----------------------------------------------------------------------

I daresay I was a just little bit dogmatic about it, and the approach
was not accepted particularly graciously...

<http://www.gnucash.org/pipermail/gnucash-devel/2003-June/009449.html>

-------------------------------------------------------------------
Derek Atkins wrote:
> Christopher Browne <gnucash at cbbrowne.com> writes:
>
> > It seems no more reasonable to expect that casual home users have to:
> >
> >  - Run mke2fs, or whatever else is involved in setting up filesystems;
> >  - Run whatever frightening incantations are involved in getting X
> >    working.
>
> If this is how you feel then you are grossly over-estimating the
> competence and skillset of the average user.  Most users grab the
> Red Hat install media and click "go".  They have no clue what mke2fs
> is.  They have no clue how to set up X.

It nonetheless happens, does it not?  They _do_ have to cope with it,
in some manner, because X and ext2 don't get there by magic.

Reciting some mantra of "embedded database, embedded database" will
also not lead to the system being simpler just because it gets
repeated enough times.

... much elided ...

But none of that changes the vital points, that
 - The "embedded" process belongs to the user;
 - So do the files;
 - It does NOT forcibly require a sysadmin's attentions.
-------------------------------------------------------------------

> I am hoping to be able to create the database on a virtual drive /
> network drive programmatically from my application.

So long as you can run the program:

  pg_ctl -D X:\WHEREVER_THE_DATA_IS start

there oughtn't be a problem with doing this.

It is a little bit disappointing that people _haven't_ documented the
use of this sort of approach to have PostgreSQL be 'quasi-embedded' in
such a manner that the database instance is not made manifestly
visible.
--
"aa454","@","freenet.carleton.ca"
http://cbbrowne.com/info/rdbms.html
Why  are  there  flotation   devices  under  plane  seats  instead  of
parachutes?

Re: embedded postgresql

From
Christopher Browne
Date:
In the last exciting episode, jiniusuk@yahoo.co.uk (jini us) wrote:
> It is a shame that postgres is not available as an embedded server
> unlike mysql database server which comes in the form of a dll.

When the postmaster runs as a separate process, this has three major
merits:

 1.  It takes advantage of the fact that modern operating systems are
     quite GOOD at spawning multiple processes.  VMS and MVS are
     historically _atrociously_ slow at this, but on Windows NT, the
     cost of spawning one process can't be _too_ dramatic.

 2.  It improves reliability since processes using data can't
     accidentally corrupt the database process(es).

 3.  As soon as there is more than one process using data, there is
     a savings in memory consumption since the overhead of
     establishing dynamic parts of database context only need be paid
     once.

That you regard it as a vital "doctrine" that it should be preferable
to embed databases using DLLs does not establish either that:

 a) The doctrine is actually valid, or

 b) The architecture of PostgreSQL is likely to be changed to conform
    to that doctrine.

You might instead investigate the notion of running PostgreSQL as a
separate process, and see if you can find a way to use it, despite the
apparent misfit of expectations.  If you fight with PostgreSQL, things
will doubtless go badly.  If you try to find a way of cooperating with
its architecture, you might find some pleasant surprises...

> However with mysql licence I would have to pay $10,000 if I wish to
> include it in mysql as an embedded server in my app.

Wow, that is rather expensive.  I thought MySQL was supposed to be
"free software," what with being licensed under the GPL and all...
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','cbbrowne.com').
http://www3.sympatico.ca/cbbrowne/postgresql.html
"I'm sorry, the teleportation booth you have reached is not in service
at this  time.   Please  hand-reassemble  your molecules or   call  an
operator to help you...."

Re: embedded postgresql

From
"Stephen"
Date:
PostgreSQL is not intended to be embedded into other programs. You might
want to try SQLite, it's a free embeddable SQL engine:

http://go.jitbot.com/sqlite

regards


"jini us" <jiniusuk@yahoo.co.uk> wrote in message
news:20031113005012.81195.qmail@web86110.mail.ukl.yahoo.com...
> Hi,
>
> I am starting a new project where I intend to use
> embedded database server in my win32 application.
> I intend to use VC++ microsoft studio 6.0 as my
> development environment.
>
> The postgres.org website seems to be catering for
> people with all sorts of requirements and platforms.
>
> 1. Where can I find the binary distribution so that I
> can  use postgres server as an embedded database.
> I assume it is a .dll
>
> 2. Also I would like to have the documentation which
> shows how to start & stop the server programmatically
> and execute sql, to create a database, use select
> insert , update etc.
>
> 3. Is it correct that I do not have to pay any user
> licences.
> Postgres is free not only for development but also I
> can include it in my software package.
>
> Thanks.
>
>
>
>
>
>
>
>
> ________________________________________________________________________
> Want to chat instantly with your online friends?  Get the FREE Yahoo!
> Messenger http://mail.messenger.yahoo.co.uk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>



Re: embedded postgresql + C++ IDE

From
jini us
Date:
I am using MS windows so ideally I would like
to get hold of a binary for  MS windows

 --- "Joshua D. Drake" <jd@commandprompt.com> wrote: >
If you are using Linux for development, you can use
> QTDesigner or any
> number of GTK based tools.
>
> jini us wrote:
>
> >I was looking at the screen shots and the screen
> shots
> >do not show any features for GUI  drag + drop
> >development.
> >
> >Does it have a GUI drag + drop for drawing windows
> >components ?
> >
> >
> > --- "BARTKO, Zoltan" <bartko.zoltan@pobox.sk>
> wrote:
> >
> >
> >>Have you ever tried KDevelop (www.kdevelop.org)?
> it
> >>is part of KDE
> >>(www.kde.org), the newest version is going to be
> >>realesed very soon, but KDE
> >>3.2 beta 1 was released already, get the tarballs
> >>from the above mentionned
> >>address. I like it a lot, but you should check it
> >>out, if it suits your
> >>needs.
> >>
> >>Cheers,
> >>
> >>Zoltan
> >>
> >>----- Original Message -----
> >>From: "jini us" <jiniusuk@yahoo.co.uk>
> >>To: "Mike Mascari" <mascarm@mascari.com>
> >>Cc: <pgsql-general@postgresql.org>
> >>Sent: Friday, November 14, 2003 4:28 AM
> >>Subject: Re: [GENERAL] embedded postgresql + C++
> IDE
> >>
> >>
> >>
> >>
> >>>I have just downloaded that one.
> >>>It doesn't any features for designing GUI forms.
> >>>It is just a project manager.
> >>>
> >>>
> >>> --- Mike Mascari <mascarm@mascari.com> wrote: >
> >>>
> >>>
> >>jini
> >>
> >>
> >>>us wrote:
> >>>
> >>>
> >>>>>Anybody knows of a c++ IDE, similar to
> >>>>>
> >>>>>
> >>Microsoft
> >>
> >>
> >>>>>studio but free.
> >>>>>Also good C++ site where I can pick up free
> >>>>>components.
> >>>>>
> >>>>>
> >>>>I've never used it but if download statistics is
> >>>>correlated in any way
> >>>>to quality Dev-C++ is one of the top downloads
> >>>>
> >>>>
> >>on
> >>
> >>
> >>>>sourceforge:
> >>>>
> >>>>http://sourceforge.net/projects/dev-cpp/
> >>>>
> >>>>Mike Mascari
> >>>>mascarm@mascari.com
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
>
>________________________________________________________________________
> >
> >
> >>>Want to chat instantly with your online friends?
> >>>
> >>>
> >>Get the FREE Yahoo!
> >>
> >>
> >>>Messenger http://mail.messenger.yahoo.co.uk
> >>>
> >>>---------------------------(end of
> >>>
> >>>
> >>broadcast)---------------------------
> >>
> >>
> >>>TIP 6: Have you searched our list archives?
> >>>
> >>>               http://archives.postgresql.org
> >>>
> >>>
> >>>
> >>>
> >>---------------------------(end of
> >>broadcast)---------------------------
> >>TIP 4: Don't 'kill -9' the postmaster
> >>
> >>
> >
>
>________________________________________________________________________
> >Want to chat instantly with your online friends?
> Get the FREE Yahoo!
> >Messenger http://mail.messenger.yahoo.co.uk
> >
> >---------------------------(end of
> broadcast)---------------------------
> >TIP 8: explain analyze is your friend
> >
> >
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL -
> S/ODBC - S/JDBC
> Postgresql support, programming, shared hosting and
> dedicated hosting.
> +1-503-222-2783 - jd@commandprompt.com -
> http://www.commandprompt.com
> PostgreSQL.Org - Editor-N-Chief -
> http://www.postgresql.org
>
>

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql

From
jini us
Date:
I would class your solution as a work around
rather than a "natural solution".

Anyway I am using  MS windows and to implement
postgres as embedded, using your approach, would
probably become complicated.
.It would probably introduce unwanted bugs in my
software.


 --- Christopher Browne <cbbrowne@acm.org> wrote: >
jiniusuk@yahoo.co.uk (jini us) writes:
> > So when the user starts my application I would
> start the database
> > server, then stop it programmatically when the
> user stops using the
> > application.
>
> > I would obviously need some functionality so that
> I can programmatically
> > configure which disk I would use to create the
> database.
>
> It is not necessary for PostgreSQL to be a "DLL" in
> order to all of do
> these things.
>
> Your application can configure where the database
> server is supposed
> to find its data, and spawn the database server.
>
> This came up a while back on the GnuCash discussion
> list, and I
> described how you'd start up a 'pseudo-embedded'
> instance of
> PostgreSQL:
>
>
<http://www.gnucash.org/pipermail/gnucash-devel/2003-June/009418.html>
>
> Code to initialize and start up the database:
>
-----------------------------------------------------------------------
> mkdir("~/GnuCash/DB");
> system("initdb -d ~/GnuCash/DB");
> [dribble a few changes into
> ~/GnuCash/DB/{pg_hba|postgres}.conf,
>    notably turning on TCP/IP, picking a port #,
> probably not too
>    much else...]
> system("pg_ctl -D ~/GnuCash/DB start");
>
-----------------------------------------------------------------------
>
> Code to stop it upon exiting the application:
>
-----------------------------------------------------------------------
> system("pg_ctl -D ~/GnuCash/DB stop");
>
-----------------------------------------------------------------------
>
> I daresay I was a just little bit dogmatic about it,
> and the approach
> was not accepted particularly graciously...
>
>
<http://www.gnucash.org/pipermail/gnucash-devel/2003-June/009449.html>
>
>
-------------------------------------------------------------------
> Derek Atkins wrote:
> > Christopher Browne <gnucash at cbbrowne.com>
> writes:
> >
> > > It seems no more reasonable to expect that
> casual home users have to:
> > >
> > >  - Run mke2fs, or whatever else is involved in
> setting up filesystems;
> > >  - Run whatever frightening incantations are
> involved in getting X
> > >    working.
> >
> > If this is how you feel then you are grossly
> over-estimating the
> > competence and skillset of the average user.  Most
> users grab the
> > Red Hat install media and click "go".  They have
> no clue what mke2fs
> > is.  They have no clue how to set up X.
>
> It nonetheless happens, does it not?  They _do_ have
> to cope with it,
> in some manner, because X and ext2 don't get there
> by magic.
>
> Reciting some mantra of "embedded database, embedded
> database" will
> also not lead to the system being simpler just
> because it gets
> repeated enough times.
>
> ... much elided ...
>
> But none of that changes the vital points, that
>  - The "embedded" process belongs to the user;
>  - So do the files;
>  - It does NOT forcibly require a sysadmin's
> attentions.
>
-------------------------------------------------------------------
>
> > I am hoping to be able to create the database on a
> virtual drive /
> > network drive programmatically from my
> application.
>
> So long as you can run the program:
>
>   pg_ctl -D X:\WHEREVER_THE_DATA_IS start
>
> there oughtn't be a problem with doing this.
>
> It is a little bit disappointing that people
> _haven't_ documented the
> use of this sort of approach to have PostgreSQL be
> 'quasi-embedded' in
> such a manner that the database instance is not made
> manifestly
> visible.
> --
> "aa454","@","freenet.carleton.ca"
> http://cbbrowne.com/info/rdbms.html
> Why  are  there  flotation   devices  under  plane
> seats  instead  of
> parachutes?
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql

From
Dustin Sallings
Date:
On Nov 14, 2003, at 14:13, jini us wrote:

> I would class your solution as a work around
> rather than a "natural solution".

    It really seemed like the obvious way to do it (I'm sure I'm not the
only person who thought of that, but didn't post it).

> Anyway I am using  MS windows and to implement
> postgres as embedded, using your approach, would
> probably become complicated.
> .It would probably introduce unwanted bugs in my
> software.

    I believe it would be you introducing those bugs if you do not
initialize the DB correctly, regardless of the mechanism.

    Now, how many bugs do you think it would create in postgres if the
entire interface model were changed from postmaster/postgres processes
to having multiple threads in a single application trying to issue
queries in the in-process DB.  What happens to the DB when your app
segfaults?  Are there any signal handlers postgres uses that you would
want to use in your app?  Do you really need to redesign the way
postgres works just because you don't want to manage the resource as a
process rather than a different type of API?

--
Dustin Sallings


Re: embedded postgresql

From
"Nigel J. Andrews"
Date:
On Fri, 14 Nov 2003, Dustin Sallings wrote:

>
> On Nov 14, 2003, at 14:13, jini us wrote:
>
> > I would class your solution as a work around
> > rather than a "natural solution".
>
>     It really seemed like the obvious way to do it (I'm sure I'm not the
> only person who thought of that, but didn't post it).

LOL, I was just composing and then aborted an answer mentioning mindsets and it
being natural to me.

>
> > Anyway I am using  MS windows and to implement
> > postgres as embedded, using your approach, would
> > probably become complicated.
> > .It would probably introduce unwanted bugs in my
> > software.
>
>     I believe it would be you introducing those bugs if you do not
> initialize the DB correctly, regardless of the mechanism.

An objection made, if I read the edited out sections correctly, that a user
shouldn't have to worry about formating the chosen disk etc, it should just
happen. Well there's nothing in this solution that prevents that from
happening. Indeed, if there's no user involvement in configuring a linked in
embedded solution then there's no user involvement required in the
configuration. How does "no user involvement required" morph into "user must do
stuff"?

>
>     Now, how many bugs do you think it would create in postgres if the
> entire interface model were changed from postmaster/postgres processes
> to having multiple threads in a single application trying to issue
> queries in the in-process DB.  What happens to the DB when your app
> segfaults?  Are there any signal handlers postgres uses that you would
> want to use in your app?  Do you really need to redesign the way
> postgres works just because you don't want to manage the resource as a
> process rather than a different type of API?

Write a library that provides the API required to which the app. can be linked
but which chats/controls the server.

If I want to find files in one directory (or folder :) that exist in another I
don't ask that bash, korn shell etc. be linked with a new library for the
job. No, I use the existing components in a combination that does the job.


--
Nigel J. Andrews

( ( cd onedirectory; ls ); ( cd otherdirectory; ls ) ) | sort | uniq -d
if you really want to know.



Re: embedded postgresql

From
Dustin Sallings
Date:
On Nov 14, 2003, at 15:43, Nigel J. Andrews wrote:

> LOL, I was just composing and then aborted an answer mentioning
> mindsets and it
> being natural to me.

    [...]

> Write a library that provides the API required to which the app. can
> be linked
> but which chats/controls the server.

    Haha.  I was just having this conversation with a co-worker.  I was
suggesting writing a -lpqembed and giving it out as the ``embedded
solution.''

    Because really, who would care about the difference?

    Now, if only I had a use for such a thing...

--
Dustin Sallings


Re: embedded postgresql

From
jini us
Date:
I have come to the conclusion that for my purpose
I would be better off using sqlite from www.sqlite.org
or firebird from www.phoenix.com.

Although mysql provides client APIs & server APIs
and is stable.
But there seems to be doubt whether mysql is actually
free if I wish to use it as an embedded database.

It has been suggested that I would have to pay
$10,000 one off licence fee if I include mysql in my
app.
Another person suggested that mysql is free to include
in my app, so I am simply not sure over the licence
costs of mysql.

 --- Dustin Sallings <dustin@spy.net> wrote: >
> On Nov 14, 2003, at 14:13, jini us wrote:
>
> > I would class your solution as a work around
> > rather than a "natural solution".
>
>     It really seemed like the obvious way to do it (I'm
> sure I'm not the
> only person who thought of that, but didn't post
> it).
>
> > Anyway I am using  MS windows and to implement
> > postgres as embedded, using your approach, would
> > probably become complicated.
> > .It would probably introduce unwanted bugs in my
> > software.
>
>     I believe it would be you introducing those bugs if
> you do not
> initialize the DB correctly, regardless of the
> mechanism.
>
>     Now, how many bugs do you think it would create in
> postgres if the
> entire interface model were changed from
> postmaster/postgres processes
> to having multiple threads in a single application
> trying to issue
> queries in the in-process DB.  What happens to the
> DB when your app
> segfaults?  Are there any signal handlers postgres
> uses that you would
> want to use in your app?  Do you really need to
> redesign the way
> postgres works just because you don't want to manage
> the resource as a
> process rather than a different type of API?
>
> --
> Dustin Sallings
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

Re: embedded postgresql

From
Christopher Browne
Date:
After a long battle with technology, jiniusuk@yahoo.co.uk (jini us), an earthling, wrote:
> It has been suggested that I would have to pay
> $10,000 one off licence fee if I include mysql in my
> app.
> Another person suggested that mysql is free to include
> in my app, so I am simply not sure over the licence
> costs of mysql.

There is a ready way of disambiguating _that_ part; were you planning
to license your application under the terms of the GPL?  If so, then
there is license compatibility, and you oughtn't need to pay anything.

If you were NOT planning to use the GPL, then you'll need to for
license fees of on the order of $500 per "server," where presumably
each deployment of your application attracts a license charge.

A $10K arrangement sounds like a minimum charge where you might be
buying 30 or so licenses up front, and would get a pretty steep
discount on the basis of prepaying for licenses.  (SolidTech went to a
model similar to that; they used to sell licenses for about
$150/server, and some users were quite chagrined when they discovered
they couldn't get small numbers of licenses anymore...)  But that's
only a wild guess; the company doesn't publish that information
publicly on their pricing web page.

In any case, it is really not a matter that would be properly
addressed here; you really should contact their sales department to
get authoritative details.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://www3.sympatico.ca/cbbrowne/x.html
Keeping a secret "Hall Of Flame" file  of people's mail indiscretions,
or copying messages to  private mailing lists for subsequent derision,
is good  fun  and also  a worthwhile  investment  in case  you need to
blackmail  the senders later.   -- from  the Symbolics Guidelines  for
Sending Mail

Re: embedded postgresql

From
Christopher Browne
Date:
After a long battle with technology, jiniusuk@yahoo.co.uk (jini us),
an earthling, wrote:
> I would class your solution as a work around rather than a "natural
> solution".

It may not be the approach you _expected_.

> Anyway I am using MS windows and to implement postgres as embedded,
> using your approach, would probably become complicated.

Sure, you'll have to decide where to put the directory.  That could
get quite hideous...

> It would probably introduce unwanted bugs in my software.

But THAT seems very odd.  Can you be more specific about the sorts of
bugs that would be expected to appear by virtue of _not_ including the
"postmaster" inside your application?

I would think the opposite would be true; that this would _diminish_
the likelihood of bugs, since it would outright eliminate the
possibility of your own code accidentally trampling on database
memory, which is a BIG risk that would be introduced by embedding the
database in your application.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www3.sympatico.ca/cbbrowne/linuxxian.html
Who  needs fault-tolerant  computers when  there's obviously  an ample
market of fault-tolerant users?

Re: embedded postgresql

From
Paul Ganainm
Date:
cbbrowne@acm.org says...


> > However with mysql licence I would have to pay $10,000 if I wish to
> > include it in mysql as an embedded server in my app.

> Wow, that is rather expensive.  I thought MySQL was supposed to be
> "free software," what with being licensed under the GPL and all...


Only if your app is GPL'd also - if you want to charge money for it and
make it closed source, then you pay - I did think that 10.000 was a bit
on the steep side.


Paul...


--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

Re: embedded postgresql

From
Paul Ganainm
Date:
jiniusuk@yahoo.co.uk says...


> It has been suggested that I would have to pay
> $10,000 one off licence fee if I include mysql in my
> app.


https://order.mysql.com/


Seems to be 500 dollars to me.


Paul...


--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.