Re: allegro cl installer -- A.I built in, all the way DOWN

"Alex Mizrahi" <udodenko@xxxxxxxxxxxxxxxxxxxxx> writes:

SQL library in LispWorks has OO ORM stuff. one can define def-view-class,
and it will automatically generate table definitions, and will allow to do
fancy queries. def-view-class has lotsa stuff, including type
specifications, but surprisingly no ON DELETE CASCADE and ON DELETE
RESTRICT. i wonder why didn't they include it, since without it whole idea
with def-view-class becomes useless -- surely one can build database
definition himself (although Lisp programmers might be more efficient
writting Lisp def-view-class code rather than SQL definitions), but then
he'll need to synchonize def-view-class definitions with SQL table
definitions, that is not good..

DEF-VIEW-CLASS isn't only for schema generation. You can also use it
as to map between an already-defined database and your classes. IMO,
the automatic table generation stuff should only be used for testing
anyway. Play with CREATE-VIEW-CLASS until your code is working, then
use a "create table" SQL command to define the schema you're going to
use, with any optimizations and delete cascade stuff included. Your
program can still benefit from having view classes that handle
interaction with the database.
.