SqLay Logo
SqLay ChangeLog
  • Home
  • News
  • Screenshots
  • Licence
  • Download
  • Install
  • Doc
  • Bugs
  • TODO
  • 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.
    
    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
    			- licence upgraded to GPL v3
    			- fixed ergonomy problem in dsc
    			- added quick sort capability to filet driver
    			- fixed bug with php checkboxes in form view
    			
    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
    }}}
    

    SourceForge.net Logo E. Lurquin
    Dec 2007
    Viewable with any browser