But "search" you mean a) searching for a keyword in all events or fetching, say, b) the user's event for some query?
For a I think the solution is to have a click house/bq and an API call. For b caching might actually do for 99% of users
No, it's a server side self hosted db.
It's the Yandex equivalent to Google's bigquery, and it's open source.
What's the usecase you're solving for? Have you thought of a caching strategy instead of a full db?
The last feature of https://jumble.social/ in 2025:
A reputation filter that hides notes from the bottom X% of users by reputation.
It works across feeds, notifications, and replies, and is especially effective at reducing spam when browsing large public relays. #devstr
How does an account get reputation? I like the approach but it typically leads to cold start problem
Depends on the usecase, of course
You can also replicate the data by streaming to an analytical db like click house or Google big query and avoid the indexes. It will just be a tad slower to update due to eventual consistency, but it is much faster for retrieval (and especially aggregations)
Will not *yet*
Just wait for it
I don't have the singer thing on this device. Will take a look tomorrow ;)
But I think the idea is great!
Odell there are dozens
nostr:nprofile1qqsx2q57xwmtqpn074kxjdqtlqe4m4fcg73e8rdl6gnqjvlf2n6jmrs85jfs4
nostr:nprofile1qqsxutc4040jmk84hgvul25wx4dpwjyyftk8p9tw9qwala6236fk83ctauk97
nostr:nprofile1qqs0l4qa3rwt34xl476at0ad8qz5ux6l4fl7m9myqngu5v4nve27epcpa9hls
nostr:nprofile1qqsg6fhv8ckvq9vnml8yxwugfvpk9qff6hhlnvrcgsh2ffm0gf6vukchg403j
nostr:nprofile1qqs0pmg7eul5pu7hdu0xx3qe6uenxz7uychd9xevsk2jdy566ljjmtgglj3zu
nostr:nprofile1qqsgntg7fdrfru08k7gc9hptmautm5anzzn8k7m8865m6yr8wk0nlscx38cpq
nostr:nprofile1qqsr5u4s9nq9acrnzrw9szr5k65u4qn3cegchyr9t0fwnqqre9spu6q5wj9js
nostr:nprofile1qqs2petr92cfgn0vtvw0m3muz20gwk99j93c44c4j3kmmuprssh4wvctxt6dv
nostr:nprofile1qqsqgkc4jpghc5r7a4qfa7pk8xenuyz3se66nl3mqk3d6mfj7sf4mngfrqhrr
nostr:nprofile1qqsgyhpxzyzugfva55xw64w6tayqmz5ck8xyd3lvx35fh3ghw5shpcgnykcvq
nostr:nprofile1qqsgcgp4wcpc8haar9v7lneyyqqcd07ugg52p9l2ctd37zpcdqjsv6cnenx9w
nostr:nprofile1qqs0vgeangklg3zwz6gsu8ckdxquyqkxw2xa5h5tut6sejhqng3zq6ckcmh4f
nostr:nprofile1qqs2pa9692amd0m7dehmt8ukwx9qucfj2j6vnynzeaes3ndr2axft4qyytkrw
nostr:nprofile1qqsza45j3pgxvmy8fgt3wp3q66jy7qaqvru3yrcxwcj7s7tnj79rr6glhfp5q
nostr:nprofile1qqsd3f6ut97x02t5kjl75pu8ve9u60gvan3j0p48kn0v4udjrnpnq5gtc2cw0
Do it against Litecoin 😁
What exactly do you mean?
How about using bigquery's public block dataset?
SELECT count(block_id) FROM 'bigquery-public-data.crypto_bitcoin.blocks'
I think for pineapple you've gone too far! What have we become?
There is a device you can use to measure it, but I'm also curious.
Interesting to see. Don't agree with it, but curious where it will end
nostr:nprofile1qqsqa6p85dhghvx0cjpu7xrj0qgc939pd3v2ew36uttmz40qxu8f8wqpzdmhxue69uhhqatjwpkx2urpvuhx2ue0ew9w8w who are the top ppl in nostr sharing about flag theory and tax optimization strategies?
#asknostr
#bitcoin
Does anyone know if nostr:nprofile1qqsvn0dkjt80raqrxd470c98n7zrdehmcvj6p5hgw3kyku6zyd8z0fqpz4mhxue69uhkummnw3ezummcw3ezuer9wchsxr5s97 supports business accounts in Estonia, Cyprus, Andorra, Bulgaria or Sweden?
Asking for a friend
