open source

Easing JPA data access with Hades

This video introduces the OpenSource library Hades that significantly eases implementing data access layers with JPA. It takes the audience on a guided tour through code samples introducing the features of Hades: * Executing queries by only declaring interface methods * Extending the EntityManager to provide a typed interface, programmatic pagination and sort support * …

Easing JPA data access with Hades Read More »

Migration From Oracle to MySQL

This talk will cover what a few Oracle experts (but MySQL newbies) learned in a recent migration at NPR.org. It discusses how we separated our previously monolithic database into smaller, more functionally cohesive databases and some of the criteria we used to decide what tables ended up where. This architecture allowed for better load balancing …

Migration From Oracle to MySQL Read More »

Aqua: A Cool, Clear Drink of Ruby Object Persistence

Even with ORMs like ActiveRecord, DataMapper which ease the pain of relational data storage, considerable developer effort goes into wrangling Ruby objects into their databases. This is true even when working with Document-oriented databases where the nested data structures more closely map to Ruby objects. Aqua is a new, proof-of-concept library that aims to painlessly …

Aqua: A Cool, Clear Drink of Ruby Object Persistence Read More »

MariaDB, the Backward Compatible Branch of MySQL(R) Database Server

MariaDB is a community developed, backward compatible, drop-in replacement branch of the MySQL(R) Database Server. What is MariaDB all about, and what is its future? What can you do with new features added in the first GA release of MariaDB 5.1, such as additional Storage Engines (Maria, PBXT, XtraDB, FederatedX), faster complex queries, pools of …

MariaDB, the Backward Compatible Branch of MySQL(R) Database Server Read More »

How To Create A Postgres Database Using pgAdmin

This video walks through the basics of creating your first database using pgAdmin, the comprehensive database design and management console for Postgres databases. Created for first time users of Postgres, you’ll also be introduced to the fundamental features in pgAdmin and be ready to start creating databases, entering data, and building multi-table queries using the …

How To Create A Postgres Database Using pgAdmin Read More »

MongoDB and MongoMapper

MongoDB is a document based database engine. Learn how to access it through MongoMapper in this episode. http://railscasts.com/episodes/194-mongodb-and-mongomapper