[Air-l] : postgresql and mysql

[Charlie Balch]

Elijah,
I've read good things about postgresql (http://www.postgresql.org/about/). I
don't know why postgresql is not more popular. Portability is going to be a
major concern when I do my next rewrite. While postgresql runs on many
platforms, it does not seem to have the installed base of MySQL.

Running with multiple DBs, languages, etc. will require exponential
complexity for my BIRAT (http://biart.net) statistical code. If BIRAT
becomes popular enough, I'll do it or perhaps others will join in this open
source project.

Charlie


-----Original Message-----
From: air-l-bounces at listserv.aoir.org
[mailto:air-l-bounces at listserv.aoir.org] On Behalf Of elw at stderr.org
Sent: Tuesday, July 25, 2006 9:06 AM
To: air-l at listserv.aoir.org
Subject: Re: [Air-l] Opinions about Web Survey Software
(ordereffects/WEXTOR/Access)



> Access
> I'm not sure that I would call Access vulnerable any more than other 
> databases are to most common attacks such as SQL injection. I 
> certainly agree that Access is not as robust and bad code would allow 
> Denial Of Service attacks.  Fortunately the Access SQL logic and 
> tables are easily ported to other databases. I'm sure that it has a 
> lot to do with my first programming experiences but I find the 
> ASP/Access combination easier for rapid prototyping. I also find the 
> resulting product capable of handling reasonably robust demands. As 
> noted before, I do intend to rewrite in PHP/MySQL.


As someone who ends up supporting other people who want to use this kind of
software... please, please, please make sure that your kit can run with a
postgresql backend in addition (or, perhaps, in preference) to mysql.

MySQL is *terrible*, as relational databases go.

thanks,

--elijah
_______________________________________________
The air-l at listserv.aoir.org mailing list is provided by the Association of
Internet Researchers http://aoir.org Subscribe, change options or
unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org

Join the Association of Internet Researchers: 
http://www.aoir.org/