• Introduction to Red Gate’s SQL Source Control

    by David Atkinson on  Oct 01, 2014

    It’s unthinkable for modern application developers to work without source control. The benefits it brings to software development are so well and so long understood that even lone hobbyist developers will tend to employ a source control system. Yet somehow, databases are often left out. David Atkinson shows how this doesn’t have to be the case with Red Gate’s SQL Source Control.

  • Don’t jump the SQL ship just yet

    by Lukas Eder on  Dec 18, 2013 4

    The SQL language has been evolving steadily over the last two decades. At the same time, the verbosity caused by the JDBC API in Java client code and the lack of first class SQL support within the Java language have led to the introduction of ORMs such as Hibernate, which was later standardised into JPA and the Criteria API.If SQL and JPA are diverging, where will our data interaction patterns go?

  • Building Scalable Applications in .NET: Introducing the FatDB Distributed Computing Platform

    by Justin Weiler on  Jul 22, 2013

    Justin Weiler introduces FatDB, a NoSQL DB and a distributed platform built on Mission Oriented Architecture meant to abstract and generalize the essential characteristics of enterprise applications.

Exploring the Architecture of the NuoDB Database, Part 2

Posted by Seth Proctor on  Jul 17, 2013

In Part 2 of this article the author takes a look at how the transaction system is implemented, the role of the administrative layer, how all components work together and what to expect in the future. 1

Exploring the Architecture of the NuoDB Database, Part 1

Posted by Seth Proctor on  Jul 12, 2013

In Part 1 of this article the author introduces NuoDB and some of its main features: 3-tiered architecture, nodes are equal peers, Atoms, and versioning and concurrency system. 8

Apache MetaModel – Providing Uniform Data Access Across Various Data Stores

Posted by Kasper Sørensen on  Jul 03, 2013

MetaModel - an Apache Incubator project – is a Java library used to browse, query and update various types of data stores, such as RDBMS, CSV, Excel, NoSQL, etc., in a uniform and programmatic way. 4

The State of NoSQL

Posted by Stefan Edlich on  Nov 21, 2012

Stefan Edlich reviews NoSQL, considering its evolution, financial impact, standards or their lack of, current landscape, books, the leaders and some newcomers, concluding that NoSQL is here to stay. 3

Transitioning from RDBMS to NoSQL. Interview with Couchbase’s Dipti Borkar

Posted by Abel Avram on  Sep 08, 2012

This article contains an interview with Dipti Borkar, Director of Product Management at Couchbase, on the challenges, benefits and the process of migrating from RDBMS to NoSQL. 6

Testing SQL Server Code with TST

Posted by Roopesh Shenoy on  Jun 18, 2012

We explore the TST framework and a few ideas for writing and maintaining good tests for database code. 2

CAP Twelve Years Later: How the "Rules" Have Changed

Posted by Eric Brewer on  May 30, 2012

In this article, author Eric Brewer discusses how designers can optimize consistency and availability by explicitly handling partitions to get the best of CAP theorem properties. 9

Using Entity Framework to Successfully Target Multiple Databases

Posted by Yevhen Shchyholyev on  Jul 25, 2011

Yevhen Shchyholyev discusses some of the problems that the user may face in the process of developing an application with Entity Framework that interacts with Oracle, MySQL, PostgreSQL and SQLite.

Making Microsoft Sync Framework work with PostgreSql

Posted by Roopesh Shenoy on  Mar 18, 2011

Roopesh Shenoy demonstrates building a PostgreSql provider for the Microsoft Sync Framework. 7