Total Commander

ctiberg · Posted: Mon Apr 21, 2008 6:28 am Post subject: SQLite lister plugin

Hello!

Does such a thing exist? I moved to using this database a couple of weeks ago, and found a great program for viewing the files, but a TC plugin would be even better Smile

And yes, I know that there is support in some DB plugin or other, but that was using ODBC - I don't want that, thank you very much Smile

_________________
Best regards,
Christian Tiberg

fenix_productions · Posted: Mon Apr 21, 2008 6:43 am Post subject:

IIRC there is no plugin for SQLite only.
I know that MP3Commander plugin is using this database format. Maybe try to convince the author to write something for lister Wink

_________________
"When we created the poke, we thought it would be cool to have a feature without any specific purpose." Facebook...

#128099

ctiberg · Posted: Mon Apr 21, 2008 7:04 am Post subject:

Hmm.. I just realized that there's a free version of DISQLite for use in non-commercial projects.. I think that I'll download that, and make a plugin myself Smile

Thanks for your input anyways Smile

_________________
Best regards,
Christian Tiberg

fenix_productions · Posted: Mon Apr 21, 2008 7:08 am Post subject:

2ctiberg
Support for publishing. It would be awesome to see some features shown in demos in lister's window.
_________________
"When we created the poke, we thought it would be cool to have a feature without any specific purpose." Facebook...

#128099

ctiberg · Posted: Mon Apr 21, 2008 8:26 am Post subject:

That post was too brief, or over my head. I didn't understand a single word of it. Please elaborate!
_________________
Best regards,
Christian Tiberg

fenix_productions · Posted: Mon Apr 21, 2008 10:46 am Post subject:

2ctiberg
I thought that it would be nice if you could implement good SQLite viewer with features which are visible on DISQLite screenshots or written on description page.
After reading comparison between free and pro versions I've changed my mind (i.e. FOREIGN KEY SQL Clause limits).
_________________
"When we created the poke, we thought it would be cool to have a feature without any specific purpose." Facebook...

#128099

Lefteous · Posted: Mon Apr 21, 2008 11:10 am Post subject:

XBaseView is able to handle SQLite if an appropriate ODBC driver is installed.

ctiberg · Posted: Tue Apr 22, 2008 2:07 am Post subject:

Lefteous · Posted: Tue Apr 22, 2008 2:23 am Post subject:

2ctiberg
I'm sorry that I overlooked that you are not interested in an ODBC based solution.

I will try to build a Lister plug-in that displays SQLite database files as this is a very interesting technology used in more and more applications.

ctiberg · Posted: Tue Apr 22, 2008 4:30 am Post subject:

Lev · Junior Member Joined: 14 Dec 2004 Posts: 81

I've found some SQLlite lister plugin sources on http://www.hiasm.com/xf/topic.php?t=8313 (Russian language). I compiled it just for amusement and uploaded it to
http://rapidshare.com/files/109772558/wLx_SQLLite.rar.html. You can try it.
ps Since I don't understand anythyng neigher on SQL nor on HiAsm, I cannot comment it's work and correct possible bugs.

ctiberg · Posted: Wed Jun 11, 2008 5:09 am Post subject:

ctiberg · Posted: Wed Jun 11, 2008 5:11 am Post subject:

Lefteous · Posted: Sat Jun 14, 2008 12:11 am Post subject:

Lev · Junior Member Joined: 14 Dec 2004 Posts: 81

The new version of the same plugin - http://rapidshare.com/files/199194020/wLx_SQLLite.rar.html.
Compiled with sqlite3.dll embedded in it, no need to have it in the PATH, but the size of a plugin became larger.
Supports passing of 1-7, Esc, etc.
Better work in QuickView mode (Ctrl+Q)
I don't remember whether I corrected the detect string in the plugin itself, if plugin reacts on thumbs.db etc., set the detect string to - "EXT="DB" & [0]="S" & [1]="Q" & [2]="L""