| Commit message (Collapse) | Author | Age | |
|---|---|---|---|
| * | Automatically perform database migrations in litterbox | June McEnroe | 2020-05-21 |
| | | | | | | To simplify upgrades, restarting litterbox should be sufficient. The database can still be explicitly migrated with -m. | ||
| * | Add Ban and Unban event types | June McEnroe | 2020-04-05 |
| | | |||
| * | Implement the causal.agency/consumer capability | June McEnroe | 2020-02-28 |
| | | |||
| * | Add -b flag for live backup | June McEnroe | 2020-01-14 |
| | | |||
| * | Add columnsize = 0 option to FTS index | June McEnroe | 2020-01-14 |
| | | | | | | | | | | | | | Since we don't use ranking functions and I don't see them being useful, there is no point in having columnsize, which just takes extra space in the database. In my database of approximately 3.5 million events, disabling columnsize saves about 62 MB. The migration unfortunately has to rebuild the entire index to disable it. | ||
| * | Bump busy timeout to 10s | June McEnroe | 2020-01-11 |
| | | | | | I'm running this on a RPi3 which is not the fastest computer. | ||
| * | Enable SQLite WAL | June McEnroe | 2020-01-04 |
| | | |||
| * | Factor out hashing function | June McEnroe | 2020-01-01 |
| | | |||
| * | Join with USING wherever possible | June McEnroe | 2019-12-30 |
| | | |||
| * | Use X macro for Type enum | June McEnroe | 2019-12-30 |
| | | |||
| * | Run PRAGMA optimize in dbClose | June McEnroe | 2019-12-28 |
| | | |||
| * | Treat topics like motds | June McEnroe | 2019-12-25 |
| | | | | | | It's more like a cache of existing topics. events is still meant to record actual topic events. | ||
| * | Insert MOTDs into the database | June McEnroe | 2019-12-25 |
| | | |||
| * | Insert existing topics into the database | June McEnroe | 2019-12-25 |
| | | | | | | | | Not sure how to handle the 333 reply that contains the user who set the topic and the timestamp of when it was set, since they're two separate messages that aren't really easily correlated since there's no guarantee that you're even going to get a 333 at all. | ||
| * | It's The Big Refactor | June McEnroe | 2019-12-24 |
| | | |||
| * | Take optional explicit path in dbFind | June McEnroe | 2019-12-23 |
| | | |||
| * | Factour out verbose, dbStep+reset | June McEnroe | 2019-12-23 |
| | | |||
| * | 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 |