▲ 44 ▼ Things you didn't know about indexes (jon.chrt.dev) submitted 3 months ago by bugsmith@programming.dev [M] to c/programming@programming.dev 4 comments fedilink hide all child comments
[–] in_my_honest_opinion@piefed.social 5 points 3 months ago (2 children) 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. permalink fedilink source hideshow 4 child comments replies: [–] aivoton@sopuli.xyz 6 points 3 months ago 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 permalink fedilink source parent [–] bugsmith@programming.dev [S] 2 points 3 months ago I'm glad you enjoyed it. I appreciate the kind words. Feel free to do so! permalink fedilink source parent
[–] aivoton@sopuli.xyz 6 points 3 months ago 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 permalink fedilink source parent
[–] bugsmith@programming.dev [S] 2 points 3 months ago I'm glad you enjoyed it. I appreciate the kind words. Feel free to do so! permalink fedilink source parent