João Pescada jpescada
jpescada
/ reset_postgresql_seq_key.sql
Created
January 29, 2021 15:30
Reset PostgreSQL sequence key
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT setval(pg_get_serial_sequence('table_name_here', 'id'), COALESCE((SELECT MAX(id) + 1 FROM table_name_here), 1), false); |
jpescada
/ nginx.conf
Created
October 20, 2020 23:25
NGINX block config for static PWA routing (React, Angular, Next, etc)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| server { | |
| location / { | |
| try_files $uri $uri.html $uri/ =404; | |
| } | |
| } |
jpescada
/ ngrok-europe-local-domain-ssl.sh
Created
October 1, 2020 23:43
Start ngrok in Europe on a custom local domain over https
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ngrok http --region=eu -host-header=rewrite https://domain.test |
jpescada
/ is-webkit-mobile.ts
Created
August 21, 2020 11:32
Detect WebKit browser on (mobile) iOS device
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Based on https://developer.mozilla.org/en-US/docs/Web/HTTP/Browser_detection_using_the_user_agent | |
| const isWebkit = (): boolean => { | |
| const UA = navigator.userAgent | |
| return /\b(iPad|iPhone|iPod)\b/.test(UA) && /WebKit/.test(UA) && | |
| !/Edge/.test(UA) && !window.MSStream | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Replaces a set number of spaces in text with non-breaking spaces to prevent widows | |
| // Example use in React: <div dangerouslySetInnerHTML={{ __html: preventWidows(text) }} /> | |
| export function preventWidows(text: string, spaces: number = 3): string { | |
| const regx: RegExp = /\s/g | |
| const spacesCount: number = (text.match(regx) || []).length | |
| const spacesTarget = spacesCount - spaces | |
| let i: number = 0 | |
| text = text.replace(regx, match => { | |
| i++ |
jpescada
/ load-3rd-party-scripts-after-scroll.ts
Last active
August 19, 2020 13:03
Load third-party JS scripts only after first scroll
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| window.addEventListener('scroll', () => | |
| setTimeout(() => { | |
| // Load Fullstory, Intercom, Segment, etc | |
| }, 1000), | |
| { once: true } | |
| ); |
jpescada
/ video-carousel-book.jsx
Last active
April 16, 2019 16:05
Memory efficient video carousel for mobile as a React component
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // This component was coded for an interactive book for mobile devices | |
| // (ie: for touch interactions) where each page was a 1080p video with the | |
| // dominant colour in the video set as it’s background colour. | |
| // All pages are part of a slider (Slick carousel). | |
| // Each video has a poster image with the first frame of the video as well | |
| // as another poster image with the last frame of the video. When the video | |
| // ends and / or the page is turned, the poster for the ended video is swapped | |
| // for the end frame version and the video sources are removed and the video | |
| // reloaded to force the the device to flush the video from memory. |
jpescada
/ dynamic-svg-react-component.jsx
Last active
November 22, 2018 13:14
React Component to generate an SVG with dynamic content (text, colour and image)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import React from 'react'; | |
| // NB: This is demo code just to explain the logic | |
| const DynamicSVG = (props) => { | |
| static defaultProps = { | |
| text: 'This is the default text', | |
| colour: '#FF0000', | |
| image: '/static/images/default.png', |
jpescada
/ get-time-left.php
Last active
November 22, 2018 12:50
Get time left between dates in days, hours and minutes with PHP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function getTimeLeft($startDate) | |
| { | |
| $now = new DateTime(); | |
| $then = new DateTime($startDate); | |
| $timeLeft = 0; | |
| // Only calculate time left if $then is still a future date | |
| if ($now < $then) { | |
| $difference = $now->diff($then); |
jpescada
/ verify-google-recaptcha.php
Last active
June 12, 2024 12:55
Verify Google ReCaptcha with PHP and cURL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Author @CreativForm (on GitHub) | |
| Source: https://gist.github.com/jonathanstark/dfb30bdfb522318fc819#gistcomment-2189252 | |
| */ | |
| function validate_recaptcha($response){ | |
| // Verifying the user's response (https://developers.google.com/recaptcha/docs/verify) | |
| $verifyURL = 'https://www.google.com/recaptcha/api/siteverify'; | |
| // Collect and build POST data | |
| $post_data = http_build_query( |
NewerOlder