SQL Zone Link Roundup (Apr. 26)

For a look at what's been happening outside of the SQL Zone, we've assembled a collection of links from around the web covering all the tutorials, tools, new releases, rants, and raves you might have missed over the past couple of weeks:

Tutorials & Tools

Broadcasting PostgreSQL NOTIFY Messages to WebSocket Clients

In this post, I look at how to broadcast NOTIFY messages from a Postgres database to WebSocket clients using Spring MVC 4.

CRUD Admin Generator

Generate a complete backend from a MySql database. In seconds.

UPSERTisms in Postgres

As I'm sure a lot of people know already, PostgreSQL 9.4 will eventually be released without "native" support for UPSERT. That said, it's still one of the most common questions on the excellent #postgresql IRC channel, and people are sometimes tempted to try and solve it via TRIGGERs (hell, even RULEs), unsuccessfully.

Design a Better SQL Database With Database Normalization

In this post, I will go over the benefits of laying out data in a relational database like SQL. By way of a simple example, I will then go over the basics of how to design a robust database and the concept of database normalization. These topics are essential in being able to design and interact effectively with databases.

Developer's Guide to Understanding DBAs

You’re a developer, and you want to know:

• What do DBAs value?
• What do DBAs need from me?
• What does my DBA want to help me with?
• How big should that server be?
• Is the DBA judging my code?
• What happens if I get in trouble with my DBA?

News & Opinion

NoSQL Meets Bitcoin and Brings Down Two Exchanges: The Story of Flexcoin and Poloniex/

Flexcoin was a Bitcoin exchange that shut down on March 3rd, 2014, when someone allegedly hacked in and made off with 896 BTC in the hot wallet. Because the half-million dollar heist from the hot wallet was too large for the company to bear, it folded.

I'll resist the urge to ask why they did not have deposit insurance for their hot wallet, because the technical story of what happened is even more colorful and fascinating.

Adventures in MySQL at Dropbox

Dropbox DBA Renjish Abraham, in his April 2 keynote at the Percona Live MySQL Conference and Expo 2014, talks about the overall architecture, some of the design decisions his team has taken at Dropbox, war stories and lessons learned.

Medoo

The lightest PHP database framework to accelerate development: Version: 0.9.5

MySQL 5.5 to MySQL 5.6 Upgrade Support for Amazon RDS

The Amazon Relational Database Service (RDS) takes care of almost all of the day to day grunt work that would otherwise consume a lot of system administrator and DBA time. You don't have to worry about hardware provisioning, operating system or database installation or patching, backups, monitoring, or failover. Instead, you can invest in your application and in your data.

Flickr from SQL Injection to RCE

Today i will write about a new vulnerability i found in Flickr.com

- How I got MYSQL root password of Flickr Database

- RCE on Flickr server