Similarity of two strings – experiences

Basically there 2 very good extension available if you need to check how similar are 2 strings. pg_trgm – extension is part of standard installation and contains “trigram comparison algorithm”. pg_similarity – extension is available on github...

pl/sh language – small hints

Maybe many people do not like this idea accessing linux shell from the database but if you the “affected one” who needs to use it – here are some hints. Extension plsh seems maybe a little bit outdated but it still works even on pg 9.6 (tested...

mysql_fdw

This extension allows you to connect from PostgreSQL with read/write capability to mySQL database. Install on Ubuntu (you need to have pg repos allowed) using: sudo apt-get install postgresql-9.5-mysql-fdw sudo apt-get install libmysqlclient-dev To create foreign...

A little bit about pgstattuple extension

This simple extension helps you to determine possible problems with amount of pages/ tuples during query run. Here is one small query which shows basic statistics for table: with obj as ( select '...schame.tablename....'::text as _name), srcdata as ( select * from obj...