Alex on Nostr: Thank you!! I completely reworked the database. Now it's optimized for Postgres and ...
Thank you!! I completely reworked the database. Now it's optimized for Postgres and uses a jsonb column for tags, making it much faster.
Published at
2024-08-17 14:57:25Event JSON
{
"id": "5afefe3221e5865b0c18e18ff833110caf530295b02ed6c6fa0007eeab1a581e",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1723906645,
"kind": 1,
"tags": [
[
"e",
"ca754ef62624426f7dd14908b23ca3f2a1253f018169d160257993de853abe43",
"wss://gleasonator.dev/relay",
"root"
],
[
"e",
"ca754ef62624426f7dd14908b23ca3f2a1253f018169d160257993de853abe43",
"wss://gleasonator.dev/relay",
"reply"
],
[
"p",
"604e96e099936a104883958b040b47672e0f048c98ac793f37ffe4c720279eb2"
]
],
"content": "Thank you!! I completely reworked the database. Now it's optimized for Postgres and uses a jsonb column for tags, making it much faster.",
"sig": "5afab925fe675f5796b69f1f57c5a07e151728be4d4488522a5594e9d7a4a287bac5ac2988c6916ef18aaa1ad79db61678e7948427edea32028012b5f82447ac"
}