Short: The "plain query language" is a kind of SQL (rather a subset) Author: lemke@lf.net (Bjoern Lemke), port by uploader Uploader: haubi@geocities.com (Stefan Haubenthal) Version: 0.8 rel. 2 Type: biz/dbase ANNOUNCEMENT PQL-0.8 ==================== by Bjoern Lemke, 1995 PQL is a relational, transaction oriented database tool, that is free available in source. PQL stands for "plain query language" and is a kind of SQL (rather a subset) Nearly all features of SQL are supported, like joins, subqueries and grouping. The join operation has been optimized using a iterative "search and join" algorithm which runs over all joined base tables. In addition to the PQL-Interpreter, a relational database engine interface is shipped within the package. The shipped engine is based on the lower level GDBM interface, a freely available database library. For the command line editing of the interpreter, the GNU readline library is another requirement for building PQL. Furthermore, PQL requires the standard Unix tools lex/yacc. (AT&T lex or flex are supported at the moment) PQL has reached an early phase of release 0.8. There are still many things to to, a lot of bugs must be eliminated and some useful features should be added. But, since the first public version of 0.7prebeta, many, many things have been changed, added and improved: - lots of bugs have been fixed - the condition evaluation should work correctly now (or-conditons have not been evaluated correctly) - transactions can be aborted explicitly now - some fundamental type casts are supported now (long -> float) - all available tables can be listed using the 'list'-command - sorting and the distinct operator is implemented now - a PQL test script has been added to the package - interactive/stdin mode is detected automatically - some missing predicate features have been added - count operator has been improved and extended The complete PQL package is free available at info2.rus.uni-stuttgart.de:/pub/unix/database/pql-0.8.tar.gz Please flame bugs and advices regarding PQL to Bjoern Lemke, lemke@lf.net ------------------------------------------------------------------------------ ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 96684 49904 48.3% 15-Apr-00 23:57:04 +pql 27764 5811 79.0% 05-Dec-99 20:24:46 +eng.c- 2959 1160 60.7% 11-Apr-00 22:57:20 +eng.h 989 252 74.5% 05-Dec-99 20:24:46 +linux.bug 1371 627 54.2% 05-Dec-99 20:24:46 +Makefile- 56696 12489 77.9% 05-Dec-99 20:24:46 +pql_parse.c 1198 497 58.5% 05-Dec-99 20:24:46 +pql_parse.h 50761 14866 70.7% 05-Dec-99 20:24:46 +pql_scan.c 1030 455 55.8% 15-Apr-00 23:43:00 +smakefile 27952 5895 78.9% 26-Feb-00 23:06:08 +eng.c 1381 629 54.4% 05-Dec-99 20:24:46 +Makefile 57660 11266 80.4% 05-Dec-99 20:24:46 +pql_query.c 9192 3412 62.8% 05-Dec-99 20:24:46 +pql_scan.l 6935 2179 68.5% 12-Dec-99 03:46:48 +pql_tree.h 3735 1275 65.8% 12-Apr-00 00:42:26 +pql_vars.c 575 311 45.9% 11-Apr-00 23:07:50 +readline.c 4645 2149 53.7% 05-Dec-99 20:24:46 +wildmat.c 6755 1504 77.7% 05-Dec-99 20:24:46 +pql_clean.c 1913 727 61.9% 05-Dec-99 20:24:46 +pql_conf.h 4098 1103 73.0% 05-Dec-99 20:24:46 +pql_create.c 15441 3562 76.9% 05-Dec-99 20:24:46 +pql_insert.c 29570 6293 78.7% 05-Dec-99 20:24:46 +pql_parse.y 30516 5317 82.5% 12-Dec-99 03:54:56 +pql_print.c 2019 996 50.6% 05-Dec-99 20:24:46 +PQL-ANNOUNCE 2710 1060 60.8% 05-Dec-99 20:24:46 +eng.h~ 3695 1266 65.7% 05-Dec-99 20:24:46 +pql_vars.c~ 1776 286 83.8% 05-Dec-99 20:24:46 +abteil 3844 163 95.7% 05-Dec-99 20:24:46 +abteil.ctx 1792 251 85.9% 05-Dec-99 20:24:46 +angest 2282 402 82.3% 05-Dec-99 20:24:46 +nix 1976 295 85.0% 05-Dec-99 20:24:46 +works_in 3844 184 95.2% 05-Dec-99 20:24:46 +works_in.ctx 17057 6339 62.8% 05-Dec-99 20:24:46 +pql.1 5726 2491 56.4% 05-Dec-99 20:24:46 +README 3844 126 96.7% 05-Dec-99 20:24:46 +angest.ctx 63 63 0.0% 05-Dec-99 20:24:46 +empsel 4073 1106 72.8% 05-Dec-99 20:24:46 +engtest.c 2280 610 73.2% 05-Dec-99 20:24:46 +pqltest 58 56 3.4% 05-Dec-99 20:24:46 +TODO 609 359 41.0% 05-Dec-99 20:24:46 +README 980 467 52.3% 05-Dec-99 20:24:46 +rel2pql 2104 299 85.7% 18-Apr-00 01:40:34 pql-0.8.1.info 9630 3801 60.5% 05-Dec-99 20:24:46 +DEVLOG 3352 1531 54.3% 05-Dec-99 20:24:46 +pql.doc 2753 977 64.5% 05-Dec-99 20:24:46 +pql.syntax 835 391 53.1% 23-Mar-00 23:21:48 +pql.info 3111 549 82.3% 18-Apr-00 02:05:32 +pqltest.log 495 238 51.9% 12-Apr-00 01:10:06 +pqltest.log.info -------- ------- ----- --------- -------- 520728 155989 70.0% 18-Apr-100 20:58:42 48 files