Excel
Converting Excel to JSON With Python for Clean Output
Convert an Excel sheet to JSON in Python: records, nested groups and JSON Lines, with typed values, ISO dates, nulls and a check that nothing was lost.
6 min read
Library
Everything you need to level up your coding skills.
YAML
Handling YAML Uploads From Users Without Getting Burned
A 40-line guard for accepting YAML uploads: size cap, UTF-8, safe parsing, expanded-size and depth limits, then key checks. Ten test inputs and what each did.
7 min read
YAML
Secrets Accidentally Committed in YAML Files and the Cleanup
What to do when a token lands in a values or config YAML: removing it from the file leaves it in history, gitleaks finds it, and rotation is the real fix.
6 min read
YAML
Safe Loaders in Python Ruby and Java Compared and Tested
Which function to call in PyYAML, Ruby Psych and SnakeYAML to load untrusted YAML safely, what each default does and how to grep for the unsafe ones.
6 min read
YAML
Billion Laughs Style Attacks Through YAML Aliases Tested
Build a 378-byte YAML document that expands to 34 MB, measure PyYAML, DuckDB and Go on it, and see which parsers fail early and which wait for the output.
7 min read
YAML
Why Loading Untrusted YAML Can Run Code and How to Stop It
How a YAML tag makes a loader build arbitrary objects, with a harmless proof in PyYAML, what safe_load and full_load did with it, and Ruby and Java behavior.
6 min read
ExcelGuide
Converting Excel to CSV JSON XML and YAML in Practice
Convert Excel workbooks to CSV, JSON, XML and YAML without losing data: choose a format, read types, dates and headers, then verify with counts and schemas.
17 min read
YAMLGuide
YAML Security Pitfalls and How to Test Your Own Code
Seven ways YAML hurts: object loading, alias bombs, size, type confusion, duplicate keys, leaked secrets and values used as code, tested in five languages.
17 min read
YAML
Using DuckDB to Query Data Stored as YAML With read_yaml
Install DuckDB's yaml community extension and query YAML files with read_yaml: inferred types, nested structs, unnest, globs, mixed types and broken files.
6 min read
YAML
Flattening Nested YAML Into Rows of Path and Value
Turn a nested YAML document into path, type and value rows with a short recursive generator, then load the rows into SQL to search and compare configs.
6 min read
YAML
Reading YAML Into SQLite for Quick Queries With json_extract
Load a YAML list into an in-memory SQLite table as JSON text and query it with json_extract and json_each, with a json_valid check that rejects bad rows.
6 min read
YAML
Fixtures in YAML for Database Tests With pytest and Rollback
Keep test data in YAML files, load it inside a transaction per test and roll back after, with pytest and PostgreSQL. Three tests ran in 0.13 seconds.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.