[clue-tech] MySQL vs. Postgres: Was additional study groups ...

[Jack Parker]

I would suggest taking a look at what used to be called Cloudscape - before
it went open source.  It's lightweight (it can run on your pda), but it has
roots in the enterprise class world.  It is now called Derby.  I gather the
starting point is
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury
I have not explored it personally, but for the purposes that I see floating
around, it may make better sense.  Certainly I have not been amused by
MySQL, I have yet to have the pleasure of wrestling with Postgres.

cheers
j.

-----Original Message-----
From: clue-tech-bounces at cluedenver.org
[mailto:clue-tech-bounces at cluedenver.org]On Behalf Of dperkins at frii.com
Sent: Sunday, November 20, 2005 7:33 PM
To: CLUE tech
Subject: Re: [clue-tech] MySQL vs. Postgres: Was additional study groups
...



>> Most of these SQL neophites also only use one table vice many.
>
> One table isn't a database, it's a spreadsheet.  I've seen that done
> frequently (first you use a spreadsheet because it's an easy way to lay
> out a table; then you use Access because you can put a fancy form on the
> front; then you either go back to a spreadsheet because you need fancy
> calculations or you get a real database because someone with a clue
> realizes you need more than one table (and people with clues don't use
> Access)).
>
> Cheers!
> Dave
>

I never thought about it in this way, but I agree.  I recently convinced
my supervisor to use a database instead of the spreadsheet he was
planning.  I showed him what a proper hierarchical database can do and,
mirabile dictu, he agreed.

I haven't developed any Access databases since 1999, and at that time I
was forced to work with the tools I had available on Windows 3.1.  I
remember that every time a new version came out, I had to fix my database.
 One time they broke my custom code so bad I couldn't even fix it on the
new version... Access crashed immediately.  Fortunately, one computer had
been missed in the upgrade.  Another time, MS broke the standard Basic
code that Access created automatically.  I don't know if MS does better
now, but I have not recommended Access for reasons like this.

_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech

_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech