Bookmarks tagged with #postgres.
Show all
Show all
Postgres Full-Text Search: A Search Engine in a Database | Crunchy Data Blog
With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.
Tags:
#postgres
Saved
on: 2021-07-28
Some SQL Tricks of an Application DBA
Some tips and misconceptions about database development I gathered along the way.
Saved
on: 2020-07-29
Lessons learned scaling PostgreSQL database to 1.2bn records/month
This isn’t my first rodeo with large datasets. The authentication and product management database that I have designed for the largest UK public Wi-Fi provider had impressive volumes too. We were…
Saved
on: 2019-10-16
Migres - The PostgreSQL migration tool : PHP
Saved
on: 2019-07-31
Why should you learn PostgreSQL? | Brightball
PostgreSQL has the capability to replace almost your entire application stack outside of the web server. Here is an attempt to summarize all of the amazing functionality that you're cheating yourself out of by not choosing PostgreSQL.
Tags:
#postgres
Saved
on: 2017-08-16
Postgres Guide
We here are very big fans of Postgres as a database and believe it is often the best database for the job. For many though, working with and maintaining Postgres involves a steep learning curve. This guide is designed as an aid for beginners and experienced users to find specific tips and explore tools available within Postgres.
If you want to take the quick & painless approach instead, there are great services available for Postgres hosting.
Tags:
#postgres
Saved
on: 2015-08-03
Goodbye MongoDB, Hello PostgreSQL
Migrating from MongoDB to PostgreSQL
Tags:
#postgres
Saved
on: 2015-03-11
Modern SQL in PostgreSQL
SQL has gone out of fashion lately—partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, the SQL standard continued to evolve during the past decades resulting in the current release of 2016. In this session, we will go through the most important additions since the widely known SQL-92. We will cover common table expressions and window functions in detail and have a very short look at the temporal features of SQL:2011 and row pattern matching from SQL:2016.
Links:
http://modern-sql.com/
http://winand.at/
http://sql-performance-explained.com/
Tags:
#postgres
Saved
on: 2015-02-09