> From: "Jopoy C. Solano" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: [plug] mysql vs. posgresql > Reply-To: [EMAIL PROTECTED] > > hi pluggers! > > I'm planning on using a linux-based sql server. > I would really appreciate it if you can give your opinion on which would > be the best choice. > > Also, what would be the best tool for the front end? PHP, Python ...? > The easier it is for me to learn the better :) (w/ security in mind)
If you love Python, then you should know there are now a gajillion Python server-side solutions. Check out my recent post in ph-python: http://lists.free.net.ph/pipermail/python/2003-January/000381.html and the one preceding it. PHP is nice, but Python is superb! I'd like to use it over PHP as much as I can because I believe that will net me major benefits. Python DB-API kicks PHP ADODB's ass anytime (and ADODB is already much better than PHP's native database APIs) As for the backend db itself, MySQL 4.1 just got subselects, but it's still in alpha I believe, nor does it have views, triggers, SPs, and working foreign keys, nor am I convinced about its complex query performance, so I'm sticking with Firebird for this enterprise system I'm going to develop. Thought of using PostgreSQL, but because it's a heterogenous environment, with Windoze and Linux machines, I'd rather use Firebird whose Windoze tools are very good and which itself runs on Windoze without much pain (unlike PostgreSQL for which you have to wrestle with Cygwin). Also I get the feeling that Firebird is friendlier than PostgreSQL and is definitely leaner (it looks even smaller than MySQL, yet more feature complete!). On the other hand, if your database is going to be simple and needs web-based speed for lots of hits (as opposed to intranet-style access), MySQL might fit the bill better. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
