lukebussey

PostgreSQL & PL/pgSQL Stored Functions Cheatsheet

Boiler-plate stored function

CREATE OR REPLACE FUNCTION public.sp_user_ins_status(status smallint)
  RETURNS integer
  LANGUAGE plpgsql
AS $function$

lukebussey

To embed the contents of an SVG file into your site using NextJS with the new Rust-based compiler (Turbopack), perform the following steps:

1. Install @svg/webpack:

$ npm install --save-dev @svgr/webpack

2. Add to your webpack config in next.config.js with the following options. This will remove the width and height from the SVG but keep the viewBox for correct scaling.

lukebussey

import PropTypes from 'prop-types';
import { useState, useEffect, useContext, createContext } from 'react';
import { useRouter } from 'next/router';
import merge from 'deepmerge';
import usePrevious from 'hooks/usePrevious';

const useProvideSegment = () => {
  const [location, setLocation] = useState();
  const router = useRouter();

lukebussey

    var cookieVal = document.cookie,
        testVal = "mixpanel",
        localStorageKey = "mixpanel-cookie",
        canWriteCookie = false;

    // Test cookie
    document.cookie = testVal;
    canWriteCookies = document.cookie === testVal;

    // Restore cookie

lukebussey

const Sitemapper = require('sitemapper');

(async () => {
  const mapper = new Sitemapper();
  const sitemap = await mapper.fetch(`https://www.example.com/sitemap.xml`);
  console.log(sitemap);
})();

lukebussey

/* Mime Types Support */
add_filter('upload_mimes', 'custom_mime_types', 999999);
function custom_mime_types($mimes) {
  $mimes['otf'] = 'application/x-font-opentype';
  $mimes['woff'] = 'application/font-woff';
	$mimes['woff2'] = 'application/font-woff2';
	return $mimes;
}

/* Custom Font Types Support */

lukebussey

sub vcl_recv {
  if (req.http.host == "domain.com" && req.url.path == "/user") {
    error 601 "user";
  }
}

sub vcl_error {
  if (obj.status == 601) {
    set obj.http.Content-Type = "text/json";
    set obj.status = 200;

lukebussey

openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout server.key -out server.crt -reqexts SAN -extensions SAN \
    -config <(cat /System/Library/OpenSSL/openssl.cnf \
        <(printf '[SAN]\nsubjectAltName=DNS:*.local'))

lukebussey

npm list -g --depth=0

lukebussey

<script type="application/ld+json">
  {
    "@context": "http://schema.org",
    "@type": "Organization",
    "@id": "#organization",
    "name": "Outlyer",
    "url": "https://www.outlyer.com/",
    "sameAs": [
      "https://github.com/outlyerapp",
      "https://twitter.com/outlyer",