Anybody using the SQLite inspectors yet? Documentation?

Content Authoring
5

If you put properties whose (it as string contains "sqlite") in the fixlet debugger, you get these:

name of <sqlite column>: string
column <integer> of <sqlite row>: sqlite column
column <string> of <sqlite row>: sqlite column
type of <sqlite column>: sqlite column type
name of <sqlite column type>: string
type of <sqlite column type>: string
integer of <sqlite column type>: boolean
float of <sqlite column type>: boolean
text of <sqlite column type>: boolean
null of <sqlite column type>: boolean
blob of <sqlite column type>: boolean
column type <integer> of <sqlite table>: sqlite column type
column type <string> of <sqlite table>: sqlite column type
column types of <sqlite table>: sqlite column type
sqlite database of <file>: sqlite database
encoding of <sqlite database>: string
rows of <sqlite statement>: sqlite row
statement <string> of <sqlite database>: sqlite statement
name of <sqlite table>: string
schema of <sqlite table>: string
table <string> of <sqlite database>: sqlite table
tables of <sqlite database>: sqlite table
indices of <sqlite table>: string

Here are some examples using this inspector:

Note: the examples are windows only, but they should work cross platform except that they are pointing to the incorrect file locations for other OSes.

Related:

1 Like