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