Individual databases have different strengths and weaknesses, and two important broad database categories are “relational” (SQL) and “non-relational” (NoSQL/Not-Only-SQL). The two frameworks are increasingly crossing over with each other but the two principally model data differently — offering either acute integrity or agile scalability.
Do you use SQL or NoSQL databases for time series data? There are a number of significant differences, advantages, and disadvantages between the two. In this article, you will learn all about the differences between SQL and noSQL databases, as well as the differences for time series use cases.
According to Burning Glass Technologies and Dice, companies are currently looking for developers with experience using older, more established technologies such as SQL. See what other tech skills are currently deemed critical and why SQL ranks above other skills.
Relational SQL has been abandoned in 1999. Since then, SQL has got many non-relational features for problems that are hard to solve with relational algebra. What can modern SQL do for you? It has come a long way. This session from the International PHP Conference will teach you about the SQL of today. Find out more with Markus Winand.
R2DBC 0.8 is now generally available. R2DBC (Reactive Relational Database Connectivity) is an open initiative that connects reactive programming with SQL databases. The R2DBC working group worked for almost two years before releasing its first version of the specification. Read about the motivation behind R2DBC and its current state.
Here is another SQL special from jOOQ inventor Lukas Eder. Looking at a time series of data points where certain events happen, there are several issues that can occur. Here’s how you can deal with those problems.
Here is another SQL special from jOOQ inventor Lukas Eder. What’s the point in using GROUPING SETS in SQL standard? Eder demonstrates a pretty subtle effect of using this feature.
Another month has passed, bringing tons of new releases and news from all around. And it is time for us to have another monthly recap of the most clicked news for the past month as well some of the most interesting news that came along.
Keep your eyes on this hat trick – Presto has just announced it is going solo! The new Presto Software Foundation shows that this big data SQL engine is ready for the main stage. Developers can take advantage of Presto’s high performance for interactive queries on data, wherever it lives. Magic!
SQLDelight, a library that generates typesafe APIs from your SQL statements, just reached its 1.0 milestone, which happens to bring a complete rework. Let’s have a closer look at what this library has to offer.
Built-in tools have some serious advantages, like easier maintenance, fewer bugs, less dependency on the database in use, easier to migrate to another server, etc. But when it comes to performance it is far from the best. What if you wanted to make our ETL even better? Veselin Davidov gives us a full tour!
QL languages are on their way up again. Bring SQL functionality to your apps with QLBridge, a SQL runtime engine for Go.
July might be gone, but summer is not over yet! And the weather forecast says that it’s going to get really hot! But I warn you, it’s about to get hot in here as well! The most clicked stories for July have arrived. Old but gold tutorials and walk-throughs, hot top lists, informative interviews and much more!