Latest Screencasts (page 3)

Whatever a database is being used for?web sites, bookkeeping, sales and inventory, or even the lowly to-do list?it’s all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling?SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features...

Technical editing by CouchDB committers Jan Lehnardt and Chris Anderson NOTE: Updated project code is available at GitHub (upgrade-couchrest branch). Imagine a world where there is no SQL. Your database doesn’t have a schema. You don’t have to worry about indexes. Replication is built-in. Scaling is part of the plan...

Have you ever wanted to fill up a database with a lot of test data? See how to do that in this episode using the populator and faker gems.

Matt Aimonetti shows how to quickly get your database queries to run faster when you are not a DBA and are running out of time. Bonus content: download the slides from this talk.

Rob Kaufman takes on database scaling with MySQL. This talk will walk you through setting up a Master (read write) Slave (read only) MySQL network, as well as a Master Master, or Multi-Master network. The talk will also cover the whys and when of database clustering. Bonus content: download the slides from this talk.

Migrations are now sexy in Rails 2.0! In this episode we will take a look at these improvements and the related rake tasks.

What do you do when third-party data vendors don't speak REST? Rob Kaufman discuss real-world techniques for importing and exporting data. (This talk was also given at RailsConf 2007.)

When two people attempt to update the same record near the same time, one of the updates will likely be overwritten. You can solve this problem with optimistic locking.

Dominic Damian talks about the different options available to you when deploying a Rails application. He covers areas such as servers, caching, database, and hosting.