adamwiggins / yaml_db Goto Github PK
View Code? Open in Web Editor NEWRails plugin for a database-independent dump format, data.yml. This fork no longer maintained, please see:
Home Page: http://github.com/ludicast/yaml_db
Rails plugin for a database-independent dump format, data.yml. This fork no longer maintained, please see:
Home Page: http://github.com/ludicast/yaml_db
This repo is no longer maintained, please see http://github.com/ludicast/yaml_db for a currently maintained fork. ------------------------------------------------------------------------------ = YamlDb YamlDb is a database-independent format for dumping and restoring data. It complements the the database-independent schema format found in db/schema.rb. The data is saved into db/data.yml. This can be used as a replacement for mysqldump or pg_dump, but only for the databases typically used by Rails apps. Users, permissions, schemas, triggers, and other advanced database features are not supported - by design. Any database that has an ActiveRecord adapter should work. == Usage rake db:data:dump -> Dump contents of Rails database to db/data.yml rake db:data:load -> Load contents of db/data.yml into the database Further, there are tasks db:dump and db:load which do the entire database (the equivalent of running db:schema:dump followed by db:data:load). == Examples One common use would be to switch your data from one database backend to another. For example, let's say you wanted to switch from SQLite to MySQL. You might execute the following steps: 1. rake db:dump 2. Edit config/database.yml and change your adapter to mysql, set up database params 3. mysqladmin create [database name] 4. rake db:load == Credits Created by Orion Henry and Adam Wiggins. Major updates by Ricardo Chimal, Jr. Patches contributed by Michael Irwin, Tom Locke, and Tim Galeckas. Send questions, feedback, or patches to the Heroku mailing list: http://groups.google.com/group/heroku
The call to ActiveRecord::Base.connection.add_limit_offset! needs an :offset parameter when using rails-mssql-2000-2005-adapter. This is non-standard, as far as the protocol for add_limit_offset! is concerned. Unfortunately, MS SQL Server needs the non-standard syntax because of limitations in its pagination capabilities. I cloned yaml_db and made the fix, but I can't test it without dumping over a gig of data.
This page still points to your repository.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.