SQL
-
Software Development
The Evolution of Database Schemas using SQL + NoSQL
Part two of the two part series: Rethinking Database Design with Apache Drill In part one of this series,Ā Drilling into…
Read More » -
Software Development
MySQL vs. MongoDB: Choosing a Data Management Solution
Table Of Contents 1. Introduction 2. The dominance of RDBM systems 3. A new era of NoSQL movement 4. Tables…
Read More » -
Core Java
Whatās Even Harder Than Dates and Timezones? Dates and Timezones in SQL / JDBC!
There was an interesting discussion recently on the jOOQ mailing list about jOOQās current lack of out-of-the-box support for TIMESTAMP…
Read More » -
Software Development
Implementing Client-Side Row-Level Security with jOOQ
Some time ago, weāve promised to follow up on our Constraints on Views article with a sequel showing how to…
Read More » -
Software Development
Northwind: Finding direct/transitive Reports in SQL and Neo4jās Cypher
Every few months we run a relational to graph meetup at the Neo London office where we go through how…
Read More » -
Software Development
What Exactly are SQL Views?
You probably know about āordinary viewsā already, but Iām sure youāll find one or two things in this article that…
Read More » -
Enterprise Java
Do Not Make This Mistake When Developing an SPI
Most of your code is private, internal, proprietary, and will never be exposed to public. If thatās the case, you…
Read More » -
Software Development
How SQL GROUP BY Should Have Been Designed ā Like Neo4jās Implicit GROUP BY
In the recent past, weāve explained the syntactic implications of the SQL GROUP BY clause. If you havenāt already, you…
Read More » -
Enterprise Java
jOOQ Tuesdays: Vlad Mihalcea Gives Deep Insight into SQL and Hibernate
Welcome to the jOOQ Tuesdays series. In this series, weāll publish an article on the third Tuesday every other month…
Read More »
