#sql

In this article, Java champion Lukas Eder invites readers to take a look at 10 SQL tricks. The article is a summary of his new, extremely fast-paced, ridiculously childish-humored talk, which he’s giving at conferences (recently at JAX, and Devoxx France).

In this article, Java champion Lukas Eder reveals that developers will now be able to completely effortlessly translate their medium to highly complex SQL queries into the exact equivalent in jOOQ annotations.

Microsoft is bringing its flagship relational database product, SQL Server, to the Linux operating system. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud, the company announced.

Bringing support for geographic objects to PostgreSQL, PostGIS has several advantages over similar spatial databases like SQL Server and Oracle Locator/Spatial. Adam Wright shows us the extender’s most popular functions, data types and how to get started.

Co-founder of Neo4j Emil Eifrem has introduced the Oracle-backed openCypher Project – an open source enterprise that aims to provide a common graph query language for any data store, tooling or application provider to query graph data.

Lukas Eder rounds up this year’s favourite DB engines for SQL and NoSQL, with a change of ranks amongst the new list. Cassandra and Redis have surged their way into the Top 10, but who have they replaced? Read on to find out.

Lukas Eder likes SQL a lot, so he’s here to show you the true meaning of Venn diagrams by describing its operations – UNION, EXCEPT and INTERSECT all play a starring role. You’ll even get a sneak peak of some of the points he’ll cover in his upcoming JAX London session.

Nowhere else are business decisions as hype-oriented as in IT. And while NoSQL is all well and good, MySQL is often the sensible choice in terms of operational cost and scalability, says JAX London speaker Aviran Mordo.

As application architecture continues to undergo change, modern applications are now living in increasingly distributed and dynamic infrastructure. Meanwhile, DNS and traffic management markets are finally shifting to accommodate the changing reality.

Java 8 streams are still new to some, but by comparing common constructs in SQL, you might be able to get your head around them. Lukas Eder explores common SQL constructs with their equivalent expressions written in Java 8 using Streams and jOOλ.

NULL is a rather polarising value. Lukas Eder wants to make his position on NULL very clear and is standing by the fact that engineers need potent tools to help them get their work done. NULL happens to play an important part in that.

A total of approximately 480 JIRA tickets is what it takes to update Apache Hive to Version 1.2. The data warehouse software for Apache Hadoop has already reached its third release of the year, with the Hive community continuing its growth.

Gartner’s latest database report is advising enterprises to begin switching to open-source RDBMS alternatives. PostgreSQL pro Sandor Klein tells us why the open-source RDBMS is finally edging out the proprietary counterpart.

Think you’re better off without NULL? Think again, writes Lukas Eder, who explores the idea of every programming language incorporating the polarising statement.