April 2nd, 2004, 11:26 PM
Just curiuos if anyone has used MYsql with python and encountered any problems. I was recently pointed here where they individuals were none to happy with it. I'd like to use a datbase on my site and i'm curious as to which one to use. Thank you all.
"In theory, there is no difference between theory and practice.
But, in practice, there is."
April 3rd, 2004, 01:41 AM
Pythons DBI could be easier i admit but i've never had a problem with MySQL and Python so it's all good. Another DB you might be interested in is SQLite or maybe even PostgreSQL, but MySQL is a great choice for webapps in general!
April 3rd, 2004, 03:44 AM
I don't know about MySQL but PostgreSQL & Python works beautifully with psycopg and with pyPgSql.
April 3rd, 2004, 06:19 PM
Say some guy (e.g. me) wants to try some DB programming with Python. Which one's the best and/or simplest ?
Time is the greatest of teachers ; sadly, it kills all of its students.
- Hector Berlioz
April 3rd, 2004, 10:54 PM
Actually, this question has very little to do with python and more to do with mysql really. Mysql is great for database lookups -- the speed is simply amazing. So, if you have a lot of prepopulated data that you want to search for results quickly, this is the engine for you. However, if you do insert or update data a lot, then there is (or at least was) a tendency for the database to get corrupted, especially if the size of the database gets large. This happens irrespective of the programming language used. They might have fixed those bugs in recent versions though. However, for industrial strength applications that have a lot of transactions and require replication and triggers and stuff, we use MS SQL Server (sorry guys, not everything I use is free software ). Yes, I know mysql now provides some of these features, but SQL Server is still a lot more flexible for our needs.
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo