aboutsummaryrefslogtreecommitdiffstats
path: root/SQLiteStudio3/coreSQLiteStudio/TODO.txt
diff options
context:
space:
mode:
Diffstat (limited to 'SQLiteStudio3/coreSQLiteStudio/TODO.txt')
-rw-r--r--SQLiteStudio3/coreSQLiteStudio/TODO.txt66
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