Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 122 — September 9, 2015
Solving the Traveling Salesman Problem with Postgres Recursive CTEs
The simplest CTEs are amazing for making readable queries, but CTEs can go far beyond being just a temporary view during a query. Recursive CTEs can essentially do a ‘for’ loop right in SQL - here’s a great example highlighting how that can be used.
Periscope
PostgreSQL Magic
A look at some handy features in Postgres that would be ‘hard to replicate in MySQL’ including sequences, inserting and selecting data with one query (using RETURNING), arrays, and user-defined data types.
Florian Brick
Want to work on new projects? Make more money? Try a new stack? Relocate?
On Hired, we'll bring the options to you. With over 2,000 pre-screened tech companies in 10 cities in the US & UK, you'll be sure to find what you're looking for. Join Hired today.
Hired.​com    #sponsored 
Common Misconceptions about Locking in Postgres
General belief is that if you have locks on your database, you’re inviting problems, but the reality is more nuanced. Postgres has a variety of lock types which mean a variety of things and have various pros and cons as we see here.
Robert M.​ Wysocki
MoSQL: A MongoDB to PostgreSQL Streaming Translator
Imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a Mongo database, and then run offline reporting using SQL.
Stripe   #tools 
Simple Index Checking with PostgreSQL
Indexes are what will generally make your queries run faster, at least for most web apps making small queries. There’s some general rules of thumb that you can use as a guide - here’s a great run down of those rules as well as some queries to help you analyze your DB.
Matt Barr
PostgreSQL Indexing with Ecto
If Postgres is your choice for your latest Elixir project, this post should get you all setup with proper indexing to make sure your app is performing as you’d hope.
Richard Nyström
Django 1.8 and Postgres Meeting Notes from DjangoCon
DjangoCon is currently happening, and as part of that there’s been some great discussion around Django and it’s experience with Postgres.
DjangoCon 2015
PostgreSQL for Ruby Developers
A paid/commercial e-book.
Jesus Castello   #news 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.