SQL Zone is brought to you in partnership with:
  • submit to reddit
Lukas Eder08/22/14
865 views
0 replies

A Wonderful SQL Feature: Quantified Comparison Predicates (ANY, ALL)

Have you ever wondered about the use-case behind SQL’s ANY (also: SOME) and ALL keywords? You have probably not yet encountered these keywords in the wild. Yet they can be extremely useful. But first, let’s see how they’re defined in the SQL standard.

Peter Zaitsev08/22/14
636 views
0 replies

5 Great New Features From Percona Cloud Tools for MySQL

Percona Cloud Tools for MySQL is a hosted service providing access to query performance insights for all MySQL uses. After a brief setup, unlock new information about your database and how to improve your applications. There’s a lot more, but let’s just look at these five new features…

Matt Butcher08/21/14
1954 views
0 replies

Database Storage in Go with Structable

I'm not a huge fan of ORMs. I usually feel more productive with my query writing when I can just write SQL. Okay, not always. Writing plain old CRUD queries is a mindless chore equivalent to scrubbing the toilet. So I wrote a little library called structable that takes care of the boilerplate CRUD for me.

Alec Noller08/21/14
2352 views
0 replies

PostgreSQL Wishlists: What Users Want to See in 9.5

It wasn't too long ago that we saw the release of PostgreSQL 9.4 Beta 1, but now there's talk of PostgreSQL 9.5 and, in particular, what sorts of changes it ought to bring. Two separate wishlists have been assembled in the last few days, each sporting a handful of hopes for 9.5.

Lukas Eder08/20/14
1235 views
0 replies

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

One of the most obvious and useful set of window functions are ranking functions where rows from your result set are ranked according to a certain scheme. There are three ranking functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). The difference is easy to remember.

Chris Travers08/19/14
2764 views
0 replies

Math and SQL, Part 4: Basic Data Types - Sets, Tuples, and Bags

A reasonable understanding of the relational model requires understanding the basic data types which make it up, both in the idealized model and in real-world applications. This post discusses both the idealized model and the accommodations the standard implementations of it make to the messiness of the real world.

Sayem Ahmed08/18/14
2527 views
0 replies

JPA Tutorial: Setting Up JPA in a Java SE Environment

When I first started out with JPA, I had real difficulties to set it up because most of the articles on the web are written for Java EE environment only, whereas I was trying to use it in a Java SE environment. I hope that this article will be helpful for those who wish to do the same in the future.

Alec Noller08/17/14
1669 views
0 replies

The Best of the Week (Aug. 8): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone. This week's best include a beginner's guide to JPA/Hibernate flush strategies, how to avoid Hibernate anemia and reduce code bloat, part of the Math and SQL series, and more.

Vlad Mihalcea08/15/14
2129 views
0 replies

The Dark Side of Hibernate Auto Flush

Now that I described the the basics of JPA and Hibernate flush strategies, I can continue unraveling the surprising behavior of Hibernate’s AUTO flush mode.

Anders Karlsson08/15/14
2160 views
0 replies

Script to Manage MaxScale

There are still some rough edges and stuff to be fixed in MaxScale 1.0, but it is clearly close to GA. One thing missing, though, is something to manage starting and stopping MaxScale in a somewhat controlled way, which is what this blog is all about.

Robert Diana08/15/14
2381 views
0 replies

Geek Reading: August 14, 2014

These items are a combination of tech business news, development news and programming tools and techniques.

Michael Mainguy08/14/14
4340 views
2 replies

Avoid Hibernate Anemia and Reduce Code Bloat

One of my beefs with Hibernate as an ORM is that it encourages anemic domain models that have no operations and are simply data structures.

Lukas Eder08/14/14
1871 views
0 replies

SQL Tip of the Day: Be Wary of SELECT COUNT(*)

Unfortunately, COUNT(*) is often the first solution that comes to mind when we want to check our relations for some predicate. But COUNT() is expensive, especially if all we’re doing is checking our relations for existence. Does the word ring a bell?

Alec Noller08/13/14
7877 views
0 replies

Dev of the Week: Markus Winand

Every week, we feature a new developer/blogger from the DZone community to catch up and find out what he or she is working on now and what's coming next. This week we're talking to Markus Winand, author, trainer, and coach specializing in helping developers deal with SQL performance issues.

Drew Harvey08/13/14
1725 views
0 replies

MySQL Find and Replace (REPLACE)

Ever had need to do a MySQL find and replace to quickly replace some data in your database? Fear not, MySQL has a nifty little string function, REPLACE, that allows a user to find and replace instances of a search string with a substitution string.

Adrian Hills08/13/14
2617 views
0 replies

dm_exec_query_plan Returning NULL Query Plan

I recently hit a scenario (SQL Server 2012 Standard, 11.0.5058) where I was trying to pull out the execution plan for a stored procedure from the plan cache, but one query was returning a NULL query plan.

Chris Travers08/12/14
2976 views
0 replies

Math and SQL Part 3: MVCC, Immutability, and Functional Programming

While first normal form is pretty much restricted to relational operations, this piece is more general. It looks at the basic promise of functional programming, and the way that this applies to PostgreSQL. In the mean time, we will also look at a fully functional approach to a key-value store in Perl as a close analogue.

Peter Zaitsev08/12/14
1236 views
0 replies

MariaDB: Selective Binary Logs Events

In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10.

Vlad Mihalcea08/11/14
4304 views
0 replies

A Beginner's Guide To JPA/Hibernate Flush Strategies

Hibernate’s flush behavior is not always as obvious as one might think.

Lukas Eder08/11/14
2450 views
0 replies

Are You Using SQL PIVOT Yet? You Should!

Every once in a while, we run into these rare SQL issues where we’d like to do something that seems out of the ordinary. One of these things is pivoting rows to columns. A recent question on Stack Overflow by Valiante asked for precisely this.

Doug Winfield08/11/14
784 views
0 replies

Telerik Data Access Deployment DOs and DON’Ts

One of the most common topics in your questions to us is the deployment of the applications you developed with Telerik Data Access. To make the process flawless for you, here we suggest a few tips for solving the easy-to-miss hitches related to Telerik Data Access.

Alec Noller08/08/14
2342 views
0 replies

How to Use Django & PostgreSQL for Full Text Search

Who says you need Solr or Elasticsearch to get full text search going? According to this talk from a recent Django NYC meetup, all you really need is Python and a PostgreSQL database, though there are other options as well.

Abishek Baskaran08/08/14
210 views
0 replies

Optiq query push down concepts

Optiq query push down concepts explained.

Chris Travers08/08/14
2758 views
0 replies

Math and SQL, Part 2: Functions and First Normal Form

There is probably no piece of relational database theory as poorly understood in professional literature as first normal form. This piece seeks to ground an understanding of 1NF in set mathematics not only so that it can be better leveraged but also so that one can be aware of when (and when not) to violate it.

Shay Shmeltzer08/07/14
3701 views
2 replies

Accessing Remote Databases from Oracle MAF with the TopLink/EclipseLink REST CRUD Services

I showed you how simple it is to expose CRUD REST operations on your database with TopLink/EclipseLink. The next logical step is to then consume those with Oracle MAF to build a mobile application.