Sample SQLite Filters

Relational databases allow complex data searches using the SQL language. The SQLite log database is open and can be queried with any tool that can handle SQLite v3.0 files. Figure 1 shows the SQLite Manager Firefox add-on. This tool can be used to query sniffer databases. It is also possible to query the database using any scripting language with SQLite bindings such as Python. Following are a few examples of how to query the database.

Figure 1. SQLite Manager Add-On for Mozilla Firefox Browser