News for hackers. Stuff that matters.
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @03:49PM (#43177210)
If the Excel spreadsheet has formulas in it, it's software. If you're just talking about the data in the sheet, i.e. what you'd get exporting it as a CSV, then it's not.

Col types, unique/FK/PK constraints, default values, and computed cols define the steps for handling row inserts/updates/deletes. For example, insert row -> check that customer ID unique -> reject if not. Even adding a uniqueness constraint to an already-unique col will change how the code interacts with it, specifically how it deals with concurrency/locking. If they said it has to be an imperative programming language, then it's not that.

If they said the schema isn't source code then ok, but I still think it is.

Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @03:52PM (#43177239)
I assure you that Excel spreadsheets with formulas in them are FOIA-able in Illinois. Since we can take that as axiomatic, I think we can put "schemas are software" to bed.
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @04:00PM (#43177326)
SQL schemas aren't Excel spreadsheets.
Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @04:08PM (#43177426)
That's fascinating, but you just claimed Excel spreadsheets were "software" in the sense of the Illinois FOIA statute definition, and they are not. QED.
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @04:19PM (#43177561)
You said that SQL schemas aren't software, and that's what this lawsuit was about. If they explicitly say that Excel docs (even w/ formulas) aren't software, I think they're wrong, but that doesn't matter because Excel docs aren't SQL schema.

Now if you want to go by Illinois definitions, SQL schemas are file layouts, that's why the plaintiff lost.

Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @04:29PM (#43177688)
Again: the post explains why the court determined schemas to be file layouts, and none of it involves any of the logic you've supplied here. Even Chicago didn't try to claim that a schema was a "software".
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @04:49PM (#43177957)
They didn't need to. In the first appeal, it didn't matter because it didn't jeopardize security. In the second appeal, they said it's a file layout.

You also said SQL schemas are declarative, not imperative. Those are types of programming languages, so software.