Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ


Choose your language

InfoQ Homepage Database Design Content on InfoQ

  • Microsoft is Making a Play for MySQL Users

    Microsoft has released its first community tech preview for a MySQL to SQL Server migration tool. This tool supports SQL Server 2005, 2008, and Azure.

  • MagLev Ruby VM Now Available, Brings GemStone's Persistence to Ruby

    The long awaited MagLev Ruby implementation, based on GemStone Smalltalk, is now available in a public alpha release. While not quite ready to run Rails, it does support frameworks like Rack and Sinatra. MagLev comes with full support for GemStone's mature distribution and persistence features.

  • Simplify SQL Migration Scripts with SQrbL

    Managing SQL-based scripts can become a nightmare with time. Rails solved this with ActiveRecord Migration. Sam Livingston-Gray wrote a small standalone Ruby tool to generate hierarchical migration script. Based on the fact that SQL scripts can become very verbose and duplication-prone, Sam started SQrbL which is a mix of SQL and Ruby.

  • MapPoint Add-In For SQL Server Released

    Microsoft released a free MapPoint 2009 Add-In for SQL Server 2008 spatial data. The add-in can be used with MapPoint to build map graphics against queries on SQL Server 2008 spatial geography columns.

  • ODBMS.ORG Adds Persistence Patterns Resources

    ODBMS.ORG has added persistence patterns to its collection of resources for educators, students, professionals, and open source practitioners. Three pattern collections comprise the initial offering in this area. A Best Persistence Pattern Award, is planned for any pattern submitted prior to May 29, 2009.

  • Open Database Alliance: New Direction for mySQL

    Monty Program Ab, a MySQL database engineering company, and Percona, a MySQL services and support firm, today announced the "The Open Database Alliance." This effort will fork the mySQL code base, using MariaDB as a starting point. MariaDB was created by Monty Widenius, co-founder of mySQL.

  • Hasso Plattner Touts Highly Parallel Computing and Column-Oriented Databases

    In his keynote at Sapphire 2009, Hasso Plattner, co-founder of SAP, explained that he sees multi-cores, and in memory column-oriented databases in the future of enterprise applications.

  • SQL Server 2008 Major Updates

    Microsoft has released significant updates for SQL Server 2008, including 2008 Service Pack 1, Express Edition Service Pack 1, large Feature Pack, Upgrade Advisor, SRS Report Builder 2.0, SharePoint integration, and data mining Office add-ins.

  • FriendFeed Implements Schema-less Storage Atop MySQL

    Brett Taylor, founder of FriendFeed, describes how they overcame some limitations of MySQL to handle problems of scaling and database evolution by implementing a "schema-less" storage system on top of MySQL.

  • Presentation: Refactoring Databases

    For years the norm for developers was to work in an iterative and incremental manner but for database developers to work in a more serial manner. The predominance of evolutionary development methods make it clear that the two groups need to work in the same manner to be productive as a team. Pramod presents material from "Refactoring Databases " on implementing evolutionary database development.

  • Clustered JRuby - Transparent Clustering of JRuby with Terracotta

    Gemstone's Maglev Demo at RailsConf sparked a lot of interest. A new project experiments with bringing this kind of transparent clustering to JRuby using Terracotta. We talked to Fabio Kung who's been experimenting with this approach.

  • Interview: Damien Katz Relaxing on CouchDB

    In this interview, Damien Katz talks about CouchDB, a distributed, fault tolerant, document oriented database developed by Apache Incubator. CouchDB is written in Erlang, and the database is accessed through an HTTP/JSON API. The database view engine is run on JavaScript, but other languages have been used like Ruby and Python.

  • Static Code Analysis for T-SQL

    Static code analysis, long neglected on the Windows platform, has been becoming more and more import in the last few years. This hasn't gone unnoticed by database developers, who thanks to Ubitsoft can now analyze T-SQL just like .NET developers analyze managed code.

  • Aster In-Database MapReduce

    Aster Data Systems has announced an in-database MapReduce implementation for their nCluster database platform.

  • Drizzle - a new direction for databases

    Unveiled at the O'Reilly Open Source Convention (OSCON), Drizzle can be described as a "what if" project - creating a database specially for applications that include web based apps, cloud computing components, databases without business logic (aka stored procedures), and multi-core architecture.