Hacker News
- Use the Index, Luke https://use-the-index-luke.com/ 3 comments
- SQL Indexing and Tuning E-Book for Developers http://use-the-index-luke.com/ 6 comments
- What's left of NoSQL? http://use-the-index-luke.com/blog/2013-04/whats-left-of-nosql/ 104 comments
- MongoDB is to NoSQL like MySQL to SQL - in the most harmful way http://use-the-index-luke.com/blog/2013-10-01/mysql-is-to-sql-like-mongodb-to-nosql 121 comments
- The B-Tree: It is like searching in a telephone directory with shuffled pages http://use-the-index-luke.com/sql/anatomy/the-tree 2 comments
- Everybody thinks SQL joins are slow-is it because MySQL doesn't have hash joins? http://use-the-index-luke.com/sql/join/hash-join-partial-objects 24 comments
Lobsters
- Use The Index, Luke https://use-the-index-luke.com/ 2 comments databases , performance
- On Uber’s Choice of Databases http://use-the-index-luke.com/blog/2016-07-29/on-ubers-choice-of-databases 4 comments databases
- Amazing book on database performance: SQL Indexing and Tuning e-Book for developers https://use-the-index-luke.com 4 comments postgresql
- Stop using offset for pagination - Why it's grossly inefficient https://use-the-index-luke.com/no-offset 212 comments programming
- Index INCLUDE Clause in SQL: How it works and when to use it https://use-the-index-luke.com/blog/2019-04/include-columns-in-btree-indexes 15 comments programming
- My site 'Use The Index, Luke!' about SQL indexing was recently updated and is available in five languages https://use-the-index-luke.com/ 76 comments programming
- The 3-minute SQL indexing quiz: Can you spot the five most common mistakes? https://use-the-index-luke.com/3-minute-test 67 comments programming
- Big News In Databases: new SQL standard, cloud wars, ACIDRain (Spring 2017) http://use-the-index-luke.com/blog/2017-05/new-sql-standard-oracle-122-acidrain 3 comments programming
- On Uber’s Choice of Databases [Use The Index Luke] http://use-the-index-luke.com/blog/2016-07-29/on-ubers-choice-of-databases 39 comments programming
- Modern SQL: Inaugural Post http://use-the-index-luke.com/blog/2015-09/modern-sql-inaugural-post 13 comments programming
- We need tool support for keyset pagination http://use-the-index-luke.com/no-offset 14 comments programming
- Basics of database optimization http://use-the-index-luke.com/blog/2014-07/finding-all-the-red-mms 113 comments programming
- What I learned about SQLite…at a PostgreSQL conference http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference 221 comments programming
- What’s left of NoSQL? http://use-the-index-luke.com/blog/2013-04/whats-left-of-nosql/ 42 comments programming
- Thank You MySQL, We’ll Miss You! http://use-the-index-luke.com/blog/2014-04-01/thank-you-mysql-we-will-be-missing-you 21 comments programming
- Result of a simple SQL indexing quiz: 60% fail http://use-the-index-luke.com/blog/2014-02/results-three-minutes-sql-performance-quiz 363 comments programming
- Unreasonable Defaults: Primary Key as Clustering Key http://use-the-index-luke.com/blog/2014-01/unreasonable-defaults-primary-key-clustering-key 4 comments programming
- MongoDB is to NoSQL like MySQL to SQL — in the most harmful way http://use-the-index-luke.com/blog/2013-10/mysql-is-to-sql-like-mongodb-to-nosql 73 comments programming
- It's not about the star, stupid! http://use-the-index-luke.com/blog/2013-08/its-not-about-the-star-stupid 9 comments programming
- The two top performance problems caused by ORM tools http://use-the-index-luke.com/blog/2013-04/the-two-top-performance-problems-caused-by-orm-tools 157 comments programming
- A URL to toss at your SQL dev's http://use-the-index-luke.com/ 5 comments sysadmin
- SQL Indexing and Tuning e-Book for *developers* — Available in English, German and now also French! http://use-the-index-luke.com/ 14 comments programming
- A quiz that teaches you how to avoid the most common SQL performance issues http://use-the-index-luke.com/l/3-minute-test 61 comments programming
- Table of Contents: Everything developers need to know about SQL performance http://use-the-index-luke.com/sql/table-of-contents 56 comments programming
- Several ways to SQL pagination, including performance charts http://use-the-index-luke.com/sql/partial-results 29 comments programming
- Indexing the order by clause? Sure! http://use-the-index-luke.com/sql/sorting-grouping/indexed-order-by 6 comments programming
- Developers Need to Index http://use-the-index-luke.com/sql/preface 68 comments programming
- A MySQL Row Generator http://use-the-index-luke.com/blog/2011-07-30/mysql-row-generator 3 comments mysql
- The smartest way to make SQL slow http://use-the-index-luke.com/sql/where-clause/obfuscation/smart-logic 121 comments programming
- Everybody thinks SQL joins are slow--is it just because MySQL doesn't have hash joins? http://use-the-index-luke.com/sql/join/hash-join-partial-objects 295 comments programming
- Scaling horizontally is not about response time--indexing is. In SQL and NoSQL. http://use-the-index-luke.com/sql/testing-scalability/response-time-throughput-scaling-horizontal 22 comments programming
- SQL Performance checklist: Avoid index filter predicates http://use-the-index-luke.com/sql/testing-scalability/system-load 7 comments programming
- A visual explanation why SQL's LIKE is slow http://use-the-index-luke.com/sql/where-clause/searching-for-ranges/like-performance-tuning 83 comments programming
- Working With Dates in SQL -- what to avoid, how to do it right http://use-the-index-luke.com/sql/where-clause/obfuscation/dates 45 comments programming
- The million dollar question of SQL indexing: Why not using one separate index for each column? http://use-the-index-luke.com/sql/where-clause/searching-for-ranges/index-combine-performance 35 comments programming
- Use The Index, Luke! A guide to database performance for developers. http://use-the-index-luke.com 34 comments programming
Linking pages
- Why SQL Is Neither Legacy, nor Low-Level, nor Difficult, nor the Wrong Place for (Business) Data Logic, but Is Simply Awesome! | Vertabelo Database Modeler http://www.vertabelo.com/blog/notes-from-the-lab/why-sql-is-neither-legacy-nor-low-level-but-simply-awesome 593 comments
- How To Become a Data Engineer https://khashtamov.com/en/how-to-become-a-data-engineer/ 137 comments
- Many SQL Performance Problems Stem from “Unnecessary, Mandatory Work” – Java, SQL and jOOQ. https://blog.jooq.org/2017/03/08/many-sql-performance-problems-stem-from-unnecessary-mandatory-work/ 117 comments
- Explaining The Postgres Meme https://avestura.dev/blog/explaining-the-postgres-meme 91 comments
- Elixir and Postgres: A Rarely Mentioned Problem | Lainblog https://blog.soykaf.com/post/postgresql-elixir-troubles/ 49 comments
- 621+ Programming Resources. Origins from Jon Schoning, Sam Liao… | by whatwhatgoose | Free Stuff | Medium https://medium.com/free-stuff/2000-programming-resources-c2c835001216#.7afcewqn0 22 comments
- Essential elements of high performance applications: SQL indexes – Foxhound Systems https://www.foxhound.systems/blog/essential-elements-of-high-performance-sql-indexes/ 13 comments
- Using EXPLAIN ANALYZE to debug a slow SQL query | by Joe Kurleto | Reverb.com — Fretboards and Motherboards https://product.reverb.com/using-explain-analyze-to-debug-a-slow-sql-query-870f6d8ea161 11 comments
- Mistakes Were Made [Part 1] https://primalskill.blog/mistakes-were-made-part-1 6 comments
- But it works on my machine | Anton on software https://blog.sergeyev.info/but-it-works-on-my-machine/ 5 comments
- The problem is not the tool itself | CommitStrip http://www.commitstrip.com/en/2014/06/03/the-problem-is-not-the-tool-itself/ 3 comments
- GitHub - flyeralarm/onboarding: A list of resources we at flyeralarm use to get new developers up and running https://github.com/flyeralarm/onboarding 0 comments
- Suggested Readings List | small data Journalism http://www.smalldatajournalism.com/readings/ 0 comments
- Yet Another List of Devops Resources https://jrott.com/posts/devops-links/ 0 comments
- May the Index be with you! - Percona Database Performance Blog http://www.tokutek.com/2011/08/may-the-index-be-with-you/#.Tk03FcyKBWI.hackernews 0 comments
- 5 Tips to Optimize Your SQL Queries | LearnSQL.com http://www.vertabelo.com/blog/technical-articles/5-tips-to-optimize-your-sql-queries 0 comments
- Don't hold back your programming http://scalabilitysolved.com/dont-hold-back-your-programming/ 0 comments
- Scaling a GraphQL Website â The Art of Machinery https://theartofmachinery.com/2020/06/29/scaling_a_graphql_site.html 0 comments
- SQL Performance Explained â the must-read book | Vertabelo Database Modeler http://www.vertabelo.com/blog/notes-from-the-lab/sql-performance-explained-must-read-book 0 comments
- GitHub - AllenJB/mysql-for-devs: MySQL for Developers: A brief but concise guide for developers to take their MySQL knowledge beyond creating and running queries to keep their databases performant https://github.com/AllenJB/mysql-for-devs 0 comments