Skip to content

Instantly share code, notes, and snippets.

View smellman's full-sized avatar

Taro Matsuzawa aka. btm smellman

117 followers · 9 following
View GitHub Profile
@smellman
smellman / .env
Created July 20, 2021 12:07
openmaptiles .env file
# 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
@smellman
smellman / gist:04a134cd530fd225726b7c3679665b11
Created July 4, 2021 05:56
ffmpeg + youtube
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 July 1, 2021 23:53
pandoc/latex + eisvogel template
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 \
@smellman
smellman / test.geojson
Last active March 27, 2021 05:59
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / omt_benchmark.txt
Last active February 6, 2021 11:16
OpenMapTiles Bench Mark
```
+ # 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 / Dockerfile
Created December 18, 2020 07:27
Py3dtiles 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 / index.html
Created July 13, 2016 13:37
leaflet + template tag
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>leaflet + template tag</title>
<meta name="viewport" content="initial-scale=1.0, maximum-scale=1.0" />
<link rel="stylesheet" href="https://npmcdn.com/leaflet@1.0.0-rc.1/dist/leaflet.css" />
<script src="https://npmcdn.com/leaflet@1.0.0-rc.1/dist/leaflet.js"></script>
<script type="riot/tag" src="my-popup.tag"></script>
@smellman
smellman / 0001-supports-proj-changes-update-mercator-projection.patch
Created November 6, 2020 11:01
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
@smellman
smellman / openmaptiles-benchmark.md
Last active September 23, 2020 10:44
OpenMapTiles benchmark

Taro's vm on mac

spec

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

results

@smellman
smellman / postgresql-tuning-docker.md
Created September 10, 2020 00:43

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