magnASCII.io Simone Magnaschi
Senior Full Stack Web Dev
Bookmarks tagged with #postgres.
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

knowledgepill.it

Diese Domain steht zum Verkauf!
Saved on: 2020-08-03

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

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

PostgreSQL vs. MS SQL Server

Tags: #postgres
Saved on: 2015-04-30

Goodbye MongoDB, Hello PostgreSQL

Migrating from MongoDB to PostgreSQL
Tags: #postgres
Saved on: 2015-03-11

Embracing SQL In Postgres — Rob Conery

Blog post not found
Tags: #postgres
Saved on: 2015-02-26

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
❤️
</>
2025