Skip to content

Instantly share code, notes, and snippets.

@ontologiae
ontologiae / pg_graph
Created June 8, 2023 22:50 — forked from akorotkov/pg_graph
Draw psql output as iTerm2 v3 inline graph using matplotlib
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# Draw psql output as iTerm2 v3 inline graph using matplotlib
# Author: Alexander Korotkov <a.korotkov@postgrespro.ru>
import sys
import re
import warnings
import matplotlib
matplotlib.use("Agg")
This file has been truncated, but you can view the full file.
Initialized native services in: /root/.gradle/native
Removing 0 daemon stop events from registry
Starting a Gradle Daemon (subsequent builds will be faster)
Starting process 'Gradle build daemon'. Working directory: /root/.gradle/daemon/4.10.2 Command: /usr/local/openjdk-8/bin/java -XX:MaxPermSize=4g -Xmx6144M -Dfile.encoding=UTF-8 -Duser.country -Duser.language=en -Duser.variant -cp /root/.gradle/wrapper/dists/gradle-4.10.2-all/9fahxiiecdb76a5g3aw9oi8rv/gradle-4.10.2/lib/gradle-launcher-4.10.2.jar org.gradle.launcher.daemon.bootstrap.GradleDaemon 4.10.2
Successfully started process 'Gradle build daemon'
An attempt to start the daemon took 2.389 secs.
The client will now receive all logging from the daemon (pid: 1440). The daemon log file: /root/.gradle/daemon/4.10.2/daemon-1440.out.log
Starting build in new daemon [memory: 6.2 GB]
Using 1 worker leases.
Starting Build
#Docker for wireapp-android compiling
FROM openjdk:8 as base
RUN apt-get clean && \
rm -rf /var/lib/apt/lists/* && \
apt-get update && \
apt-get install -yq libc6 libstdc++6 zlib1g libncurses5 build-essential libssl-dev ruby ruby-dev wget --no-install-recommends docker.io vim unzip apt-utils maven sudo file && \
apt-get clean
drop table if exists tmpGeoAdresses;
create table tmpGeoAdresses(id text,nom_voie text,id_fantoir text,
numero text, rep text,code_insee text,code_post text,
alias text,nom_ld text,x float,y float,commune text,fant_voie text,
fant_ld text,lat numeric,lon numeric);
create table bureauxAdresse(bureau text, adresse text, cp text, ville text);
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_01-csv.bz2 && bunzip2 BAN_odbl_01-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_01-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_02-csv.bz2 && bunzip2 BAN_odbl_02-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_02-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_03-csv.bz2 && bunzip2 BAN_odbl_03-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_03-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_04-csv.bz2 && bunzip2 BAN_odbl_04-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_04-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_05-csv.bz2 && bunzip2 BAN_odbl_05-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_05-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI
curl -O http://bano.openstreetmap.
/*
Exemple de réutilisation opendata
_ _ _ ___ ___
/_\ | \| | __| _ \
/ _ \| .` | _|| /
/_/ \_\_|\_|_| |_|_\
Description : installations radioélectriques de plus de 5 watts, hormis celles de l'Aviation Civile et des ministères de la Défense et de l'Intérieur.
Les données présentées proviennent d'une base de données de l'ANFR alimentée par tous les exploitants d'installations radioélectriques,
publics ou privés, dans le cadre de la procédure administrative prévue par l'article L.43 du code des postes et communications électroniques.
create table threePointsData( tid serial primary key, p1 geometry(Point,4326), p2 geometry(Point,4326), p3 geometry(Point,4326),n1 text, n2 text, n3 text, k1 text, v1 text, k2 text, v2 text, k3 text, v3 text,
ang double precision, distp1p2 double precision, distp2p3 double precision, distp1p3 double precision, bearing double precision);
insert into threePointsData(p1,p2,p3, n1,n2, n3, k1, v1, k2, v2, k3, v3, ang, distp1p2, distp2p3, distp1p3, bearing)
SELECT p1.point, p2.point, p3.point, p1.nom, p2.nom, p3.nom, p1.tagk, p1.tagv, p2.tagk, p2.tagv, p3.tagk, p3.tagv,
abs
(
degrees(
ST_Azimuth( p3.point , p2.point) -- Pc, Pb
-
var tab = ["Aï-Khanoum,Afghanistan",
"Aq Köprük,Afghanistan",
"Begrâm,Afghanistan",
"Bouddhas de Bâmiyân,Afghanistan",
"Bâmiyân,Afghanistan",
"Complexe archéologique bactro-margien,Afghanistan",
"Minaret et vestiges archéologiques de Djam,Afghanistan",
"Hadda,Afghanistan",
"Haji Piyada,Afghanistan",
"Mes Aynak,Afghanistan",
@ontologiae
ontologiae / gen_expr.ml
Last active September 14, 2016 14:50 — forked from c-cube/gen_expr.ml
generate all possible expressions from a list of basic values
open Sequence.Infix
type op =
| Add
| Mult
| Div
| Minus
| Int of int
let pp_op out = function
type opc = M | P ;;
type opnc = D | S;;
type vals = A | B | C;;
open Sequence.Infix;;
let combs k l =
let n = List.length l in