Re: Version 8.1

Lists: pgsql-novice
From: "Saloom, Joe \(Space Technology\)" <joe(dot)saloom(at)ngc(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Version 8.1
Date: 2006-02-16 19:05:02
Message-ID: C448EC7056762442858D09FC8380D112997598@XCGC3008.northgrum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

Is this database just standalone or can it be embedded. All the info
that you can find concerning this would be greatly appreciated.

Thank you,

joe


From: <operationsengineer1(at)yahoo(dot)com>
To: "Saloom, Joe \(Space Technology\)" <joe(dot)saloom(at)ngc(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Version 8.1
Date: 2006-02-17 01:04:47
Message-ID: 20060217010447.9923.qmail@web33306.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

--- "Saloom, Joe (Space Technology)"
<joe(dot)saloom(at)ngc(dot)com> wrote:

> Is this database just standalone or can it be
> embedded. All the info
> that you can find concerning this would be greatly
> appreciated.
>
> Thank you,
>
> joe

Joe, i'm no guru, but it would probably help if you
defined "embedded."

i've never heard of an embedded database and i'm
curious as to what it is.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Version 8.1
Date: 2006-02-17 05:56:54
Message-ID: 878xsav87t.fsf@wolfe.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

The world rejoiced as joe(dot)saloom(at)ngc(dot)com ("Saloom, Joe \(Space Technology\)") wrote:
> Is this database just standalone or can it be embedded.  All the
> info that you can find concerning this would be greatly appreciated.

If, by "embedded," you mean that the database would run inside some
existing process, the answer is a clear "no, not gonna do that."

If you *truly* need an "embedded" database, you should probably look
into SQLite.

It would be possible to mostly hide a PostgreSQL instance, via:
- creating some local directory inside your application filesystem
where it would hide
- don't turn on TCP/IP; only use Unix Domain Sockets to communicate
with the instance
- make sure the UDS is created somewhere "hidden" in the application
filesystem so it isn't readily visible to users on the system

That would still consist of multiple processes independent of the
application...
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/slony.html
Rules of the Evil Overlord #218. "I will not pick up a glowing ancient
artifact and shout "Its power is now mine!!!" Instead I will grab some
tongs, transfer it to a hazardous materials container, and transport
it back to my lab for study." <http://www.eviloverlord.com/>


From: John DeSoi <desoi(at)pgedit(dot)com>
To: "Saloom, Joe ((Space Technology))" <joe(dot)saloom(at)ngc(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Version 8.1
Date: 2006-02-17 13:26:10
Message-ID: A688B0C8-172E-4F96-9D4D-1AC3FFF33072@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice


On Feb 16, 2006, at 2:05 PM, Saloom, Joe ((Space Technology)) wrote:

> Is this database just standalone or can it be embedded. All the
> info that you can find concerning this would be greatly appreciated.

PostgreSQL is designed to be a multi-user client/server database. You
won't find an easy way to embed it in another application.

Search the mailing list archives for previous discussions about this.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL