Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

The Best of the Week (Apr. 25): SQL Zone

DZone's Guide to

The Best of the Week (Apr. 25): SQL Zone

· Java Zone
Free Resource

Bitbucket is for the code that takes us to Mars, decodes the human genome, or drives your next car. What will your code do? Get started with Bitbucket today, it's free.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (Apr. 25 to May 1). Here they are, in order of popularity:

1. Groovy Database Resource Handling

This post contains a simple example of using Groovy Categories to help manage the resource management of database connections. There are a lot more robust solutions (ie: GORM), but sometimes you only need a quick implementation.

2. NoSQL? No, SQL! – How to Calculate Running Totals

If only we Java developers knew how easy and how much fun it can be to replace thousands of lines of erroneous Java code with five lines of SQL. Don’t believe it? Check this out.

3. SQLStats Plugin Version 1.4 Released

The author has released version 1.4 of his sqlstats plugin for MySQL and MariaDB. As of this version, he focused on testing with MariaDB, but it should work with MySQL also. In addition, he has now made the code a bit more portable by removing some features that depended on the THD struct.

4. How to Leverage SQL Server with Node.js Using Edge.js

The author has looked at Node.js many times over the past few years. It’s hard to ignore all the attention it has received. Unfortunately, being heavily invested in Microsoft technology, one of the reasons he has never got very far in learning Node.js is its lack of support for SQL Server. One solution is Edge.js.

5. NuoDB for .NET Takes Another Step

We will soon be releasing NuoDB 2.0.4 and this release will include support for the latest ADO.NET provider. As the ADO.NET world evolves, especially the Entity Framework (EF), we here at NuoDB are not standing by but are moving the driver forward as well.

Bitbucket is the Git solution for professional teams who code with a purpose, not just as a hobby. Get started today, it's free.

Topics:

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}