A valiant effort has been made by Little Tim this year, who for some reason has decided to change his name to Tim'); INSERT INTO [NiceList] SELECT * FROM [NaughtyList];--

HO HO HO! Nice try Tim. I don't use #SQL, I use several dozen interconnected #Excel spreadsheets, like a professional.

@briankrebs

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. 🙁

#SQL

GROUP BY ALL for all https://peter.eisentraut.org/blog/2025/11/11/waiting-for-sql-202y-group-by-all #sql #postgresql

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

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

Hey nerds, we're experimenting with publishing our complete (but raw!) XBRL-derived #FERC data using @duckdb so you can, for example:

ATTACH 's3://pudl.catalyst.coop/nightly/ferc1_xbrl.duckdb' AS ferc1_xbrl (READ_ONLY);
SELECT * FROM ferc1_xbrl.transmission_lines_added_during_year_424_duration;

#SQL #OpenData #Electricity #Energy

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

My 2nd-year students sent me a code snippet to review... I'm not super familiar with the express.js framework they've been using, but I do think little Bobby Tables might like to have a word 😈

#infosec #sql

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

Hey nerds, we're experimenting with publishing our complete (but raw!) XBRL-derived #FERC data using @duckdb so you can, for example:

ATTACH 's3://pudl.catalyst.coop/nightly/ferc1_xbrl.duckdb' AS ferc1_xbrl (READ_ONLY);
SELECT * FROM ferc1_xbrl.transmission_lines_added_during_year_424_duration;

#SQL #OpenData #Electricity #Energy

Need a quick intro into #SQL? Get "Become a SELECT Star!" by Julia @b0rk Evans. #Databases

https://wizardzines.com/zines/sql/

It turns out a misconfigured #ClickHouse #SQL query brought down the internet managed by #Cloudflare... #Databases

https://blog.cloudflare.com/18-november-2025-outage/

@briankrebs

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. 🙁

#SQL

GROUP BY ALL for all https://peter.eisentraut.org/blog/2025/11/11/waiting-for-sql-202y-group-by-all #sql #postgresql

(Sorry in advance for bombarding with hashtags, but..)

Yet again I plead to the #Fediverse to get #Fedihired as a paid or unpaid #DataAnalyst #intern. I'm not formally trained but (as uncomfortable as it is for me to boast) I truly feel that I have the cognitive *capability* of learning as I go. I want to see whether I actually *can* do so.

Unfortunately I'm guessing this is probably the worst possible time to try and break into the industry, however I am desperate and hoping for a miracle.

I've always been "self-taught" because I've never been an ideal student. It's how I learned to program #PHP, #SQL, and how I learned to work with #spreadsheets.

I might not be an expert with any of those topics but I usually managed to stumble my way through, and accomplish the goal I needed, serving my purpose for a previous employer for 8½ years, until their financial position necessitated my layoff.

I need real-life experience working with #Data and hopefully build a portfolio I can use for #gig work or a job or something.

So I'm reaching out to #selfemployed any #Data experts to ask if they might need help. Let me take a stab at some non-critical things.

If I suck, you're not out more than just a little bit of your time interacting with me; you were going to do it yourself anyway, right?

If I do it *well*, then you just got free labor, I get experience and potential portfolio fodder.

Plus you get the sense of pride from helping someone struggling to survive, and helping a #neurodivergent, #LGBTQ couple who both struggle with #MentalIllness and #poverty.

Obviously I will take *paid* work as well; remember, #MinimumWage in my state is still a measly seven dollars and twenty-five goddamned cents per hour, so you can go super cheap.

Think of it like you're rummaging through the bargain bin for temp workers and you decide to give some no-name brand a try: Me!!

Wrote a CLI for formatting SQL within sqlx macros like query_as!

It includes a GitHub CI Action for format checks and uses the sqruff formatter under the hood.

https://github.com/jflessau/sqlx-fmt

#rust #sql #postgres #ci #github

(Sorry in advance for bombarding with hashtags, but..)

Yet again I plead to the #Fediverse to get #Fedihired as a paid or unpaid #DataAnalyst #intern. I'm not formally trained but (as uncomfortable as it is for me to boast) I truly feel that I have the cognitive *capability* of learning as I go. I want to see whether I actually *can* do so.

Unfortunately I'm guessing this is probably the worst possible time to try and break into the industry, however I am desperate and hoping for a miracle.

I've always been "self-taught" because I've never been an ideal student. It's how I learned to program #PHP, #SQL, and how I learned to work with #spreadsheets.

I might not be an expert with any of those topics but I usually managed to stumble my way through, and accomplish the goal I needed, serving my purpose for a previous employer for 8½ years, until their financial position necessitated my layoff.

I need real-life experience working with #Data and hopefully build a portfolio I can use for #gig work or a job or something.

So I'm reaching out to #selfemployed any #Data experts to ask if they might need help. Let me take a stab at some non-critical things.

If I suck, you're not out more than just a little bit of your time interacting with me; you were going to do it yourself anyway, right?

If I do it *well*, then you just got free labor, I get experience and potential portfolio fodder.

Plus you get the sense of pride from helping someone struggling to survive, and helping a #neurodivergent, #LGBTQ couple who both struggle with #MentalIllness and #poverty.

Obviously I will take *paid* work as well; remember, #MinimumWage in my state is still a measly seven dollars and twenty-five goddamned cents per hour, so you can go super cheap.

Think of it like you're rummaging through the bargain bin for temp workers and you decide to give some no-name brand a try: Me!!

Wrote a CLI for formatting SQL within sqlx macros like query_as!

It includes a GitHub CI Action for format checks and uses the sqruff formatter under the hood.

https://github.com/jflessau/sqlx-fmt

#rust #sql #postgres #ci #github