Resources · Blog

Data & Formats

Parsing file formats, databases, data mining, and enrichment.

Data & Formats
JSON Parser Guide: How to Parse JSON in Any Language

How to parse JSON in Python, JavaScript, Java, Go, C#, PHP and Rust, with every version checked in August 2026: duplicate keys, 64-bit integers, byte order marks, nesting limits, streaming, and JSONPath after RFC 9535.

3 December · 22 min
Data & Formats
Log Parsing: How to Parse Server and Application Logs

How to parse Nginx, Apache, JSON Lines, journald and Kubernetes CRI logs: the escaping traps that corrupt fields without raising an error, and throughput measured in August 2026 on a one-million-line access log.

27 November · 11 min
Data & Formats
MongoDB for Web Scraping: What It Is and When to Use It

How MongoDB stores scraped data, rechecked August 2026: SSPL is not an open source license, sharding is not automatic, and Atlas free clusters stop at 100 operations per second.

23 November · 19 min
Data & Formats
Is Structured Data Usually Stored in NoSQL Databases?

No: structured data lives in relational databases, and NoSQL is built for the semi-structured. Verified 13 August 2026 against vendor documentation, with the document, key-value, wide-column and graph limits that bite at scale, current licences, and where scraped data should actually land.

13 November · 21 min
Data & Formats
Parsing Excel Files: Sheets, Formulas, Merged Cells

Excel parsing rechecked in August 2026: why data_only=True returns None, how to recalculate formulas headless, openpyxl vs calamine timings on 200,000 rows, and why npm install xlsx still pulls a 2022 build with two open advisories.

7 November · 15 min
Data & Formats
Parsing Text Files: Line-by-Line Reading, Regex, and Examples

How to parse TXT files: line-by-line reading, delimiters, fixed-width columns and regex in Python, Node, PHP and Go, with measured line-ending behavior, encoding traps and timings from a 2,000,000-line file.

5 November · 15 min
Data & Formats
PDF Scraping: Extract Text and Tables from PDF Files

How to scrape data from PDF files: extract text and tables, run OCR on scans, and pick the right library, with measured numbers from August 2026 and examples in Python, Node, Java and PHP.

3 November · 14 min
Data & Formats
Python Parameterized Queries to Prevent SQL Injection

Python parameterized queries for scraped data, retested in August 2026: why the Bobby Tables demo does not drop the table in sqlite3, why IN %s stopped working in psycopg 3, which identifier cases fail silently, and measured insert timings on 20,000 rows.

16 October · 16 min
Data & Formats
RSS Feed Parser: How to Extract Data from RSS Feeds

Build an RSS feed parser in Python, Node, PHP, Go and Ruby. Library versions and release dates verified 13 August 2026, three parser bugs reproduced in runnable code, and parse timings on a 6.8 MB feed.

26 September · 18 min