Programming Forums > Script Programming > Python

Dietrich · Oct 22nd, 2006, 1:36 PM

I need some handholding here, asking for some hints to get going with an SQL database and Python. Just some information on what to download, how to connect with Python, and maybe some code examples. Hopefully something easy such as SqLite or MySQLdb. I am in the experimenting mood!

Sane · Oct 22nd, 2006, 2:11 PM

The thread directly below this one.

Infinite Recursion · Oct 22nd, 2006, 6:43 PM

MysqlDB is what you need, and I gave Bulio code to do this in the thread Sane mentions... I was experimenting with this myself, pretty cool stuff.

Dietrich · Oct 22nd, 2006, 9:14 PM

So what all do I have to download and install on my old HP Windows XP machine, so I can play around a little?

Also, how about SQlite, wouldn't that be a little simpler for starters?

Infinite Recursion · Oct 23rd, 2006, 10:12 AM

Python and MySQLdb...

This only looks hard on the surface, I downloaded MySQLdb and tinkered with the connection, search, and insert methods and had a working solution in few minutes... with a limited knowledge of Python. I'm sure you'll be able to figure it out, give it a go and see what you come up with. You could always come back for help if needed.

Game_Ender · Oct 23rd, 2006, 11:01 AM

Do you want to use databases? or learn how to use SQL + Python to manipulate a database. If you want to do the latter stick with the above solutions. But if you want to just use a database and not care to much about how it works you should give SQLObject or SQLAlchemy. They allow you map objects to database tables. They aren't perfect and performance won't be as good (unless you down to raw SQL) but they provide a pythonic way to access databases.

Dietrich · Oct 23rd, 2006, 12:53 PM

Do I need to download the actual database MySQL? That one is somewhat huge.

Infinite Recursion · Oct 23rd, 2006, 2:08 PM

Yes, unless you have access to a remote server with a MySql database.

Game_Ender · Oct 23rd, 2006, 6:31 PM

Python 2.5 comes with SQLite built in, so you don't have to go as heavy weight as MySQL if you don't need it.

Dietrich · Oct 23rd, 2006, 7:07 PM

Quote:

Originally Posted by Game_Ender

Python 2.5 comes with SQLite built in, so you don't have to go as heavy weight as MySQL if you don't need it.

Thank you muchly! That sounds good, now I would love to have a few examples to get started.

Oct 22nd, 2006, 1:36 PM	#1
Dietrich Professional Programmer Join Date: Feb 2005 Posts: 434 Rep Power: 4	Python and SQL I need some handholding here, asking for some hints to get going with an SQL database and Python. Just some information on what to download, how to connect with Python, and maybe some code examples. Hopefully something easy such as SqLite or MySQLdb. I am in the experimenting mood! __________________ I looked it up on the Intergnats!

Oct 22nd, 2006, 6:43 PM	#3
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,472 Rep Power: 8	MysqlDB is what you need, and I gave Bulio code to do this in the thread Sane mentions... I was experimenting with this myself, pretty cool stuff. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Oct 22nd, 2006, 9:14 PM	#4
Dietrich Professional Programmer Join Date: Feb 2005 Posts: 434 Rep Power: 4	So what all do I have to download and install on my old HP Windows XP machine, so I can play around a little? Also, how about SQlite, wouldn't that be a little simpler for starters? __________________ I looked it up on the Intergnats!

Oct 23rd, 2006, 10:12 AM	#5
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,472 Rep Power: 8	Python and MySQLdb... This only looks hard on the surface, I downloaded MySQLdb and tinkered with the connection, search, and insert methods and had a working solution in few minutes... with a limited knowledge of Python. I'm sure you'll be able to figure it out, give it a go and see what you come up with. You could always come back for help if needed. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Oct 23rd, 2006, 12:53 PM	#7
Dietrich Professional Programmer Join Date: Feb 2005 Posts: 434 Rep Power: 4	Do I need to download the actual database MySQL? That one is somewhat huge. __________________ I looked it up on the Intergnats!

Oct 22nd, 2006, 2:11 PM	#2
Sane Programming Guru Join Date: Apr 2005 Location: Waterloo, Ontario Posts: 2,069 Rep Power: 6	The thread directly below this one.

Oct 23rd, 2006, 11:01 AM	#6
Game_Ender Professional Programmer Join Date: May 2006 Location: Maryland, USA Posts: 306 Rep Power: 3	Do you want to use databases? or learn how to use SQL + Python to manipulate a database. If you want to do the latter stick with the above solutions. But if you want to just use a database and not care to much about how it works you should give SQLObject or SQLAlchemy. They allow you map objects to database tables. They aren't perfect and performance won't be as good (unless you down to raw SQL) but they provide a pythonic way to access databases.

Oct 23rd, 2006, 2:08 PM	#8
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,472 Rep Power: 8	Yes, unless you have access to a remote server with a MySql database. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Oct 23rd, 2006, 6:31 PM	#9
Game_Ender Professional Programmer Join Date: May 2006 Location: Maryland, USA Posts: 306 Rep Power: 3	Python 2.5 comes with SQLite built in, so you don't have to go as heavy weight as MySQL if you don't need it.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Script Programming > Python

Python and SQL