[thelist] probably simple SQL question
Joel Lieberman
joel_lieberman at yahoo.com
Sat Jan 19 07:30:02 CST 2002
How about PostgreSQL - open-source, free, well
supported, handles foreign keys, triggers, all manner
of queries, procedures, transactions, etc.?
joel
--- ".jeff" <jeff at members.evolt.org> wrote:
> andrew,
>
>
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > From: Andrew Clover
> >
> > > If this wasn't such a small project I'd consider
> a
> > > more robust database.
> >
> > For most non-critical web applications it's not
> > massively important to enforce complete
> consistency
> > using transactions, but I'd consider using a more
> robust
> > database anyway.
>
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> agreed. there are *many* projects that can get away
> without support for
> transactions depending on your database
> architecture. however, i would say
> that as soon as you get into a project with
> e-commerce, you damn well better
> have the ability to wrap an entire bit of logic up
> as a single transaction.
>
>
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > Access is a desktop database, and Jet is not a
> 'real'
> > database server as such. In practice I have had
> > unexplained hangs in accessing MDBs through ODBC
> even
> > with test-phase websites under no significant
> load.
>
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> in contrast, the first version of evolt.org used
> access with no worries at
> all (except for the couple of times we were
> slashdotted).
>
>
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > When you can get a proper database server with
> > transactions and everything for free (eg.
> MySQL/InnoDB
> > for Windows) [...]
>
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> if you're lucky enough to be on a host that has the
> latest version (4.0)
> installed. if not, then you don't have the
> fail-safe of transactions.
>
> http://www.mysql.com/products/mysql-4.0/index.html
>
> imo, there are other *much* bigger obstacles in the
> way of using mysql in an
> enterprise application. it doesn't yet support
> nested subqueries, foreign
> key integrity rules, or even stored procedures which
> are all staples in a
> performance minded application developer's toolbox.
> it's claimed these
> things will be in v4.1, but who knows how long
> before that's released.
> mysql v4.0 was released over 3 months ago, but only
> in available in an alpha
> release. who knows how long until the kinks are
> ironed out and it's labeled
> a "stable release" and there's still no hint of v4.1
> yet.
>
> at least access has all of these features already.
> ;p
>
> just my 2c,
>
> .jeff
>
> http://evolt.org/
> jeff at members.evolt.org
> http://members.evolt.org/jeff/
>
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
More information about the thelist
mailing list