🖼️0024/30 Days System Design QuestionsDEV Community: database·Joud Awad·2 days ago#f9RmFvn5#dev#systemdesign#postgresql#backendengineering#created_at#rows+6 more🧰Tag tools✨Add tagYour API returns 10 million orders. The frontend asks for "page 5." Offset 40, limit 10. Simple...15s0Read later0Read More
🖼️00SQL Queries Every Developer Should Know (With Examples)DEV Community·Alex Chen·17 days ago#enzZiwQd#sql#beginners#database#select#users#name+4 more🧰Tag tools✨Add tagSQL Queries Every Developer Should Know (With Examples) You don't need to be a DBA. But...15s0Read later0Read More
🖼️00PostgreSQL Query Rewriting TechniquesDEV Community·Philip McClarence·29 days ago#ot3RuWut#postgres#performance#database#sql#user_id#select+4 more🧰Tag tools✨Add tagPostgreSQL Query Rewriting Techniques The previous articles in this series covered...15s0Read later0Read More
📰00Laravel whereDate() Silently Kills Your IndexDEV Community: laravel·Ivan Mykhavko·about 1 month ago#O24M5AxW#dev#class#code#highlight#created_at#article+1 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 more15s0Read later0Read More
