Over a million developers have joined DZone.

The Best of the Week (July 11): 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 (July 11 to July 17). Here they are, in order of popularity:

1. Realm: A Memory-Efficient Mobile Database

If you're a mobile developer looking for a database that won't crush devices more thoroughly than Play Services 5.0, SQLite isn't the only option anymore. Now there's Realm, currently available for iOS (and Android, soon).

2. More Functional Relational Transformation

In the past, we’ve been providing you with a new article every Friday about what’s new in Java 8. It has been a very exciting blog series, but we would like to focus again more on our core content, which is Java and SQL.

3. PostgreSQL vs. NoSQL: Your Database is a Humvee

If you're wondering about the similarities between your database choices and your militarized suburban vehicle choices, Bruce Momjian and Marc Linster have the presentation for you!

4. Logon Triggers: The Oracle Database Magic Bullet

Imagine you want to collect detailed usage statistics to tune your Oracle database, e.g. if you want to have A-Rows and A-Time values in your execution plans. It's simple enough, but of course, you hardly ever have the required privileges. So how can we get those advanced statistics? Easy: by using a logon trigger.

5. From JPA to Hibernate's Legacy and Enhanced Identifier Generators

While there’s not much application-side IDENTITY generator optimization (other than configuring database identity preallocation), the sequence identifiers offer much more flexibility in this regard. One of the most common optimization strategy is based on the hi/lo allocation algorithm. This article will investigate various sequence-like generation strategies and all the available optimizations.


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 }}