Name

Value

Description

action

getinfo | query

This argument is optional, default is 'query' if not specified.

getinfo - get hardware board information (Firmware version and library version).

query - input sqlite query statement.

Usage example:

http://192.168.1.41/sqlite.cgi?action=getinfo

query

<query string>

This argument cannot be empty if argument action=query.

Usage example:

http://192.168.1.41/sqlite.cgi?action=query&query=.help

mode

csv | column | html | insert | line | list | tabs | tcl

This argument equivalent to .mode <mode> in sqlite command line.

Usage example:

http://192.168.1.41/sqlite.cgi?query=select * from sensors limit 50&mode=csv

header

on | off

This argument equivalent to .header <on|off> in sqlite command line. If this argument not specified, default is 'on'

Usage example:

http://192.168.1.41/sqlite.cgi?query=select * from sensors limit 50&mode=csv&header=on

db

<database file name>

Specify database file name. If this argument not specified, default is 'database.db'.

http://192.168.1.41/sqlite.cgi?query=.tables&db=database.db

output

<sqlite query output to file> | sqlite_query.html

This argument ask server to save output of query to file to directory 'system', and also response to web browser the same file.

Usage example:

http://192.168.1.41/sqlite.cgi?query=select * from sensors limit 50&mode=csv&header=on&output=sql.csv

Then request output file (stored in directory 'system'):

http://192.168.1.41/system/sql.csv

Note: sqlite_query.html is reserved for demo of query form.