cl-dbi
cl-dbi copied to clipboard
fukamachi
Database independent interface for Common Lisp
When using `connect-cached`, after a disconnect the next `connect-cached` returns the previous connection but because of the `disconnect` the `handle` slot is unbound. ``` lisp CL-USER> (let ((conn (dbi:connect-cached :sqlite3...
`BEGIN TRANSACTION / END TRANSACTION` cannot be used in a nested fashion. `SAVEPOINT dummy_name/ RELEASE dummy_name` should work nested. http://www.sqlite.org/lang_savepoint.html
When certain errors occur while executing an SQLite prepared query, no condition is signalled until the *next* time the statement is used. As a result, I have to add special...
E.g., (dbi:do-sql *dbh* "CREATE TABLE example (name text)") (dbi:execute (dbi:prepare *dbh* "INSERT INTO example (name) VALUES (?)") nil) yields a text string 'false' in the name column. So, is it...
CL-DBI throws EXCEPTION_ACCESS_VIOLATION when used with MYSQL database query with multiple columns
Lisp Environment: SBCL on Windows OS: Windows 8.1 Enterprise and Windows 10 Personal DB : MYSQL 64 bit Scenario: Any query with more than one column or a \* in...
the defpackage form for dbd.postgres looks as follows: (defpackage dbd.postgres (:use :cl :dbi.driver :dbi.error :cl-postgres) (:import-from :cl-postgres :connection-socket :send-parse) (:import-from :cl-postgres-error ... It would be nice if we either imported...
I was working on an ODBC driver for cl-dbi the other day, and I've run into a snag: the driver has to allocate some (foreign) resources to execute a query,...
CL-MSSQL
What would need to happen before "MS SQL Server" could be added to this list https://github.com/fukamachi/cl-dbi#databases ?
when i tried to use it by sbcl, clone it on quicklisp/local-projects, register-local-projects and quickload it, then i got the error. ``` To load "dbi": Load 1 ASDF system: dbi...
I believe I've found a base issues on the code for transactions. I"m working on MySQL 8 and the following sequence: _(begin-transaction conn) (query conn "insert...") (commit conn)_ Ends up...
