monica_b1998 · 20 days agoSQL Anti‑Patterns and How to Fix Themplus-squareslicker.meexternal-linkmessage-square0linkfedilinkarrow-up16arrow-down11
arrow-up15arrow-down1external-linkSQL Anti‑Patterns and How to Fix Themplus-squareslicker.memonica_b1998 · 20 days agomessage-square0linkfedilink
MoopsEnglish · 2 years agoWhat are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )plus-squaremessage-squaremessage-square2linkfedilinkarrow-up18arrow-down11
arrow-up17arrow-down1message-squareWhat are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )plus-squareMoopsEnglish · 2 years agomessage-square2linkfedilink
Kafkacious · 2 years agoBuilding a DIY ERP/Inventory Database?plus-squaremessage-squaremessage-square2linkfedilinkarrow-up110arrow-down10
arrow-up110arrow-down1message-squareBuilding a DIY ERP/Inventory Database?plus-squareKafkacious · 2 years agomessage-square2linkfedilink
ericbombEnglish · 2 years agoWhen you're asked to write a custom query to be used in crystal reportsplus-squareimagemessage-square0linkfedilinkarrow-up117arrow-down11
arrow-up116arrow-down1imageWhen you're asked to write a custom query to be used in crystal reportsplus-squareericbombEnglish · 2 years agomessage-square0linkfedilink
DeadNinja · edit-22 years agoSQL Dev learning MongoDBplus-squareimagemessage-square50linkfedilinkarrow-up1296arrow-down111
arrow-up1285arrow-down1imageSQL Dev learning MongoDBplus-squareDeadNinja · edit-22 years agomessage-square50linkfedilink
DeadNinja · 3 years agoNoSQL keeps rising, but relational databases still dominate big dataplus-squarewww.techrepublic.comexternal-linkmessage-square0linkfedilinkarrow-up111arrow-down10
arrow-up111arrow-down1external-linkNoSQL keeps rising, but relational databases still dominate big dataplus-squarewww.techrepublic.comDeadNinja · 3 years agomessage-square0linkfedilink
requiemEnglish · 3 years agoGraphical SQL Editor with auto-complete for Relational Tables?plus-squaremessage-squaremessage-square3linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareGraphical SQL Editor with auto-complete for Relational Tables?plus-squarerequiemEnglish · 3 years agomessage-square3linkfedilink
pahakala · 3 years agoCreate an advanced search engine with PostgreSQLplus-squarexata.ioexternal-linkmessage-square1linkfedilinkarrow-up14arrow-down10
arrow-up14arrow-down1external-linkCreate an advanced search engine with PostgreSQLplus-squarexata.iopahakala · 3 years agomessage-square1linkfedilink
biofaust · 3 years agoAre there patterns one learns to solve SQL interview questions (or tasks in general)?plus-squaremessage-squaremessage-square4linkfedilinkarrow-up13arrow-down11
arrow-up12arrow-down1message-squareAre there patterns one learns to solve SQL interview questions (or tasks in general)?plus-squarebiofaust · 3 years agomessage-square4linkfedilink
pahakalaEnglish · 3 years agoYour favorite database engine?plus-squaremessage-squaremessage-square11linkfedilinkarrow-up15arrow-down10
arrow-up15arrow-down1message-squareYour favorite database engine?plus-squarepahakalaEnglish · 3 years agomessage-square11linkfedilink
ShertsonM · 3 years agoBest practices for writing SQL (according to metabase)plus-squarewww.metabase.comexternal-linkmessage-square0linkfedilinkarrow-up13arrow-down10
arrow-up13arrow-down1external-linkBest practices for writing SQL (according to metabase)plus-squarewww.metabase.comShertsonM · 3 years agomessage-square0linkfedilink
ShertsonM · 3 years agoAsk complex questions of high-volume real-time data streamsplus-squaregithub.comexternal-linkmessage-square0linkfedilinkarrow-up12arrow-down10
arrow-up12arrow-down1external-linkAsk complex questions of high-volume real-time data streamsplus-squaregithub.comShertsonM · 3 years agomessage-square0linkfedilink
ShertsonM · 3 years agoSQL:2023 is finished: Here is what's new (Peter Eisentraut)plus-squarepeter.eisentraut.orgexternal-linkmessage-square0linkfedilinkarrow-up13arrow-down10
arrow-up13arrow-down1external-linkSQL:2023 is finished: Here is what's new (Peter Eisentraut)plus-squarepeter.eisentraut.orgShertsonM · 3 years agomessage-square0linkfedilink
ShertsonM · 3 years agoAnnouncing SQL Communityplus-squaremessage-squaremessage-square0linkfedilinkarrow-up18arrow-down10
arrow-up18arrow-down1message-squareAnnouncing SQL Communityplus-squareShertsonM · 3 years agomessage-square0linkfedilink
