January 11th, 2013, 06:18 PM
Python & sql
I wanted to ask you guys few questions about python and sql together.
So, i am supposed to make a program that connects with online sql database, and make it able to write and read content on online sql db. I was reserching online a lot, and i though that this is the way i'm gonna cover this thing with sql: 'SqlAlchemy'. But i also heard so many things about python connecting with online db, about how you need to have installed some kind of mysql or what ever drivers, so your python program could actually connect with sql database.
My program should be compiled after all with py2exe ( i guess), And it would be very bad if users of that program had to install some kind of drivers..
I searched a lot, but for final answers and consultations i would like to hear those from this community, cause i found this place most quality.
What module(or what ever) should i use in my program so i could connect with ONLINE (remote host) sql database ( it's not localhost)?
Do users of that program need to install some kind of extra drivers or something similar?
Also all advices about py and sql are welcome, this is my first time i doing something with sql.
Thank you in advance!
January 13th, 2013, 04:45 AM
Unless you have users accessing a Web application (through their web browsers), any direct access to a remote/local database on a given computer requires a python specific driver to be installed.
January 13th, 2013, 06:42 AM
Is there any solution for not installing the driver? It's really stupid to install a driver, no one would do that. Is there any ways around? Could driver be installed thru python program? Any solution? Also isn't there already installed drivers for sql on windows?