Skip to content

Instantly share code, notes, and snippets.

View LdDl's full-sized avatar
🤡
love neural networks

Dimitrii Lopanov LdDl

🤡
love neural networks
View GitHub Profile
This file has been truncated, but you can view the full file.
{"type": "FeatureCollection", "features": [{"id": 7, "type": "Feature", "geometry": {"type": "MultiPolygon", "coordinates": [[[[37.874237, 55.820153], [37.874247, 55.820153], [37.874317, 55.820157], [37.874392, 55.820164], [37.874518, 55.820182], [37.875248, 55.820311], [37.875322, 55.820323], [37.87598, 55.820432], [37.876335, 55.820484], [37.876639, 55.820528], [37.877237, 55.820616], [37.878385, 55.820802], [37.878693, 55.820491], [37.879053, 55.820162], [37.879402, 55.819943], [37.879495, 55.819892], [37.879593, 55.819849], [37.879645, 55.819833], [37.88003, 55.819732], [37.880041, 55.81973], [37.880051, 55.819728], [37.880097, 55.81972], [37.880373, 55.819682], [37.880463, 55.819677], [37.880532, 55.819676], [37.880549, 55.819676], [37.880566, 55.819677], [37.880685, 55.819685], [37.881105, 55.819735], [37.881259, 55.81976], [37.881277, 55.819763], [37.881295, 55.819766], [37.882102, 55.819943], [37.882305, 55.819988], [37.882627, 55.820071], [37.882774, 55.820118], [37.882914, 55.820171], [37.883376, 55
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@LdDl
LdDl / pg_upgrade_postgis.md
Last active January 31, 2024 13:50
Postges pg_upgrade workaround

My case

Current environment

  • Ubuntu 18.04
  • PostgreSQL 13.1
  • PostGIS 3.x.x + obsolete SFCGAL(somehow it was installed with PostGIS)

Target

  • PostgreSQL 14.x
  • Postgis 3.x.x
@LdDl
LdDl / check_gitlab.sh
Created March 26, 2025 11:48
Bash script to scan Gitlab repositories to check if there are any branches, containers, packages or variables
#!/bin/bash
GITLAB_URL="https://gitlab.my.site.com"
GROUP_PATH="my-group" # Your group path
TOKEN="" # Token with read_api + read_registry + read_repository
PER_PAGE=100 # Max repos per page
OUTPUT_FILE="repo_analysis.csv"
echo "Generating repository analysis report..."