InfoQ Homepage SQL Content on InfoQ
-
Google Extends Their Services with Cloud SQL
Google is making MySQL available in the cloud as a fully managed service, including a JSON API for programmatic management.
-
NuoDB 1.1 Targets .NET Developers
NuoDB 1.1 includes a ADO.NET driver, LINQ and EF providers, support for Windows 64-bit and Azure, performance improvements.
-
Greenplum Pivotal HD Combines the Strengths of SQL and Hadoop
EMC Greenplum has announced Pivotal HD, a new Hadoop distribution including a fully compliant SQL MPP database running on HDFS and being “hundreds of times faster than Hive”.
-
Phoenix: Running SQL Queries on Apache HBase [Updated]
Salesforce.com has open sourced Phoenix, a Java layer enabling developers to run SQL queries on Apache HBase. Update: An interview on Phoenix with James Taylor, Lead Developer at Salesforce.com, has been appended.
-
Hekaton: In-Memory Transaction Processing Integrated with SQL Server
During the PASS Summit 2012, a technical conference for SQL Server professionals, Microsoft announced Hekaton, an in-memory row-based data management system targeted at transaction processing (TP) workloads. Besides the advertised increase in TP speeds of up to 10x for old applications and up to 50x for new optimized ones, Microsoft touts Hekaton as being fully integrated into SQL Server.
-
News from O’Reilly Strata Conference + Hadoop World 2012: Azure HDInsight, Cloudera Impala, MapR M7
Several new Hadoop-based frameworks where announced during this year O’Reilly Strata Conference + Hadoop World 2012 in New York last week.
-
FluentData: A New, Lightweight ORM with a Fluent API
FluentData is a new introduction to the micro-ORM family that aims to be more straightforward to use than full ORMs like NHibernate and Entity Framework. It uses a fluent API and supports SQL Server, SQL Azure, Oracle, and MySQL.
-
Hybrid SQL-NoSQL Databases Are Gaining Ground
Hybrid SQL-NoSQL database solutions combine the advantage of being compatible with many SQL applications and providing the scalability of NoSQL ones. Xeround offers such a solution as a service in the cloud, including a free edition. Other solutions: Database.com with ODBC/JDBC drivers, NuoDB, Clustrix, and VoltDB.
-
VMware Releases SQLFire 1.0
VMware releases SQLFire 1.0 a distributed SQL database geared towards high availability and horizontal scalability which offers table replication, table partitioning and parallel execution of queries.
-
Heroku Launches Postgres as a Standalone Service.
Until now, Postgres was only available to Heroku customers for use with Heroku platform apps. This new service can be used from anywhere and with any Postgres client. Apps can connect from Heroku, Google App Engine, Microsoft Azure, Cloud Foundry, EC2, or from your local computer while PostgreSQL is supported by most modern programming languages - including Perl, Python, Ruby, Scala ...
-
Interview: Richard Hipp on UnQL, a New Query Language for Document Databases
This interview with Richard Hipp, creator of SQLite, unveils the details of UnQL, a new query language for JSON document databases. Hipp mentions UnQLite, an embedded document database he plans to create.
-
SQL Server 2008 SP1 and Feature Pack CTP Bring New Features and Tools
Microsoft has announced the availability for download of SQL Server 2008 R2 SP1 CTP, including all cumulative updates, and SQL Server 2008 R2 SP1 Feature Pack CTP1, containing a number of stand alone tools adding more value to SQL Server 2008.
-
MySQL/HandlerSocket and VoltDB: Contenders to NoSQL
NoSQL systems are considered by some as performing better than traditional SQL ones. Two SQL solutions, one based on MySQL plus a NoSQL layer used as a plug-in and VoltDB claim SQL still is a viable solution for large applications with high scalability needs.
-
SQLAzureMW Migrates SQL Databases to SQL Azure
The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.
-
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.