summary refs log tree commit diff
path: root/database.h (follow)
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.
* Fold networks into contextsJune McEnroe2019-12-06
|
* Rename IDs to nouns and join with USINGJune McEnroe2019-12-06
|
* Add eventsDelete triggerJune McEnroe2019-12-06
|
* Import in one transaction per fileJune 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