Learning curve for new database program with Python?
cmpython at gmail.com
Mon Apr 7 07:05:33 CEST 2008
On Apr 5, 11:50 am, Jetus <stevegi... at gmail.com> wrote:
> I have a need for a database program. I downloaded the db2 from ibm,
> and reviewed some of the documentation.
> My question is, what is the easiest program for me to try to learn. I
> will be creating a database of about 25,000 records, it will be
> relational. I am a beginner Python programmer, and need a database
> solution that is easy to grasp. I played with sql,
> and found that very difficult, if not overly cumbersome.
> A database that could work with Django would be very interesting to
> look at as well..
> Any suggestions out there?
Re: Django...from the Django site:
"If you want to use Django with a database, which is probably the
case, you'll also need a database engine. PostgreSQL is recommended,
because we're PostgreSQL fans, and MySQL, SQLite 3, and Oracle are
Those all use SQL, and really if you are using a relational database,
pretty much what is used. SQL has not struck me as difficult nor
e.g., for a database table called "customers" that has a column
"name" and "city":
SELECT name FROM customers WHERE city='Chicago'
(in partially shouted English):
"GIVE ME ALL THE names OF customers WHOSE CITY IS Chicago.")
or, in Python 2.5 if you import sqlite3:
conn = sqlite3.connect('C:/Documents and Settings/user/Desktop/
cur = conn.cursor()
cur.execute("SELECT name FROM customers WHERE city='Chicago'")
I've enjoyed using SQLite in Python, and there's some good
online documentation to help there. And SQLite, Python, Django all
play well together, somehow, AFAIK.
More information about the Python-list