3 ms·
If you want to see a dumb example of how you can implement indexing on top of a SQL database without it, I wrote a tutorial on implementing basic indexes [0] as
by eatonphil 5y ago
If you want to see a dumb example of how you can implement indexing on top of a SQL database without it, I wrote a tutorial on implementing basic indexes [0] as part of a series on making a SQL database from scratch.
And of course, Use the Index Luke is a great reference for the real world.
[0] https://notes.eatonphil.com/database-basics-indexes.html https://notes.eatonphil.com/database-basics-indexes.html
[1] https://use-the-index-luke.com/ https://use-the-index-luke.com/
- unemphysbro 5y agoPhil, These are great! Thank you!
- eatonphil 5y agoThank you!
- frosted-flakes 5y ago[1] above is a fantastic resource. I highly recommend Markus Winand's book "SQL Performance Explained" if you're in need of better performing SQL queries. It's quite short and small, but it covers all the bases, and uses introductory language.
- bogomipz 5y agoI loved your series on writing a SQL DB from scratch. I also enjoyed your recent SMTP post as well. I hope you continue to do these, they're always good reading.
- eatonphil 5y agoThank you! There's a very long list of topics to write about so I'm not too worried about continuing. :) Always open to ideas as well.
- zerr 5y agoDo you implement transactions/ACID?
- eatonphil 5y agoNope. It was a bad idea not to build in transaction support up front. It gets harder to build in later.