content='cgit 1.4.1'/>
summary refs log tree commit diff
path: root/database.h (unfollow)
Commit message (Collapse)Author
2020-07-08Delay creating eventsTime index when migration from v2 1.4June McEnroe
2020-07-08Add link to "IRC Suite" post in READMEJune McEnroe
2020-07-08Fix -D nowJune McEnroe
2020-07-08Convert timestamps to unix epoch timeJune McEnroe
This saves 125 MB on my own database after VACUUM.
2020-07-07Allocate enough bind space for :open and :closeJune McEnroe
Big oops!
2020-07-07Create index on events.timeJune McEnroe
This vastly improves the speed of scoop -a, -b and -D.
2020-07-07Use >= and < on events.time for -DJune McEnroe
This will enable the use of an index on events.time.
2020-07-07Only join FTS table when FTS query is presentJune McEnroe
This makes query construction more complex, but should allow for performance gains, since it seems that as soon as the FTS table is involved, SQLite will use no other indexes. (The query planner always uses a VFilter.)
2020-06-24Bump ParamCap to 254June McEnroe
Apparently IRCds have decided that the 15-parameter limit doesn't matter anymore. 254 is the maximum number of single-byte parameters (following a single-byte command) which fit in a 512-byte CR-LF-terminated line. When everyone decides that the 512-byte line length limit doesn't matter either, I will delete my software and people can use some JavaScript garbage instead. This makes struct Message 2080 bytes, but there's only ever one of it around at once. Avoid passing it by value to handle.
2020-06-12Remove RPL_MOTDSTART handlerJune McEnroe
Relying on the MOTDSTART handler to set motd.cap and allocate the buffer is an issue if a regular RPL_MOTD is received without one. Just allocate the buffer on the first RPL_MOTD.
2020-06-08Add additional permission for linking with LibreSSLJune McEnroe
https://www.gnu.org/licenses/gpl-faq.en.html#GPLIncompatibleLibs
2020-05-22Perform all migrations in one transaction 1.3June McEnroe
2020-05-21Clean up unscoop manual pageJune McEnroe
2020-05-21Fix search expression appendJune McEnroe
Oops.
2020-05-21Fix dbPrepare errx callJune McEnroe
2020-05-21Add only the necessary expressions to scoop's queryJune McEnroe
This makes the queries generally faster and capable of taking advantage of any indexes that get created.
2020-05-21Explicitly set stdout line buffered when pagingJune McEnroe
2020-05-21Do not sort results in scoop by defaultJune McEnroe
The -s flag now enables sorting (-g and -l also imply it), while the -S flag now launches the sqlite3 shell. Avoiding sorting by default is much faster and less memory-intensive as it doesn't require loading the entire result set into memory at once.
2020-05-21Expand and clarify documentationJune McEnroe
2020-05-21Execute PAGER with the SHELLJune McEnroe
Same as how git executes it. Allows flags to be set in PAGER.
2020-05-21Automatically perform database migrations in litterboxJune McEnroe
To simplify upgrades, restarting litterbox should be sufficient. The database can still be explicitly migrated with -m.
2020-05-20Don't install rc scripts on other platformsJune McEnroe
Oops, meant to do this in the last commit.
2020-05-20Rewrite build and install like pounce 1.3June McEnroe
man pages are no longer compressed!
2020-05-20Update email addressesJune McEnroe
2020-04-23Call updateConsumer from handleError 1.2p1June McEnroe
This should prevent continually crashing on the same ERROR in the pounce buffer.
2020-04-20Use . as ${LDLIBS.$@} separatorJune McEnroe
2020-04-05Error on invalid ISUPPORT values 1.2June McEnroe
2020-04-05Only set RCS on FreeBSDJune McEnroe
2020-04-05Log bans and unbansJune McEnroe
2020-04-05Parse mode types from ISUPPORTJune McEnroe
2020-04-05Add unscoop matchers for ban/unban eventsJune McEnroe
The IRC and Textual matchers miss bans mixed with other mode changes, but those are rare.
2020-04-05Check unscoop regexps with make testJune McEnroe
2020-04-05Add unscoop -n flag for checking regexpsJune McEnroe
2020-04-05Add Ban and Unban event typesJune McEnroe
2020-04-02Update styleJune McEnroe
Replacing declarations followed by while loops with for loops and generating the short option string from the long options.
2020-03-31Update unscoop catgirl matchersJune McEnroe
I'm not concerned about keeping the old matchers since I'm almost entirely certain I was the only one who ever used the old version of catgirl, and I already imported those logs.
2020-03-31Fix writing verbose to stderrJune McEnroe
2020-03-02Include <>/-/* around nicks in scoop coloring 1.1June McEnroe
2020-03-02Replace .mk files with configure scriptJune McEnroe
2020-02-28Implement the causal.agency/consumer capabilityJune McEnroe
2020-02-22Include <>/-/* around nicks in coloringJune McEnroe
2020-02-22Use (almost) the full range of IRC colors for nicksJune McEnroe