---
title: "This Week's PostgreSQL News (#94)"
publication: "Postgres Weekly"
issue: 94
published_at: "2015-02-25"
canonical_url: "https://postgresweekly.com/issues/94"
---

Postgres Weekly 94   . 

[Read this on the Web](http://postgresweekly.com/issues/94) 

[Postgres Weekly](http://postgresweekly.com) Issue 94 — February 25, 2015     

[Embracing SQL In Postgres](http://rob.conery.io/2015/02/24/embracing-sql-in-postgres/?utm_source=postgresweekly&utm_medium=email)SQL is powerful and especially so in Postgres. If you rely on your ORM a bit too much here are some great examples of when you should take a deeper look at how simply some things can be done with raw SQL in Postgres. Rob Conery [Is Postgres NoSQL Better Than MongoDB?](http://www.aptuz.com/blog/is-postgres-nosql-database-better-than-mongodb/?utm_source=postgresweekly&utm_medium=email) Aptuz [Postico: A Modern PostgreSQL Client for OS X](https://eggerapps.at/postico/?utm_source=postgresweekly&utm_medium=email)Postico is the successor to PG Commander, one of the few solid OS X GUI clients for working with and managing Postgres. Egger Apps [Comprehensive Postgres Admin Training with Bruce Momjian](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=postgresweekly&utm_medium=email)Whether you’re an established professional or new to Postgres, our training will give you the expertise you need in Postgres 9.4. Accelerate your learning with live training taught by Postgres Community Leader Bruce Momjian. 20% off for Postgres Weekly subscribers with promo code_COMB-PGW-01_ EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/864cc1f3.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=postgresweekly&utm_medium=email) [Million User Webchat with Full Stack Flux, React, Redis and PostgreSQL](https://blog.rotenberg.io/million-user-webchat-with-full-stack-flux-react-redis-and-postgresql/?utm_source=postgresweekly&utm_medium=email)A basic 3 tier application can get you pretty far when using Postgres, but sometimes you grow beyond that and have to change your architecture. Look at how this demo app and architecture could get you to a scale of 1 million users. Elie Rotenberg [How to Build Your Distributed Database](http://citusdata.com/blog/114-how-to-build-your-distributed-database?utm_source=postgresweekly&utm_medium=email)Building a distributed database is a task many take on, often because you’ve reached to need to tackle a new scale. There’s plenty to be learned from others who’ve tackled this, and this article provides some guidance. Ozgun Erdogan ['In-Memory' Is Not A Feature, It's A Bug](http://www.databasesoup.com/2015/02/in-memory-is-not-feature-its-bug.html?utm_source=postgresweekly&utm_medium=email)Here’s a thought piece that talks about in-memory, which is undoubtedly faster but lacks certain guarantees around… well not losing your data. Josh Berkus [Developing and Rails: Install Ruby on Rails in Windows —and Postgres, and Mongo, and Redis...](http://www.developingandrails.com/2015/02/install-ruby-on-rails-in-windows-and.html?utm_source=postgresweekly&utm_medium=email)For all the progress we’ve made on new and modern languages, getting set up with a local development can still be far too much of a pain. This guide gets you up and running on Rails with Postgres and Redis on Windows. Developing and Rails [rdb: A JavaScript ORM for PostgreSQL and MySQL](https://github.com/alfateam/rdb?utm_source=postgresweekly&utm_medium=email)If you don’t want to think about SQL, ORMs are the way to go. Here’s yet another one, this time in JavaScript and targeted at both Postgres and MySQL. alfateam#code    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/94) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK