{"repo":"emilpriver/geni","free":true,"listed":false,"github":"https://github.com/emilpriver/geni","clone":"git clone https://github.com/emilpriver/geni.git","description":"Standalone database migration tool which works for Postgres, MariaDB, MySQL, Sqlite and LibSQL(Turso).","language":"Rust","stars":273,"topics":["database-migrations","libsql","mariadb","mysql","postgres","rust","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"Geni Geni is a standalone migration tool designed to work in conjunction with your preferred ORM/toolkit/code. It allows multiple developers to collaborate without overriding database migrations. It can be used in a CD pipeline alongside your code to ensure your database stays up to date. This project was heavily inspired by dbmate and was created because dbmate lacked support for LibSQL. The application is developed using the Rust programming language and relies on the libsql-client-rs library for SQLite and LibSQL. Moreover, it makes use of SQLX to support Postgres, MariaDB, and MySQL databases. As this is written in rust is lighting fast, blazingly fast, tiny, ultra fast and memory safe Geni in the news - Database Migrations made easy with Geni by Jamie Barton Features - Databases: - Postgres - MariaDB - MySQL - SQLite - LibSQL - Generating migrations using geni new name - Migrating using geni up - Rollback using geni down - Create database using geni create - Dropping database using geni drop - Timestamp based migrations - Running migrations in a transaction - Status command to see which migrations that is pending to be applied - Dump a schema.sql after each migration which can be used in version control - Note: The dumped schema file is intended only for schema diffs and version control reference. It should NOT be used to re-apply or reconstruct the database schema. - Dumping needs another binaries to work: - Postgres: Works without need for another binary. Uses SQL code","default_branch":null,"files":null,"tree":[],"storefront":"/r/emilpriver","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/emilpriver/geni/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."}