c-relay-pg

api_upgrade_implementation_plan.md

v2.1.16 - Implemented api-worker timer + LISTEN/NOTIFY monitoring (Phases 1,2,5) and fixed thread-connection binding bug that stopped dashboard updates

2026-07-25 10:07:08 -04:00

api_upgrade_plan.md

v2.1.11 - Fix api-worker DB lifecycle and NIP test reliability: add dedicated worker DB connection, guard PG expiration cast in REQ path, correct NIP-45 baseline-aware expectation, and harden run_all_tests skip handling

2026-04-03 07:32:14 -04:00

backfill_redesign_plan.md

v2.1.23 - Caching service: descriptive error reporting, retry limit, inbox poller fix, config reload fix, PHP admin page

2026-07-28 16:37:08 -04:00

backfill_relay_by_relay_plan.md

v2.1.23 - Caching service: descriptive error reporting, retry limit, inbox poller fix, config reload fix, PHP admin page

2026-07-28 16:37:08 -04:00

c_relay_pg_html_migration_plan.md

v2.1.12 - Implement multi-admin auth cache and checks, add admin management commands, and add multi-admin integration test

2026-04-03 15:46:33 -04:00

c_relay_pg_plan.md

v2.1.9 - Rebrand repository, docs, scripts, and tooling from c-relay to c-relay-pg

2026-04-02 07:06:41 -04:00

c_relay_thread_pool_plan.md

v2.1.9 - Rebrand repository, docs, scripts, and tooling from c-relay to c-relay-pg

2026-04-02 07:06:41 -04:00

caching_code_consolidation_plan.md

v2.1.19 - Consolidated caching_relay code into caching/ directory, switched launcher to PostgreSQL mode (-p pg_conn) so all config comes from the config table instead of a JSON config file

2026-07-25 16:27:56 -04:00

caching_error_reporting_retry_limit_plan.md

v2.1.23 - Caching service: descriptive error reporting, retry limit, inbox poller fix, config reload fix, PHP admin page

2026-07-28 16:37:08 -04:00

caching_follows_status_plan.md

v2.1.23 - Caching service: descriptive error reporting, retry limit, inbox poller fix, config reload fix, PHP admin page

2026-07-28 16:37:08 -04:00

caching_relay_daemon_plan.md

v2.1.16 - Implemented api-worker timer + LISTEN/NOTIFY monitoring (Phases 1,2,5) and fixed thread-connection binding bug that stopped dashboard updates

2026-07-25 10:07:08 -04:00

caching_relay_integration_plan.md

v2.1.16 - Implemented api-worker timer + LISTEN/NOTIFY monitoring (Phases 1,2,5) and fixed thread-connection binding bug that stopped dashboard updates

2026-07-25 10:07:08 -04:00

caching_status_fix_plan.md

v2.1.18 - Fixed caching service integration: aligned caching_status response schema, fixed launcher to use -c config_path instead of --pg-conn, added caching service config fields to UI, replaced misleading not-implemented placeholder with accurate auth-failure messaging

2026-07-25 11:19:37 -04:00

database_architecture_analysis.md

v2.1.9 - Rebrand repository, docs, scripts, and tooling from c-relay to c-relay-pg

2026-04-02 07:06:41 -04:00

eliminate_g_db_plan.md

v2.1.6 - Fix strict-mode admin API key access by prewarming config and relay private key caches

2026-04-01 19:08:42 -04:00

event_json_storage_and_migration_plan.md

v1.2.0 - Schema v11: Added event_json storage for 2500x performance improvement

2026-02-02 20:27:50 -04:00

event_tags_denormalization_plan.md

v1.2.5 - Add nip17_admin_enabled config toggle (default off) to prevent OOM from NIP-17 gift wrap decryption flood

2026-02-23 08:58:10 -04:00

idle_connection_ban_plan.md

v1.2.29 - Added idle connection ban system - bans IPs that connect but never send REQ/EVENT (idle timeout or early disconnect) with separate rate limiting from auth failures

2026-02-24 14:18:27 -04:00

main_thread_offload_plan.md

v2.1.9 - Rebrand repository, docs, scripts, and tooling from c-relay to c-relay-pg

2026-04-02 07:06:41 -04:00

memory_leak_investigation_plan.md

v2.1.9 - Rebrand repository, docs, scripts, and tooling from c-relay to c-relay-pg

2026-04-02 07:06:41 -04:00

multi_admin_plan.md

v2.1.12 - Implement multi-admin auth cache and checks, add admin management commands, and add multi-admin integration test

2026-04-03 15:46:33 -04:00

php_admin_page_plan.md

v2.1.23 - Caching service: descriptive error reporting, retry limit, inbox poller fix, config reload fix, PHP admin page

2026-07-28 16:37:08 -04:00

postgres_implementation_plan.md

v2.1.10 - Fix NIP-50 PG search semantics and NIP-17 test compatibility

2026-04-02 13:00:34 -04:00

postgres_relays.md

v2.1.2 - Fix async REQ callback leak and validate Phase 2+3 subscription offload path

2026-04-01 11:01:38 -04:00

query_analysis_report.md

v2.1.2 - Fix async REQ callback leak and validate Phase 2+3 subscription offload path

2026-04-01 11:01:38 -04:00

relay_admin_migration_plan.md

v2.1.14 - Fix PostgreSQL replaceable/addressable upsert semantics with NIP-01 conflict ordering

2026-05-01 14:38:57 -04:00

remaining_implementation_plan.md

v2.1.6 - Fix strict-mode admin API key access by prewarming config and relay private key caches

2026-04-01 19:08:42 -04:00

sqlite_off_main_thread_plan.md

v2.1.5 - Offload duplicate and COUNT paths, add config/NIP-11 caching, and reduce DB reader threads

2026-04-01 16:15:46 -04:00

thread_pool_pg_optimization_plan.md

v2.1.11 - Fix api-worker DB lifecycle and NIP test reliability: add dedicated worker DB connection, guard PG expiration cast in REQ path, correct NIP-45 baseline-aware expectation, and harden run_all_tests skip handling

2026-04-03 07:32:14 -04:00

wal_checkpoint_fix_plan.md

v2.1.8 - Implement explicit WAL checkpoint scheduling and disable SQLite auto-checkpoint

2026-04-01 21:03:24 -04:00

web_of_trust_plan.md

v1.2.5 - Add nip17_admin_enabled config toggle (default off) to prevent OOM from NIP-17 gift wrap decryption flood

2026-02-23 08:58:10 -04:00

wot_web_ui_plan.md

v1.2.5 - Add nip17_admin_enabled config toggle (default off) to prevent OOM from NIP-17 gift wrap decryption flood

2026-02-23 08:58:10 -04:00