[DB-SIG] Beginner in troubles.
Mon, 18 Mar 2002 20:32:20 +1100
Ignacio Guerrero wrote:
> I have a little problem... be patient, I'm a beginner.
> I'm exercising my newly aquired skills and I found myself with a problem
> that outskills me.
> I'm writing a script that:
> -asks you if you're a new user or a registred one.
> -then, if you're new, asks you to:
> -fill a form with personal data...
> -and prompts you for a userName and a userPass (which you have to type
> twise with exact spelling).
> -then, verifies if the userName is already taken or not and...
> -if it is, takes you back to the previous prompt or...
> -if it's not, adds your pass and Id to a database file.
> -I leave the else: to you :-)
> Now, my problem is that I'm not working with a database file but with a
> text file, appending the userName and the userPass to it, and retrieving
> them later.
> What I want to know is: How do I work with a database file?
> I work under Windows 98 (sadly, I wish I could use Linux, but my mom
> would die, or may be kill me.)
> -I have looked for every tutorial and nothing...
> -I went to the SQL site, red a tutorial... looks easy.
> -I had no troubles with Python, so far... lots of doc.
> -I had no troubles with Tkinter nor wxPython either... lot of doc too.
> -But (and it's a big BUT)... I can't find a single tutorial for
> beginners on working with DB's under Windows OS.
> -Should I download a Db's API?
> -Should I create a DB file or does my script should do that?
> -How do I link the data generated by my script to de DB file?
> ”””HEEEEEEEEELP!!! Please.
> If it sounds like a stupid question just tell me where to FAQ myself
> (FAQ... I said FAQ).
You've hit a bit of a problem area there I believe. I searched Google
for 'python database tutorial' and the results were a little sparse to
say the least.
I think the problem here is that most people who come to the DB-SIG know
how to use databases and how to program in Python but just need to join
those two areas of knowledge together.
I think it would be a very good idea to write a getting started type
document which could fit into the Python HOWTO Documents
(http://py-howto.sourceforge.net). Sadly, I don't have the time to do it
but if anyone would like to volunteer ...
If you want to persevere with a relational database the one I've had the
most success with on Windows 98 is MySQL. You can download the database
from http://www.mysql.com/ and the DB-API module from
In the short term, if a full blown relational database is too much to
learn in the short term maybe you should check out the anydbm module
Whichever you choose please let us know how you get on and the list is
always here for you to ask questions if you get stuck.
From the desk of Andrew J Todd esq.
"So I curtailed my Walpoling activities, sallied forth and infiltrated
your place of purveyance to negotiate the vending of some cheesy
comestibles." - Monty Python.