| Commit message (Collapse) | Author | Age | |
|---|---|---|---|
| * | Rewrite litterbox statements with functions | June McEnroe | 2019-12-18 |
| | | |||
| * | Use sqlite3_bind_int | June McEnroe | 2019-12-18 |
| | | |||
| * | Separate dbBindText wrappers to allow for transient | June McEnroe | 2019-12-17 |
| | | |||
| * | Use parameter names for all binds | June McEnroe | 2019-12-17 |
| | | |||
| * | Move ARRAY_LEN to database.h | June McEnroe | 2019-12-16 |
| | | |||
| * | Style cleanup | June McEnroe | 2019-12-13 |
| | | |||
| * | Index network, context, nick, user, target, message in FTS | June McEnroe | 2019-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 quotes | June McEnroe | 2019-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. | ||
| * | Fold networks into contexts | June McEnroe | 2019-12-06 |
| | | |||
| * | Rename IDs to nouns and join with USING | June McEnroe | 2019-12-06 |
| | | |||
| * | Add eventsDelete trigger | June McEnroe | 2019-12-06 |
| | | |||
| * | Import in one transaction per file | June McEnroe | 2019-12-05 |
| | | |||
| * | Add prepare and bind helpers | June McEnroe | 2019-12-05 |
| | | |||
| * | Set busy timeout | June McEnroe | 2019-12-05 |
| | | |||
| * | Make user and host NOT NULL as well | June McEnroe | 2019-12-02 |
| | | | | | | Since involving NULLs in comparisons is awkward, I think I'll just use "*" for unknowns. | ||
| * | Enable foreign key enforcement | June McEnroe | 2019-12-02 |
| | | |||
| * | Implement DB initialization and migration | June McEnroe | 2019-12-02 |
| | | |||
| * | Rename header file to database.h | June McEnroe | 2019-12-01 |