SQL Zone | The social network for developers

SQL Zone

Did you know? DZone has great portals for Python, Cloud, NoSQL, and HTML5!

Should the CIO Know How to Code?

5 Signs You Should Hire a Programmer on the Spot

How Twitter Does MySQL - Get Their Fork

BIRT 3.7 Report Design Refcard - Meet the Author: Michael Williams

Gian Maria05/14/12
4411 views
1 replies

Misusing an ORM

ORM are primarily used to avoid writing SQL and persist completely anemic domain, where all the logic reside on services. In such a scenario it is easy to abuse an ORM and probably in the long term the ORM could become much more a pain than a real help.

Mitch Pronschinske05/12/12
3205 views
0 replies

Hadoop, Mahout, R and Lucene/Solr on One Cloud Platform

Some more cool news has come out of this week's Lucene Revolution conference related to their theme of 'Solr's not just for search, it's for analytics. In addition to their Solr-as-a-Service cloud search platform, which is basically LucidWorks Enterprise on the cloud, Lucid Imagination has now announced the beta release of LucidWorks Big Data.

Corey Goldberg05/05/12
588 views
0 replies

Python - Search a Local or Remote Splunk Server

Corey Goldberg gives us some basic instructions for searching Splunk and Python and then walks us through the process of using the tools.

Geoffrey Papilion05/03/12
4396 views
0 replies

Redunancy Planning - A Guide to What's Right for You

The general best practice is to add an additional element for each service tier, also know as N+1 redundancy. This approach is straight forward, but many people would actually be surprised by how often these schemes fail.

Brian Kelly05/02/12
14771 views
7 replies

5 Signs You Should Hire a Programmer on the Spot

When a programmer nails the interview and test the hiring manager is still inclined to say "we'll be in touch" but that's just not always the best idea...

James Betteley04/20/12
8031 views
0 replies

Beer and Pizza with Facebook: Learning Their Secrets...

James Betteley was invited to go along to the Facebook offices in London this week. What he learned was the secrets and tools behind their engineering and automated testing, all while enjoying some beer and pizza.

Dino Oglic04/11/12
2874 views
0 replies

Apache Solr Test Suite - Getting Optimal Response Times

In this article we will try to present the importance of understanding the data in pursuit of optimal response times for a search engine. By comprehending the data and the user you are able to tune a good generic search tool to meet your needs and demands.

A. Jesse Jiryu Davis04/10/12
1906 views
0 replies

The Disconnect Between Introductory SQL Courses and Real World Application Development

Wikipedia's article on schema design seems to leave out an important step; this post suggests one question that should be introduced before deploying a large-scale app.

Chris Smith04/09/12
8973 views
0 replies

How Twitter Does MySQL - Get Their Fork

Twitter has made their "flavor" of MySQL available on GitHub this week, and in this post, Chris explains some of the additional features and changes they've made to make MySQL work for them.

German Viscuso04/05/12
5426 views
3 replies

Beyond Java ORM: What Versant Did with the JPA (Part 1)

The Versant team reviewed state-of the-art JPA tech. to bring you Versant JPA; this article introduces the basic building blocks of the Java Persistence API

Mitch Pronschinske03/28/12
9285 views
4 replies

NEW Refcardz Topics (Round 2): Awesome or Lame?

See a new menu of potential upcoming DZone Refcardz with some brief descriptions. Then simply vote on whether you think the topic idea is AWESOME, or lame.

Anders Karlsson03/26/12
1972 views
0 replies

MongoDB for MySQL Folks: Queries and Indexes

Following the basic format of the MongoDB query, this post covers some query/indexing how-to's designed for the MySQL user.

Prabath Siriwardena03/12/12
3537 views
1 replies

A SMALL Cross-section of BIG Data

How big is a zettabyte? One billion terabytes. This well-researched post identifies and introduces some of the ways we're coping with Big Data.

Moshe Kaplan02/24/12
2139 views
0 replies

Cloud Computing Makes MySQL Replication Easier

Adding a new slave to support your MySQL system expansion is easier than ever, thanks to the cloud. This post show you how to do it in eight simple steps.

Anders Karlsson02/22/12
2854 views
0 replies

Amazon RDS for MySQL - Is it any good?

So far, Anders Karlsson is happy with Amazon's MySQL RDS, but there are a couple of things you should know before you use the services. This article will give you a quick look at the most important things to remember, and if you've considered using RDS, you'll want to read this...