PUBLIC MARKS with tag bdd

Sequel: The Database Toolkit for Ruby

"The primary online data store for an application is the worst place to take a risk with new technology. If you lose your database or there's corruption, it's a disaster that could be impossible to recover from."

Par L.Nerima * Introduction * Les fichiers (chap. 1) * L'approche base de données (chap. 2) * Le modèle entité-association (chap. 3) * Le modèle relationnel (chap. 4) * Le langage SQL (chap. 5) * Bibliographie

ultimate database of sampled music and cover songs

Scala Migrations is a library to manage upgrades and rollbacks to database schemas. Migrations allow a source control system to manage together the database schema and the code using the schema. It is designed to allow multiple developers working on a project with a database backend to design schema modifications independently, apply the migrations to their local database for debugging and when complete, check them into a source control system to manage as one manages normal source code. Other developers then check out the new migrations and apply them to their local database. Finally, the migrations are used to migrate the production databases to the latest schema version. The Scala Migrations library is written in Scala and makes use of the clean Scala language to write easy to understand migrations, which are also written in Scala. Scala Migrations provides a database abstraction layer that allows migrations to target any supported database vendor.

Osmos provides on-disk ordered key-value tables for Erlang, based on a sort-merge machine with user-defined merging semantics. This allows a very high volume of updates to be handled efficiently while still supporting a variety of useful operations with transactional safety, e.g., adding to a counter, taking the union of sets, or simply replacing a record. Osmos is ideal for situations where updates are much more frequent than queries, for example, collecting statistics for reporting, and periodically generating reports.

flatula is a simple "write-once" database for Erlang that provides an easy way to remember a piece of data, then look it up later using a compact identifier. See FlatulaHowTo for a brief introduction and tutorial.

Over the weekend, I started exploring the Google Visualisation API Query Language, which is reminiscent of SQL (if that means anything to you!). This language provides a way of interrogating a data source such as a public online Google spreadsheet and pulling back the results of the query as JSON, CSV, or an HTML table.