InfoQ Homepage SQL Content on InfoQ
-
Amazon Adds Cross Region and Encrypted Replication Support for Aurora
In a recent blog post, Amazon announced updates to its MySQL-compatible Database Engine, Aurora. In this update, Amazon is including support for cross region snapshot copy, cross region replication for encrypted databases, cross account encrypted snapshot sharing, adding a region where Aurora can be provisioned and a new instance size called T2.Small.
-
Data Geekery Releases Version 3.9.0 of jOOQ, a Java ORM Tool for Building Type Safe Queries
Data Geekery released version 3.9.0 of jOOQ, their object-relational mapping (ORM) Java toolkit, featuring an experimental parser, additional type safety, better integration with Oracle, and improved transactions. InfoQ spoke to Lukas Eder, founder and CEO of Data Geekery GmbH, about this latest release.
-
Speedment Releases Stream ORM Version 3.0.1
Speedment released version 3.0.1 of their stream object-relational mapping Java toolkit and runtime application, featuring a new declarative Java 8 stream API, an improved user interface, and better code generation. InfoQ spoke to Per-Åke Minborg, co-founder and CTO of Speedment, about this latest release.
-
Plumbr Adds Slow Query Detection
JVM monitoring vendor Plumbr has added slow query detection to its flagship product. With this addition, Plumbr now detects four types of problems: Memory Leaks, Garbage Collection Inefficiencies, Locked Threads and Expensive JDBC Operations.
-
FoundationDB SQL Layer: Storing SQL Data in a NoSQL Database
FoundationDB has announced the general availability of SQL Layer, and ANSI SQL engine that runs on top of their key-value store. The result is a relational database backed up by a scalable, fault-tolerant, shared-nothing, distributed NoSQL store with support for multi-key ACID transactions.
-
JetBrains 0xDBE: A Tool for DBAs and SQL Developers
Up until now, JetBrains’ IDEs have included plug-ins for dealing with database administration and development tasks. JetBrains has decided to extract the respective functionality and place it in an IDE of its own, namely 0xDBE.
-
Hadoop Summit 2014 Day Two - On the Path to Enterprise Grade Hadoop
Hadoop Summit Day Two report covers the important trends and changes from last year's summit. It also covers the important announcements of the day in relation to this year's trending topics. This report shares an analysis of the Hadoop market by leading analysts, competing benchmarks by vendors and platform specific innovations and announcements.
-
DataBricks Announces Spark SQL for Manipulating Structured Data Using Spark
DataBricks, the company behind Apache Spark, has announced a new addition into the Spark ecosystem called Spark SQL. Spark SQL is separate from Shark, and does not use Hive under the hood. InfoQ reached out to Reynold Xin and Michael Armbrust, software engineers at DataBricks, to learn more about Spark SQL.
-
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.