OK... now we're talking my lingo...lol
Really, postgres and mysql are the big open-source databases.
Mysql: fast as hell, no transaction support (current version yes), no
rollbacks (restore from a log of transactions), perfect for small databases
and for backing a web site.
Postgress: larger footprint, lots of full-featured support, transactions,
rollbacks, the whole deal.
Mysql runs on port 3306, I'm not sure about postgres.
And yes, your firewall can handle that database easy enough, especially mysql.
Oh hell, just call me 688-9725 or 915-3283
--Mike
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!
--
I do what the voices on my console
tell me to do.
