{"repo":"Grandbusta/jone","free":true,"listed":false,"github":"https://github.com/Grandbusta/jone","clone":"git clone https://github.com/Grandbusta/jone.git","description":"A @knex inspired SQL migration and schema builder for Go. Supports PostgreSQL today, Others coming soon. Designed to be flexible, and fun to use.","language":"Go","stars":30,"topics":["golang","knex","postgresql","sql","mysql","orm"],"license":"MIT","category":"databases-storage","readme_excerpt":"Jone A Go database query builder. Supports PostgreSQL and MySQL. 📦 Installation 1. Install the CLI (one-time, adds jone command to your system): 2. Add library to your project (run in your project directory): 🚀 Quick Start 💻 CLI Commands Command Description --------- ------------- jone init Initialize jone project. Creates jone/ folder and config. jone migrate:make Create a new migration file. jone migrate:latest Run all pending migrations. jone migrate:up [name] Run next pending migration (or specific one). jone migrate:down [name] Rollback last migration (or specific one). jone migrate:rollback Rollback last batch of migrations. jone migrate:list List all migrations with status. jone migrate:status Alias for migrate:list . Flags jone init - --db , -d — Database type: postgres , mysql , sqlite (default: postgres ) jone migrate:latest , migrate:up , migrate:down , migrate:rollback - --dry-run — Show SQL that would be executed without running it jone migrate:rollback - --all , -a — Rollback all migrations (not just last batch) ⚙️ Configuration After running jone init , edit jone/jonefile.go : PostgreSQL: MySQL: 🔗 Connection Pooling Jone leverages Go's built-in database/sql connection pool. You can configure pool behavior by adding a Pool field to your config: All fields are optional. Omitting Pool (or using zero values) preserves the database/sql defaults. 🏗️ Schema Builder Creating Tables Column Types Method SQL Type -------- ---------- Increments(name) SERIAL / AUTO INC","default_branch":null,"files":null,"tree":[],"storefront":"/r/Grandbusta","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Grandbusta/jone/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."}