about summary refs log tree commit diff
path: root/database.h (unfollow)
Commit message (Collapse)Author
2019-12-18Rearrange SQL and IRC codeJune McEnroe
2019-12-18Wrap handlers in transactionsJune McEnroe
2019-12-18Rewrite litterbox statements with functionsJune McEnroe
2019-12-18Use sqlite3_bind_intJune McEnroe
2019-12-17Insert events for PRIVMSG and NOTICEJune McEnroe
2019-12-17Separate dbBindText wrappers to allow for transientJune McEnroe
2019-12-17Use parameter names for all bindsJune McEnroe
2019-12-17Handle ISUPPORTJune McEnroe
2019-12-17Implement -j joinJune McEnroe
2019-12-17Implement basic IRC connection and message parsingJune McEnroe
2019-12-16Add server-time extension to STANDARDSJune McEnroe
2019-12-16Link litterbox with -ltlsJune McEnroe
2019-12-16Move ARRAY_LEN to database.hJune McEnroe
2019-12-13Style cleanupJune McEnroe
2019-12-13Compact matcher arrays a littleJune McEnroe
2019-12-13Index network, context, nick, user, target, message in FTSJune McEnroe
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.
2019-12-13Use a macro to write SQL as C tokens without quotesJune McEnroe
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.
2019-12-13Document context inferrence in unscoopJune McEnroe
2019-12-12Infer context from input pathsJune McEnroe
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.
2019-12-08Match missing final parameters in irc formatJune McEnroe
2019-12-07Add irc formatJune McEnroe
2019-12-07Stop after the first matcher to matchJune McEnroe
2019-12-06Use named parameters in unscoop matchersJune McEnroe
2019-12-06Fold networks into contextsJune McEnroe
2019-12-06Rename IDs to nouns and join with USINGJune McEnroe
2019-12-06Add deduplication function to unscoopJune McEnroe
2019-12-06Add eventsDelete triggerJune McEnroe
2019-12-06Add catgirl formatJune McEnroe
2019-12-06Handle optional regex groupsJune McEnroe
2019-12-05Add textual format to unscoopJune McEnroe
2019-12-05Document what the generic format matchesJune McEnroe
2019-12-05Include network/context in progress outputJune McEnroe
2019-12-05Import in one transaction per fileJune McEnroe
2019-12-05Insert colons into timezonesJune McEnroe
2019-12-05Add basic unscoop import toolJune McEnroe
2019-12-05Add prepare and bind helpersJune McEnroe
2019-12-05Set busy timeoutJune McEnroe
2019-12-02Make user and host NOT NULL as wellJune McEnroe
Since involving NULLs in comparisons is awkward, I think I'll just use "*" for unknowns.
2019-12-02Enable foreign key enforcementJune McEnroe
2019-12-02Implement DB initialization and migrationJune McEnroe
2019-12-01Rename header file to database.hJune McEnroe
2019-12-01Change database file name to litterbox.sqliteJune McEnroe
2019-12-01Add XDG_DATA_DIRS default valueJune McEnroe
2019-12-01Implement database file searchJune McEnroe
2019-11-29Document -d option to unscoopJune McEnroe
2019-11-29Add unscoop manual pageJune McEnroe
generated by cgit-pink 1.4.1 (git 2.36.1) at 2024-11-24 02:02:01 +0000