Commit Graph

8 Commits

Author SHA1 Message Date
23b9d34e16 Add configurable history length (#447)
* Add configurable history length

This allows servers to decide the max length of each history item they
want to store! Some users might have much larger history lines than
others.

This setting can be set to 0 to allow for unlimited history length. This
is not recommended for a public server install, but for a private one it
can work nicely.

* Format lol
2022-06-10 10:00:59 +01:00
796644e24e Add created_at column to users (#354) 2022-04-26 22:27:51 +01:00
f8233bcb63 SQLx cannot run this migration OK (#353)
And also correct a typo
2022-04-26 18:17:56 +01:00
4030de4bea Add btree index on history table (#345)
This speeds up a whole bunch of our queries by a *lot* :)
2022-04-26 09:32:59 +01:00
5aca6114d4 Allow for larger commands (#321)
Followup: Limit command length client side too
2022-04-21 18:54:58 +01:00
fe05d86bfa Fix delete trigger (#317)
I've tested this again by deleting my full history and re-syncing, all
good.
2022-04-21 09:12:51 +01:00
b98a378861 Add count trigger (#308)
This can be used in a later PR to optimise our database usage
significantly. Avoiding COUNT will be fantastic for our CPU usage, and
therefore sync times.
2022-04-19 18:19:21 +01:00
156893d774 Update docs, unify on SQLx, bugfixes (#40)
* Begin moving to sqlx for local too

* Stupid scanners should just have a nice cup of tea

Random internet shit searching for /.env or whatever

* Remove diesel and rusqlite fully
2021-04-25 17:21:52 +00:00