I Went to SQL Injection Court (sockpuppet.org)

Article summary

The article discusses a court case in Illinois where a journalist, Matt Chapman, sued the City of Chicago for access to the database schema of the city's parking ticket system, CANVAS, under the Freedom of Information Act (FOIA). The city claimed that releasing the schema would jeopardize the security of the system, but the court ultimately ruled in favor of Chapman. The case highlights the tension between government transparency and security concerns. The author, an expert witness in the case, argues that database schemas are not sensitive information and do not pose a security risk.

Main themes

• FOIA and government transparency
• Database security and vulnerability
• Local politics and civic engagement
• Zoning laws and urban development
• Technical expertise in legal cases

What commenters say

• Engaging in local politics can be more effective and responsive than national politics, allowing individuals to create meaningful change.
• The elimination of single-family zoning and relaxation of building restrictions can increase density and improve urban development.
• Violence is not an effective means of creating lasting change, and nonviolent movements are more likely to succeed in the long run.
• Government databases, unlike private company databases, should be transparent and accessible to the public, as they are a public resource.
• The value of a database schema lies not in its secrecy, but in its design and implementation, which can be a valuable intellectual property.
• Local governments have varying levels of power to make laws, and some may have limited authority to enact laws on certain topics.
• Technical expertise is essential in legal cases involving complex technical issues, such as database security and vulnerability.