Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
On 2018-10-19, at 09:02, Winfried wrote: > Before I build a GUI, is there a Windows SQLite database manager that can do > this? > > I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none seems > to support this feature. SQLite's closest thing to a native scripting language is Tcl, with a Tk graphical toolkit. If you write your app in Tcl/Tk it will run on Windows, Mac, and UNIX. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
Am 19.10.2018 um 16:02 schrieb Winfried:
I have a bunch of hyperlinks in an SQLite database, and need to read
each page for validation before deleting the record.
To make it easier, the DB manager should launch the default web browser
when I double click on a column that contains a hyperlink.
Before I build a GUI, is there a Windows SQLite database manager
that can do this?
Am a bit late here - but perhaps it's interesting for others as well...
Since you need it for Windows - why not write a little tool for that -
using VBScript (*.vbs Files), which are supported on all current Win-OS.
VBScript interacts nicely with COM-libraries (less so with "flat-Dlls"),
via CreateObject("Lib.Class") - so your question basically boils down to:
- is there a COM-lib for SQLite
- is there a COM-lib which also supports GUI-development
- does this GUI-support include DataGrid-Bindings to SQLite-ResultSets
(to keep the efforts low)...
Well, yes there is: http://vbRichClient.com/#/en/Downloads.htm
(a COM-framework, which wraps SQLite - as well as cairo for its GUI-
and drawing-stuff).
Whilst the above Link is targetting VBA and VB6-developers primarily,
an adaption with decent support for VBScript-development is here:
http://vbRichClient.com/Downloads/ScriptGUI5.zip
The above Zip contains several *.vbs examples in its Root-Folder -
and already includes all the needed libs in a \Bin\-SubDirectory.
The tool allows after unzipping, a development "right-out-of-the-box"
(it does not require any Setup when running on Win-Systems > XP) -
and the frameworks size is comparably small (about 3MB zipped).
I've included a solution to your problem already in two versions:
(both demos are using a dynamically created "Urls"-DB and -Table)
- SQLite_DataGrid_Simple.vbs
- SQLite_DataGrid.vbs
Here is a ScreenShot of the complete Code for the simple version:
http://vbRichClient.com/Downloads/ScriptGUI5.png
And here one of the running *.vbs-App from the "enhanced version"
(which has only a dozen more lines of code than the simple one):
http://vbRichClient.com/Downloads/SQLiteDataGrid.png
Help-Files which describe the interfaces of the Framework-
Classes are contained as *.chm in the Zips \Doc\ Subdirectory.
HTH
Olaf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
> I have a bunch of hyperlinks in an SQLite database, and need to read each > page for validation before deleting the record. > To make it easier, the DB manager should launch the default web browser when > I double click on a column that contains a hyperlink. > Before I build a GUI, is there a Windows SQLite database manager that can do > this? Hello, Though my application does not do what you desire it is a framework for plugins. The GUI, database connection stuff and a tutorial for creating plugins is available as open source. Seems a lot of work to create a new GUI for the purpose stated. The other response on creating a HTML file seems quicker. http://ajqvue.com/documentation.html http://ajqvue.com/docs/Plugins/PluginBasics/Ajqvue_PluginBasics.html http://ajqvue.com/docs/Plugins/PluginAdvanced/Ajqvue_PluginAdvanced.html danap. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
I suppose you COULD get rid of the \n in the query Its a Linux thing. *sigh* On Fri, Oct 19, 2018 at 10:50 AM Stephen Chrzanowski wrote: > This would be something you'd need to write something quick for. There's > no application in the world that knows how to use your specific schema and > react to it. There may be apps that will read the values and automatically > 'understand' that http:// and https:// are addresses, but, these probably > are custom built applications that do something completely different to > what you're doing. I've just checked with SQLite Expert, and it doesn't > have any knowledge of how to treat a field as a URL/URI. > > That said, you may be able to get an ugly query going, and dump it to an > HTML file you can bring up in your browser. > > My example table: > CREATE TABLE [Test]( [TestID] INTEGER, [Name] CHAR, [Address] URL); > INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(1, 'Google', ' > http://www.google.com'); > INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(2, 'YouTube', ' > http://www.youtube.com'); > > Then execute SQLite3.exe like this: > > R:\>c:\myapps\sqlite3.exe > SQLite version 3.20.0 2017-08-01 13:24:15 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> .open TestDB.db3 > sqlite> .output test.html > sqlite> select ''||Name||'\n' from Test; > sqlite> .quit > > R:\>type test.html > http://www.google.com;>Google\n > http://www.youtube.com;>YouTube\n > > (R: for me is a RamDRIVE) > > > > On Fri, Oct 19, 2018 at 10:03 AM Winfried wrote: > >> Hello, >> >> I have a bunch of hyperlinks in an SQLite database, and need to read each >> page for validation before deleting the record. >> To make it easier, the DB manager should launch the default web browser >> when >> I double click on a column that contains a hyperlink. >> >> Before I build a GUI, is there a Windows SQLite database manager that can >> do >> this? >> >> I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none >> seems >> to support this feature. >> >> Thank you. >> >> >> >> -- >> Sent from: http://sqlite.1065341.n5.nabble.com/ >> ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
This would be something you'd need to write something quick for. There's no application in the world that knows how to use your specific schema and react to it. There may be apps that will read the values and automatically 'understand' that http:// and https:// are addresses, but, these probably are custom built applications that do something completely different to what you're doing. I've just checked with SQLite Expert, and it doesn't have any knowledge of how to treat a field as a URL/URI. That said, you may be able to get an ugly query going, and dump it to an HTML file you can bring up in your browser. My example table: CREATE TABLE [Test]( [TestID] INTEGER, [Name] CHAR, [Address] URL); INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(1, 'Google', ' http://www.google.com'); INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(2, 'YouTube', ' http://www.youtube.com'); Then execute SQLite3.exe like this: R:\>c:\myapps\sqlite3.exe SQLite version 3.20.0 2017-08-01 13:24:15 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open TestDB.db3 sqlite> .output test.html sqlite> select ''||Name||'\n' from Test; sqlite> .quit R:\>type test.html http://www.google.com;>Google\n http://www.youtube.com;>YouTube\n (R: for me is a RamDRIVE) On Fri, Oct 19, 2018 at 10:03 AM Winfried wrote: > Hello, > > I have a bunch of hyperlinks in an SQLite database, and need to read each > page for validation before deleting the record. > To make it easier, the DB manager should launch the default web browser > when > I double click on a column that contains a hyperlink. > > Before I build a GUI, is there a Windows SQLite database manager that can > do > this? > > I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none > seems > to support this feature. > > Thank you. > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?
Hello, I have a bunch of hyperlinks in an SQLite database, and need to read each page for validation before deleting the record. To make it easier, the DB manager should launch the default web browser when I double click on a column that contains a hyperlink. Before I build a GUI, is there a Windows SQLite database manager that can do this? I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none seems to support this feature. Thank you. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
