Ok, mike already filled you in on MySQL so i'll
do the Postgres advocacy ;-)
Transactions, triggers, rollbacks and stored procedures mean that you can
use the db itself to handle some of the housekeeping logic.
The speed difference between the two is not likely to affect you unless
you're slashdot.
You can configure postgres to use any port(default is 5432), and it's got
all sorts of options for controlling access by host, auth_method, login
etc.
Even so it runs fine on my creaky old laptop P90 24mb so i really don't
think you need to worry about having enough computer to run it.
pg also has some funky stuff, like object-relational mappings, rich
datatypes and enough foreign language interfaces to keep everyone
functional.
Larry Price | "We have seen the truth.
[EMAIL PROTECTED] | And the truth makes no sense." -chesterton
_______________________________________________________________
On Wed, 11 Jul 2001, Justin Bengtson wrote:
> background :
> i'm a gamer geek. i had this wild idea last night amid a heat-induced
> trance of keeping a SQL database of NPC's. also, my employer is gearing me
> up for SQL programming, which makes this an excellent side-project.
>
> question :
> who's better? PostgreSQL, MySQL, or some other flavor i haven't heard of?
> further, if it's a small database (100mb,most likely far less...), will
> there be any problems with my P-166-MMX firewall doing double-duty? and is
> that computer beefy enough to handle a SQL database (128mb ram, 2 PCI NIC's
> for packet inspection)? i'm going to assume that the database must be
> local. can it be on a hard drive other than "hda"? all i know is a little
> SQL 7. do any of these linux databases have a command structure near or
> like SQL 7? also, what ports do i have to open up on my internal LAN to
> make this happen?
>
> thanks in advance!
>
