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.

One subtle point about JSON is that you cannot include more than one object in a file. This is not a problem in many situations. For example, reading and writing the configuration data of a program ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...