SQLite plugin

Discuss and announce Total Commander plugins, addons and other useful tools here, both their usage and their development.

Moderators: white, sheep, Hacker, Stefan2

Post Reply
little-brother
Junior Member
Junior Member
Posts: 8
Joined: 2021-09-27, 10:27 UTC

SQLite plugin

Post by *little-brother »

Hi!

I made a new plugin to view SQLite3 files (*.db, *.db3, *.sqlite, *.sqlite3) as alternative to SQLite Viewer

Image: https://raw.githubusercontent.com/little-brother/sqlite-wlx/main/sqlite-wlx.png

Features
  • Column filters: "contains" (ABC), "exclude" (!ABC), "equals" (=ABC), "greater" (>ABC), "less" (<ABC)
  • Sort data by column click
  • Doesn't require SQLite library (built-in)
  • Supports huge tables
  • Free and open-source
Project page - https://github.com/little-brother/sqlite-wlx
Download link - https://github.com/little-brother/sqlite-wlx/releases/latest/download/sqlite-wlx.zip

P.S. 32bit version does not load :( I'll try to fix it as soon as possible.
Fixed in 0.9.3 with milo1012's answer
Last edited by little-brother on 2021-09-30, 09:06 UTC, edited 8 times in total.
User avatar
Usher
Power Member
Power Member
Posts: 1243
Joined: 2011-03-11, 10:11 UTC

Re: SQLite plugin

Post by *Usher »

Can you explain features of your plugin? There is no description on your Github page, no readme in the zip file, no helpful info at all…
Regards from Poland
Andrzej P. Wozniak
little-brother
Junior Member
Junior Member
Posts: 8
Joined: 2021-09-27, 10:27 UTC

Re: SQLite plugin

Post by *little-brother »

Thanks, I'll add readme.txt to zip.
User avatar
Horst.Epp
Power Member
Power Member
Posts: 4490
Joined: 2003-02-06, 17:36 UTC
Location: Germany

Re: SQLite plugin

Post by *Horst.Epp »

And whats the benefit compared with the already existing SQliteViewer plugin ?
Windows 11 Home x64 Version 21H2 (OS Build 22000.258)
TC 10.00 x64 / x86
Everything 1.5.0.1280a (x64)
little-brother
Junior Member
Junior Member
Posts: 8
Joined: 2021-09-27, 10:27 UTC

Re: SQLite plugin

Post by *little-brother »

Column filters (instead of query input), support for big tables and maybe smaller size and sources.
In the next small update I'll also improve performance to be extremely fast. (released)
Also it's extremely fast.
User avatar
Usher
Power Member
Power Member
Posts: 1243
Joined: 2011-03-11, 10:11 UTC

Re: SQLite plugin

Post by *Usher »

little-brother wrote: 2021-09-27, 13:02 UTCDoesn't require SQLite library (built-in)
Really? The file size is only 686 KB. It definitely DOES NOT contain the newest SQLite libs.
Regards from Poland
Andrzej P. Wozniak
little-brother
Junior Member
Junior Member
Posts: 8
Joined: 2021-09-27, 10:27 UTC

Re: SQLite plugin

Post by *little-brother »

Really?
Really contains! :D There are some points to gain it
  • -Os compile flag: optimize even more for size
  • -s complie flag: strip all symbols from binary
  • -DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_SHARED_CACHE - disable some SQLite features
  • No additional modules e.g. FullTextSearch (FTS3, 4, 5), geopoly and r-tree are included (but json1 does)
The result size can be reduced by excluding -static option (gcc overhead), but in this case the app will be require addition dll for Win10.
With extrenal sqlite3.dll the app size is about 75Kb.
Post Reply