News for hackers. Stuff that matters.
Re:I Went to SQL Injection Court by kasey_junk on Tuesday February 25, 2025 @02:33PM (#43176258)
The article describes why. 2 different db engines (or even instances) can use different file layouts for the same schema.

In many was sql is all about divorcing the schema from the files.

Re:I Went to SQL Injection Court by ludston on Tuesday February 25, 2025 @02:50PM (#43176430)
But on the other hand, in all database systems the schema is used to determine how the files are laid out. Although I suppose the same thing could be argued for any data that is stored in a file, excepting that a schema is metadata that determines the organisation of data so it's a bit of a special case.
Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @03:12PM (#43176736)
In a Microsoft Word document, the section headings also tell Word how to lay out the Word document file.
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @04:18PM (#43177545)
Do you mean that section headings aren't a file layout? That's their entire purpose.

Edit: If you're talking about the byte representation only, I don't think section headings indicate the placement of the body's bytes.

Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @04:29PM (#43177690)
You have found an argument that proves too much.
Re:I Went to SQL Injection Court by Xelynega on Wednesday February 26, 2025 @01:16AM (#43181189)
Yea coupled with the courts arguments the interpretation of sections in a document as a "file format" means no files with sections can be released via FOIA requests
Re:I Went to SQL Injection Court by Xelynega on Wednesday February 26, 2025 @01:15AM (#43181184)
Does your interpretation not mean that(coupled with the court ruling that file formats can't be foia'd) any document with sections cannot be requested via FOIA?
Re:I Went to SQL Injection Court by hot_gril on Wednesday February 26, 2025 @01:49AM (#43181342)
If this format is reused across many files, they might want to give the contents of those docs in a different format from the original.
Re:I Went to SQL Injection Court by ludston on Tuesday February 25, 2025 @08:06PM (#43179502)
Arguably, all requests for files could be returned with all of the letters in the document but scrambled in a random order soas to obfuscate the file layout.
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @03:18PM (#43176822)
There's a solid chance that the schema gives away what DBMS is being used. But even if it didn't, I'd still call it a file layout in this context.
Re:I Went to SQL Injection Court by chaps on Tuesday February 25, 2025 @03:19PM (#43176842)
The DBMS is almost definitely going to be mentioned in RFP or specification documentation. As it was in this lawsuit.
Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @03:19PM (#43176837)
So?
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @03:24PM (#43176897)
So if you have the schema and the DBMS, you probably know how data is arranged in the files ("files" in the filesystem sense).
Re:I Went to SQL Injection Court by chaps on Tuesday February 25, 2025 @03:41PM (#43177118)
Is your argument that government agencies should also withhold the names of filing cabinet manufacturers? :)
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @03:58PM (#43177306)
Just that it's a file layout. Or even if you strictly define a file layout as say an ext4, NTFS, or FAT file tree, that revealing the schema is revealing the file layout.

I don't know why they don't want to reveal file layouts, but for whatever reason, they decided it was "per se" exempt regardless of the security implications.

Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @04:07PM (#43177416)
It's obviously not a file format. The same SQL schema can generate N different files, with N different layouts, for N different databases. By the logic you're using ("schema" + "database vendor" = "file format"), a Word document outline is also a file format.
Re:I Went to SQL Injection Court by hyperpape on Tuesday February 25, 2025 @03:32PM (#43176998)
The parent asks "how is it not a file layout" not "can you guess the file layout?" given it.

I am a human, you know I have a kidney, but I am not a kidney.

Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @04:01PM (#43177340)
If you send a copy of the code, is that sending the code? If it is, what about sending a copy of the code with a Caesar Shift?
Re:I Went to SQL Injection Court by darkarmani on Wednesday February 26, 2025 @03:12PM (#43187687)
The gov't releasing the hardware and software licencing used in CANVAS already gives that away.
Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @02:36PM (#43176282)
Another way to think about it is that if a SQL schema is a file, so is an Excel spreadsheet template.
Re:I Went to SQL Injection Court by hot_gril on Tuesday February 25, 2025 @03:30PM (#43176963)
File or file layout? Cause both of these are probably stored as files, .sql and .xltx respectively.
Re:I Went to SQL Injection Court by paulddraper on Tuesday February 25, 2025 @03:53PM (#43177251)
An Excel spreadsheet template is an arrangement of rows/columns/cells which is encoded in a XML document which is encoded in a ZIP file archive.
Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @04:09PM (#43177438)
I don't follow your point.
Re:I Went to SQL Injection Court by paulddraper on Tuesday February 25, 2025 @07:47PM (#43179375)
Yes, it's a file format.

(Kinda a file format inside a file format inside a file format.)

Re:I Went to SQL Injection Court by tptacek on Tuesday February 25, 2025 @08:13PM (#43179551)
"Excel" is a file format, but my point is that if a schema is a file format, so are the contents of an Excel spreadsheet.
Re:I Went to SQL Injection Court by atkulp on Tuesday February 25, 2025 @05:36PM (#43178463)
It's interesting that the opening analogy in the post uses an Excel spreadsheet as a great way to explain a database. It's such an easy next step to say the way an xls/ods file is saved is a file format but the column layout in the tabs/tables are the schemas. The court (and the city) playing these games is so scary since it is so biased toward all modern government data being covered by FOIA exemptions.