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
In this post, I look at how to broadcast NOTIFY messages from a Postgres database to WebSocket clients using Spring MVC 4.
Generate a complete backend from a MySql database. In seconds.
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.
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.
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
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.
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.
The lightest PHP database framework to accelerate development: Version: 0.9.5
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.
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