SQL Zone is brought to you in partnership with:
  • submit to reddit
Peter Zaitsev07/23/14
1526 views
0 replies

A Schema Change Inconsistency with Galera Cluster for MySQL

I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.

Alec Noller07/22/14
3997 views
0 replies

What's to Come in Oracle Big Data SQL

We heard some interesting news regarding SQL and Big Data earlier this month, and now there's more: Oracle Big Data SQL. Even if that incredibly creative name doesn't do it for you, it looks like it should be useful as a way to connect the various Big Data technologies you might be working with.

Vlad Mihalcea07/22/14
1300 views
0 replies

Hibernate Hidden Gem: The Pooled-Lo Optimizer

In this post we’ll uncover a sequence identifier generator combining identifier assignment efficiency and interoperability with other external systems (concurrently accessing the underlying database system).

Markus Winand07/21/14
2764 views
0 replies

Finding All the Red M&Ms: A Story of Indexes and Full‑Table Scans

A common question that comes up when people start tuning queries is “why doesn’t this query use the index I expect?" There are a few myths surrounding when database optimizers will use an index. The basic decision on whether or not to use an index, though, comes down to its cost.

John Piekos07/21/14
1747 views
0 replies

The Rise of NoSQL is An Opportunity for New RDBMS Solutions

It should come as no surprise that NoSQL has become popular over the past few years. This popularity has been driven in large part by the app revolution. Many new apps are hitting millions of users in less than a week, some in a day. This presents a scaling problem for app developers who seek a large audience.

Alec Noller07/20/14
2431 views
0 replies

The Best of the Week (July 11): 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 look at Realm, a memory-efficient mobile database, a renewed focus on Java and SQL, the similarities between databases and humvees, and more.

Peter Zaitsev07/18/14
1124 views
0 replies

Managing Shards of MySQL Databases with MySQL Fabric

This is the fourth post in our MySQL Fabric series. In case you’re joining us now, we started with an introductory post, and then discussed High Availability (HA) using MySQL Fabric. Today we will talk about how MySQL Fabric can help you scale out MySQL databases with sharding.

Sony Arouje07/18/14
1706 views
0 replies

Compile SQLite for WinRT with FTS4 unicode61 Support

I was experimenting with the FTS3/FTS4 feature of SQlite in a WinRT app. The default tokenizer ‘simple’ wont tokenize special character like $, @, etc. The solution is to use ‘unicode61’ tokenizer. Unfortunately the SQLite installer for WinRT8.1 comes without unicode61 tokenizer.

Lukas Eder07/17/14
2513 views
0 replies

Logon Triggers: The Oracle Database Magic Bullet

Imagine you want to collect detailed usage statistics to tune your Oracle database, e.g. if you want to have A-Rows and A-Time values in your execution plans. It's simple enough, but of course, you hardly ever have the required privileges. So how can we get those advanced statistics? Easy: by using a logon trigger.

Alec Noller07/17/14
4090 views
0 replies

Realm: A Memory-Efficient Mobile Database

If you're a mobile developer looking for a database that won't crush devices more thoroughly than Play Services 5.0, SQLite isn't the only option anymore. Now there's Realm, currently available for iOS (and Android, soon).

Alec Noller07/16/14
2629 views
0 replies

Devs of the Week: Jeffrey Kim & Trevor Gasdaska

Every week here and in our newsletter, 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 getting a different sort of perspective from DZone's development interns, Jeffery Kim and Trevor Gadaska!

Vlad Mihalcea07/16/14
2295 views
0 replies

From JPA to Hibernate's Legacy and Enhanced Identifier Generators

While there’s not much application-side IDENTITY generator optimization (other than configuring database identity preallocation), the sequence identifiers offer much more flexibility in this regard. One of the most common optimization strategy is based on the hi/lo allocation algorithm. This article will investigate various sequence-like generation strategies and all the available optimizations.

Peter Zaitsev07/16/14
1388 views
0 replies

Looking Out for Max Values in Integer-Based Columns in MySQL

Recently, one of my long-term clients was noticing that while their INSERTs were succeeding, a particular column counter was not incrementing. Here's what happened and how to solve it.

Anders Karlsson07/15/14
1916 views
0 replies

MariaDB Replication, MaxScale and the Need for a Binlog Server

This is an introduction to MariaDB Replication and to why we need a binlogs server and what this is. The first part is an introduction to replication basics, and if you know this already, then you want want to skip past the first section or two.

Alec Noller07/15/14
1043 views
0 replies

Arel & ActiveRecord: The Definitive Guide to Ruby's SQL Manager

If you're a Ruby developer working with SQL, you might want to check out Jiří Pospíšil's definitive guide to Arel, the SQL manager for Ruby. It's one of those libraries that you use constantly and rely on heavily, even though you might not know much about how it works, or even that it exists.

Doug Winfield07/15/14
1374 views
0 replies

Generate a Serializable Data Access Layer with Telerik Data Access

A demanded feature on our Ideas and Feedback portal is the out-of-the-box ability to generate persistent classes that can be serialized, and here it is in Telerik Data Access Q2 2014.

Lukas Eder07/14/14
3486 views
0 replies

More Functional Relational Transformation

In the past, we’ve been providing you with a new article every Friday about what’s new in Java 8. It has been a very exciting blog series, but we would like to focus again more on our core content, which is Java and SQL.

Alec Noller07/14/14
2992 views
0 replies

PostgreSQL vs. NoSQL: Your Database is a Humvee

If you're wondering about the similarities between your database choices and your militarized suburban vehicle choices, Bruce Momjian and Marc Linster have the presentation for you!

Peter Zaitsev07/14/14
1671 views
0 replies

Failover with the MySQL Utilities: Part 2 – mysqlfailover

In the previous post of this series we saw how you could use mysqlrpladmin to perform manual failover/switchover when GTID replication is enabled in MySQL 5.6. Now we will review mysqlfailover (version 1.4.3), another tool from the MySQL Utilities that can be used for automatic failover.

Dmitriy Setrakyan07/11/14
2118 views
0 replies

GridGain 6.1.9: One Click Installation, One Jar Dependency

For those who are not familiar with GridGain, it is an open source distributed data grid product. With the release of 6.1.9, GridGain significantly simplified its installation and deployment. GridGain now allows for one click installation and one JAR dependency.

Alex Bolenok07/11/14
241 views
0 replies

SQL Server: Deleting with Self-Referential FOREIGN KEY, Handling Loops

Responding to a comment involving infinite loops, the author looks at how to clean them up using check conditions.

Peter Zaitsev07/10/14
1160 views
0 replies

Using MySQL Triggers and Views in Amazon RDS

I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views. I came across two significant issues that prevented me from following Amazon’s documentation.

Matt Lacey07/10/14
1468 views
0 replies

SQLitePCL vs. Akavache

Earlier this week I shared the news that there is now an "official(ish)" version of SQLite that can be used in what Microsoft calls "Universal Apps". I was asked how this compares with using Akavache, and if I have any recommendations.

Vlad Mihalcea07/09/14
2942 views
0 replies

Hibernate Identity, Sequence and Table (Sequence) Generator

In my previous post I talked about different database identifier strategies. This post will compare the most common surrogate primary key strategies: IDENTITY, SEQUENCE, and TABLE (SEQUENCE).

Lukas Eder07/08/14
1128 views
0 replies

PostgreSQL’s Table-Valued Functions

Table-valued functions are an awesome thing. Many databases support them in one way or another and so does PostgreSQL. In PostgreSQL, (almost) everything is a table.