CodeWitchBella

This was quiet an ordeal, but a combination of preexisting tools and a few lines of custom scripting made it possible.

I really benefitted from having a script to create whole database from scratch, heavily recommended. That part is inspired by: https://mgdm.net/weblog/postgresql-in-a-nix-shell/

What you need: postgres server, psql, pg_dump (all of those come standard with postgres installation) and pgloader. The postgresql starting script is written for nodejs but you could easily replace it...

The basic process is as follows

1. load the data from sqlite to postgres as is
2. fix any incompatibilities that'd break step 5

CodeWitchBella

// if in browser, just use https://developer.mozilla.org/en-US/docs/Web/API/createImageBitmap
// you probably have to read the pixel data at some point anyway...


function parseImageMeta(image: Uint8Array) {
  // https://en.wikipedia.org/wiki/JPEG_File_Interchange_Format
  if (jfif.every((value, index) => value < 0 || image[index] === value)) {
    const view = new DataView(image.buffer)
    let offset = 2
    while (true) {

CodeWitchBella

const fs = require('fs')
const path = require('path')

let files = 0
let lines = 0
function rd(dir) {
  for (const dirent of fs.readdirSync(dir, { withFileTypes: true })) {
    const fname = path.join(dir, dirent.name)
    if (dirent.isDirectory()) {
      rd(fname)

CodeWitchBella

// files was created by running
// grep -R createFactory modules > files
const fs = require('fs')

const files = Array.from(
  new Set(
    fs
      .readFileSync('files', 'utf-8')
      .trim()
      .split('\n')

CodeWitchBella

/**
 * Copyright 2015-present, Facebook, Inc.
 *
 * This source code is licensed under the MIT license found in the
 * LICENSE file in the root directory of this source tree.
 *
 */

'use strict';

CodeWitchBella

/**
 * @return {string}
 */
export function jsonHtml(json) {
  let indentSize = 0
  function indent() {
    return `<span style="font-size: 0px; position: absolute;">${' '.repeat(
      indentSize,
    )}</span>`
  }

CodeWitchBella

UPDATE: capture groups are supported in firefox since July 2020 (Firefox 78)

Firefox currently does not support capture groups https://bugzilla.mozilla.org/show_bug.cgi?id=1367105

But the non-capture group version is still better than https://bundlephobia.com/result?p=url-pattern@1.0.3

Example inputs and outputs:

matchPath('/hello/:world', '/hello/123') // { world: '123' }