InfoQ Homepage SQL Content on InfoQ
-
PRQL: a Simple, Powerful, Pipelined SQL Replacement
Aljaž Mur Eržen discusses PRQL, a language that can be compiled to most SQL dialects, which makes it portable and reusable, important factors of OLAP.
/presentations/PRQL/en/mediumimage/AljažMurEržen-medium-1706775748156.jpg)
-
Massively Scaling MySQL Using Vitess
Sugu Sougoumarane gives an overview of the salient features of Vitess, and at the end, covers some advanced features with a demo.
/presentations/vitess/en/mediumimage/Sugubig-1550628002303.JPG)
-
Streaming SQL to Unify Batch & Stream Processing w/ Apache Flink @Uber
Shuyi Chen and Fabian Hueske explore SQL’s role in the world of streaming data and its implementation in Apache Flink and covering streaming semantics, event time, and incremental results.
/presentations/sql-streaming-apache-flink/en/mediumimage/Doibig-1529543212560.JPG)
-
Gimel: PayPal’s Analytics Data Platform
Deepak Chandramouli introduces and demos Gimel, a unified analytics data platform which provides access to any storage through a single unified data API and SQL.
/presentations/gimel-paypal/en/mediumimage/Deebig-1528941201064.JPG)
-
Streaming SQL Foundations: Why I ❤ Streams+Tables
Tyler Akidau explores the relationship between the Beam Model and stream & table theory and explains what is required to provide robust stream processing support in SQL.
/presentations/sql-streaming/en/mediumimage/Tybig-1525536964170.JPG)
-
Streaming SQL Foundations: Why I ❤Streams+Tables
Tyler Akidau explores the relationship between the Beam Model and stream & table theory, stream processing in SQL with Apache Beam, Calcite, Flink, Kafka KSQL and Apache Spark’s Structured streaming.
/presentations/beam-model-stream-table=theory/en/mediumimage/Tybig-1518993323788.JPG)
-
Panel: SQL over Streams, Ask the Experts
The panelists discuss the new generation of Stream Processing engines.
/presentations/sql-streams-panel/en/mediumimage/Pan1big-1512562189830.jpg)
-
SQL Server on Linux: Will it Perform or Not?
Slava Oks talks about SQL Server’s history, high-level architecture and dives into core of I/O Manager, Memory Manager, and Scheduler. Topics include lessons learned and experiences behind the scenes.
/presentations/sql-server-linux/en/mediumimage/Slabig.JPG)
-
Scaling Dropbox
Preslav Le talks about how Dropbox’s infrastructure evolved over the years, how it looks today, as well the challenges and lessons learned on the way.
/presentations/dropbox-infrastructure/en/mediumimage/Prebig.JPG)
-
Introduction to Spring Data
Greg Turnquist explains how Spring Data avoids writing data queries by hand and provides the means to avoid SQL lock-in and connect to multiple data stores.
/presentations/intro-spring-data/en/mediumimage/Gregbig.JPG)
-
But I Need a Database that _Scales_
Aaron Spiegel reviews common scaling techniques for both relational and NoSQL databases, discussing trade-offs of these techniques and their effect on query flexibility, transactions and consistency.
/presentations/database-scalability-techniques/en/mediumimage/Aaronbig.JPG)
-
Elasticsearch for SQL Users
Shaunak Kashyap looks at several well-understood concepts and SQL queries from the relational paradigm and maps these to their Elasticsearch equivalents.
/presentations/elasticsearch-sql/en/mediumimage/Shabig.JPG)