SqLay ChangeLog
Changelog: This is the SqLay Changelog, also including notes on intermediate builds,
which are mainly used as quick temp backups and not checked in cvs (this is
TODO, but not done essentially because of a broken configure during devel).
See the NEWS file for a summary of new features available in releases.
20081231 0.8 - code review: removd need for c/c++ separate binaries
- code review: merged dl an dllt loaders
- code review: renamed some Makefiles
- sqldsq: added ability to delete selected rows
- php: added ability for ooo d? to handle multiline strings
- php: added ability for ooo ds to show boolean as x
- php: added events listbefore and listafter
- php: added table.fields..strip property
- reg fix: file databases accept url's without
trailing slash to open a schema so that one can use
again file associations with sqlscq
- reg fix: added libsqlayslit0 to cope with old sqlite databases
- reg fix: qt: broken -si command line option
- bug fix: php search beginning with % show correct resultset
- bug fix: php ds and df show newlines
- bug fix: php df event rowretrieved understood
- bug fix: php form custom field value substitution working
- bug fix: php backt to list after insert working
- bug fix: php mysql ignoring host info
- bug fix: c/c++ ip command line option not ignored anymore
20071231 0.7 - bug fixes in sql drivers to follow new versions of rdbmses
- sqlite drivers supports sqlite 3
- ncurses binaries have basic menus as qt ones have
- c/c++ schema viewers show datatype lengths
- more accurate documentation
- c/c++ datasheet accept sql filter on command line
- more stable datapages (master-detail) in PHP framework
- ooo generation based on templates in PHP framework
- blob (images) in PHP framework
- fixed ergonomy problem in dsc
- added quick sort capability to filet driver
- fixed bug with php checkboxes in form view
- licence upgraded to GPL v3
20051231 0.6.3 - fixed most bugs in PHP framework and prepared for (unstable) release
- introduced oocalc generation of ds in php framework
- added .deb and .rpm packages generation scripts.
- introduction of redundant PHP framework including PHP module
- introduced aliases for driver names
- created spec file for rpm's creation, and deb packages
- added desktop icons
- added odbc drivers for iodbc and unixODBC
- added mdbtools driver
- added csv file driver 'filet'
- added file type detection in file driver
- fixed sqldsa -tw-1 segfault
- added comma separated output to sqldsa
- fixed pgsql composed fk not shown in sc's
- added update/delete on pk's
- began adding connect dialog
- began adding exclude table name pattern as list (pgsql only)
20040222 0.6.2 - added visual distinction for views in interactive sc's
- prepared future inclusion of csv file driver
- fixed pgsql driver compilation problem with newer version of gcc
- fixed last col not detected as fk in pgsql driver
- fixed hardcoded paths in configure for Qt on Debian
and various other configure problems empeaching compilation
- fixed font problem in sqlscq
- added --enable-help-me-now configure option
- fixed dsc refresh problem on large datasheets (nothing visible)
- made TERM=rxvt recognized as xterm
- fixed cgi-bin segfault on exit and file opening problems
- fixed some segfaults at sc startup with all defaults
- fixed sc hanging on sybase system tables (at least for 11.0.3)
200306161 0.6.1.2 - fixed another install bug: rm -f done during install without prior test -L
20030611 0.6.1.1 - fixed cygwin compilation problem and wrong symlinks (without .exe)
20030609 0.6.1 See NEWS file summarizing what is here under.
{{{ intermediate devel builds
0.6.1-b-16
- reviewed INSTALL, README, ... for cvs cin
- added in dsa same functionalites (-tw, -tt, -tl) as in dsc and dsq
- added SQLAYDRIVER env var
0.6.1-b-15
- fixed some driver and configure bugs, changed return of exec
- reviewed installation directory structure, mainly under share
- fixed most of dsq reliability and ergonomy problems
- reviewed TODO BUGS
0.6.1-d-14
- added small test suite with sql files / driver
- repaired configure vpath build
- ensured install and uninstall work fine
0.6.1-d-13
- added some stylesheets for html / CGI, some icons, man pages for input drivers
- linked schemas with datasheets by spawning external process
- added SqLITE input driver and half of FreeTDS input driver
0.6.1-d-12
- added user menu in dsq
0.6.1-d-11
- added mysql driver
0.6.1-d-10
- added fast and dirty support for views in pg and ds
- sc: added button bars and (unstable) sort and filter
0.6.1-d-09
- made sqlsca and sqldsa work as cgi-bin
0.6.1-d-08
- added sqldsa readonly
- mostly repaired autoconf with inlibs makeable
- sqldsc: made editable (in common situations),
- with variable col widths
- added xterm caption
- with simple search, sort and filter
0.6.1-d-07
- c: added slk's and colors
- sqldsc: enhanced reliability of cursor moves.
0.6.1-d-06
- sqldsq: added menubar, help screen
- sqldsc: added button bar, help screen
- libouts: made layout and schema more independant
0.6.1-d-05
- doc: made quick sqlds man page
- doc: splitted this Changelog into NEWS and Changelog and incorporated old
devel Changelog
- splitted sqlay.c into sqlay.c and schema.c for use of some funcs by ds'es
- added url stylish command line args parsing in all exe's
0.6.1-d-04
- added null driver sqlnull.c
- made driver from original sqlfile.c
200302xy 0.6.1-d-03
- libs: drivers renamed to sqlwxyz.c
200302xy 0.6.1-d-02
- (temporarily) broke configure scripts at least for Qt exe's
- libs incorporated into main source tree and drivers renamed to sqlxy.c
- sqldsc using now sqlay libs
- sqlds'es integrated into main source tree and renamed to sqldsx
200302xy 0.6.1-d-01
- sqdsq using now sqlay libs
200302xy 0.6.1-d-00
- first tests of static, dyn and dl libs outside of source tree
with addition of a PostgreSQL driver using libpq
- first tests of sqlds'es (ncurses and Qt2) named sqdsc and sqdsq
outside of source tree using libpgeasy and libpq++
intermediate devel versions }}}
20030124 0.6.0 - checked in into sf cvs and published
- added configure script and reorganised the sources tree
- added optional display of most table and field features with cmd line args
{{{ intermediate devel versions
20030122 0.5.1.0.9
- moved sqldummy and sqlfile in src/in subdir
20030121 0.5.1.0.8
- updated headers for cvs and retagged alpha instead of prealpha
- renamed sqlayq files
20030120 0.5.1.0.7
- changed and harmonized cmd ln opts between sqlayc-q
- backported sqlayq to qt1
20030118 0.5.1.0.6
- got autotools working dist and distcheck
20030117 0.5.1.0.5
- reviewed Makefile's.am for dist
- reviewed include path
20030116 0.5.1.0.4
- recovered from accidental destruction of the sources subdir
- converted install and doc to automake as well
- began to use a small home brew test suite
20030115 0.5.1.0.3
- began integrating autoconf & automake
- added sql terminator command line arg and enhanced a little bit start and
end of statement detection in parser
- added debug level command line arg, using bitwise operators (16,32,64, then and)
- accidental crash: sources subdir destroyed on ext3fs with no backup since
10 days !
20030106 0.5.1.0.2
- reintegrated CVS info into the new sources tree
0.5.1.0.1
- reorganized the source tree to separate front-ends from sql parsing
- splitted sqldummy from sqlfile
- began adding a QT front-end
20030101 0.5.1.0 - added detection of foreign keys defined in pg_dump formatted create trigger
statements: should only work for non composed fk's
- addedd partial index detection
- addedd fairly unaccurate not null and default detection
- addedd fairly unstable detection of comments on table and column
- added partial dml detection (nbr of insert statements)
- addedd grants and revokes detection
- fixed sqlayc help scr bug with key strokes switching back to main screen
- added basic search capabilities in sqlayc
intermediate devel versions }}}
20021218 0.5.0.1 - fixed memory leak on pg_dump -D | sqlay
- reviewed e-mail addresses in doc for publishing on sourceforge
20021203 0.5 - last time before public release to change my mind about commamd line naming
conventions: I did it
- cleaned doc one more time, reviewed headers inside source
- fixed one more bug of pref not read from rc file
- enhanced Makefiles
- changed copyright to GPL
{{{ original devel versions
20021129 0.4.9 - generally speaking, brought it to a more or less releasable state
- added inclusive and exclusive filters for tables
- added custom html templates parsing
- added rc files parsing
- reviewed some command line parms, i.e. c which is now sw
- made ascii and html output available from sqlayc as well
- solved most of the problems of incorrect terminal with sqlayc and pipes
- memory usage optimization: switched to link list for the tables
- splitted sql.c into sqlfile.c and layout.c
20021116 0.4.8 - added in sqlayc possibility to scroll upwards, downwards by using a pad
instead of stdscr
- added in sqlayc basic interactivity with a small help screen
- tried to compile on a PII with 40 Mb Ram: no way, still segfaults @ startup
- tried to compile sqlaya with TC on a PC-XT running DOS 3.3 with conditional
compil directives: ok for (small) demo but sql parsing won't work because of
strsep and, of course, memory problems
- did again comments style update (was in wrong direction last time)
- changed a little bit the layout of the source tree
20021110 0.4.7 - finished removing c++ comments
- fixed messed up html output on tables with many columns
- added (hardcoded) template dir for html output
- wrote man page
- fixed first memory problem with dynamic 2d array for sqlaya screen
- added -tl and -tt options for spacing of tables
20021109 0.4.6 - cleaned a little bit command line args and help in both sqlaya and sqlayc
- fixed no detection of lower case create table
- fixed infinite loop causing segfault on inexisting referenced column in
constraint defs
- added tw (table width) and th (table height) command line args
- partially fixed impossibility to use stdin with sqlayc
- removed c++ style comments in sqlaya and libs for ansi (?, TC/DOS) compat
- nicely truncated too long fields or too many columns
20020623 0.4.5 - added (fairly unstable and partial) fk detection
20020616 0.4.4 - added html output in sqlaya
20020615 0.4.3 - cmd line args (including variable cols) & stdin input for sqlaya
- code review: sqlsttmts as link list
20020615 0.4.1 - allowed detecting pk's without constraint name in constraint clause
20020612 0.4 - changed name again to sqlay (kind of sqLayout)
- very primitive mysql parsing (exclusion of pk's and keys from the cols)
- splitted into 2 exe's: sqlaya for ascii console and sqlayc for interactive
ncurses
- began to split into presentation, and logic (sql.c for loggic and layout)
20020608 0.3 - changed name to dbvisu
- buggy parsing of pg_dump on multiple cols with pk indicators but no datatypes
20020607 0.2 - basic parsing of a pg_dump sql file (just field names, including bugs :-)
- basic ncurses schema drawing on one row
20020606 0.1 - basic ncurses schema drawing with 5 dummy tables, each with 6 fields, on one row
original devel versions }}}
{{{
vim600: fdm=marker
}}}
|
|
E. Lurquin Dec 2008 |
 |