summary refs log tree commit diff
path: root/database.h (follow)
Commit message (Collapse)AuthorAge
* Automatically perform database migrations in litterboxJune McEnroe2020-05-21
| | | | | To simplify upgrades, restarting litterbox should be sufficient. The database can still be explicitly migrated with -m.
* Add Ban and Unban event typesJune McEnroe2020-04-05
|
* Implement the causal.agency/consumer capabilityJune McEnroe2020-02-28
|
* Add -b flag for live backupJune McEnroe2020-01-14
|
* Add columnsize = 0 option to FTS indexJune McEnroe2020-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 10sJune McEnroe2020-01-11
| | | | I'm running this on a RPi3 which is not the fastest computer.
* Enable SQLite WALJune McEnroe2020-01-04
|
* Factor out hashing functionJune McEnroe2020-01-01
|
* Join with USING wherever possibleJune McEnroe2019-12-30
|
* Use X macro for Type enumJune McEnroe2019-12-30
|
* Run PRAGMA optimize in dbCloseJune McEnroe2019-12-28
|
* Treat topics like motdsJune McEnroe2019-12-25
| | | | | It's more like a cache of existing topics. events is still meant to record actual topic events.
* Insert MOTDs into the databaseJune McEnroe2019-12-25
|
* Insert existing topics into the databaseJune McEnroe2019-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 RefactorJune McEnroe2019-12-24
|
* TakJune McEnroe
2022-02-20Save input buffer contentsJune McEnroe
2022-02-20Share a cut buffer between all edit buffersJune McEnroe
2022-02-20Assert return values in edit testsJune McEnroe
2022-02-20Move mbs out of struct Edit, use a global bufferJune McEnroe
This saves 4K in the edit buffers, not to mention all the heap allocations for the separate mbs buffers! There might be a way to be more clever about capacities, but I don't think it's worth it.
2022-02-20Clear edit buffer before running commandJune McEnroe
Otherwise a command that switches windows will update the status line while the edit buffer still has input "pending", showing an indicator.
2022-02-20Show indicator in status when window has pending inputJune McEnroe
2022-02-20Use separate edit buffers for each IDJune McEnroe
2022-02-20Make sure new cap is actually larger than new lengthJune McEnroe
2022-02-20Remove unused mbs.len field from struct EditJune McEnroe
2022-02-19Remove unneeded includes in ui.cJune McEnroe
2022-02-19Reimplement tab completeJune McEnroe
2022-02-19Handle errors from editFn, etc.June McEnroe
2022-02-19Reimplement text macrosJune McEnroe
2022-02-19Factor out input handling to input.cJune McEnroe
2022-02-19Factor out window management to window.c803'>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