InfoQ Homepage Relational Databases Content on InfoQ
-
Google Updates Cloud Spanner: Query Introspection, New Regions, and New Multi-Region Configurations
In a recent blog post, Google announced a few enhancements for Cloud Spanner - a globally distributed NewSQL database. Based on customer requests, Google updated the service with query introspection improvements, new region availability, and new multi-region configurations.
-
Building Resilience in Netflix Production Data Migrations: Sangeeta Handa at QCon SF
At QCon SF, Sangeeta Handa discussed how Netflix had learned to build resilience into production migrations across a number of use cases. Key lessons learned included: aim for perceived or actual zero downtime, even for data migrations; invest in early feedback loops to build confidence; find ways to decouple customer interactions from your services; and build independent checks and balances.
-
Google Cloud Platform Recommends Strong Consistency in Data Stores
A recent post on the Google Cloud Platform blog recommends strong consistency in the data layer, which helps in creating an application platform that reduces complexity and the potential for bugs.
-
QCon New York 2017: Migrating Speedment to Java 9
Dan Lawesson, CSO at Speedment, presented “Migrating Speedment to Java 9” at this year’s QCon New York. Lawesson spoke to InfoQ about Speedment and how they are addressing the challenges of migrating Speedment to Java 9.
-
FaunaDB: A New Distributed Database from the Team That Scaled Twitter
Former technical leaders from Twitter and Couchbase have created FaunaDB, a new general-purpose database.
-
How Database Administration Fits into DevOps
InfoQ interviewed Dan North about the activities that are performed by database administrators and how they are related to those done by developers and by operations, how database administration is usually organized, how the database fits into DevOps or Continuous Delivery, and what he expects that the future will bring for database administration when organizations adopt DevOps.
-
SQLite 3.9 Supports JSON, Indexes on Expressions and More
Recently released SQLite 3.9 provides a number of new features and enhancements, including support for JSON encoding/decoding, full text search version 5, indexes on expressions, eponymous virtual tables and more.
-
Lovefield: An SQL-like Query Engine by Google
Lovefield is a JavaScript library providing an SQL-like query engine to web developers who want the benefits of a relational database.
-
You Are Using the ORM the Wrong Way
When teams abandons an Object-Relational Mapper, ORM, it is often due to bad usage Jimmy Bogard stated in a recent presentation highlighting what he sees as incorrect and correct ways of using an ORM, including mapping and querying problems.
-
ORM Tool Hibernate 4.3 Released, Implementing JPA 2.1 Specification
The final version of the Object-Relational Mapping, ORM framework Hibernate 4.3 was recently released and is now a certified implementation of the JPA 2.1 specification, (JSR 338), released in May 2013.
-
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 Launches Scalable, Cloud Based, Relational Database
NuoDB recently released its Cloud Database Management System which supports SQL queries, ACID (Atomic, Consistent, Isolated and Durable) transactions, and easy scaling to multiple nodes. It is designed for companies that need to scale their databases to multiple servers but don’t want to give up the power of relational algebra or transactional guarantees.
-
Heroku Dataclips 2.0 - The Gist of Data
Heroku Dataclips 2.0 are a new way of sharing data - much like GitHub Gists. Exposing results of running SQL statements agains Postgres databases, Dataclips render in HTML, IFrames, CSV, XLS and JSON. Supporting revisions and versioning as well as forking they work as self-updating stand-alone data views or as simple HTTP based data APIs.
-
James Phillips on Moving from Relational to NoSQL Databases
James Phillips, co-founder of Couchbase, recently gave a presentation on the differences between a distributed document-oriented and relational data models and what the database developers need know to move from a relational to a NoSQL database. InfoQ caught up with James to talk about the advantages and limitations of document-oriented NoSQL databases.
-
Amazon Offers MySQL as a Service
Amazon has announced a new service, Amazon Relational Database Service or RDS, a solution for creating and accessing a relational database in the cloud. The hosted database is MySQL 5.1 and the announcement precedes PDC 2009 by 3 weeks when Microsoft will announce the availability of SQL Azure, a cloud solution based on its relational DB.