TODO:		This the SqLay TODO list. See also the BUGS file


Sorted descendant by a mix of what I consider priority, 
perceived ease of implementation and dependencies.

Note: this file is not up-to-date anymore

Legend:
- cpp:		c/c++ executables
- c: 		curses executables
- q: 		Qt executables
- sc: 		schema executables
- ds: 		datasheet executables


Asap:

- php:		selectable table with dropdowns loses values of dropdowns on multiple 
		edition (at least if degfault values for dropdowns ?)
- php:		fix i18n
- php:		ooo generation make sure ooo 2 file extensions are understood
- php:		screenshots
- php:		make pickup button in master/detail for choosing existing detail
- install:	find a good place to install tests/*.sql
- install:	generate pgsql and/or mysql test databases or install sql files
- options:	fix -si option broken
- release:	keep TODO file up-to-date

Later:

- php:		make sure enough secured against xss and sql injection
- scc:		fix PGDOWN regression
- rpm:		find out why rpmbuild unusefully requires pear for php package
- php:		include **some** session mgmt for perf without breaking useability
- php:		include **some** JS for perf without breaking useability
	  	by ultra-light browsers
- php:		make global array including actions
- php:		built-in check for unique indices
- php:		udf (user defined datatypes) i.e. for tel
- php:		input masks (i.e. for dates, telephone)
- php:		make it usable without frames as well (i.e. for mobile phones iMode)
- php:		brother menu items should be shown
- php:		full SqLay C-C++ compat
- plugouts:	split out/a into out/a and out/h
- plugouts:	make sure command line is used first
- tests:	fix broken test suite
- display:	achieve connection dialog
- cpp:		i18n
- dsq:		left alignement of numbers in char cols
- optimize:	check at least the drivers against Electric Fence
- command:	#row_xy URL parm, allowing to scroll to the row @ opening
- commands:	port -ix table name pattern list to other drivers and document
- commands:	-in should be able to handle comma separated lists as well
- input:	rename sqlay datatypes with more unique names (next libs version)
- input:	more drivers: odbc, mdbtools, sqlrelay, ...
- tests:	blanks in names, mixed/upper case
- input:	defaults connection parms by driver + document environment
- output:	sqldf family for forms or masks
- display:	resurrect sqlay exe's with list of databases from which to trigger sc's
- display:	make cgi interactive (with AND without DHTML) and make some screenshots
- ds:		clipboard
- output:	ascii art or html output for current selection only, so that ds'es can be 
		used as dialog from shell scripts
- command:	sort order and filter (ldap style or with -in -ix?) from command line
- command:	fields selection or widths to 0, also from command line
- ds:		internal harmonized structures for rows and resultsets
- command:	one should be able to force on or off toggle options to override rc files
- sc: 		info window instead of ugly debug window or edit
- display:	advanced filter, advanced sort
- c: 		menu bar
- doc:		gather all TODO tags spread in (especially new) c files herein
- sc: 		symbol for .iscounter
- sc: 		sort should be feasible on comments as well
- commands:	connection parms -ih -ip -iu -iw and -id (default driver) instead of -D
- c-q: 		interactive geometry specification ( sw, th tw tl tt )
- c-q: 		interactive file save of ascii art or html output
- c-q: 		interactive file or connection opening
- input:	ds.conn.options: i.e. tty for pg, with_data and terminator for files
- input: 	make drivers return clean lists of datatypes instead of current quick list
- display:	generally speaking, harmonize functionalities between all the exe's: they
		should all be able to do the same things except non-interactive ones
- c-q: 		real status bar with selected output format, file name, table count, ...
- code review: 	use gettext for i18n
- code review: 	use bison for parsers, especially file
- sc: 		grants also under columns instead of instead
- scc-q: 	width adjusted on resize event if no explicit sw switch
- scc-q: 	enhance search with 'n'/F3 and scrolling to result
- commands: 	possibility to open multiple files or to use wildcards in filename(s)
- commands: 	implement --long-options for all command line options
- sc: 		others output formats like xfig, tcm and dia in order to be able to alter and
  		print beautifull schemas, xml as well
- code review:	input: make thread safe
- code review: 	all options into prefs and currprefs globals in order to be able to save 
		options, including Qt specific ( geom, bg, fg, ... )
- code review: 	review unused return values and general architecture of calls
- optimize: 	track unused variables, malloc of names (fields, constraints, ...)
- optimize: 	secure against buffer overflows, stat file openings against race conditions,
		as I would like to be able to tag this as beta and make rpm's and deb's
- release: 	make rpm's and debs (after securing a little bit against buffer overflows, ...)
- tests: 	create a full test suite to run before releasing or enquiry possibility of 
		use of dejagnu or other test tools
- sc: 		other layouts: fixed, proportional, ...
- sc: 		layout computation to optimize from avg nb of columns, nb tables, screen size
- sc: 		layout computation results also available in pixels scale to calling funcs
- sc: 		other sort options: unsorted, reverse, maybe by nb cols
- sc: 		force lower / upper case display
- release:	links page to other nice softwares of same kind as mine
- release:	take a quick look at other projects (i.e. dbdesigner and alzabo) to see whether I 
		cannot either reuse a functional parser or contribute by incorporating my viewer(s) 
- filet:	make it sortable and filterable
- odbc3:	finish it and document in man pages and else where
- mysql:	make update work in ds
- files: 	enhance detection of foreign keys as create trigger: support composed keys 
- files: 	enhance detection of indices: also multiple fields, also as table constraints 
- files: 	refs and data
- files: 	detection of datatypes lengths and precisions
- input: 	detection of ownership
- files: 	wrapper to try to autodetect RDBMS type from comments on top of sql file
- input: 	support spaces in names
- input: 	create ldap schema parsing and split from sql
- output:	metasql
- output: 	sql passthrough, after filtering, maybe one day, who knows ...
- pgsql:	client version from configure if available
- q: 		-bf -fg should (theoretically) be storable in rc files
- dsq:		backport to qt1 ???
- ...