382 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	24d27c4cdd	Index I/i tags	2025-06-01 19:45:36 -05:00
Alex Gleason	96799d1918	Index kind 1111 tags	2025-06-01 14:45:29 -05:00
Alex Gleason	789b6c7e93	Guard against duplicate ephemeral events being streamed	2025-05-08 19:52:41 -05:00
Alex Gleason	984f76d184	DittoPgStore: remove fulfillment batching	2025-05-08 19:42:10 -05:00
Alex Gleason	fd87bad238	Add subscriptions bytes metrics	2025-04-29 13:24:36 -05:00
Alex Gleason	808c3f70f5	Merge branch 'fix-logging-defaults' into 'main' ... fix logging default config See merge request soapbox-pub/ditto!735	2025-04-29 18:06:56 +00:00
Siddharth Singh	b75cc0e372	fix early return in jsonl path for log level	2025-04-29 23:34:46 +05:30
Siddharth Singh	319620a414	remove relative import from ditto/utils in DittoConf	2025-04-29 23:32:37 +05:30
Siddharth Singh	e2ce3f32c3	fix logging default config	2025-04-29 23:25:38 +05:30
Alex Gleason	f8d4fa57c6	Also don't log more expected SQL errors	2025-04-29 12:54:36 -05:00
Alex Gleason	49e509e420	Fix LOG_CONFIG parsing	2025-04-29 12:42:40 -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
P. Reis	9d375f4afe	goose created files remove	2025-04-08 12:23:12 -03:00
P. Reis	fb7c57a1d0	Merge branch 'main' into mint-cashu ... Conflicts: packages/ditto/interfaces/DittoEvent.ts packages/ditto/storages/hydrate.ts	2025-04-08 12:16:53 -03:00
P. Reis	aadc3079fa	refactor: make GET wallet a bit faster	2025-04-08 12:14:47 -03:00
Siddharth Singh	1b55932193	apply review fixes (thanks @alexgleason)	2025-04-08 17:09:05 +05:30
Siddharth Singh	8305cea81e	fmt ... again	2025-04-06 15:53:06 +05:30
Siddharth Singh	a1aed97dec	enable all subscopes of a given scope when it's supplied	2025-04-06 15:50:25 +05:30
Siddharth Singh	8f51a9d6d7	only show extra params when they are actually present	2025-04-06 15:46:24 +05:30
Siddharth Singh	1b19ff415a	add types to public api for dittoconf	2025-04-06 15:40:42 +05:30
Siddharth Singh	d3a15a699e	fmt	2025-04-06 15:33:36 +05:30
Siddharth Singh	82e7f854b9	replace logi handler	2025-04-06 15:28:54 +05:30
Siddharth Singh	6778a42d54	remove isCI conf var	2025-04-06 15:28:54 +05:30
Siddharth Singh	5dc2cc405f	add log configuration variables	2025-04-06 15:28:54 +05:30
Siddharth Singh	feab5f8cd0	stop logging every single query	2025-04-06 15:28:54 +05:30
Alex Gleason	1c2d7a6793	Index client addr in search extensions	2025-04-03 12:38:39 -05:00
Alex Gleason	621d92dcf6	Render "client" tags in statuses even if they don't have an application handler event	2025-04-03 12:31:10 -05:00
Alex Gleason	0abee76e38	nip89: add ["t", "ditto"] tag to application handler event	2025-04-03 12:29:58 -05:00
Alex Gleason	c425a9d39a	DittoPgStore: index "client" tag	2025-04-03 12:29:45 -05:00
Alex Gleason	23eb531305	Render client tags	2025-04-01 20:26:05 -05:00
Alex Gleason	caf59f4078	Insert NIP-89 "client" tags when users post statuses	2025-04-01 19:49:31 -05:00
Alex Gleason	c8b1c2050b	Publish nip89 application handler on startup	2025-04-01 18:55:36 -05:00
Alex Gleason	8dc9ea98e2	Fix relay always sending a CLOSED message after the client sends CLOSE	2025-03-28 17:50:51 -05:00
Alex Gleason	34a29c8f4e	NIP-11 improvements	2025-03-28 16:15:20 -05:00
P. Reis	69fe86890f	feat: add accepts_zaps_cashu boolean field to DittoEvent and hydrate it	2025-03-27 09:48:29 -03:00
P. Reis	8a75f9e944	feat: implement GET statuses/:id{[0-9a-f]{64}}/nutzapped_by (with tests)	2025-03-26 15:55:59 -03:00
P. Reis	71a558a9de	Merge branch 'main' into mint-cashu	2025-03-25 18:23:13 -03:00
P. Reis	cda5196007	fix: remove unused import	2025-03-25 18:22:51 -03:00
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
P. Reis	83c96c88b7	feat: support pagination in GET transactions ... remove getTransactions function and replace it with renderTransaction function (all tests updated)	2025-03-24 23:02:04 -03:00
Alex Gleason	95c10fd2b9	Merge branch 'fix-nip05-notification' into 'main' ... Fix name grant notification not being rendered See merge request soapbox-pub/ditto!728	2025-03-23 17:15:59 +00:00
Alex Gleason	06c9c8d898	Fix name grant notification not being rendered	2025-03-23 12:11:39 -05:00
P. Reis	4451aafadc	fix: index k tag even if the value is not a number and count is less than 3	2025-03-21 16:56:24 -03:00
P. Reis	1360484ae9	fix: call paginationSchema as a function	2025-03-21 10:49:58 -03:00
P. Reis	0b8b9e726a	Merge branch 'main' into mint-cashu	2025-03-21 10:47:49 -03:00
P. Reis	7226d503f5	fix(getTransactions): coerce tags to string in schema ... This is not really needed but it doesn't hurt	2025-03-21 10:09:38 -03:00
P. Reis	d69854fa3c	fix: save amount tag value as a string	2025-03-21 10:07:34 -03:00
P. Reis	f9c4ec5835	feat: create GET transactions endpoint (with tests)	2025-03-20 14:02:43 -03:00