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.
After having a sudden… burst of inspiration, Lukas Eder was ready to embark on a total rewrite. After some careful digestion, he isn’t feeling pooped at all about the new Generic Type of solution he’s come up with.
FIRST_VALUE(), LAST_VALUE(), LEAD(), and LAG() – you’ll soon be asking yourself how you’ve survived SQL this long without these window functions.
Imagine a builder that has never heard of windows. Now imagine the joys of a SQL programmer that discovers window functions.
Some had written it off as dated. Others never even considered it. From way out in leftfield comes an old database technology that is quickly overtaking NoSQL.
Lukas Eder introduces us to one SQL function that will clean up your data and totally change your life. Well, maybe that last bit is overdoing it.
Clustrix CEO Mike Azevedo explains what his company is doing to make its database more appealing to e-commerce enterprises.
Some IT topics are absolutely in need of debate. Then again, there are others that developers simply need to leave behind.
CEO of Metanautix speaks to JAXenter about their latest venture into big data analytics: Quest.
A comparison of the major features of the top ten SQL and NoSQL databases.
Max De Marzi shows us how to increase payment security by using Neo4j to check for relationships that increase the risk.