#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14
Elo – A data expression language which compiles to JavaScript, Ruby, and SQL
3Pillar Global is hiring Mid Java Software Engineer
🔧 #java #json #sql
🌎 Romania
⏰ Full-time
🏢 3Pillar Global
Job details https://jobsfordevelopers.com/jobs/mid-java-software-engineer-at-3-pillarglobal-com-dec-18-2025-483bd4?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
3Pillar Global is hiring Mid Java Software Engineer
🔧 #java #json #sql
🌎 Romania
⏰ Full-time
🏢 3Pillar Global
Job details https://jobsfordevelopers.com/jobs/mid-java-software-engineer-at-3-pillarglobal-com-dec-18-2025-483bd4?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
It will never, ever stop annoying me that #SQL has "LEFT" and "RIGHT" joins.
These keywords' names are horribly inaccessible for those with Left–right confusion, which is A REAL THING that affects MANY MILLIONS OF PEOPLE.
Including, yes, myself.
It will never, ever stop annoying me that #SQL has "LEFT" and "RIGHT" joins.
These keywords' names are horribly inaccessible for those with Left–right confusion, which is A REAL THING that affects MANY MILLIONS OF PEOPLE.
Including, yes, myself.
How SQL Parsers Work
https://nishchith.com/sql-parsers/
#HackerNews #SQL #Parsers #SQL #Programming #Tech #Explained #Data #Parsing #Database
For 25 years now, it's been mind-blowing to know that a significant number of orgs (and their developers) won't take the time to sanitize RDBMS queries by using stored procedures or readily available tools/code for parameterization.
It's one of those tech 'problems' that never goes away. 🙁
The #SQL GROUP BY ALL syntax introduced by analytical systems like DuckDB, Databricks, and Snowflake will be part of the next SQL standard. #Databases
https://peter.eisentraut.org/blog/2025/11/11/waiting-for-sql-202y-group-by-all
The Rise of SQL:the second programming language everyone needs to know
https://spectrum.ieee.org/the-rise-of-sql
#HackerNews #SQL #Programming #Language #Learning #Data #Analytics #Tech #Trends
The Rise of SQL
Anna's Archive will provide the audio files too. The AI music generation tech bros will be so happy... #Fail (or, likely, they already know and used the same vulnerability to get the audio)
Some nice #SQL in the wild in the blog post! Examples for SQLite should work for DuckDB with minimal adaption (which is probably your system to go to if you want to recreate the nice analysis and visualisations on this much data on a single machine). #Databases
https://annas-archive.li/blog/backing-up-spotify.html#metadata-files
This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).
And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi
https://github.com/ha1tch/tsqlparser
#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres
Vacuum Is a Lie: About Your Indexes
https://boringsql.com/posts/vacuum-is-lie/
#HackerNews #VacuumIsALie #Indexes #Database #BoringSQL #HackerNews #SQL