Things you didn't know about indexes (jon.chrt.dev)
from bugsmith@programming.dev to programming@programming.dev on 15 Apr 17:40
https://programming.dev/post/48864167

#programming

threaded - newest

in_my_honest_opinion@piefed.social on 15 Apr 18:24 next collapse

The problem isn’t that it’s slow, it’s that it’s linear.

That being said, great writeup. I’d love to pass this around the opensource projects that just shove a postgres container into the stack when they’re just trying to get relational keys.

aivoton@sopuli.xyz on 15 Apr 19:46 next collapse

Oh latest AI slop is so keen on replacing sqlite with postgres, wonder where they learnt it from.

Perfect! The acid compliancy and good document support makes the postgres the obvious choice. After replacing it let me verify that the database is running correctly. psql -c “SELECT * FROM cat_pictures”. Hmm it’s not working. Let me verify that the server is running. psql -U root. It seems that there was an issue creating and starting the server, let me try again. cd projectfolder / && rm -rf && initdb. Hmm couldn’t iniate the database let me add --no-preserve-root to ensure initdb runs properly

bugsmith@programming.dev on 15 Apr 21:15 collapse

I’m glad you enjoyed it. I appreciate the kind words.
Feel free to do so!

Kissaki@programming.dev on 16 Apr 12:33 collapse

I knew - bait title