• submit to reddit
Lukas Eder04/03/14
0 replies

A Better Query Language than SQL

Leland Richardson, Founder of Tech.Pro has recently published a very interesting article about BQL, his visions of a better query language (than SQL). The deciding feat of his new language proposal is the fact that it is really a superset of SQL itself.

Alec Noller04/02/14
0 replies

Dev of the Week: Nicolas Frankel

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 talking to Nicolas Frankel, IT consultant with 10 years experience in Java and JEE environments.

Lukas Eder04/02/14
0 replies

The Power of Spreadsheets in a Reactive, RESTful API

The author has recently been deceived by his own Dilbertesque attitude when he stumbled upon a buzzword-filled article about Espresso Logic. But the actual product that claims to implement “reactive programming” through a REST and JSON API is frankly impressed by the ideas behind this product.

Mike Hadlow04/02/14
0 replies

Docker: Bulk Remove Images and Containers

I’ve been playing around creating new images and containers and debugging my Dockerfile, and I’ve wound up with lots of temporary containers and images. It’s really tedious repeatedly running ‘docker rm’ and ‘docker rmi’, so I’ve knocked up a couple of bash commands to bulk delete images and containers.

jb j04/01/14
0 replies

Manage WordPress comments using SQL

Although WordPress have an effective built-in comment management interface, for several tasks like deleting bulk comments it is way easier and quicker to use SQL. In this article, the author is going to show you some super useful SQL queries to manage your WordPress comments more easily.

Jim Highsmith04/01/14
0 replies

Don't "Control" Agile Projects

One common complaint about agile methods is that management doesn’t have the same degree of “control” over projects. We need to stop worrying about this complaint as a vice and start thinking of it as a virtue.

Rob Galanakis04/01/14
0 replies

What if Carl Sagan were a hack?

Neil deGrasse Tyson talked some about how stellar of a scientist Carl Sagan was and what an impact Carl had on Neil personally. What a reminder for those of us that have moved into managing and left behind creating. Should our dues, once paid, last forever?

Eyal Golan04/01/14
0 replies

Installing PostgreSQL on Fedora

The author started the book Seven Databases in Seven Weeks in order to have better understanding of the different SQL / NoSQL paradigms. What are the pros and cons of each approach and play around with each type. In this post, he wants to share the installation process I had with PostgreSQL on Fedora.

Mpumelelo Msimanga03/31/14
2 replies

6 Simple Performance Tips for SQL SELECT Statements

After years writing SQL statements, the author began to develop a mental check-list of things he looked at when trying to improve query performance. These are the things the author checks before moving on to query plans and reading the sometimes complicated documentation of the database he is working on.

Gil Zilberfeld03/31/14
0 replies

Good vs. Evil

Agile was a developer thing, and now it’s out there in the hands of the uninitiated.

Lorna Mitchell03/31/14
2 replies

Quick Switch Between Git Branches

Today's little-known git feature (or maybe everyone knows but me? I only found this a few months ago) is for quickly switching between branches. Usually I would switch branches with: git checkout [branchname]

Trek Palmer03/31/14
0 replies

Isolation Levels in Terms of MVCC, Part 2: Indexes and Latency

In this article, the author will continue to pontificate upon isolation levels as a SQL construct and how to understand them in a distributed MVCC database like NuoDB.

Alec Noller03/30/14
0 replies

The Best of the Week (Mar. 21): 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 how-to on using Hibernate native SQL queries in Grails applications, tips and tricks for SQL's date time arithmetic, part 3 of a series on MaxScale, and more.

Mike Stonebraker03/29/14
0 replies

VoltDB Beyond Multi-Partition Transactions: Run Everywhere

VoltDB supports single- and multi-partition transactions. But what if you wanted to run an operation on all data (each partition), but you didn’t want to execute the operation as a multi-part transaction? Here’s how to do that.

George Dinwiddie03/28/14
1 replies

Definition of Ready

Many time, in the middle of developing a user story, the programmer discovers a question about how it’s intended to work. Or the tester, when looking at the functionality that’s been developed, questions if it’s really supposed to work that way.