Database Software Development Videos and Tutorials: MySQL, Oracle, NoSQL
This talk gives an overview of how to connect to MySQL and which drivers are available today under Python v2.x, and tomorrow’s Python v3.x. We’ll dive into MySQLdb, its strong history, its present. We’ll go over OurSQL and various other community projects, as well as Sun Microsystems’ MySQL Connector/Python.
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. MariaDB is a database server that offers drop-in replacement functionality for MySQL1. He presents an overview of the future of this community developed branch of the MySQL database.
Although ActiveRecord and the new Rails ORMs are optimized for general use cases with relational databases, most enterprise applications will not preform well enough using just the out-of-the-box functionality. Further, since often the ORMs do such a good job of hiding details when interfacing with the database, issues that might …
Paul Vick describes the purpose and concepts of the M Programming Language. The Microsoft code name “M†language is a declarative language for working with data and building domain models. “M†lets users write down how they want to structure and query their data using a textual syntax that is …
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 …
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 …