Skip site navigation (1) Skip section navigation (2)

Re: support for embedded db and a clustered index?

From: Paul Bohme <paul(dot)bohme(at)brivo(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Julian Bui <julianbui(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: support for embedded db and a clustered index?
Date: 2008-10-26 14:21:46
Message-ID: 49047CFA.8060503@brivo.com (view raw or flat)
Thread:
Lists: pgsql-general
Scott Marlowe wrote:
>
>> Also, can pgsql be embedded in an application?  By that I mean it is easily
>> deployable with an application.
>>     
>
> Not really the same thing.  PostgreSQL is not embeddable in the
> classic sense, and if you need an embedded database, look at SQLLite.
>
>   
...
>> I do NOT mean
>> a db that runs on an embedded device (although I am hoping pgsql has a small
>> memory footprint) and I also do NOT mean to ask if pgsql supports embedded
>> sql.
>>     
>
> PostgreSQL is not optimized for small memory or disk footprint, it is
> optimized for using more memory and being fast and reliable.  I think
> you might want SQLLite for this job.
>   

I would second the recommendation for SQLite.  Am using it extensively 
in an embedded application with reasonably low constraints (32M of RAM 
and flash) and have nothing but good to say about it.  (I find that its 
C API kicks the tar out of Postgres' API, for usability/friendliness 
btw. ;-)

Different tools for different jobs..

  -P

-- 
Paul Bohme | Chief Technologist
Brivo Systems LLC | 4330 East-West Highway Suite 250 Bethesda, MD 20814
Office: 301.664.5249 | Fax: 301.664.5264 | paul(dot)bohme(at)brivo(dot)com
Brivo's Official Website is: www.brivo.com


In response to

pgsql-general by date

Next:From: JeffDate: 2008-10-26 15:47:24
Subject: Re: again...
Previous:From: ThomasDate: 2008-10-26 13:12:36
Subject: Re: How to tell PostgreSQL about a relationship

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group