Skip to content

Instantly share code, notes, and snippets.

View gplv2's full-sized avatar
😁

Glenn Plas gplv2

😁
View GitHub Profile
@gplv2
gplv2 / csv2DaimlerGPX.py
Created July 16, 2018 10:34 — forked from pperle/csv2DaimlerGPX.py
convert CSV to DaimlerGPX (for SCDB)
import csv
import glob
import os
# gpx layout from https://www.gps-data-team.com/convert/
gpx_header = '<?xml version="1.0" encoding="ISO-8859-2" standalone="no" ?><gpx:gpx creator="csv2DaimlerGPX" version="1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gpx="http://www.topografix.com/GPX/1/1" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd" xmlns:gpxd="http://www.daimler.com/DaimlerGPXExtensions/V2.4">'
gpx_entry = '<gpx:wpt lat="{lat}" lon="{lon}"><gpx:name>{name}</gpx:name><gpx:extensions><gpxd:WptExtension><gpxd:WptIconId IconId="16"></gpxd:WptIconId><gpxd:POICategory Cat="Speed Cameras"></gpxd:POICategory><gpxd:Activity Active="true" Level="warning" Unit="second" Value="15"></gpxd:Activity><gpxd:Presentation ShowOnMap="true"></gpxd:Presentation><gpxd:Address ISO="" Country="" State="" City="" CityCenter="" Street="" Street2="" HouseNo="" ZIP=""></gpxd:Address><gpxd:Phone Default=""></gpxd:Phone></gpxd:WptExtension></gpx:extensions></gpx:wp
@gplv2
gplv2 / read-access.sql
Created October 3, 2018 12:38 — forked from oinopion/read-access.sql
How to create read only user in PostgreSQL
-- Create a group
CREATE ROLE readaccess;
-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;
-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;
@gplv2
gplv2 / psql_useful_stat_queries.sql
Last active December 4, 2018 13:26 — forked from anvk/psql_useful_stat_queries.sql
List of some useful Stat Queries for PSQL
------------
-- Locks --
------------
SELECT
blocked_locks.pid AS blocked_pid,
blocked_activity.usename AS blocked_user,
blocking_locks.pid AS blocking_pid,
blocking_activity.usename AS blocking_user,
blocked_activity.query AS blocked_statement,
blocking_activity.query AS current_statement_in_blocking_process
@gplv2
gplv2 / ErrorHandler.js
Created January 15, 2019 16:24 — forked from deanrather/ErrorHandler.js
NodeJS Error Handler
process.on
(
'uncaughtException',
function (err)
{
var stack = err.stack;
var timeout = 1;
// print note to logger
logger.log("SERVER CRASHED!");
@gplv2
gplv2 / AlfrescoMysql2Postgresql.txt
Created October 14, 2020 08:42 — forked from loftux/AlfrescoMysql2Postgresql.txt
Alfresco Mysql to Postgresql migration. This is a simple outline on how to migrate Alfresco from mysql to postgresql.
Prerequisite
One instance of Alfresco on mysql, one postgresl of exactly the same version (schema version).
Step 1. Dump database
mysqldump --port 3306 -u alfresco --password=alfloftux -h 127.0.0.1 --databases alfresco --skip-comments --skip-extended-insert --no-create-db --hex-blob --default-character-set=utf8 --skip-triggers --compact --no-create-info --skip-quote-names > mydump.sql
Step 2. Dump local Postgres schema
You can install a clean version of Alfresco to use as for schema dump
(need to insert command for dump here)
# This is the car code for the remote controlled Hot Rod
# (c) Anton's Mindstorms & Ste7an
# Full tutorial here:
# https://antonsmindstorms.com/2021/06/19/how-to-remote-control-lego-spike-prime-and-robot-inventor-with-python/
# Building instructions here:
# https://antonsmindstorms.com/product/remote-controlled-hot-rod-with-51515/
# Use with the the remote control script here:
@gplv2
gplv2 / upgrade-postgresql-service-ubuntu.md
Created July 3, 2023 22:17 — forked from ShvaykaD/upgrade-postgresql-service-ubuntu.md
Upgrading PostgreSQL service from 9.x or 10.x to 11 version on Ubuntu server

TL;DR

Create a backup:

sudo -Hiu postgres pg_dumpall > mybackup.sql

Install Postgres 11, and then: