Over a million developers have joined DZone.

The Best of the Week (Sep. 19): SQL Zone

DZone's Guide to

The Best of the Week (Sep. 19): SQL Zone

· Java Zone ·
Free Resource

"I love writing authentication and authorization code." ~ No Developer Ever. Try Okta Instead.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (September 19 to 26). Here they are, in order of popularity:
  1. Solving ORM: Keep the O, Drop the R, No Need for the M

    The ORM complexity problem has a simple, production-ready solution hiding in plain sight in the Java world.

  2. NoSQL and NewSQL: A Primer

    To fulfill the need for additional database processing speed and storage, the goal is to scale-out (add more commodity nodes to the system) rather than having to scale up (add more CPU or memory to each node). And to handle this need, two new kinds of scale-out databases have emerged: NoSQL and NewSQL. Let’s take a look at what sets them apart.

  3. JPA tutorial: Mapping Entities – Part 1

    In this article I will discuss about the entity mapping procedure in JPA. As for my examples I will use the same schemathat I used in one of my previous articles.

  4. SQL Injection & Optimizations Path

    It is silly, but I just had a conversation with one of our developers on SQL Injection. In RavenDB we support replicating to a relational database, which obviously require using SQL. We are doing things properly, with parameters and everything.

  5. How to Find Duplicate Indexes

    Josh Berkus at Database Soup wrote a post recently explaining how to find duplicate indexes in SQL. He has written a few queries to help those who need to filter through large amounts of indexes within a database. Berkus says his queries help to minimize the number of false positives that occur.

"I love writing authentication and authorization code." ~ No Developer Ever. Try Okta Instead.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}