Re: embedded postgresql

 
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