M Programming Language with Paul Vick
Published July 13th, 2010 Under Coding, Database | Leave a Comment
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 convenient to both author and reader. “M” does not mandate how data is stored or accessed, nor does it mandate a specific implementation technology. Rather, “M” is designed to allow users to write down what they want from their data without having to specify how those requirements are met by a specific technology or platform.
Easing JPA data access with Hades
Published July 7th, 2010 Under Database, Open Source Tools | 1 Comment
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
* Combining execution of finder methods with pagination
* Auditing of entities to keep track of creation and modification date and user
* Integration of custom data access code
* Integration into Spring applications via Spring namespace and Spring IDE extension
Development Best Practices and Patterns for Using Microsoft SQL Azure Databases
Published June 22nd, 2010 Under Database | Leave a Comment
SQL Azure provides a fully relational database service that is based on Microsoft SQL Server and familiar concepts such as T-SQL, schema-based tables, and stored procedures. Learn patterns and best practices for developing resilient applications that allow you to take full advantage of the scale and elasticity of SQL Azure Database Service.
Migration From Oracle to MySQL
Published June 10th, 2010 Under Database, Open Source Tools | Leave a Comment
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 and fault tolerance but it was outside our budget before we move to MySQL. There will be a discussion of some specific differences in SQL to be aware of between Oracle and MySQL. My team put together a cheat sheet of changes in function names or signatures that I will share. We also found equivalents for sequences and Oracle Text indexes and other Oracle specific functionality in MySQL. A few free tools we found helpful when writing code and debugging issues will be demoed and Ill explain some differences between how these tools work verses some of the Oracle tools you might be used to. Finally Ill describe a few of the test cases we used that revealed issues with our MySQL server configuration and our own code. This will touch on some of the challenges we encountered with concurrency and encoding.
Aqua: A Cool, Clear Drink of Ruby Object Persistence
Published June 8th, 2010 Under Coding, Database, Open Source Tools | Leave a Comment
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 and transparently persists Ruby objects, allowing developers to focus more on object-oriented code and less on storage structuring.
keep looking »