Merging the comfortable familiarity and efficiency of SQL with the flexibility and scalability of a non-relational systems is no easy task. CrateDB, offered by Crate.io, is a “distributed SQL database that is built on top of a NoSQL foundation.” It allows users who are comfortable using and SQL database to save and query machine data, […]
Debugging Complex SQL Queries
Click to learn more about author Michael Blaha. We favor the offloading of application logic to SQL queries. Developers can save time, effort, and reduce mistakes by substituting SQL for programming code. This leads to lengthy and complex SQL that must be debugged. It is common to write a SQL query that initially fails to execute. […]