Fwd: This Week's PostgreSQL News (#105)

Wed May 13 11:43:49 BRT 2015

---------- Forwarded message ----------
From: Postgres Weekly <postgres at cooperpress.com>
Date: Wed, May 13, 2015 at 11:18 AM
Subject: This Week's PostgreSQL News (#105)
To: brauliobo at gmail.com


 .
Read this on the Web
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=2c8bb8285a&e=e94a93aae6>
 Postgres Weekly
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=06da797292&e=e94a93aae6>
Issue 105 — May 13, 2015
     'Upsert' Lands in PostgreSQL 9.5 – A First Look
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=ec7801b3ba&e=e94a93aae6>
Here’s a first look at ‘upsert’ (essentially a cute name for ‘create or
update’), covering the basics of what it is as well as the syntax for using
it. We’re a few months off from it being in a release, but at least now we
know it’s coming.
 Craig Kerstiens
PostgreSQL Anti-Patterns: Unnecessary JSON
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=23fb966bda&e=e94a93aae6>
JSONB and hstore are both awesome datatypes, but that doesn’t mean you
should create a single table with one record and use Postgres as a JSON
only store. This post guides you through some of the performance
implications, and highlights when JSON is a good fit.
 Craig Ringer
Full Text Search in Milliseconds with PostgreSQL
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=cb5a284af1&e=e94a93aae6>
Adding a basic, but performant full-text search to your application can be
completely trivial with Postgres. Here’s a basic walkthrough along with
some performance numbers.
 Max Novakovic
Telerik Developer Digest: A Bi-Weekly from Telerik Developer Network
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=be541f5e1c&e=e94a93aae6>
As well as our own newsletters, we also publish them for other companies,
such as Telerik. The Telerik Developer Digest includes the latest articles
from the Telerik Developer Network and things from around the web that will
interest Telerik users. See today's issue here.
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=5dd32eff89&e=e94a93aae6>
  sponsored     Telerik
Slinky: Write Queries Through A Lightweight Web Interface
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=441dc15fd4&e=e94a93aae6>
If you’ve ever had anyone ask you to give you a report or extract, you’ve
felt the pain of sharing data from a silo. Slinky aims to make this easier
letting you write SQL, but then giving an easy mechanism for others to
consume the results of that SQL.
 Slinky
PostgreSQL vs. MS SQL Server
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=8aac382b29&e=e94a93aae6>
A comparison of the two relational databases from the point of view of a
data analyst.
 Matthew Byrne
Upsert Lands in Postgres 9.5
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=d095824011&e=e94a93aae6>
Upsert is here! Well… It will be available in Postgres 9.5, it’s now fully
committed so there’s no question about if, it’s just when. Take a read
through the commit here.
 postgresql.org
DB Weekly: Our Weekly Database Technology Newsletter
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=0ca1f5adce&e=e94a93aae6>
DB Weekly covers general database trends, graph databases, NoSQL, tools,
and more. Issue 57
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=5f14139af2&e=e94a93aae6>
looked at RethinkDB, the Disque queue service, compression in MongoDB 3.0,
and Microsoft's 'Azure Data Lake'.
 Cooper Press

Postgres Weekly is curated by Craig Kerstiens
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=7bc7e4646d&e=e94a93aae6>
Read this issue on the Web
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=0e0a88741f&e=e94a93aae6>
See our archives
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=cbd4593d6a&e=e94a93aae6>
Change your email address
<http://postgresweekly.us1.list-manage.com/profile?u=0618f6a79d6bb9675f313ceb2&id=b3f056442a&e=e94a93aae6>
Stop getting Postgres Weekly
<http://postgresweekly.us1.list-manage.com/unsubscribe?u=0618f6a79d6bb9675f313ceb2&id=b3f056442a&e=e94a93aae6&c=b90db037f9>

Published by Cooper Press
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=b758f371d9&e=e94a93aae6>
Office 30, Lincoln Way, Louth, LN11 0LS, UK


-- 
"Lute pela sua ideologia. Seja um com sua ideologia. Viva pela sua
ideologia. Morra por sua ideologia" P.R. Sarkar

EITA - Educação, Informação e Tecnologias para Autogestão
http://cirandas.net/brauliobo
http://eita.org.br

"Paramapurusha é meu pai e Parama Prakriti é minha mãe. O universo é meu
lar e todos nós somos cidadãos deste cosmo. Este universo é a imaginação da
Mente Macrocósmica, e todas as entidades estão sendo criadas, preservadas e
destruídas nas fases de extroversão e introversão do fluxo imaginativo
cósmico. No âmbito pessoal, quando uma pessoa imagina algo em sua mente,
naquele momento, essa pessoa é a única proprietária daquilo que ela
imagina, e ninguém mais. Quando um ser humano criado mentalmente caminha
por um milharal também imaginado, a pessoa imaginada não é a propriedade
desse milharal, pois ele pertence ao indivíduo que o está imaginando. Este
universo foi criado na imaginação de Brahma, a Entidade Suprema, por isso
a propriedade deste universo é de Brahma, e não dos microcosmos que também
foram criados pela imaginação de Brahma. Nenhuma propriedade deste mundo,
mutável ou imutável, pertence a um indivíduo em particular; tudo é o
patrimônio comum de todos."
Restante do texto em
http://cirandas.net/brauliobo/blog/a-problematica-de-hoje-em-dia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/noosfero-dev/attachments/20150513/b7f55c02/attachment-0001.html>