usually the only thing that can vary across different database systems for examplein the mysql interface this call accepts network host' domain nameuser nameand passwordpassed as keyword arguments insteadand the oracle example sketched earlier expects more specific sting syntax once we've gotten past this platformspecific callthoughthe rest of the api is largely database neutral making databases and tables nextlet' make cursor for submitting sql statements to the database serverand submit one to create first tablecurs conn cursor(tblcmd 'create table people (name char( )job char( )pay int( ))curs execute(tblcmdthe last command here creates the table called "peoplewithin the databasethe namejoband pay information specifies the columns in this tableas well as their datatypesusing "type(size)syntax--two strings and an integer datatypes can be more sophisticated than oursbut we'll ignore such details here (see sql referencesin sqlitethe file is the databaseso there' no notion of creating or using specific database within itas there is in some systems at this pointthere is simple flat file in the current working directory named data which contains binary data and contains our people database table adding records so farwe've logged in (which just means opening local file in sqliteand created table next let' start new python session and create some records there are three basic statement-based approaches we can use hereinserting one row at time or inserting multiple rows with single call statement or python loop here is the simple case ( ' omitting some call return values here if they are irrelevant to the story) :\pp \dbase\sqlpython import sqlite conn sqlite connect('dbase 'curs conn cursor(curs execute('insert into people values (???)'('bob''dev' )curs rowcount sqlite paramstyle 'qmarkcreate cursor object to submit sql statements to the database server as before the sql insert command adds single row to the table after an execute callthe cursor' rowcount attribute gives the number of rows produced or affected by the last statement run this is also available as the return value of an execute call in some database interface modulesbut this is not defined in the database api specificationand isn' databases and persistence