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: 21
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: 1247
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: 21
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: 4570
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.318)
TC 10.00 x64 / x86
Everything 1.5.0.1285a (x64)
little-brother
Junior Member
Junior Member
Posts: 21
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: 1247
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: 21
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.
User avatar
nsp
Power Member
Power Member
Posts: 1428
Joined: 2005-12-04, 08:39 UTC
Location: Lyon (FRANCE)
Contact:

Re: SQLite plugin

Post by *nsp »

I have many sqlite database where the only way to see data is to query joining multiple tables.
Does your plugins allow to have "virtual view" i.e to edit a real sql query and then use your plugin to have columns filtering ?
little-brother
Junior Member
Junior Member
Posts: 21
Joined: 2021-09-27, 10:27 UTC

Re: SQLite plugin

Post by *little-brother »

You can create a view and fetch data from it. The plugin is a basic tool to quick view and only.
If you need to run queries I'll recommend to use a special tools e.g. SQLite Studio, Database Browser for SQLite or my app sqlite-gui. They have many additional features.
User avatar
nsp
Power Member
Power Member
Posts: 1428
Joined: 2005-12-04, 08:39 UTC
Location: Lyon (FRANCE)
Contact:

Re: SQLite plugin

Post by *nsp »

Thanks,
I already use such tools i was just curious as the columns filtering can also be nice on top of dynamic query. Creating view must be done externally using another tool or command line sqlite3 before watching.
Jerzynathor
New Member
New Member
Posts: 1
Joined: 2021-11-24, 15:41 UTC

Re: SQLite plugin

Post by *Jerzynathor »

Hi,
Would it be possible to add a right-click menu option to extract (copy and/or save to an external file) the content of a "blob" field?

MN
little-brother
Junior Member
Junior Member
Posts: 21
Joined: 2021-09-27, 10:27 UTC

Re: SQLite plugin

Post by *little-brother »

Done.
Post Reply