Spatialite GUI - add some items in workspace

[sym ow]

Hi!

I would ask if is possible to implement into Spatialite GUI some items:
1) in workspace shell, should be for each row on left, the number of relative code line (as Notepad++);
2) in errors dialog window, should show of row number involved too;

3) open new workspace shell tabs (as Notepad++) for same database;

Best regards!

[a.fu...@lqt.it]

Hi,

your idea is decisely attracting, and I personally would be the
first to appreciate a software tool like what you are dreaming of.

that said, there are several technical problems making it an
impossible dream that will never realize.

1. you are substantially asking to transform SpatiaLite GUI
into a sophisticated text editor like the excellent
Notepad++ (btw my preferred text editor, it's the best
of the best and I adore it).

2. the sad reality is that the GUI tool has only the very
limited text editing capabilities directly supported by
wxWidgets (wxRichTextCtrl class), and attempting to expand
this specific area would certainly require a prohibitive
development effort.

3. said in different words; the simplest way to realize
something like what you are dreaming would probably be
to start from the Notepad++ sources adding what is needed
to interact with SQLite and SpatiaLite.
it will be much simpler that working in the opposite way
attempting to add to SpatiaLite GUI the sophisticated
text editing environment supported by Notepad++

4. reporting line numbers in error messanges is simply
impossible, because SQL errors are directly reported
by SQLite itself that has no idea about text formatting,
it just cares about SQL syntax correctness.

final consideration: implementing a multi tabbed interface
would cause lot of toubles, because SQLite does not like
at all multiple conccurrent accesses to the same DB,
even if they come from the same process.
it would be a continuous stall due to reciprocal locks
triggered by the competing connections (one for each
tabbed windows).

my personal hint: learn to use both SpatiaLite GUI and
Notepad++ at the same time (as I personally always do).
and you'll probably discover that switching from the
one to the other just requires some trivial copy-and-paste.

bye Sandro