Thursday, May 23, 2013

Postgres 9.3 feature highlight: new flavors of IF EXISTS and IF NOT EXISTS (michael.otacoo.com)

IF EXISTS and IF NOT EXISTS are clauses allowing to return a notice message instead of an error if a DDL query running on a given object already exists or not depending on the DDL action done. If a given query tries to create an object when IF NOT EXISTS is specified, a notice message is returned to client if the object has already been created and nothing is done on server side. If the object is altered or dropped when IF EXISTS is used, a notice message is returned back to client if the object does not exist and nothing is done.

Prior to 9.3, PostgreSQL already proposed this feature with many objects: tables, index, functions, triggers, language, etc. Such SQL extensions are useful when running several times the same script several times and avoiding errors on environments already installed.

9.3 introduces some new flavors of IF [NOT] EXISTS completing a bit more the set of objects already supported.

  • CREATE SCHEMA [IF NOT EXISTS]
  • ALTER TYPE ADD VALUE [IF NOT EXISTS]
  • Extension of DROP TABLE IF EXISTS such as it succeeds if the specified schema does not exists
  • Note also that the new materialized views are also supported with IF [NOT] EXISTS for CREATE, ALTER and DROP.

Read more...

Tuesday, May 21, 2013

Native equivalents of jQuery functions (leebrimelow.com)

But if you are able to target modern browsers in your work, using the native C++ methods provided by your browser will not-surprisingly give you a tremendous performance boost in most areas.

Read more

Thursday, May 16, 2013

PostgreSQL 9.3 beta: Federated databases and more (LWN.net)

In Berkeley, California — the birthplace of PostgreSQL — it's spring: plum and cherry blossoms, courting finches and college students, new plans for the summer, and the first beta release of the database system. Every year, the first beta of the next PostgreSQL version comes out in April or May, for a final release in September. PostgreSQL 9.3 beta 1 was released to the public on May 13th, and contains a couple dozen new features both for database administrators and application developers.

Read more...

Wednesday, May 15, 2013

Go and Rust — objects without class (lwn.net)

Since the advent of object-oriented programming languages around the time of Smalltalk in the 1970s, inheritance has been a mainstay of the object-oriented vision. It is therefore a little surprising that both "Go" and "Rust" — two relatively new languages which support object-oriented programming — manage to avoid mentioning it. Both the Rust Reference Manual and The Go Programming Language Specification contain the word "inherit" precisely once and the word "inheritance" not at all. Methods are quite heavily discussed, but inheritance is barely more than a "by the way".

Read more...

Friday, May 3, 2013

UNICEF Tells Slacktivists: Give Money, Not Facebook Likes (theatlantic.com)

It’s easier than ever to support a good cause – all you have to do is hit the like button. The organization gets one more supporter and you get positive publicity among your friends. But even though it’s important to be liked, likes can’t fund medicine, water or food. In this campaign for Unicef Sweden, we highlight the absurdness of our blind faith in likes, to raise money for vaccine.

Read more

Wednesday, May 1, 2013

Download Google fonts to your desktop (googledevelopers.blogspot.co.uk)

The goal of Google Fonts has always been to bring beautiful, open-source fonts to the web, fast and free of cost. Starting today, you can download these fonts for offline access on your desktop. We’ve made all of the fonts from the Google Fonts directory available in SkyFonts, a tool from Monotype that allows you to install and sync fonts from the web onto your Windows or Mac OS X devices.

Read more...