Skip to content
Common Lisp library for working with firebird databases
Common Lisp
Find file
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
README.md
cl-fbclient-cffi.lisp
cl-fbclient-functions.lisp
cl-fbclient.asd
cl-fbclient.lisp
package.lisp

README.md

cl-fbclient

Common Lisp library for working with firebird databases

Library is a set of classes and methods for working with firebird databases. Basic classes:

  • fb-database
  • fb-transaction
  • fb-statement
  • fb-error

Supported SQL-vars types:

  • float
  • double
  • integer
  • decimal(numeric)
  • varchar
  • timestamp

Example:

(require 'cl-fbclient)

;; create an instance of the database and automatically connect to the database
(defparameter *db* (make-instance 'cl-fbclient:fb-database
                   :path "/path-to-db/db-file.fdb"))
             
;; query that returns no value
;; (transaction will be created, started and commited automatically)
(cl-fbclient:fb-noresult-query *db* "INSERT INTO T1(A1,A2) VALUES(121, 42)")

;; to query and write results to the list
;; (transaction will be created, started and commited automatically)
(cl-fbclient:fb-query-fetch-all *db* "SELECT * FROM t1")

;; disconnecting from DB
(cl-fbclient:fb-disconnect *db*)

Tested on:

  • SBCL(ubuntu)
  • CLISP(ubuntu)
  • SBCL-win32-threads (by akovalenko). (WindowsXP)

Documentation: cl-fbclient/wiki

TODO:

  • Create support types: date, time, array
  • Add docstrings
  • ...
Something went wrong with that request. Please try again.