Vinorcola

Gitlab upgrade script

This script is a Node.js script for upgrading a Gitlab instance run on Docker. (tested with Node.js v14, but should run OK with some lower version - if someone can advise in the comments)

If you followed the Gitlab documentation to launch a Gitlab instance (https://docs.gitlab.com/ce/install/docker.html) by using the following command:

sudo docker run --detach \
--hostname gitlab.example.com \
--publish 443:443 --publish 80:80 --publish 22:22 \

Install PostgreSQL pg_similarity extension on Ubuntu

1. Install the package

For PostgreSQL version 12.

sudo apt update
sudo apt install postgresql-12-similarity

Use Promises with PostgreSQL in Node

This pattern is a pattern I use for all my Node projects that need PostgreSQL. I work a lot with Promises, and ended-up designing this db.js file.

Put this file wherever you want in your app directory. Edit the connectionInfo string and voilà!

Call the execute method passing a callback function. Your callback function will be called with a function as first parameter which will allow you to execute SQL queries retourning Promises. Execute as much queries as you want, but don't forget to return a Promise that must be resolved once all your queries are done. After that, the database connection will be properly closed automatically.

	import { ReactNode, useEffect } from "react"
	import { useLocation } from "react-router-dom"

	interface Props {
	children: ReactNode
	}

	export default function AnchorScroller(props: Props) {
	let location = useLocation()


	'use strict'

	var React = require('react')



	var Child = React.createClass({

	render: function()


	'use strict'

	var config = {
	bufferMaxSize: 1,
	}



	var _pushPromise