Login/Register to vote and to have access to more featuresYou are here: Root > Standards and Specifications > ODBC
View the dependency graph for this libraryYstokSQL
Created by Edi on: Wed, 11 Jan 2006 23:57:07 GMT, Last modification: Fri, 26 Jun 2009 10:04:57 GMT
YstokSQL is a Common Lisp library for interfacing relational databases via ODBC.
| Web site | http://lisp.ystok.ru/ysql/ |
| Mailing list | http://www.ystok.ru/cgi/mwf/forum.pl |
| Version | 0.4.009 - Thursday, 05 October 2006 |
| Maturity | Stable |
| OS compatibility | Windows |
| ASDF installable | Yes |
| Official Download | http://lisp.ystok.ru/ysql/ysql-1-1-012.zip |
| Mirrored Download | |
| Source code repository |
The implementation is much inspired by LispWorks(R) CommonSQL, provides the functional SQL interface in full but only a partial object-oriented interface, and only supports the ODBC back-end.
Latest Releases and Features Added
Release 0.3 (2006-06-08)
- Object-oriented interface in its simplest.
- The desktop-mixin class covering several Jet database subclasses: access-database, excel-database, etc.
- Coalescing SQL references to save space.
- sql-case-exp covering three operators CASE, COND and COALESCE
(analogous to ODBC IFNULL, Jet's Nz, Oracle's NV). - SQL_NUMERIC and SQL_BIGINT types support.
Release 0.4 (2006-10-05)
- Regression test suite.
- Set operations UNION, INTERSECT, EXCEPT.
- Database creation, destroying, and listing functions.
Release 1.1 (2007-05-01)
- DDL functions for roles and privileges.
- Transaction support:
- macros define-commit-action and define-rollback-action,
- after methods on db-end-transaction executing action lists.
- Object-oriented interface improvements:
- added generics db-delete-instance-records, db-update-record-from-slot, and db-update-records-from-instance,
- added generic db-class-to-allocate to determine dynamically what class should be instance of. Useful for storing the extension of several subclasses in a single database table (so called ORM "flat mapping").
Prerequisites and options
The library requires Ystok-Library.
Compatible Implementations
Authors and Maintainers
Organizations
Tags
ODBC | Unicode | Windows family | Database | BSD license | LLGPL
See Also
Linked from these items
Ystok-Local-Time | Ystok-Systema
1 Notes and 0 comments
1 Notes
You must be logged to add a note
Ystok-Local-Time dependence
This module 'optionally requires" Ystok-Local-Time, i.e. if the latter is loaded before, YstokSQL provide more functionality.
Submitted by divanov 26/06/2009 09:51:50
0 Comments
You must be logged to add a comment