Home

Filters

• Use ABC as a column filter to find rows containing "ABC"
• Use =ABC to find rows with column values equal to "ABC"
• Use !ABC to find rows without "ABC"
• Use >N or <N to find rows with more or less N

Hot keys

Key	Description
Ctrl + Mouse wheel	Change font size
Tab	Switch focus to the next control
Ctrl + Tab	Switch focus to the previous control
F1	Open Wiki
F11	Toggle full screen mode
Ctrl + C	Copy current value
Shift + C	Copy selected row(s)
Ctrl + Shift + C	Copy column
Ctrl + Column click	Hide column
Ctrl + Space	Restore all hidden columns
Alt + Cell click	Extract an url from the cell and open it in a browser
Ctrl + 1, Ctrl + 2, ...	Sort by column number
Ctrl + 0	Sort by current column

Settings

Settings are stored in sqlite-wlx-section in c:\Users\%User%\AppData\Roaming\GHISLER\lsplugin.ini.
If the plugin folder contains sqlite-wlx.ini then settings will be read from it.
Check default.ini in a distributive to get available options and their descriptions.

RGB colors are integer values. You can use Get Color Picker.

How to build

del sqlite-wlx.wlx
del sqlite-wlx64.wlx

set opts=-DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_AUTHORIZATION -DSQLITE_OMIT_AUTOINCREMENT -DSQLITE_OMIT_AUTOMATIC_INDEX -DSQLITE_OMIT_AUTORESET -DSQLITE_OMIT_AUTOVACUUM -DSQLITE_OMIT_CAST -DSQLITE_OMIT_CHECK -DSQLITE_OMIT_COMPILEOPTION_DIAGS -DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DESERIALIZE -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FLAG_PRAGMAS -DSQLITE_OMIT_FOREIGN_KEY -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_INTEGRITY_CHECK -DSQLITE_OMIT_MEMORYDB -DSQLITE_OMIT_PROGRESS_CALLBACK -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRUNCATE_OPTIMIZATION -DSQLITE_UNTESTABLE

set PATH=C:\mingw64\mingw32\bin;%PATH%
gcc.exe -Wl,--kill-at -shared -static main.c include/sqlite3.c -o sqlite-wlx.wlx -m32 -s -Os -lgdi32 -lcomctl32 -lcomdlg32 -luxtheme %opts%

set PATH=C:\mingw64\mingw64\bin;%PATH%
gcc.exe -Wl,--kill-at -shared -static main.c include/sqlite3.c -o sqlite-wlx.wlx64 -m64 -s -Os -lgdi32 -lcomctl32 -lcomdlg32 -luxtheme %opts%