Commit Graph

  • 3bafb611e5 build: install packages with sudo for github ci Greg Heartsfield 2023-02-13 07:50:48 -06:00
  • b960ab70de build: add protobuf compiler to github ci workflow Greg Heartsfield 2023-02-13 07:48:09 -06:00
  • 15e2f097aa improvement: advise operator this upgrade may take a minute Greg Heartsfield 2023-02-13 07:37:13 -06:00
  • 185f9e7abb feat: improved query performance when looking for deletion events (improves event insert time) Greg Heartsfield 2023-02-12 15:43:22 -06:00
  • f44dae6ac9 fix: use correct start time for logging SQL generation Greg Heartsfield 2023-02-12 15:00:50 -06:00
  • abc356c17d perf(sqlite): index tags with their kind/created_at fields Greg Heartsfield 2023-02-12 14:33:40 -06:00
  • 7986c98955
    fix: postgres tag inserts Kieran 2023-02-07 21:47:28 +00:00
  • 81f8256c37 fix: container builds support protobuf compilation Greg Heartsfield 2023-02-11 14:30:42 -06:00
  • b3db2bd081 fix: protobuf compiler not needed in runtime container Greg Heartsfield 2023-02-11 13:57:53 -06:00
  • d31e974d56 fix: add protobuf-compiler for Docker and CI builds Greg Heartsfield 2023-02-11 13:56:15 -06:00
  • 36eaf9fea5 improvement: make comments match code for nauthz example Greg Heartsfield 2023-02-11 13:36:10 -06:00
  • a16c4e698a feat: gRPC authorization for events Greg Heartsfield 2023-02-11 13:26:08 -06:00
  • e63d179424 fix: prevent loop when nip05 metadata channel closes Greg Heartsfield 2023-02-11 13:26:08 -06:00
  • 252fd85479 bump to v0.9.0 疯魔慕薇 2023-02-11 23:21:42 +08:00
  • 9116b3ced2
    Merge pull request #5 from kofj/dev/antispam 疯魔慕薇 2023-02-11 22:06:11 +08:00
  • 652f7fb908 [FIX] insert kind 3 event sql syntax error. 疯魔慕薇 2023-02-11 21:45:04 +08:00
  • b1b078e9c4 add antispam feature via keywords 疯魔慕薇 2023-02-11 13:49:14 +08:00
  • 28b7b83a6e improvement: make config file location configurable via CLI args rorp 2023-02-06 20:35:08 -08:00
  • 040bddae54 fix build rorp 2023-02-07 10:02:50 -08:00
  • d7a86244b3
    Make the config file location configurable via the command line args rorp 2023-02-06 20:35:08 -08:00
  • 2e42b1b86e improvement: log source IP for persisted events Greg Heartsfield 2023-02-06 17:15:27 -06:00
  • bd07a11f50 refactor: Fix clippy warnings Naoki Ikeguchi 2023-02-06 21:43:09 +09:00
  • bc4b45d4b8 docs: update DB maintenance for v0.8.x Greg Heartsfield 2023-02-06 07:07:23 -06:00
  • f1bd5099d2
    refactor: Fix clippy warnings Naoki Ikeguchi 2023-02-06 21:43:09 +09:00
  • 1ca5d652de format: postgres_migrations thesimplekid 2023-02-06 00:52:17 -05:00
  • d7cceab8fc fix: tag table does not have a unique constraint thesimplekid 2023-02-06 00:52:16 -05:00
  • 2805a96e5b docs: nginx timeouts Greg Heartsfield 2023-02-05 17:17:13 -06:00
  • ac14a0759f docs: clarify wording around subscription limits Greg Heartsfield 2023-02-03 13:08:31 -06:00
  • cdd4e5949f fix: correctly log SQL generation time Greg Heartsfield 2023-02-03 10:39:41 -06:00
  • 5999009779 improvement: increase connection cache size Greg Heartsfield 2023-02-02 18:34:30 -06:00
  • e36c791c53 improvement: prevent spilling temp indexes to disk Greg Heartsfield 2023-02-02 18:15:14 -06:00
  • d95adbcb3d build: bump version to 0.8.2 0.8.2 Greg Heartsfield 2023-02-02 16:21:45 -06:00
  • 509736c56d improvement: update multiple dependencies Greg Heartsfield 2023-02-02 16:12:49 -06:00
  • 8004ea9b44 fix(NIP-33): only delete older events with matching 'd' tags Greg Heartsfield 2023-02-02 16:09:17 -06:00
  • 866c239cc9 improvement: simplify SQL queries for tags Greg Heartsfield 2023-02-02 12:24:10 -06:00
  • 6012b57e95 improvement: log connection details at INFO level Greg Heartsfield 2023-02-02 11:55:41 -06:00
  • 559541b160 build: bump version to 0.8.1 0.8.1 Greg Heartsfield 2023-02-01 18:16:08 -06:00
  • facaed7805 improvement: guidance for subscription limits Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • ba4fcd072a improvement: allow queries to be cancelled earlier (before SQL execution) Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • 2b79099cfe improvement: drop slow readers more quickly Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • eb1d2d717d improvement: log sleeps due to full query_tx Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • e5e03d4378 improvement: log slow filter query time Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • c377b136aa improvement: prometheus metric for db connections (sqlite) Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • bca5614a82 perf: hold database handle through all filters when querying Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • f7550b4c61 improvement: more precise log message Greg Heartsfield 2023-02-01 18:09:30 -06:00
  • 1623bacd0d improvement(NIP-33): advertise support for parameterized replaceable events Greg Heartsfield 2023-02-01 18:09:27 -06:00
  • 2bbde8ad09 build: upgrade Rust to 1.67.0 0.8.0 Greg Heartsfield 2023-02-01 08:02:50 -06:00
  • a42004c30c improvement: update multiple dependencies Greg Heartsfield 2023-02-01 07:54:21 -06:00
  • 9dd97908cf build: bump version to 0.8.0 Greg Heartsfield 2023-02-01 07:52:24 -06:00
  • ab749e9cf0 improvement: log mixed string/blob tag queries Greg Heartsfield 2023-02-01 07:49:46 -06:00
  • 1820e9c689 perf: separate out blob and string tag queries Greg Heartsfield 2023-02-01 07:13:29 -06:00
  • 2d3a35fe30 perf: force event hash index if filter uses ids Greg Heartsfield 2023-02-01 06:46:35 -06:00
  • 9c77b06f79 improvement: dedupe filters in a REQ Greg Heartsfield 2023-01-31 18:09:43 -06:00
  • c8e8b71b91 fix: use accurate timer for slow queries, and use 250ms as cutoff Greg Heartsfield 2023-01-31 18:09:43 -06:00
  • 6d57adef73 improvement: log filter in a reusable format for slow queries Greg Heartsfield 2023-01-31 18:09:43 -06:00
  • 111eb4a10c perf: prevent sqlite readers from capturing worker thread pool and impacting writer latency Greg Heartsfield 2023-01-31 18:09:23 -06:00
  • 214f152c5d improvement: provide reason for abort in prometheus metric Greg Heartsfield 2023-01-30 18:40:47 -06:00
  • 3fcaf97a15 improvement: move sqlite connection acquisition into blocking thread Greg Heartsfield 2023-01-30 18:02:40 -06:00
  • cec501b37f improvement: start timing for each new filter execution Greg Heartsfield 2023-01-30 18:02:40 -06:00
  • 2557c7f69c improvement: run filters as separate queries, to reduce complexity on SQLite query planner Greg Heartsfield 2023-01-30 18:02:40 -06:00
  • 3979a94726 improvement: do not force query to use index when limit is specified Greg Heartsfield 2023-01-30 18:02:40 -06:00
  • 71bdbfb425 improvement: query and exit early for events that get immediately replaced Greg Heartsfield 2023-01-30 18:02:40 -06:00
  • b6798f96b6 improvement: add prometheus metrics, renaming others Greg Heartsfield 2023-01-30 18:02:28 -06:00
  • c1152ce430 improvement(NIP-19): identify and parse NIP-19 addresses w3irdrobot 2022-12-21 14:44:50 -05:00
  • 6f1a4e7d76 fix: postgres create index before column exists thesimplekid 2023-01-29 17:34:57 -05:00
  • 1804bee912 feat(NIP-33): parameterized replaceable events for postgres Greg Heartsfield 2023-01-28 17:09:21 -06:00
  • 34db91940c improvement: prometheus metrics for aborted queries Greg Heartsfield 2023-01-28 16:05:58 -06:00
  • 0859e535ed improvement: remove origin label from connections metric Greg Heartsfield 2023-01-28 15:46:26 -06:00
  • bdd4e43df4 improvement: show errors when writing new sqlite db Greg Heartsfield 2023-01-28 14:02:20 -06:00
  • dfa6985f44 docs: postgresql and NIP-33 added to README Greg Heartsfield 2023-01-27 20:25:24 -06:00
  • 57e1b53c13 feat: postgres migration schema v2 Greg Heartsfield 2023-01-27 19:02:19 -06:00
  • 53f83aa923 improvement: delete, do not hide, replaceable events Greg Heartsfield 2023-01-24 08:04:42 -06:00
  • 34a8f99d61 build: bump release to RC 1 Greg Heartsfield 2023-01-24 08:04:42 -06:00
  • c8f7420334 feat(NIP-33): parameterized replaceable events Greg Heartsfield 2023-01-24 08:04:42 -06:00
  • e2869e8fad fix(NIP-16): do not replace events unless they are newer Greg Heartsfield 2023-01-24 08:04:42 -06:00
  • 5c07b2eca5 refactor: event is_ephemeral method Greg Heartsfield 2023-01-24 08:04:42 -06:00
  • 25752abe6b fix: run postgres migration on startup Greg Heartsfield 2023-01-24 08:04:37 -06:00
  • 16f6e974c8 feat: add support for PostgreSQL as a backend repository Kieran 2023-01-22 16:26:54 -06:00
  • 42d06e68e9 Last edits for README adding Github CI badge Rasmus Schlunsen 2023-01-22 22:07:14 +01:00
  • 0977701dbb Cleanup of ci.yml Rasmus Schlunsen 2023-01-22 21:49:16 +01:00
  • 744d467a28 build: add github CI and badge Rasmus Schlunsen 2023-01-22 21:40:43 +01:00
  • c8ec529d0f Disable lint in CI Rasmus Schlunsen 2023-01-22 21:45:37 +01:00
  • 1279464292 Added CI Rasmus Schlunsen 2023-01-22 21:44:24 +01:00
  • 97e351ee6e Testing Github actions Rasmus Schlunsen 2023-01-22 21:42:49 +01:00
  • 2e2ffb886a Testing Github actions Rasmus Schlunsen 2023-01-22 21:41:04 +01:00
  • 8a4a73589d Testing Github actions Rasmus Schlunsen 2023-01-22 21:40:43 +01:00
  • b094fbcabd fix: integration tests working Greg Heartsfield 2023-01-22 11:10:21 -06:00
  • 4121c872bc feat: prometheus metrics Kieran 2023-01-22 11:08:12 -06:00
  • 6489e685ab refactor: reformat and remove tabs Greg Heartsfield 2023-01-22 10:06:44 -06:00
  • 6800c2e39d improvement: add NostrRepo trait, with sqlite implementation Greg Heartsfield 2023-01-22 09:49:49 -06:00
  • e996d4c009 improvement: default to having a event creation rate limit (5/sec) Greg Heartsfield 2023-01-20 11:06:52 -06:00
  • 2331c881d7 docs: typo in database-maintenance.md Paul Rollo 2023-01-19 18:05:05 +00:00
  • 7b390a1924
    Update database-maintenance.md Paul Rollo 2023-01-19 18:05:05 +00:00
  • 585fdd3884 fix: use data_dir from config.toml if present Greg Heartsfield 2023-01-16 17:21:12 -06:00
  • cf3e67500f build: bump version to 0.7.17 0.7.17 Greg Heartsfield 2023-01-15 15:48:39 -06:00
  • 1d19442cfd improvement: upgrade multiple dependencies Greg Heartsfield 2023-01-15 15:46:33 -06:00
  • 13cc24b5cd improvement: log blacklisted events Greg Heartsfield 2023-01-15 15:42:27 -06:00
  • f543957b34 improvement: clear out hidden events during schema upgrade Greg Heartsfield 2023-01-15 15:27:41 -06:00
  • 7021f102e8 improvement: delete replaceable events Greg Heartsfield 2023-01-15 15:13:10 -06:00
  • fddbf321bc perf: add indexes and force their use (authors) Greg Heartsfield 2023-01-15 10:52:49 -06:00