a Launchy plugin to search records from an SQLite database
You'll need to download and install:
Put sqlite.py in your Launchy\plugins\python directory
Copy the supplied sqlite_config.example.json to Launchy\plugins\python\sqlite_config.json and modify it as needed (see below).
sqlite_config.json is a JSON configuration file that tells launchy-sqlite what to do.
Top level:
database: the filename of the SQLite database to use. Remember that backslashes (\) need to be escaped in JSON stringstables: a list with a section for each database table to show (array of table objects)Table:
name: name of the table in the sqlite databasedisplay_name_field: a field to use as a display name for the record in the Launchy search result (optional)search_fields: a list of text fields to search for the text typed into Launchyicon_url_field: a field with a URL to an icon to display for Launchy search results for this record (optional)fields: a list of fields with associated actions that individual search results should be shown for (array of field objects).Field:
action_name: A display name for the action associated with this fieldaction_url_pattern: A URL to open if this search result is selected; this can contain a %s placeholder to be filled in with the value from this field in the database row