Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

Winfried
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

Stephen Chrzanowski
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 '<a href="'||Address||'">'||Name||'</a><br>\n' from Test;
sqlite> .quit

R:\>type test.html
<a href="http://www.google.com">Google</a><br>\n
<a href="http://www.youtube.com">YouTube</a><br>\n

(R: for me is a RamDRIVE)



On Fri, Oct 19, 2018 at 10:03 AM Winfried <[hidden email]> 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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

Stephen Chrzanowski
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 <[hidden email]>
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 '<a href="'||Address||'">'||Name||'</a><br>\n' from Test;
> sqlite> .quit
>
> R:\>type test.html
> <a href="http://www.google.com">Google</a><br>\n
> <a href="http://www.youtube.com">YouTube</a><br>\n
>
> (R: for me is a RamDRIVE)
>
>
>
> On Fri, Oct 19, 2018 at 10:03 AM Winfried <[hidden email]> 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
>> [hidden email]
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
dmp
Reply | Threaded
Open this post in threaded view
|

Re: Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

dmp
In reply to this post by 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?

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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

Olaf Schmidt-2
In reply to this post by Winfried
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

Peter da Silva-2
In reply to this post by Winfried
On 2018-10-19, at 09:02, Winfried <[hidden email]> 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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users