about summary refs log tree commit diff
Commit message (Collapse)AuthorAge
* Index network, context, nick, user, target, message in FTSJune McEnroe2019-12-13
| | | | | | This way the FTS query syntax for column filtering can be used like "network:freenode" without having to separately build a WHERE clause. The names.host column is not included since it's mostly just noise.
* Use a macro to write SQL as C tokens without quotesJune McEnroe2019-12-13
| | | | | | | | | | This switches to using :params rather than $params only because $ is allowed in identifiers as an extension, whereas : is always a separate preprocessor token. This has the advantage that # collapses excessive whitespace but otherwise preserves formatting, so the resulting SQL query strings look pretty normal.
* Document context inferrence in unscoopJune McEnroe2019-12-13
|
* Infer context from input pathsJune McEnroe2019-12-12
| | | | | | | | This could probably use some cleanup, but it's been in-progress for a week already. Also missing documentation and examples. But this did let me import 3.5 million events from Textual logs in about 6 minutes, so that's cool.
* Match missing final parameters in irc formatJune McEnroe2019-12-08
|
* Add irc formatJune McEnroe2019-12-07
|
* Stop after the first matcher to matchJune McEnroe2019-12-07
|
* Use named parameters in unscoop matchersJune McEnroe2019-12-06
|
* Fold networks into contextsJune McEnroe2019-12-06
|
* Rename IDs to nouns and join with USINGJune McEnroe2019-12-06
|
* Add deduplication function to unscoopJune McEnroe2019-12-06
|
* Add eventsDelete triggerJune McEnroe2019-12-06
|
* Add catgirl formatJune McEnroe2019-12-06
|
* Handle optional regex groupsJune McEnroe2019-12-06
|
* Add textual format to unscoopJune McEnroe2019-12-05
|
* Document what the generic format matchesJune McEnroe2019-12-05
|
* Include network/context in progress outputJune McEnroe2019-12-05
|
* Import in one transaction per fileJune McEnroe2019-12-05
|
* Insert colons into timezonesJune McEnroe2019-12-05
|
* Add basic unscoop import toolJune McEnroe2019-12-05
|
* Add prepare and bind helpersJune McEnroe2019-12-05
|
* Set busy timeoutJune McEnroe2019-12-05
|
* Make user and host NOT NULL as wellJune McEnroe2019-12-02
| | | | | Since involving NULLs in comparisons is awkward, I think I'll just use "*" for unknowns.
* Enable foreign key enforcementJune McEnroe2019-12-02
|
* Implement DB initialization and migrationJune McEnroe2019-12-02
|
* Rename header file to database.hJune McEnroe2019-12-01
|
* Change database file name to litterbox.sqliteJune McEnroe2019-12-01
|
* Add XDG_DATA_DIRS default valueJune McEnroe2019-12-01
|
* Implement database file searchJune McEnroe2019-12-01
|
* Document -d option to unscoopJune McEnroe2019-11-29
|
* Add unscoop manual pageJune McEnroe2019-11-29
|
* Add litterbox manual pageJune McEnroe2019-11-29