mirror/ditto
mirror/ditto
1
0
Fork 0
mirror of https://gitlab.com/soapbox-pub/ditto.git synced 2025-12-06 11:29:46 +00:00
Code Issues Projects Releases Packages Wiki Activity Actions
3607 commits 84 branches 4 tags 20 MiB
Commit graph

29 commits

Author SHA1 Message Date
Chad Curtis
baa7968305 Optimize top_authors materialized view for better performance 
- Limit materialized view to authors with followers_count > 0 and top 10k records
- Add proper indexes (search GIN, pubkey B-tree, followers_count DESC)
- Use CONCURRENTLY for non-blocking refreshes in cron job
- Reduces sorting overhead and memory usage during refresh

The original materialized view was expensive because it sorted all authors
regardless of follower count. This optimization reduces the dataset to a
manageable size while maintaining search functionality.

Fixes expensive query issue in top_authors materialized view.
 2025-09-14 21:11:14 +00:00
Alex Gleason
f8d4fa57c6
Also don't log more expected SQL errors 2025-04-29 12:54:36 -05:00
Alex Gleason
3a849700db
KyselyLogger: don't log expected errors 2025-04-29 12:32:44 -05:00
Alex Gleason
3a260f7873 Merge branch '10x-better-logging' into 'main' 
Make logging 10x better

See merge request soapbox-pub/ditto!734
 2025-04-29 14:24:48 +00:00
Siddharth Singh
feab5f8cd0
stop logging every single query 2025-04-06 15:28:54 +05:30
P. Reis
7dc56f594b feat: add zaps_amount_cashu to event_stats (with tests) 
add zapped_cashu and zaps_amount_cashu field to MastodonStatus
 2025-03-25 18:19:40 -03:00
Alex Gleason
affea45a08
Store link previews in the database 
Fixes https://gitlab.com/soapbox-pub/ditto/-/issues/301
 2025-03-08 19:33:15 -06:00
Alex Gleason
e85e89e0af
Automatically fetch missing authors from pool 2025-03-06 14:55:40 -06:00
Alex Gleason
9b422d8e31
Add note about hanging queries in DittoPostgres test 2025-03-05 14:47:35 -06:00
Alex Gleason
0b72533b05
DittoPglite: test that queries reject after it's closed 2025-03-05 14:06:13 -06:00
Alex Gleason
4e0479f7c8
Add DittoPostgres test 2025-03-05 13:27:34 -06:00
Alex Gleason
2ca216dfdf
Set all packages to version 0.1.0 2025-03-03 19:31:41 -06:00
Alex Gleason
14b809b1e8
db: add TestDB module 2025-03-03 12:21:02 -06:00
Alex Gleason
a52fe9fbc6
Try to fix pkey migration 2025-02-23 09:30:00 -06:00
Alex Gleason
02d4235abd
Rename nostr_events_new_pkey to nostr_events_pkey 2025-02-23 09:21:14 -06:00
Alex Gleason
6cd64500ce
Fix stats test 2025-02-22 21:24:43 -06:00
Alex Gleason
63c0f8b032
ditto/db: make adapters use classes instead of static classes 2025-02-22 15:32:47 -06:00
Alex Gleason
084c6aa944
Fix DummyDB test 2025-02-21 21:55:00 -06:00
Alex Gleason
d4fc10fe3e
Add userMiddleware tests 2025-02-21 21:09:22 -06:00
Alex Gleason
44c4b3188c
DittoPolyPg: fix path to migrations 2025-02-20 11:35:37 -06:00
Alex Gleason
5231c8a94f
Rename DittoDatabase to DittoPolyPg 2025-02-20 11:32:04 -06:00
Alex Gleason
c7624e99d7
Swap the names of DittoDB and DittoDatabase 2025-02-20 11:26:27 -06:00
Alex Gleason
6f7fc11635
Super duper extra close the database 2025-02-19 22:00:09 -06:00
Alex Gleason
e1c1967a66
db: remove some external deps 2025-02-16 11:42:48 -06:00
Alex Gleason
dbfd759fba
Merge remote-tracking branch 'origin/main' into ditto-metrics 2025-02-16 00:45:01 -06:00
Alex Gleason
4e0bb16b85
Fix db tests 2025-02-16 00:39:00 -06:00
Alex Gleason
739153afc9
Add @ditto/metrics package 2025-02-16 00:30:00 -06:00
Alex Gleason
773b5da461
Add db tests 2025-02-16 00:21:41 -06:00
Alex Gleason
c59bb421c6
Add @ditto/db package 2025-02-16 00:14:41 -06:00