sqlite3 or mysqldb?

[John Salerno]

I did a little experimentation with MySQL, and yesterday I was reading 
up on SQLite. Since they both use the SQL language, does this mean that 
the queries you write will be the same for both modules? I'm sure there 
are slight differences for how you connect to DBs, but since they both 
use the same DB API 2.0, and both use SQL, I was wondering how easily 
you could 'switch' them out if you needed to go from one to the other.

(I know there are slight differences between the two in terms of SQL 
commands understood, but I'm mainly referring to the most important 
things, like simply accessing and changing DB information.)

I was using mysqldb just because MySQL seems to be a pretty big 
standard, but now that sqlite3 is coming with Python 2.5, I might 
switch, since it seems to be easier to use.

(And again, I'm such an amateur programmer that really I'm using these 
things just to learn them. It's not like I control my company's entire 
employee records or anything.)   :)

Thanks.