-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Karl Lautman wrote: > E.g. pysqlite's .lastrowid method isn't mentioned at all on pysqlite.org.
Go to pysqlite.org Click on pysqlite usage guide All Python database adapters attempt to have the same interface so your code can (in theory) work with SQLite, MySQL, Oracle etc. That common interface is known as DBAPI and is documented at http://www.python.org/dev/peps/pep-0249/ As an example it is the one that mandates lastrowid. > Same for fetchall(), which I'd assume is a core function of sqlite, Not even close :-) I'd strongly recommend reading DBAPI and then the whole of the pysqlite usage guide. The latter is full of examples which will make things clearer. > isn't it listed on the core functions page on sqlite.org, The SQLite documentation itself is listed at http://www.sqlite.org/docs.html In general you'll want to be reading the "SQL syntax" one. The C API is what wrapper authors use to bind their language to SQLite. Unfortunately there is also a lot of documentation that is in the wiki as well not mentioned on the docs page. Examples of wiki information are date and time functions, performance tuning, virtual tables, performance tuning etc. When the site was last redesigned I did suggest a nice search box in the top right that searches the documentation and wiki, but it was not done. I'd also recommend a good book. You can find my review of one at http://rogerbinns.com/sqlitereview.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkGLSsACgkQmOOfHg372QT+OwCeNFp6V0NC0Ti2+LGlBfM+7xsA G48AniGnGHr8LsoUe2bcbct1AVAvOwM8 =0MH/ -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
