/usr/share/doc/cl-sql/TODO is in cl-sql 6.5.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | TESTS TO ADD
* Test that ":db-kind :key" adds an index for that key. This is complicated by
different backends showing autogenerated primary key in different ways.
* :db-constraint tests
* Number and Char field types
* symbol slot
* generalized-boolean slot
* tests for db-reader and db-writer
OPTIMIZATIONS
* Revisit result-type list creation, perhaps caching
* Rework LIST-ATTRIBUTE-TYPES and LIST-INDEXES such that they exhibit their
current behaviours using single database queries.
* Possible use of cached attribute type information for operations which
insert/update records as mentioned in the CommonSQL user guide.
* Extend caching of generated SQL strings to more complex expressions which
are likely to be repeatedly executed many times.
POSSIBLE EXTENSIONS
* improve large object api and extend to databases beyond postgresql
* add support for prepared statements
RACE CONDITIONS
* sql/databases.lisp: *connected-databases* is shared globally but not modified in a threadsafe manner.
|