InfoQ Homepage SQL Content on InfoQ
-
Espresso Logic DBaaS Now Wraps SQL Stored Procedures in RESTful APIs
Espresso Logic has added RESTful endpoints for SQL stored procedures to their DBaaS service.
-
Going Offline with LocalForage
The Mozilla Foundation has released localForage, a new JavaScript library that promises to simplify the process of storing offline data in web applications. What makes this library unique is the fact that it tries to combine the best of both worlds: the features of some more recent technologies (asynchronism and blob support) with a simple API.
-
Presto-as-a-Service: Interactive SQL Queries on AWS
Presto, a technology from Facebook enabling interactive SQL queries on petabytes of data, has now taken a first step into mainstream adoption. Big Data startup Qubole has launched its Presto-as-a-Service alpha with integration to Amazon Web Services.
-
Open Source SQL-in-Hadoop Solutions: Where Are We?
With Facebook recently releasing Presto as open source, the already crowded SQL-in-Hadoop market just became a tad more intricate. A number of open source tools are competing for the attention of developers: Hortonworks Stinger initiative around Hive, Apache Drill, Apache Tajo, Cloudera’s Impala, Salesforce’s Phoenix (for HBase) and now Facebook’s Presto.
-
Cascading 2.5 Supports Hadoop 2
New version of Cascading released this week incorporates Hadoop 2 support and includes Cascading Lingual - an open source project that provides a comprehensive ANSI SQL interface for accessing Hadoop-based data
-
Presto: Facebook’s Distributed SQL Query Engine
Facebook has open-sourced Presto, their distributed SQL query engine. Presto uses a pipelined architecture rather than the Map/Reduce design found elsewhere. In production since early this year, Facebook has since “deployed in multiple geographical regions and [they] have successfully scaled a single cluster to 1,000 nodes”.
-
SQL Makes a Comeback through NewSQL
New database developments indicate a return to SQL, but not by running the traditional relational stores on bigger and better hardware, not even on sharded architectures, but through NewSQL solutions.
-
NuoDB Blackbirds 2.0 Gets Geo-distributed Capability
NuoDB has announced version 2.0 of their NewSQL database, now a globally distributed database that can run in the cloud or on premises with real-time replication.
-
Entity Framework 6 RC Adds SQL Logging, Testability Improvements and New IntelliSense Documentation
Microsoft has released release candidate version of Entity Framework 6 with support for interception, SQL logging, testability improvements. It also includes substantial changes to API, IntelliSense documentation.
-
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.