DZone
Java Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Java Zone > The Best of the Week (May 16): SQL Zone

The Best of the Week (May 16): SQL Zone

Alec Noller user avatar by
Alec Noller
·
May. 25, 14 · Java Zone · Interview
Like (0)
Save
Tweet
3.98K Views

Join the DZone community and get the full member experience.

Join For Free

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

1. The PostgreSQL Datatypes You Aren't Using

You're probably not using all the datatypes available to you in PostgreSQL - there are actually quite a few. And that's not to say you should be using all of them, but it's always interesting to know what's out there, and to that end, Craig Kerstiens has made a list with descriptions and warnings.

2. Errant Transactions: Major Hurdle for GTID-Based Failover in MySQL 5.6

The author previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the potential solutions.

3. SQL Server Trick: Circumvent Missing ORDER BY Clause

SQL Server is known to have a very strict interpretation of the SQL standard. In this article, the author discusses a number of ways to handle ORDER BY clauses in SQL Server.

4. High Availability with MySQL Fabric: Part I

Today, the author will review MySQL Fabric’s HA concepts, and then walk you through the setup of a 3-node cluster with one Primary and two Secondaries, doing a few basic tests with it.

5. Mobilize and Restify your SQL Data

Full-featured back-office Mobile apps in minutes, with RESTful APIs for front-office apps. Declarative logic and security - simple and powerful as a spreadsheet. JavaScript for complex logic and integration. Here’s two new technologies that make it possible.

MySQL

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • 6 Things Startups Can Do to Avoid Tech Debt
  • Password Authentication. How to Correctly Do It.
  • DZone's Article Submission Guidelines
  • Ultra-Fast Microservices: When Microstream Meets Wildfly

Comments

Java Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo