• submit to reddit
Peter Zaitsev10/07/14
0 replies

Percona Server, OpenStack and the Tesora DBaaS Platform

The Tesora platform is an enterprise-ready database as a service (DBaaS) platform based on the OpenStack Trove project. Percona Server was certified by Tesora in August as part of their Tesora DBaaS Platform certification program.

Mark Needham10/07/14
0 replies

PostgreSQL: ERROR: Column Does Not Exist

A short article about the troubles that letter case can cause in PostgreSQL queries.

John De Goes10/06/14
3 replies

The Rise (and Fall?) of NoSQL

If you haven’t heard of the meteoric rise of NoSQL, you’ve been living in a hole. Likely at the bottom of the ocean. In the Mariana trench. What you probably haven’t heard, what’s been lost in all the hype, is that NoSQL’s unprecedented growth has very little to do with “big data” or “SQL”!

Andrew Gilmartin10/06/14
0 replies

Streaming content for non-media applications

You can improve your application's user-interface responsiveness by designing a better on-the-wire data format.

Lukas Eder10/06/14
1 replies

Using Your RDBMS for Messaging is Totally OK

Controversial database topics are a guaranteed success on reddit, because everyone has an opinion on those topics. More importantly, many people have a dogmatic opinion, which always triggers more debate than pragmatism.

John Georgiadis10/05/14
0 replies

A MongoDB-based JAAS plugin for Karaf and ActiveMQ

ActiveMQ supports pluggable JAAS modules that handle the authentication of incoming requests. ActiveMQ comes preloaded with a few JAAS modules, none of which supports MongoDB as the backend repository of the authentication data.

Franck Wolff10/05/14
13 replies

Beyond JSON: Introducing the Spearal Serialization Protocol

Spearal is a new, open-source, serialization protocol that aims to overcome the limitations of JSON. It targets - as a first step - HTML and native mobile applications connected to a Java backend.

Jayanga Dissanayake10/05/14
1 replies

Simple SecurePasswordVault in Java

There are some instances when you want to store your passwords in files to be used by programs or scripts. But storing your passwords in plain text is not a good idea. Use the SecurePasswordVault to encrypt your passwords before storing and get it decrypted when you want to use it.

Erik Ejlskov Jensen10/04/14
0 replies

Comparison of SQL Server Compact, SQLite, SQL Server Express and LocalDB

Now that SQL Server 2014 and SQL Server Compact 4 has been released, some developers are curious about the differences between SQL Server Compact 4.0 and SQL Server Express 2014 (including LocalDB). I have updated the comparison table from the excellent discussion of the differences between Compact 3.5 and Express 2005 here to reflect the changes in the newer versions of each product.

G. Ryan Spain10/03/14
3 replies

PostgreSQL vs. MongoDB - FIGHT!

EnterpriseDB recently published findings on a series of performance tests they ran in order to compare the PostgreSQL and MongoDB databases. In their results, they found that PostgreSQL performed better than MongoDB in many key areas.

Peter Zaitsev10/03/14
0 replies

More Than 1000 Columns - Get Transactional with TokuDB

Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point.

Pat Shaughnessy10/02/14
0 replies

How Arel Converts Ruby Queries Into SQL Statements

This is the second in a series of posts based on a presentation I did at the Barcelona Ruby Conference called “20,000 Leagues Under ActiveRecord.” I took an innocent and unsuspecting audience on an adventure inside and underneath ActiveRecord to find out how Rails and PostgreSQL actually execute a simple SQL query.

Kevin Rutherford10/02/14
0 replies

Where do conditionals come from?

I’ve listed out those origins of conditionals that I could think of. Is this a fool’s errand? Possibly, but let’s give it a try anyway.

Lukas Eder10/02/14
4 replies

Asynchronous SQL Execution with jOOQ and Java 8’s CompletableFuture

Functional syntax greatly helps with structuring asynchronous execution chains, and today, we’ll see how we can do this in Java 8 using jOOQ and the new CompletableFuture API.

Adam Diaz10/02/14
0 replies

The Evolution of MapReduce and Hadoop

Recently I authored a section of the DZone Guide for Big Data 2014. I wrote about MapReduce and the evolution of Hadoop.