Encoding HTML tags in PostgreSQL

regexp_replace(xmlelement(name x, 'Some string with <strong>html</strong>', null)::text, '</?x>', '', 'g')

postgres migration

Simple source control for postgres

Import CSV file from internet in postgres

COPY film_locations FROM PROGRAM 'wget -q -O - "$@" "https://data.sfgov.org/api/views/yitu-d5am/rows.csv?accessType=DOWNLOAD"' HEADER CSV DELIMITER ',';

iframe postMessage with Promise

postMessagePromise({msg:'getSomething'}) .then((r)=>{ console.log('response from iframe', r) })

evolvitcms doc

docs

svelte use: ClickOutside directive

svelte use: ClickOutside directive

2020 css reset

Css reset

Screen recorder

Online screen recorder using MediaStream_Recording_API and Svelte v3

thescreenshare.com

Plugin free screenshare

working example of socket.io and nginx

upstream upstream-nodejs { server 127.0.0.1:3000; }

Postgres jsonb_to_recordset join

SELECT specs.name, COUNT(*) AS total FROM categories, jsonb_to_recordset(categories.specifics) AS specs(name jsonb, required boolean)

filip

Fix blurry font after translate %

Normalize the resulting transformation matrix

Svelte parallax scroll example

https://vujovicigor.github.io/svelte-parallax/public/

Svelte Vs Vue

Focus on your code/business logic, not on the framework

No pg_hba.conf entry for host, SSL off error on dbeaver heroku postgres connection

check "Use SSL", add "org.postgresql.ssl.NonValidatingFactory" to "SSL Factory" field

Postgres Synchronous Replication

Asynchronous, synchronous & logical replication and horizontal scale

Postgres links

Things To Do After Installing cPanel

Show hidden files (.htaccess), Enable gzip compression, Select fresh PHP version. Force https

Send HTML Form to Google Sheets using PHP… without Google Forms

Download google-api-php-client (via compose or direct download from https://github.com/googleapis/google-api-php-client/releases ) Create a project on https://console.developers.google.com/apis/dashboard. Enable APIs, enable the Google Sheets API...