Skip to content

Instantly share code, notes, and snippets.

Avatar

Taro Matsuzawa aka. btm smellman

View GitHub Profile
@smellman
smellman / .env
Created Jul 20, 2021
openmaptiles .env file
View .env
# This file defines default environment variables for all images
# Layers definition and meta data
TILESET_FILE=openmaptiles.yaml
# Use 3-part patch version to ignore patch updates, e.g. 5.0.0
TOOLS_VERSION=5.3
# Make sure these values are in sync with the ones in .env-postgres file
PGDATABASE=openmaptiles
View gist:04a134cd530fd225726b7c3679665b11
ffmpeg -thread_queue_size 512 -f alsa -i hw:2,0 -f v4l2 -s 1280x720 -i /dev/video1 -vcodec libx264 -pix_fmt yuv420p -preset ultrafast -g 20 -b:v 2000k -acodec aac -b:a 128k -threads 0 -f flv rtmp://a.rtmp.youtube.com/live2/xxxxxxxxxxx
@smellman
smellman / Dockerfile
Created Jul 1, 2021
pandoc/latex + eisvogel template
View Dockerfile
FROM pandoc/latex:2.14.0.3
ARG eisvogel_version=2.0.0
RUN tlmgr install luatexja
RUN tlmgr install haranoaji haranoaji-extra
RUN tlmgr install adjustbox babel-german background bidi collectbox csquotes everypage filehook footmisc footnotebackref framed fvextra letltxmacro ly1 mdframed mweights needspace pagecolor sourcecodepro sourcesanspro titling ucharcat ulem unicode-math upquote xecjk xurl zref || exit 1
RUN tlmgr install selnolig || exit 1
RUN mkdir -p /templates/eisvogel \
View test.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / Dockerfile
Created Dec 18, 2020
Py3dtiles dockerfile
View Dockerfile
FROM ubuntu:20.10
LABEL maintainer="Taro Matsuzawa (taro@georepublic.co.jp)"
WORKDIR /
RUN set -ex \
&& apt-get update \
&& apt-get install -y --no-install-recommends \
python3 \
python3-pip \
@smellman
smellman / Dockerfile
Created Dec 16, 2020
Potree 1.7 Dockerfile
View Dockerfile
FROM ubuntu:bionic
ENV DEBIAN_FRONTEND=noninteractive
RUN apt-get update && apt-get install -y --no-install-recommends g++-8 git build-essential cmake make ca-certificates \
&& rm -rf /var/lib/apt/lists/*
# gcc-8 is required for new c++17 headers used in Potree Converter
RUN update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-8 800 --slave /usr/bin/g++ g++ /usr/bin/g++-8
RUN mkdir /data
@smellman
smellman / omt_benchmark.txt
Last active Feb 6, 2021
OpenMapTiles Bench Mark
View omt_benchmark.txt
```
+ # pgtune + dw
+ command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.9 -c wal_buffers=16MB -c default_statistics_target=500 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=26214kB -c min_wal_size=4GB -c max_wal_size=16GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
+ # pgtune + oltp
+ # command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.9 -c wal_buffers=16MB -c default_statistics_target=100 -c random_page_cost=1.1 -c effective_io_concurrency=200 -c work_mem=52428kB -c min_wal_size=2GB -c max_wal_size=8GB -c max_worker_processes=8 -c max_parallel_workers_per_gather=4
+ # pgtune + web
+ # command: postgres -c max_connections=40 -c shared_buffers=8GB -c effective_cache_size=24GB -c maintenance_work_mem=2GB -c checkpoint_completion_target=0.7 -c wal_buff
@smellman
smellman / 0001-supports-proj-changes-update-mercator-projection.patch
Created Nov 6, 2020
0001-supports-proj-changes-update-mercator-projection.patch
View 0001-supports-proj-changes-update-mercator-projection.patch
From cb83398706df33b08242e66714608c66e7d6b8e4 Mon Sep 17 00:00:00 2001
From: Taro Matsuzawa <taro@georepublic.co.jp>
Date: Fri, 6 Nov 2020 19:58:53 +0900
Subject: [PATCH] supports proj changes: update mercator projection
---
regress/core/tickets.sql | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
View postgresql-tuning-docker.md

PostgreSQL tuning via https://pgtune.leopard.in.ua/

# DB Version: 9.6
# OS Type: linux
# DB Type: dw
# Total Memory (RAM): 32 GB
# CPUs num: 8
# Data Storage: ssd
@smellman
smellman / openmaptiles-benchmark.md
Last active Sep 23, 2020
OpenMapTiles benchmark
View openmaptiles-benchmark.md

Taro's vm on mac

spec

  • macbook pro 2018 + pararell desktop pro
  • 8 cpu
  • 16GB Memory
  • Ubuntu 20.04

results