tailSQLite
This is an attempt to create an application that will act like a regular tail but for sqlite. This will allow you to pass the SQLite database and the table that you want to watch and have the program refresh every few seconds.
Additional Documentation for this project can be found at:
https://github.com/burnsoftnet/Documentation/blob/master/tailSQLite.pdf
Parameters
| Switch | Description |
|---|---|
| -help or -h | Display Help |
| tail | Tell the app to be in tail mode, Requires the db, table and idcol parameters, the t parameter is optional |
| db=DatabaseName | The path and name of the database you want to follow |
| t=seconds | the number of seconds you want to refresh the trace, by default this will be 5 seconds |
| table | The table name that you want to trace |
| idol | the Identity column to the table that you want to tail |
| showtables | Show all the tables of the database, requires the db parameter |
| showcolumns | Show all the columns for the table requires the table & db parameters |
| debug | Display Debug messages, currently this is just displaying on the query when running the tail. |
Examples
start tailing: tailSQlite -table=process_stats_main -idcol=id -db=C:\BSAP\bsap_client.db /t=5 /tail
Show Tables
tailSQlite --db=C:\BSAP\bsap_client.db /showtables
Show Columns
tailSQlite --db=C:\BSAP\bsap_client.db /table=process_stats_main /showcolumns
Release Notes
Version 1.0.0 - Fresh Release
]