You are looking at historical revision 8540 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
| Op | MySQL | PostgreSQL | SQLite |
|---|---|---|---|
| Connect | mysql-connect | pg:connect | sqlite3:open |
| Close | mysql-close | pg:close | sqlite3:finalize! |
| Query | mysql-query | <none> | sqlite3:exec |
| Fetch Row | mysql-fetch-row | <none> | <none> |
| Get Insert ID | mysql-insert-id | <none> | sqlite3:last-insert-rowid |
| Query for-each | mysql-query-foreach | pg:query-for-each | sqlite3:for-each-row |
| Query map | <none> | <none> | sqlite3:map-row |
| Query fold | <none> | pg:query-fold-left | <none> |