#sqlquery — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlquery, aggregated by home.social.
-
Felix Krause just turned his life into a SQL query. 🍽️🤖 Why bother with #privacy when you can log your #lunch and get validation from a database? 🚀📊 Next up: a neural network to judge your caloric intake. 😂🔍
https://howisfelix.today/ #FelixKrause #SQLquery #Logging #NeuralNetwork #HackerNews #ngated -
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
-
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
-
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
-
What's wrong with this SQL order by?
What's wrong with this SQL order by in a search endpoint. The SQL code interpolates a user supplied sort field, enabling injection. In SQL backends this exposes data and crashes queries.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlinjection #sqlorderby #sqlquery #sqlsecurity
-
SQL joins are the backbone of relational data analysis.
They help combine tables to extract meaningful insights — from inner joins that show matches to outer joins that reveal unmatched data.
Mastering joins turns raw data into relationships that tell real business stories.
📕 https://ebokify.com/data-analysis
#SQL #DataAnalytics #DataScience #Database #BusinessIntelligence #Joins #SQLQuery #DataAnalysis #LearnSQL #Analytics