Database Queries

The database engine is sqlite3. The file is located in the project work directory under db and is named "core.db". All standard sqlite3 tools will work with it.

One program that has been tested is DB Browser for SQLite

Examples

Find all strings that deca found that contain the sub-string "flash"

SELECT string FROM core_hash_strings WHERE string LIKE "%flash%"

Find all files that have a string that contains the sub-string "flash"

SELECT vpath FROM core_vnodes where uid IN 
    (SELECT src_node FROM core_hash_string_references WHERE hash_row_id IN 
        (SELECT rowid FROM core_hash_strings WHERE string LIKE "%flash%"))