Barry Frost

This is Barry Frost’s personal website.

Tagged #database

knex

A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder for Node.js and the Browser

sequelize

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, SQLite and Microsoft SQL Server. It features solid transaction support, relations, read replication and more.

dynalite

An implementation of Amazon’s DynamoDB built on LevelDB

Rails Database Best Practices

N+1 Queries or Memory Problems: Why not Solve Both?

Sequel cheatsheet

How FriendFeed uses MySQL to store schema-less data

PSequel

PostgreSQL GUI Tool for Mac OS X

cayley

Open source graph database from Google

PouchDB

It enables applications to store data locally while offline, then synchronize it with CouchDB and compatible servers when the application is back online

Firebase - Build Realtime Apps

“A powerful API to store and sync data in realtime.”

Web Hosting For App Developers – Marco.org

I especially like the advice on backing up databases via slaves.

Scaling PostgreSQL Performance Using Table Partitioning

Reco4j

Open source project that aims at developing a recommendation framework based on graph data sources

Screencast: using ruby to add schema-less data to PostgreSQL

With hstore you can add schema-less data to PostgreSQL. This allows you to store model attributes without creating separate database columns. Watch how to do this using the activerecord-postgres-hstore gem.

Handling Growth with Postgres

5 tips from Instagram

Lanyrd's Big Move

Moving from MySQL to Postgres

y310/kodama

MySQL replication listener based on ruby-binlog. Kodama provides a simple DSL to easily write your own replication listener. Can be used to do things like replicate from MySQL to Postgres, etc.

Postgres.app

“The easiest way to run PostgreSQL on the Mac”

octopus

Database sharding for activerecord (Ruby)