📰00Read later0Read MoreThe Wasteful JOIN I Was Afraid to Write? GORM Wrote It for Me.DEV Community: go·Yash Chavan·about 1 hour ago#95GsuAU8#devtogo#devto#dev#orders#join+3 more🧰Tag tools✨Add tagIn my last article I wrote an unnecessary JOIN by hand to see what it cost. That test came from a...15s
📰00Read later0Read MorePHPStan is green. Why is this code still hard to change?DEV Community: php·Alexandr·about 1 hour ago#vDlNQBE7#devto#dev#order#method#orders+3 more🧰Tag tools✨Add tagSuppose you need to change when an order can ship. You open the method and find this: final class...15s
00Read later0Read MoreComposite index column order: four queries, four query plans (tested on SQLite, check your own engine)Database·ClickOk5811·about 1 hour ago#QdEMpoyo#database#redditdatabase#index#customer_id#status+5 more🧰Tag tools✨Add tagA composite index on (customer_id, status) is not the same as one on (status, customer_id). Instead of explaining it abstractly, here’s a small test.… Read more15s
📰00Read later0Read MoreGeneral contractors: stop losing evenings to paperwork with one Notion system for jobs, invoices and change ordersDEV Community: productivity·Mira·about 13 hours ago#OD3CWr8P#devtoproductivity#devto#dev#construction#notion+9 more🧰Tag tools✨Add tagThis post is for general contractors who finish a long day on site and then lose the evening to...15s
🖼️00Read later0Read MoreRetail Sales and Customer Intelligence using Postgresql.DEV Community: database·Expert Writer·about 13 hours ago#pyF8mGau#devtodatabase#devto#dev#customers#profit+5 more🧰Tag tools✨Add tagIntroduction This article entails a SQL analysis of Duka Smart Electronics, a Kenyan...15s
🖼️00Read later0Read MoreTell screen readers when the content changes (Web HIG tip #18)DEV Community: html·FrozonFreak·about 13 hours ago#3IJb0jxd#devto2#devto#dev#status#orders+5 more🧰Tag tools✨Add tagSomeone filters orders on example.com/orders. The list updates in place: three shipped rows appear,...15s
📰00Read later0Read MoreCustomer Lists Without N+1: withCount, withSum and Subquery Selects in LaravelDEV Community: php·Tuğrul Yıldırım·about 13 hours ago#cee6j6DO#devto#dev#orders#customer#open+4 more🧰Tag tools✨Add tagEvery ERP or CRM has a customer list that people open fifty times a day. Name, number of orders, open...15s