PostgreSQL: The MongoDB Killer

[Bráulio Bhavamitra]

see below

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


.
Read this on the Web
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=a5d1094357&e=e94a93aae6>
Postgres Weekly
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=4027f115ef&e=e94a93aae6>
Issue 135 — December 9, 2015
Postgres and JSON with Node - Hands on with MassiveJS
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=5f3d922982&e=e94a93aae6>
Postgres got JSON support years ago, and it only improved with JSONB. Just
now ORMs and libraries are getting support, including MassiveJS, a Node
package with a novel approach to letting Postgres work as a document store.
Craig Kerstiens
MongoDB 3.2: Now 'Powered' by PostgreSQL?
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=08313f9088&e=e94a93aae6>
An extensive writeup about how MongoDB 3.2 will use Postgres in its ‘legacy
BI connector’ so that SQL-based BI systems can operate against it.
John De Goes
Emulating Row Security in PostgreSQL 9.4
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=6e3b27c581&e=e94a93aae6>
PostgreSQL 9.5 adds declarative row security. It’s not available in 9.4 but
you can achieve a similar effect.
Craig Ringer
Get Ready for 2016! What Are Your Postgres Database Resolutions?
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=e0d867e197&e=e94a93aae6>
Have you finally resolved to fix that nagging performance problem once and
for all? Are you prepared for data growth in 2016? Now is the time to do a
quick tune up. Evaluate your Postgres database performance with a
rapid Architectural
Health Check
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=072a5ad670&e=e94a93aae6>
and ensure your system is optimally configured and tuned as you start the
year.
EnterpriseDB    #sponsored
<http://postgresweekly.us1.list-manage2.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=76b5934e4e&e=e94a93aae6>
The First Annual PGConf Silicon Valley Wrap Up
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=c2e9b00885&e=e94a93aae6>
Great speakers, enthusiastic attendees, lively networking, and standing
room only sessions were all highlights of the first annual Postgres
conference in the Bay Area.
Citus Data
Dictionaries and PostgreSQL FTS
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=5e00758364&e=e94a93aae6>
If you’re new to what it means to have ‘full text search’ capabilities,
this run through should give you a great primer on how it works in Postgres
as well as some practical steps.
Arthur Zakirov
Choosing PostgreSQL Over MySQL or MariaDB
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=294b785b7e&e=e94a93aae6>
David Bolton   #opinion
PostgreSQL Studio 2.0 Released
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=3dc6d4517d&e=e94a93aae6>
A fully open source Web-based UI for Postgres.
Jim Mlodgenski
Agg: Parallel Aggregations for Postgres
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=ead88afacf&e=e94a93aae6>
The most expensive operations in any Postgres database are generally
*aggregations*. Whether it’s some sum, average, or most common counts, such
operations often consume a large amount of time, but the *agg* extension
looks to improve this.
Hans-Juergen Schoenig
pg_repack: Reorganize Tables in PostgreSQL Databases with Minimal Locks
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=05519da768&e=e94a93aae6>
Pg_repack is an interesting extension that lets you remove bloat from
tables and indexes, and optionally restore the physical order of clustered
indexes.
The Reorg Development Team   #code
Join The Top 3% of Freelance PostgreSQL Developers Worldwide
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=f3e098f778&e=e94a93aae6>
Toptal is an exclusive network of elite freelance software engineers. Apply
today to work with top clients, set your own rates, and collaborate with
other top PostgreSQL developers.
Toptal    #job
Join our team of brainiacs and be a part of the database monitoring
revolution
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=0de27fbd34&e=e94a93aae6>
Vivid Cortex    #job

Postgres Weekly is curated by Craig Kerstiens
<http://postgresweekly.us1.list-manage.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=2d40f5b552&e=e94a93aae6>
Read this issue on the Web
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=e7cb55cca7&e=e94a93aae6>
See our archives
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=3b4d5f22fa&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=65c139a3bf>

Published by Cooper Press
<http://postgresweekly.us1.list-manage1.com/track/click?u=0618f6a79d6bb9675f313ceb2&id=3499d5f997&e=e94a93aae6>
Office 30, Lincoln Way, Louth, LN11 0LS, UK
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/noosfero-dev/attachments/20151209/b95d99df/attachment-0001.html>