Commit message (Collapse) | Author | ||
---|---|---|---|
2019-12-23 | Take optional explicit path in dbFind | June McEnroe | |
2019-12-23 | Factour out verbose, dbStep+reset | June McEnroe | |
2019-12-18 | Handle NICK | June McEnroe | |
2019-12-18 | Handle JOIN, PART and KICK | June McEnroe | |
2019-12-18 | Rearrange SQL and IRC code | June McEnroe | |
2019-12-18 | Wrap handlers in transactions | June McEnroe | |
2019-12-18 | Rewrite litterbox statements with functions | June McEnroe | |
2019-12-18 | Use sqlite3_bind_int | June McEnroe | |
2019-12-17 | Insert events for PRIVMSG and NOTICE | June McEnroe | |
2019-12-17 | Separate dbBindText wrappers to allow for transient | June McEnroe | |
2019-12-17 | Use parameter names for all binds | June McEnroe | |
2019-12-17 | Handle ISUPPORT | June McEnroe | |
2019-12-17 | Implement -j join | June McEnroe | |
2019-12-17 | Implement basic IRC connection and message parsing | June McEnroe | |
2019-12-16 | Add server-time extension to STANDARDS | June McEnroe | |
2019-12-16 | Link litterbox with -ltls | June McEnroe | |
2019-12-16 | Move ARRAY_LEN to database.h | June McEnroe | |
2019-12-13 | Style cleanup | June McEnroe | |
2019-12-13 | Compact matcher arrays a little | June McEnroe | |
2019-12-13 | Index network, context, nick, user, target, message in FTS | June 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-13 | Use a macro to write SQL as C tokens without quotes | June 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-13 | Document context inferrence in unscoop | June McEnroe | |
2019-12-12 | Infer context from input paths | June 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-08 | Match missing final parameters in irc format | June McEnroe | |
2019-12-07 | Add irc format | June McEnroe | |
2019-12-07 | Stop after the first matcher to match | June McEnroe | |
2019-12-06 | Use named parameters in unscoop matchers | June McEnroe | |
2019-12-06 | Fold networks into contexts | June McEnroe | |
2019-12-06 | Rename IDs to nouns and join with USING | June McEnroe | |
2019-12-06 | Add deduplication function to unscoop | June McEnroe | |
2019-12-06 | Add eventsDelete trigger | June McEnroe | |
2019-12-06 | Add catgirl format | June McEnroe | |
2019-12-06 | Handle optional regex groups | June McEnroe | |
2019-12-05 | Add textual format to unscoop | June McEnroe | |
2019-12-05 | Document what the generic format matches | June McEnroe | |
2019-12-05 | Include network/context in progress output | June McEnroe | |
2019-12-05 | Import in one transaction per file | June McEnroe | |
2019-12-05 | Insert colons into timezones | June McEnroe | |
2019-12-05 | Add basic unscoop import tool | June McEnroe | |
2019-12-05 | Add prepare and bind helpers | June McEnroe | |
2019-12-05 | Set busy timeout | June McEnroe | |
2019-12-02 | Make user and host NOT NULL as well | June McEnroe | |
Since involving NULLs in comparisons is awkward, I think I'll just use "*" for unknowns. | |||
2019-12-02 | Enable foreign key enforcement | June McEnroe | |
2019-12-02 | Implement DB initialization and migration | June McEnroe | |
2019-12-01 | Rename header file to database.h | June McEnroe | |
2019-12-01 | Change database file name to litterbox.sqlite | June McEnroe | |
2019-12-01 | Add XDG_DATA_DIRS default value | June McEnroe | |
2019-12-01 | Implement database file search | June McEnroe | |
2019-11-29 | Document -d option to unscoop | June McEnroe | |
2019-11-29 | Add unscoop manual page | June McEnroe | |