Search Results for "sql table"

pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided output. One of the main differentiators of pgstream is the fact that it tracks and replicates schema changes automatically. It relies on SQL triggers that will populate a Postgres table (pgstream.schema_log) containing a history log of all DDL changes for a given schema. Whenever a schema change occurs, this trigger creates a new row in the schema log 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.

...Genji 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.

goose is a database migration tool. Manage your database schema by creating incremental SQL changes or Go functions. Starting with v3.0.0 this project adds Go module support, but maintains backwards compatibility with older v2.x.y tags. Goose supports embedding SQL migrations, which means you'll need go1.16 and up. If using go1.15 or lower, then pin v3.0.1. We use timestamped migrations by default but recommend a hybrid approach of using timestamps in the development process and sequential versions in production. ...

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 to your own applications. ...

pREST (PostgreSQL REST), simplify and accelerate development, instant, realtime, high-performance on any Postgres application, existing or new. There is PostgREST written in Haskell, but keeping Haskell software in production is not an easy job. With this need pREST was born. Instant, realtime, high-performance on any Postgres application, existing or new. Add the JWT Authentication Middleware to implement authentication using JSON Web Token. This middleware will process the authorization...

...Built on bitmaps, FeatureBase offers up to 5-10X reduction in storage footprint and 90% reduction in hardware footprint. A distributed, highly-scalable database built to handle extreme data volumes. FeatureBase is SOC 2 Type II compliant, and includes features like table-level access control, and query and admin auditing. Built-in SQL support plus our own native query language, PQL. Automatic decentralized sharding, and more.

RadonDB is a cloud-native database based on MySQL, and architected in fully distributed cluster that enable unlimited scalability (scale-out), capacity and performance. It supported distributed transaction that ensure high data consistency, and leveraged MySQL as storage engine for trusted data reliability. RadonDB is compatible with MySQL protocol, and sup-porting automatic table sharding as well as batch of automation feature for simplifying the maintenance and operation workflow. RadonDB...

Beerus-DB is a database operation framework, currently only supports Mysql, Use [go-sql-driver/mysql] to do database connection and basic operations, based on this do a lot of extensions, such as, connection pool management, multiple data sources, transaction management, single table no sql operation, multiple tables and complex operations can write their own sql, sql support {} placeholder, can use struct as parameters to operate the database, etc.