Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
SQL Layer: The SQL-NoSQL Love Child
FoundationDB announced today the release of SQL Layer, calling it the love child of SQL and NoSQL. SQL Layer combines scalability and consistency with high performance and fault tolerance.
Kelsey Levitt
September 10, 2014
1 Min Read
FoundationDB announced today the release of SQL Layer, a SQL database engine powered by the FoundationDB Key-Value Store. SQL Layer is a combination of the best features from both SQL and NoSQL, and presented to users in a free, open-source SQL database system.
The new release supports multi-machine scalability and fault-tolerance, using FoundationDB's Key Value Store to store all persistent data, and it can power multiple different kinds of websites without requiring extensive modification. This new release is available together with Spree Commerce, an open-source ecommerce platform, with a one button deployment via GoGrid.
SQL Layer provides to users a handful of new features, including:
Hierarchical table modeling, which allows users to model related tables into a hierarchy that reflects an object structure, offsetting other functions that slow performance.
SQL Layer is optimized for highly-concurrent applications, and can use parallel execution to parallelize random IO requests and drive down latencies for complex queries.
Nested select is another new feature in SQL Layer, providing users with the option to select data that relates to an object in a hierarchical manner without explicitly specifying the joins.
These features and more are available to the public on Github, or you can check out the FoundationDB and Spree combination for your SQL application. For more information on SQL Layer, watch the demo video or visit the FoundationDB website.
About the Author
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
