pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Aaron Bono <postgresql@aranya.com>
To: Amadeus Zilfinski <amadeus0@cox.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: running PostGres without installing it
Date: Sun, 6 Aug 2006 15:13:59 -0500
Message-ID: <bf05e51c0608061313h28973179nee1b094e660cff26@mail.gmail.com> (raw)
In-Reply-To: <1154891491.3403.11.camel@workstation01.barsandtone.com>
References: <20060806040747.99775.qmail@web32509.mail.mud.yahoo.com>
	<bf05e51c0608061109x368a06b3uec4a7c5ff38ff58e@mail.gmail.com>
	<1154891491.3403.11.camel@workstation01.barsandtone.com>

On 8/6/06, Amadeus Zilfinski <amadeus0@cox.net> wrote:
>
> <snip>
> >
> > For years I have struggled with desktop applications and data
> > access/storage.  Databases are very powerful tools but, other than MS
> > Access, I have not seen any that are easily distributable bundled with
> > a desktop application.  Not having a personal database to bundle with
> > my applications has proven to be a "one hand tied behind my back"
> > situation.
> >
> > Any ideas you guys have would be deeply appreciated.
> >
>
> SQLite can be complied to a single binary/.dll/.so and used. That is the
> route I'm looking at due to having to be an 'expert' to install
> PostgresQL, and how invasive it can be on a system. I don't have any
> experience with firebird or MySQL, so you might want to check out those.



Would something like SQLite support the full functionality that we get from
PostgreSQL: subqueries, transactions, views, triggers and stored
procedures?  MySQL does not (yes I know they are adding some or all of this
but it isn't all there or proven to be reliable yet).

I will check SQLite out but MySQL is probably NOT a good option for this.
Historically it did not support subqueries (an absolute must for any serious
database user) - not sure if they have added subquery support recently or
not.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

view thread (9+ messages)  latest in thread

Message-ID: <bf05e51c0608061313h28973179nee1b094e660cff26@mail.gmail.com>
Permalink:  ../bf05e51c0608061313h28973179nee1b094e660cff26@mail.gmail.com/
Also on:    postgresql.org/message-id/bf05e51c0608061313h28973179nee1b094e660cff26@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: postgresql@aranya.com, amadeus0@cox.net
  Subject: Re: running PostGres without installing it
  In-Reply-To: <bf05e51c0608061313h28973179nee1b094e660cff26@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox