diff options
Diffstat (limited to 'SQLiteStudio3/coreSQLiteStudio/TODO.txt')
| -rw-r--r-- | SQLiteStudio3/coreSQLiteStudio/TODO.txt | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/SQLiteStudio3/coreSQLiteStudio/TODO.txt b/SQLiteStudio3/coreSQLiteStudio/TODO.txt new file mode 100644 index 0000000..a86a49b --- /dev/null +++ b/SQLiteStudio3/coreSQLiteStudio/TODO.txt @@ -0,0 +1,66 @@ +* Next versions: +- commiting DataView should be async +- syntax checkers as services - per language +- code assistants as services - per language +- specialized validation of expressions for DEFAULT constraint. +- "recovery" after failed startup - detecting if previous start crashed and if yes, propose cleaning of configuration. +- tcl highlighter +- plugin to do performance testing +- plugins to generate artifacts +- qtscript syntax checker +- tcl syntax checker +- dbf import +- dbf export +- code assistant as a service with plugins, so it can be extended with other langs and injected in custom functions window, collations window, etc +- in configuration dialog option to disable each individual native SQL function +- move "integrity check" into dedicated window, add "PRAGMA foreign_key_check" as a second stage of checking and present all in one window +- tips&tricks dialog +- crash management +- SqlEditor::refreshValidObjects() doesn't add valid object names from other databases (not yet attached). It might be tricky to implement. +- need an idea for some smart "revert" or "backup", so users are protected from accidentaly deleting table, or data in table. +- expose query executor steps chain to plugins +- complete plugin for "Search in database(s)" +- complete plugin for compare tables/databases +- executing queries with bind parameters +- completer: when suggesting table in FROM clause, look at columns after SELECT to give related tables first. +- constraints tab in table window should have toolbar for adding/editing/deleting constraints + +CLI: +- plugin management commands +- export commands +- import commands +- populate commands +- formatting command + +UNIT TESTS: +- Parser::parse: more complex examples, errors detecting +- Lexer::detokenize +- utils_sql (for splitQueries() check the CREATE TRIGGER) +- utils +- SelectResolver +- SchemaResolver + +* Advanced syntax error checks: +- many idxColumns are not allowed for column FK +- autoincrement not allowed for not integer type + + + + + + + + + +Qt mingw: +Not an easy task. I got Perl, Python, Ruby and MinGw/bin in path and +use this line + +configure -opensource -confirm-license -platform win32-g++ -make libs +-qt-libjpeg -qt-libpng -no-openssl -no-icu -qt-zlib -qt-pcre +-no-iconv -nomake examples -nomake tests -qt-style-windowsxp +-qt-style-windowsvista -opengl +desktop + +Qt linux: +./configure -no-icu -nomake examples -nomake tests -no-dbus -opensource -skip webkit -skip quickcontrols -prefix /home/spakowane/qt5.3.1/output |
