Databases - geekmonkey

geekmonkey

Sign in Subscribe

Databases

A collection of 3 posts

Detecting unused database columns using Ecto schemas

Detecting unused database columns using Ecto schemas

When building large database-backed Elixir applications using Ecto, it is inevitable for your database schema to evolve over time. As your database schema changes, it's possible for there to be discrepancies between the tables in the database and your local schema definitions. Tracking inconsistencies between the schema defined in your

Using Neo4j with Rails 3.2

Using Neo4j with Rails 3.2

Neo4j is a NoSQL graph database written in Java. This means that you work with nodes and relationships rather than fixed tables with a schema. Nodes can easily be mapped to Ruby object and relationships seen as references to other objects. This article will show how to utilize Neo4j to

Extracting a single database from a mysqldump

Some days ago a friend asked me how to extract a single database from a complete database dump. He created the dump using mysqldump and only wanted to restore a single database, without having go through >80k lines. After a little thinking I came up with a little script that