I loaded a large JSON file in Python and watched memory jump from 43 MB to 808 MB. Here’s what happened and how streaming changed everything.

Microsoft SQL 2016 and later versions and Azure SQL provide JSON support through functions that operate on nvarchar columns. The mssql-python driver sends and receives JSON as regular Python strings.

# "polars[pyarrow]==1.24.0", DuckDB supports reading and writing JSON through the `json` extension that should be present in most distributions and is autoloaded on ...

This script reads conversation data from a JSON file and loads it into Mirix. The JSON file should contain an array of conversation records, each with: python load ...