3 ms·
Another way to think about it is that if a SQL schema is a file, so is an Excel spreadsheet template.
by tptacek 2y ago
Another way to think about it is that if a SQL schema is a file, so is an Excel spreadsheet template.
- hot_gril 2y agoFile or file layout? Cause both of these are probably stored as files, .sql and .xltx respectively.
- paulddraper 2y agoAn 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.
- tptacek 2y agoI don't follow your point.
- paulddraper 2y agoYes, it's a file format. (Kinda a file format inside a file format inside a file format.)
- tptacek 2y ago"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.
- atkulp 2y agoIt'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.