Skip to content

Instantly share code, notes, and snippets.

Avatar

Taro Matsuzawa aka. btm smellman

View GitHub Profile
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 21, 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

View eduke32_error_position.diff
diff --git a/source/duke3d/src/common.cpp b/source/duke3d/src/common.cpp
index d269f526f..41ef06dab 100644
--- a/source/duke3d/src/common.cpp
+++ b/source/duke3d/src/common.cpp
@@ -255,12 +255,13 @@ void G_ExtPreInit(int32_t argc,char const * const * argv)
void G_ExtInit(void)
{
+/*
#ifdef EDUKE32_OSX
@smellman
smellman / index.html
Created Aug 23, 2020
Kakegawa Castle on Cesium
View index.html
<!DOCTYPE html>
<html>
 <head>
  <meta charset="UTF-8">
  <title>Kakegawa Castle on Cesium</title>
  <script src="https://cesium.com/downloads/cesiumjs/releases/1.72/Build/Cesium/Cesium.js"></script>
 <link href="https://cesium.com/downloads/cesiumjs/releases/1.72/Build/Cesium/Widgets/widgets.css" rel="stylesheet">
<style>
#cesiumContainer {
View entwine_memo.txt
# shizuoka data convert to cesium data
docker run -it -v $(pwd):/entwine connormanning/entwine build -i /entwine/kakegawa.las -o /entwine/entwine -r EPSG:2444 EPSG:4978
ept tile -i entwine -o cesium/
cd cesium/kakegawa
npx serve -C
View openmaptiles-log-20200708.txt
====> : Start SQL postprocessing: ./build/sql/* -> PostgreSQL
: Source code: https://github.com/openmaptiles/openmaptiles-tools/blob/master/bin/import-sql
Starting postgres docker compose target using default image (no recreate if exists)
Starting openmaptiles_postgres_1 ... done
docker-compose run --rm -u 1000:1000 openmaptiles-tools sh -c 'pgwait && import-sql' | \
awk -v s=": WARNING:" '$0~s{print; print "\n*** WARNING detected, aborting"; exit(1)} 1'
Importing /usr/src/app/sql/CleanNumeric.sql (md5 d8300fc8b346b6288993391fb4f3c31d - 18 lines) into Postgres...
Timing is on.
CREATE FUNCTION
Time: 11.222 ms
@smellman
smellman / Dockerfile
Created Jun 17, 2020
Sphinx + plantuml
View Dockerfile
FROM sphinxdoc/sphinx-latexpdf
WORKDIR /docs
RUN mkdir -p /usr/share/man/man1
RUN apt-get update \
&& apt-get install -y \
default-jre \
&& apt-get autoremove \
View my-postgres.conf
# DB Version: 12
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 16 GB
# CPUs num: 12
# Connections num: 100
# Data Storage: ssd
max_connections = 100
shared_buffers = 4GB
View shinjuku-station-area.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View tokyo_station_area.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
You can’t perform that action at this time.