Home

About

The app is a standalone version of sqlite-wlx-plugin for Total Commander. That is why the app code is slightly strange.

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
Shift + Tab	Switch focus to the previous control
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
Ins	Add new row
Del	Delete selected row(s)
Ctrl + 1, Ctrl + 2, ...	Sort by column number
Ctrl + 0	Sort by current column
Ctrl + Space	Force open autocomplete in any input field

Settings

Settings are stored in sqlite-x.ini.
Check sqlite-x.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-x.exe
del sqlite-x64.exe

set opts=-DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_AUTHORIZATION -DSQLITE_OMIT_AUTORESET -DSQLITE_OMIT_AUTOVACUUM -DSQLITE_OMIT_COMPILEOPTION_DIAGS -DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DESERIALIZE -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_MEMORYDB -DSQLITE_OMIT_PROGRESS_CALLBACK -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRUNCATE_OPTIMIZATION -DSQLITE_UNTESTABLE -DSQLITE_ENABLE_HIDDEN_COLUMNS

set PATH=C:\mingw64\mingw32\bin;%PATH%
windres.exe  -J rc -O coff -i resource.rc -o resource.res
gcc.exe -Wl,--kill-at -static main.c include/sqlite3.c -o sqlite-x.exe -m32 -mwindows -s -Os resource.res -lgdi32 -lcomctl32 -lcomdlg32 -luxtheme -lshlwapi %opts% 

set PATH=C:\mingw64\mingw64\bin;%PATH%
windres.exe  -J rc -O coff -i resource.rc -o resource.res
gcc.exe -Wl,--kill-at -static main.c include/sqlite3.c -o sqlite-x64.exe -m64 -mwindows -s -Os resource.res -lgdi32 -lcomctl32 -lcomdlg32 -luxtheme -lshlwapi %opts%