Nate
Nate Levin

Again, I could very well be reading this wrong, but the joins dont look necassary to me, it could look something like this
SELECT *
FROM nostr_events ne
WHERE (kind IN ($1, $2) AND pubkey IN ($3))
AND EXISTS (
SELECT 1
FROM nostr_tags tag0
WHERE tag0.event_id = ne.id
AND tag0.name = $4
AND tag0.value IN ($5, $6)
))
(this isnt directly taken from your query below, this is just an example)
This is also why i recommended the use of the composite index (event_id, name, value), which I would image would give a huge performance boost on that EXISTS check, but without being able to test it (and make sure it returns the correct results) I could be talking out of my ass

2024-07-02 07:08:58

- reply

Unless Im reading this wrong (which I could very well be) the performance would likely be increased dramatically if the unions were removed, as this creates a temporary table in postgresql (or atleast it does in MYSQL which im used to) which adds a lot of overhead. I guess this is probably hard to get rid of however, as Im going to assume this is dynamically generated SQL?
Another performance optimization would be using EXISTS in a few of the queries where the INNER JOIN on nostr_tags is used just to filter (most of them)
Id also suggest if you make the EXISTS change that you create a composite index on (event_id, name, value)
This is my experience with MYSQL though, I know postgres is more efficent in some manners so maybe all of this is automatically done under the hood
If you want me to have a look further into this I would be happy to, but Id probably need to spin up a database (and therefore would need some data)

2024-06-25 21:45:32

- reply

Would be awesome to see this in both Notedeck and Gossip!

2024-06-25 04:57:25

- reply

apples and oranges my friend

2024-06-25 04:56:02

- reply

Alternative to Twitter, not a twitter clone

2024-06-13 23:57:37

- reply

The real problem that this illustrates is 5% deposits

2024-06-11 03:46:10

- reply

The compile time is a feature, we want to keep out the plebs here at rust

2024-06-10 21:06:44

- reply

Well, that is certainly a point of view. Not a good one though. I was suspicious that you may have thought like this however, hence why I used tax in my example

2024-06-10 09:44:22

- reply

I tolerate high tax rates to afford free (hospitalised) healthcare, or taking care of the sick or disabled. One could argue that is good, and one could argue it may cause stress on others. There’s one example for you of something that is good and requires tolerance, please put a little more thought into your next posts!

2024-05-23 05:05:10

- reply

Huh? AFB has been around for many many years before Covid, don’t trust the ‘government scientists’ if that’s what you please, but at least do your own research before talking nonsense

2024-05-22 07:47:23

- reply

The carbon filter makes a massive difference in my opinion. I can’t stand chlorinated water, so we got a plumbed fridge with a carbon filter and it honestly takes 95% as good as rain water

2024-05-18 09:04:22

- reply

This is stupid because AFB colonies aren’t burnt because the government says so, they’re burnt because farmers don’t want to contaminate more hives, because the honey can’t be sold once it’s detected

2024-05-04 07:10:58

- reply

That’s not a jungle brother

2024-04-29 04:09:38

- reply

God himself created rust

2024-03-29 21:31:14

- reply

I’ll keep it in mind 🤣

2024-03-28 22:43:51

- reply

Seems like a client algorithm possibility. The option to add x amount of hours relevancy to someone you follow, meaning that a note published 10 hours ago by publisher X with + 10 hours note relevancy would show as the same relevancy as a new note posted by publisher Y with no added relevancy

2024-02-04 01:32:29

- reply

How the fuck does it make it impossible to test a relay? You can just open a web socket on your local machine and send events. It’s really not that difficult. If you need I can make a terminal for you to do this

2024-02-02 08:42:05

- reply

Congrats!

2024-01-24 00:03:32

- reply

What’s my score? 🧐

2023-10-18 10:18:00

- reply

Wow thats way less than I thought actually. Was just discussing this before and was curious

2023-10-18 10:15:34

@npub1xts…kk5s How much storage is the Damus relay using?

2023-10-13 04:18:39

- reply

People getting carried away and jumping to conclusions... never. I refuse to believe it...

2023-10-12 09:38:20

- reply

on a more happy note im loving the new gossip client look

2023-10-08 21:24:23

- reply

Looks great

2023-10-05 09:36:29

- reply

They keep putting more and more letters in that shit. Couldn’t just keep it LGBT? 🤣

2023-10-03 21:08:36

- reply

This is a really bad take. You can’t make a story up and then claim it’s accurate of ‘their society’. If it was, you wouldn’t need to post a factually incorrect article as proof

2023-09-28 11:12:56

Just watched the New Zealand Election Youth Debate, and it hurt me to watch. Chloe Swarbrick for the greens party was the only one with original thoughts, the rest were struggling to regurgitate barely relevant information, or fumbling statistics written down infront of them. Though my own plotical opinions differ from Chloes, shes clearly a smart woman with a great ability to articulate her thoughts in a clear and concise manner and was the only one to, at one point or another, recognise that her own thoughts are not all that matters, and that the thoughts of the community are what should be pressuring/pushing her decisions. That is democracy, and she would be a leader I would vote for as my vote will go to someone I believe 1) Has similar political beliefs, 2) And more importantly, respects democracy and all it entails.
Just to be clear for any New Zealanders reading... I will not be voting Greens

2023-09-26 21:52:24

- reply

Yes you can query s3 by filename

2023-09-24 04:41:36

- reply

Thats a pretty big jump to make mate. Not sure you understand much of this at all.

2023-09-09 06:10:33

Great, get to hear every armchair coach tell me what the allblacks did wrong. The worst bit about New Zealand losing

2023-09-07 09:43:35

- reply

Beyond Bitcoin price go up I don’t know shit about Bitcoin, I haven’t been bullied for it at all

2023-09-02 08:31:55

- reply

Mousepad had seen better days

2023-08-24 08:20:51

- reply

Your experience is a typical user experience. I don’t really use social media that much, so I really struggle to find people to follow on nostr. You are at the forefront of it all, so lots of interactions

2023-08-12 09:41:29

- reply

?? Better performance will almost always mean better battery life in this case

2023-08-10 07:33:51

- reply

Fantastic work. Insane performance

2023-08-09 10:47:30

- reply

Incredibly impressive

2023-08-05 09:53:01

- reply

Hey mate love your work. Ive followed Melisearch for about 3 months on github and have been begging for a place to use it. Keep it up

2023-08-05 09:40:05

- reply

Its just another way of interfacing with git

2023-08-05 03:35:01

- reply

This seems exceptionally bizarre. Im sorry thats the experience that you've had.

2023-08-05 01:17:35

- reply

I already do this with @npub1acg…p35c so I guess I can agree to do this with you too 🤣

2023-08-04 08:15:37

- reply

Awesome, yeah I’ve looked at some of your nostrdb stuff it’s really well done. Great steps forward.

2023-08-04 05:35:03

- reply

Is the nostrdb live in the latest testflight for damus?

2023-07-19 07:58:34

- reply

This is done by… building consents. They already know the outlay of your house

2023-07-18 04:29:28

- reply

How is Domus coming along? Is there somewhere i can pull from?

2023-07-13 12:28:43

@npub1xts…kk5s how is domus going? I can’t git clone it anymore

2023-07-08 08:21:36

- reply

Congrats everyone. All the hard work you’ve put in has paid off. So awesome to see this for the community

2023-07-05 23:00:26

- reply

I just read this is a design not the actual app, you've got a mountain in front of you lol

2023-07-05 22:58:51

- reply

God damn it takes some kind of wizard to turn egui into this props to you

2023-07-05 09:54:49

Maybe it’s just me… yeah it’s probably just me but c# fucking sucks 🤣

2023-07-03 23:42:53

- reply

What even is this?

2023-07-02 08:40:17

- reply

Bro… what the hell is that next to the steak? Looks like an over-cooked air fryer dumpling 🤣

2023-07-02 08:39:07

Just starting work on a c# client to help learn the language… unfortunately that’s where all the jobs in New Zealand are. Going to take some time because I have 1/1000th the skill of most the programmers on here 🤣

2023-07-01 06:22:43

- reply

From context he means rounded edges

2023-06-25 03:33:02

Available for purchase at a market in Oamaru, New Zealand… the poor woman had no idea 🤣 it’s a croc charm https://nostr.build/i/5f5949a92fe1458a1fc8e9bdc7d1d6f099327af011df0396d50c82304cd3b3ab.jpg

2023-06-19 05:15:39

- reply

I’m thinking one (or both) of these videos might be a lie, though I suppose they aren’t mutually exclusive

2023-06-04 08:04:47

- reply

This is hilarious

2023-05-31 05:16:03

- reply

@npub1tsg…htk4 and their npubs?

2023-05-31 05:13:41

- reply

@npub1tsg…htk4 any more good accounts to follow not related to bitcoin?

2023-05-31 04:54:24

- reply

@dave could I please have the npubs associated with these accounts?

2023-05-31 04:01:17

@npub1tsg…htk4 could you please list a few of the more popular nostr accounts npub's for me to follow

2023-05-22 02:15:35

- reply

Thats fucking bullshit

2023-05-16 03:19:49

Gossip new ui in lets go boys

2023-05-12 01:06:36

- reply

How do we even know whats wrong and whats right

2023-05-10 05:29:13

- reply

What oamaru is that then?

2023-05-09 03:26:54

Oamaru isn’t the tech capital of the world it would seem

2023-05-07 02:05:23

- reply

Thats not going to happend...

2023-05-03 08:27:16

- reply

This is the content I come to nostr for 🤣🤣

2023-05-02 09:24:10

- reply

100% agree

2023-04-21 06:20:14

- reply

I see. I just pushed my contactlist and now it has synced with damus. My last push must have failed for some reason. Thanks

2023-04-20 05:35:12

#[0] how can I sync who I follow on damus with other clients?

2023-04-17 10:06:45

- reply

South Miami beach and in Washington… it looks like someone else who replied to you might have been at the same one at Miami Beach

2023-04-17 10:05:56

- reply

Was this south Miami Beach? We could have been at the same one

2023-04-11 11:18:13

- reply

Got to love adelaide!

2023-04-11 05:24:08

Damn gossip is looking unreal now. Good work @npub1acg…p35c and all others who have been working on it

2023-03-31 08:07:57

- reply

#[1] sorry didn’t tag correctly

2023-03-31 08:05:58

Big ups to @ hodlbod for the impressive work with corocle. Looks and works great

2023-03-30 07:50:09

- reply

Or use chatgpt to create the whole app for you 🤣

2023-03-29 23:31:04

Maui hot as fuck 🥵

2023-03-25 20:11:58

- reply

Sometimes I jump on twitter just to see how the other half lives

2023-03-22 23:31:35

She is grand, and she is canyon https://nostr.build/i/nostr.build_cab616b741243c9a5670e43153bac7a6cf072ae5646c9507c360c48358d97a58.jpg

2023-03-21 00:31:46

- reply

Don’t waste your time replying to this garbage

2023-03-20 22:11:23

- reply

#[3] king of the normies

2023-03-20 22:10:47

- reply

#[4] normies are the worst

2023-03-20 02:49:11

- reply

Sorry I wasn’t replying to you but other the guy. What does GFY mean 🤣

2023-03-19 14:44:51

- reply

How exactly does having experience with Bitcoin help with a banking crisis?

2023-03-19 14:39:55

- reply

The problem with being stupid is that you don’t realize that you are stupid. I will point it out for you though, you’re stupid. If you have an opinion on something, that is entirely your right, but it’s your opinion which means it’s never likely to be true. I have a genuine feeling of sympathy for you

2023-03-10 05:46:33

- reply

What’s brexit but for the US states? In all seriousness I’ve met some fantastic people while travelling the states, but when talking politically with them, it seems that many have just accepted that politicians are crooked and don’t really care about the American people.
Though I didn’t fully agree with some of them politically, it’s very clear that the average Americans voice just isn’t heard in the political (echo) chamber

2023-03-09 15:28:39

Damn I’m starting to really get sick of hearing Empire State of Mind by Jay-Z and Alicia keys blasting by 13 different people in every tourist destination in Manhattan 🤣

2023-03-09 02:56:21

- reply

There’s still a fix me in that commit?

2023-03-07 03:03:04

- reply

It’s your project don’t get rushed by others. You’re building this to be an app you want to use, with support for other users

2023-03-07 03:00:34

- reply

Tbh I hardly know what the idea of shitcoins are, like I know of ethereum and the noobs over there but not really much else

2023-03-06 22:18:18

- reply

What shitcoins are you against?

2023-03-05 10:27:02

- reply

That’s disgusting… I can’t believe you use a MacBook for programming 🤣

2023-03-05 10:24:32

- reply

It’s impossible to create bugs in rust, but nice try fooling us 🤣 Very good work I’ve been scanning all the commits a few times a day. Awesome seeing how many are contributing aswell. I wish I could be doing something

2023-03-02 05:00:37

For some reason when I open Damus, for the first five minutes or so the only person who’s posts I will see is #[0]‘s 🤣

2023-03-01 22:30:47

- reply

Oh and I’ll try to set up a wallet when I get back to LA and have some time. In San Diego now, heading back to LA shortly and flying out to NYC on Friday (Saturday your time)

2023-03-01 22:29:34

- reply

I see that I have been added thank you! I’ve been following closely. I’ve been close to hijacking Kristina’s mac to develop on 🤣

2023-02-25 19:30:39

- reply

Take that back. Don’t put rust in the same category as PHP 🤣

2023-02-25 03:43:14

- reply

Damn awesome progress man. It’ll be cool to see all the progress when I get back