summary refs log tree commit diff
path: root/database.h (follow)
Commit message (Collapse)AuthorAge
* Factour out verbose, dbStep+resetJune McEnroe2019-12-23
|
* Rewrite litterbox statements with functionsJune McEnroe2019-12-18
|
* Use sqlite3_bind_intJune McEnroe2019-12-18
|
* Separate dbBindText wrappers to allow for transientJune McEnroe2019-12-17
|
* Use parameter names for all bindsJune McEnroe2019-12-17
|
* Move ARRAY_LEN to database.hJune McEnroe2019-12-16
|
* Style cleanupJune McEnroe2019-12-13
|
* 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