From: | jini us <jiniusuk(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: embedded postgresql |
Date: | 2003-11-13 20:36:49 |
Message-ID: | 20031113203649.55634.qmail@web86108.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)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(at)commandprompt(dot)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(at)commandprompt(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-11-13 21:10:19 | Re: More Praise for 7.4RC2 |
Previous Message | Christopher Browne | 2003-11-13 20:36:13 | Re: More Praise for 7.4RC2 |