Over a million developers have joined DZone.

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

· Java Zone

Navigate the Maze of the End-User Experience and pick up this APM Essential guide, brought to you in partnership with CA Technologies

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.

Thrive in the application economy with an APM model that is strategic. Be E.P.I.C. with CA APM.  Brought to you in partnership with CA Technologies.

Topics:

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

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

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

{{ parent.tldr }}

{{ parent.urlSource.name }}