📰00Read later0Read MoreComposite Indexes in PostgreSQL & MySQL: Column Order GuideDEV Community: postgres·Muhammad Ali Mughal·1 day ago#ga8Ko7NR#devtopostgresql#devto#dev#index#status+5 more🧰Tag tools✨Add tagAdding three separate single-column indexes on tenant_id, status, and created_at will not make a...15s
🖼️00Read later0Read More24/30 Days System Design QuestionsDEV Community: database·Joud Awad·5 months ago#f9RmFvn5#dev#systemdesign#postgresql#backendengineering#created_at+7 more🧰Tag tools✨Add tagYour API returns 10 million orders. The frontend asks for "page 5." Offset 40, limit 10. Simple...15s
🖼️00Read later0Read MoreSQL Queries Every Developer Should Know (With Examples)DEV Community·Alex Chen·5 months ago#enzZiwQd#sql#beginners#database#select#users+5 more🧰Tag tools✨Add tagSQL Queries Every Developer Should Know (With Examples) You don't need to be a DBA. But...15s
🖼️00Read later0Read MorePostgreSQL Query Rewriting TechniquesDEV Community·Philip McClarence·6 months ago#ot3RuWut#postgres#performance#database#sql#user_id+4 more🧰Tag tools✨Add tagPostgreSQL Query Rewriting Techniques The previous articles in this series covered...15s
00Read later0Read MoreLaravel whereDate() Silently Kills Your IndexDEV Community: laravel·Ivan Mykhavko·6 months ago#O24M5AxW#dev#class#code#highlight#created_at+2 more🧰Tag tools✨Add tagwhereDate('created_at', $date) looks clean, but on a big table it quietly drops your index and does a full scan. Say you want notifications created on a specific day.… Read more15s
