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@listserv.aoir.org [mailto:air-l-bounces@listserv.aoir.org] On Behalf Of elw@stderr.org Sent: Tuesday, July 25, 2006 9:06 AM To: air-l@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@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/