You are looking at historical revision 8538 of this page. It may differ significantly from its current revision.

DBI Discussion

Streams

How about using SRFI-40/41 streams as query results? This would allow us to use all of the stream-fold, stream-map, etc. functions.

This may be a job for a library on top of DBI as well.

Comparison of Current DB Intefaces

	MySQL	PostgreSQL	SQLite
Connect	mysql-connect	pg:connect	sqlite3:open
Close	mysql-close	pg:close	sqlite3:finalize!
Query	mysql-query		sqlite3:exec
Fetch Row	mysql-fetch-row
Get Insert ID	mysql-insert-id		sqlite3:last-insert-rowid
Query for-each	mysql-query-foreach	pg:query-for-each	sqlite3:for-each-row
Query map			sqlite3:map-row
Query fold		pg:query-fold-left