querying sqlite3 database

[Bill King]

Have been investigating alternative method to query a sqlite3 database using tclsh84 ...

 

Initially, I have installed on my PC(s) - tcl/tk(8.4.12.0). Also, have installed the

tclsqlite3 dll. I have multiple (simple) sqlite3 databases which I maintain on my PC(s)

and one on the USB stick. The premise was not to rewrite code in PHP (not a PHP guru)

and to utilize and modify existing tcl code to query several simple sqlite3 databases...

I was not prepared to download more extensions/update PHP etc. at this time.

 

Here is synopsis of this investigation (after various iterations):

 

1. Created a searchit.html file with a form (action=post) to pass information to searchit.php:

note: pass the database name/table/field to query and the search string.

 

2. With searchit.php I utilized the $_POST[""] (PHP array?) to make the variables that I wanted to

pass to the tclsh84 (tcl shell).

ie. $searchstring =$_POST["searchstring"]; etc.

 

Built and printed initial HTML code (headers etc.)

 

I then made a call to "tclsh84" and passed (script name: searchit.tcl) and variables to

query a database:

ie. $output = exec("tclsh84 searchit.tcl $database $table $entry $searchstring");

 

3. tclsh84 opens the script (searchit.tcl) and reads in the variables - loads tclsqlite3 and performs

the query (as coded in searchit.tcl script). This builds a variable that I called "page" to return to

searchit.php.

note: variable "page" is 1 string (containing results with HTML code in order to build a table as

well as highlight the search string(color red) in textual results etc. )

 

4. The searchit.php script then prints the information received ($output) from tclsh84

ie. print $output;

 

The searchit.php script then prints out final HTML code and new html page produced.

 

Lessons learned:

1. PHP - likes 1 string (with no breaks/newlines) returned from calls

and remember those ";'s" in PHP.

2. I thought this approach would bog down; but Uniform Server proved to be pretty

quick. I am impressed with speed on this old PC.

3. Unfortunately this would limit sqlite3 queries to those systems with tcl/tk installed;

however, for my purposes this works well....

4. Considering using this same approach using Python......

 

Cheers!

wjk

[olajideolaolorun]

Thanks