|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
|||
|
|||
|
MySQL Sucks?
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."
|
|
#2
|
||||
|
||||
|
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!
Mark. |
|
#3
|
|||
|
|||
|
I don't know about MySQL but PostgreSQL & Python works beautifully with psycopg and with pyPgSql.
|
|
#4
|
||||
|
||||
|
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 |
|
#5
|
||||
|
||||
|
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 Puzzle of the Month solved by sizeablegrin, etienne141 and L7Sqr, superior C/C++ programmers of the month |
![]() |
| Viewing: Dev Shed Forums > Programming Languages > Python Programming > MySQL Sucks? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|