JSON Support in Databases

For storing JSON in the database Pony uses the following types:

• SQLite - TEXT

• PostgreSQL and CockroachDB - JSONB (binary JSON)

• MySQL - JSON (binary JSON, although it doesn’t have ‘B’ in the name)

• Oracle - CLOB

Starting with the version 3.9 SQLite provides the JSON1 extension module. This extension improves performance when working with JSON queries, although Pony can work with JSON in SQLite even without this module.