{"repo":"elitan/terradb","free":true,"listed":false,"github":"https://github.com/elitan/terradb","clone":"git clone https://github.com/elitan/terradb.git","description":"Declarative schema management for PostgreSQL and SQLite.","language":"TypeScript","stars":19,"topics":["postgres","database","migrations","postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"terradb Declarative schema management for PostgreSQL and SQLite. Install Quick Start PostgreSQL SQLite How It Works 1. Write your desired schema as CREATE statements 2. Run terradb plan to see what changes are needed 3. Run terradb apply to execute the changes terradb compares your schema file against the current database state and generates the necessary ALTER/DROP/CREATE statements. Configuration PostgreSQL PostgreSQL URLs may use either the postgres:// or postgresql:// scheme. Percent-encode special characters in the user, password, database name, or Unix-socket host. TerraDB preserves driver parameters such as application name , connect timeout , keepalives , and TLS certificate paths. The supported TLS modes follow node-postgres : disable , prefer , require , verify-ca , verify-full , and no-verify ; other values fail before a connection is attempted. Multi-host libpq URLs are not supported by the driver, so use a single load-balanced or failover endpoint. Or individual variables: SQLite Feature Support Feature PostgreSQL SQLite --------- ------------ -------- Tables & Columns Yes Yes Generated Columns Yes Yes Primary Keys Yes Yes Foreign Keys Yes Yes Indexes Yes Yes Unique Constraints Yes Yes Check Constraints Yes Yes Views Yes Yes ENUM Types Yes No Composite Types Yes No Domain Types Yes No Range & Multirange Types Yes No Sequences Yes No Functions Yes No Procedures Yes No Triggers Yes Yes Materialized Views Yes No Schemas Yes No Roles Yes No Object Privileges ( GRANT ","default_branch":null,"files":null,"tree":[],"storefront":"/r/elitan","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/elitan/terradb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}