Search Results for "json table"

... with the schema encoded as a JSON value. This table tracks all the schema changes, forming a linearised change log that is then parsed and used within the pgstream pipeline to identify modifications and push the relevant changes downstream.

... header, check if there is a JSON Web Token in it, and if it is, create the user identity and claims based on the content of JWT. Migrations are pREST's way of propagating changes you make to your tables (adding a field, deleting a table, etc.) into your database schema. No complexity to use, download a single binary for all operating systems (and architectures). You can also extend and write your own endpoints as you would using one framework, gaining all existing endpoints for free.

... was designed for simplicity in mind. It is really easy to insert and read documents of any shape. Genji mixes the best of both worlds by combining powerful SQL commands with JSON. Genji tables are schemaless, but it is possible to add constraints on any field to ensure the coherence of data within a table.

OctoSQL is predominantly a CLI tool which lets you query a plethora of databases and file formats using SQL through a unified interface, even do JOINs between them. (Ever needed to join a JSON file with a PostgreSQL table? OctoSQL can help you with that.) OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. At the same time it's an easily extensible full-blown dataflow engine, and you can use it to add a SQL interface...