Replacement for ActiveRecord?

[vitorpamplona]

@wilsonsilva I assume you have thought about this but do you think there is any way to build an ActiveRecord replacement that saves things on Nostr instead of a regular database?

I am trying to connect a Rails app into Nostr and thought about doing this via nostr-protocol/nips#1168

[wilsonsilva]

@vitorpamplona It is certainly possible. Either by:

• Creating an ActiveRecord adapter that inherits from ActiveRecord::ConnectionAdapters::AbstractAdapter
• Leveraging ActiveResource, with a custom implementation of ActiveSupport::Connection.

The latter seems more straightforward to implement because it probably doesn't involve relational algebra and AREL visitors.

Do you need to use ActiveRecord or ActiveResource would do?

[vitorpamplona]

I am currently converting an old system that uses ActiveRecord to Nostr and could try to use it. But insert, update, delete are the easy parts. The hard part is how to migrate querying. I am not an advanced Ruby dev, so we will see how this goes. :)

[wilsonsilva]

I see. This sounds like an exciting challenge. I would love to help. I looked at other ActiveRecord adapters to understand how this could be implemented.

However, due to my current focus on securing a job, I cannot actively contribute to coding this feature immediately. Once my job situation is resolved, I will happily revisit this request and collaborate on implementing the ActiveRecord adapter.

For querying, would an API like this match your needs?

# Define your ActiveRecord model
module YourApp
  class Event < ApplicationRecord
  end
end

# Perform a query using the filters available in nostr
events = YourApp::Event.where(
  kinds: [
    Nostr::EventKind::TEXT_NOTE,
    Nostr::EventKind::ENCRYPTED_DIRECT_MESSAGE
  ],
  since: Time.now.to_i - 3600, # 1 hour ago
  until: Time.now.to_i,
).limit(5)

This query would be then translated by the adapter into an nostr request to create a subscription:

 ["REQ","e5b444d640206e906b4ac6a2c33b3413",{"kinds":[1,4],"since":1713099732,"until":1713103332,"limit":5}]

The nostr relay would send the events matching the nostr above:

["EVENT","e5b444d640206e906b4ac6a2c33b3413",{"content":"Estou testando e espero que eles divulguem o código no futuro. As outras redes são opcionais.","created_at":1713103312,"id":"471368d61ef8d99a32f3e6ea3232a0d70ee73585e60daf6532172ece317d4343","kind":1,"pubkey":"619af6a60b3fe4c733aaca061c522cc9c7cf1d87ef4c908facc5ed936d3bdf23","sig":"44dc4637e63b2699e9cac74c3df068a0ca83982cd6eb2fc65642dc1352200364662388356d8fd11038282ac4d69cfe2e87871e7b671e7ddac43b3347c27696c5","tags":[["e","271aeb104708e454ef99f9435da343cad273ca316b288fa0d6f318e411079762","wss://nos.lol/","root"],["e","e5486c2d7da52556297765f0d52a3041a002352c0d2614ee1f17eeb42cd9977e","wss://nostr.bitcoiner.social/","reply"],["p","34651a9392d34bf9d064e39f3c10beef74b5e28e710c07324317b687c4abd7e8","wss://relay.nostr.band/","mention"]]}]

["EVENT","e5b444d640206e906b4ac6a2c33b3413",{"content":"#foodstr #steakstr 😋 https://image.nostr.build/b43eb53d82b82ef37466f8ce46d6c78e1674ec1b1295e29970a898c6c71c0367.jpg ","created_at":1713103312,"id":"43f0a593c9ac03cb040b868643a2b85c4c7b522ade8a6d67c8babe608db38e35","kind":1,"pubkey":"a6d9fa6142f2808ff2f8fc567996a9428051530f9de8801c559b691d0abd11e7","sig":"1ed4ec1bbf378a03ecd6074de8a1ea530a10558075776540eb163d51c700a110b1469bb9a651e23fffb929976b3c3e9aa4d9d4f86bc1ecaf429ac876a71df73e","tags":[["imeta","url https://image.nostr.build/b43eb53d82b82ef37466f8ce46d6c78e1674ec1b1295e29970a898c6c71c0367.jpg","blurhash eLJ%FEBo_M-:x]ouMdX4Rjof%}xv-;soaht7V?kWtQ%3yDxu%3o0I:","dim 3024x4032"],["t","foodstr"],["t","steakstr"],["r","https://image.nostr.build/b43eb53d82b82ef37466f8ce46d6c78e1674ec1b1295e29970a898c6c71c0367.jpg"]]}]

["EVENT","e5b444d640206e906b4ac6a2c33b3413",{"content":"Sometimes I have to double-check myself that I’m not getting swept up in bitcoin’s hype/craze/moonboy predictions.\n\nThen I work through everything again for the 10,000th time and ultimately conclude that bitcoin is the most logical store of value asset we’ve ever seen.","created_at":1713103305,"id":"25acfbcc7ea23587d1ec535e8435e6066695a59a185ff139a1999ee90bd35a80","kind":1,"pubkey":"77073de7bf2e25947419712f10b1ff7e3c34c67e8774becfa9ceae25010dcedb","sig":"c3d96004be47664da98fb10b5c3f3e30954aa404bf03f15804f04955e5b23c3f3370d6eea31db59e01294047dc54b8ccf1722cb263cfb2a9a2def4aa723cd103","tags":[]}]

["EVENT","e5b444d640206e906b4ac6a2c33b3413",{"content":"59WKeKkhqt94GiQD3UdP6vrTogyzHRsq0Eud1BBEYHIZMOrsqfiN+YyZahGAvXoNBSUZefTcxFcPxMmwUzAuvg==?iv=9jbK+ojG4W7SUE54i2VcgQ==","created_at":1713103305,"id":"9d31662d6484170217807369df490a00087d9ae0f167ecd4a50990a7739949d1","kind":4,"pubkey":"21b419102da8fc0ba90484aec934bf55b7abcf75eedb39124e8d75e491f41a5e","sig":"70a5e1f884de8eafa4bef966c32dc04ceabd2bf24de9e50d6509e24cea8b39dbfa5fb58740641af5eb398a989e534810f5c93da976f09059af50660dc9eebea6","tags":[["p","3bc472388945350b78fc9e5b69e82f6e8f8fe2ee14953b81517960e3a08efb71"],["alt","Private Message"]]}]

["EVENT","e5b444d640206e906b4ac6a2c33b3413",{"content":"Lightning Force Close Detected in Block 839197 between  and River Financial 1\n22K sats to force close a 17M sats channel 🤮\nhttps://mempool.space/tx/da861d54957bc3d0c675e84ce3a2c609ce7ab6b823cc90d0637cb240642643ca","created_at":1713103305,"id":"b5dc800e21034ec107627afbd76c50cdcd6fd2475bd6c8b9c419495bc27ffe90","kind":1,"pubkey":"d1665cf52f5a9f27cf29703e05cc180c09b52aca9bb598af2c58c63e572bf387","sig":"fa49dd774c3e2b16f2007ad28c1ef1778f7b410a620e1254c77a0bd7948c15e92aa2c4a98bd2b4a15e355632e08ef24a8fe52c7564c299376e03f089535d9f90","tags":[]}]

Finally, upon receiving the EOSE message, it would build the ActiveRecord objects:

["EOSE","e5b444d640206e906b4ac6a2c33b3413"]

event = events.first
event.id # => "43f0a593c9ac03cb040b868643a2b85c4c7b522ade8a6d67c8babe608db38e35"
event.pubkey # => "a6d9fa6142f2808ff2f8fc567996a9428051530f9de8801c559b691d0abd11e7"
event.content # => "Estou testando e espero que eles divulguem o código no futuro. As outras redes são opcionais."