#sql

Bind variables are important for SQL performance. Lukas Eder, Java champion and founder of JOOQ, tells us more about them.

Big news for the TIOBE Index, as SQL rejoins the top 20 after a long hiatus. This month, Java reigns supreme, Python jumps past C#, and Swift continues to freefall.

As it is becoming increasingly important for DevOps specialists to possess SQL knowledge, here is a list that I hope will help you find the right tools and methods to increase your SQL skills.

Structured Query Language or SQL is considered the standard language for database management systems. In this article, Chirag Thumar explains the best ways for your to optimize your SQL databases for the most efficient results.

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λ.