Lodewijk Evers jadwigo

If composer runs out of memory on digitalocean or another RAM limited cloud VM You need to create a swap drive

Create and activate the swapdrive as superuser And get back to the normal shell

sudo /bin/dd if=/dev/zero of=/var/swap.1 bs=1M count=8192
sudo chmod 600 /var/swap.1
sudo /sbin/mkswap /var/swap.1
sudo /sbin/swapon /var/swap.1

	-- # Convert block type CMS entries to Rich HTML Textarea entries - with JSON objects too #

	-- Because there will be large joins make this size ridiculous
	SET SESSION group_concat_max_len = 6000000;

	-- String variable replacement in mysql is handy
	SET @uploads_target_path = CAST('/storage/uploads/' AS CHAR CHARACTER SET utf8);

	-- this inserts rows with concatenated formatted blocks
	-- from source_db.page and source_db.block

	-- https://stackoverflow.com/a/22669310/1531963
	-- Assuming that the comma separated list is in table data.list,
	-- and it contains listing of codes from other table classification.code, you can do something like:

	SELECT
	d.id, d.list, c.code
	FROM
	classification c
	JOIN data d
	ON d.list REGEXP CONCAT('[[:<:]]', c.code, '[[:>:]]');

	-- The MIT License (MIT)
	-- Copyright (c) 2014 jose reis<[email protected]>

	-- Permission is hereby granted, free of charge, to any person obtaining a copy
	-- of this software and associated documentation files (the "Software"), to deal
	-- in the Software without restriction, including without limitation the rights
	-- to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
	-- copies of the Software, and to permit persons to whom the Software is
	-- furnished to do so, subject to the following conditions:
	-- The above copyright notice and this permission notice shall be included in all

	<?php
	/**
	* Lookup provincie ahv postcode:
	* https://nl.wikipedia.org/wiki/Postcodes_in_Nederland
	*
	* @param $postcode
	*
	* @return string
	*/
	function lookupProvincie($postcode, $location = false)

	#!/bin/bash

	# This script takes a directory with many files and moves all nnormal files
	# to a subdirectory with the year-month

	for i in *
	do
	if [ -f "$i" ]
	then
	filemonth=`stat --format=%y "$i" \| cut -c 1-7`

	<!doctype html>
	<html class="no-js" lang="{{ htmllang() }}">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="x-ua-compatible" content="ie=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>{%- if seo.title is defined -%}
	{{ seo.title }}
	{%- elseif record.title is defined -%}
	{{ record.title }} \| {{ config.get('general/sitename') }}

	{
	"autoload": {
	"psr-4": {
	"Bolt\\Composer\\EventListener\\": "../vendor/bolt/bolt/src/Composer/EventListener"
	}
	},
	"config": {
	"discard-changes": true,
	"preferred-install": "dist"
	},

	<?xml version='1.0' encoding='utf-8'?>
	<widget
	id="com.example.appname"
	xmlns="http://www.w3.org/ns/widgets"
	xmlns:cdv="http://cordova.apache.org/ns/1.0"
	xmlns:gap="http://phonegap.com/ns/1.0"
	versionCode="10203"
	version="1.2.3">

	<name>appname</name>