https://peter-hoffmann.com

Peter HoffmannPeter HoffmannPeter Hoffmann Peter Hoffmann TIL Conferences Archive Garmin inReach Mini 2 Leaflet checkin map Posted on February 13, 2026 in python · leaflet · gpx · geo Scraping Checkin Messages from a Garmin Inreach Mini 2 and displaying them with a leaflet plugin on a map Read More Local macOS Dev Setup: dnsmasq + caddy-snake for python projects Posted on February 5, 2026 in python · til This guide is about setting up a clean development for python wsgi web services on MacOS with wildcard domains, caddy serving multiple Python WSGI services and automatic startup on boot. Read More Georg Bayerle - Der Alpen Appell Posted on September 30, 2025 in alpin · buch Georg Bayerle schildert in seinem Buch der Alpen Appell den Konflikt zwischen der immer weitergehenden Erschließung und dem Versuch den Naturraum Alpen zu bewahren. Read More Mistune 3 Wikilink Inline Parser Posted on September 20, 2025 in python Extending Mistune 3 to parse inline wikilinks. Read More BikeRouter and OnRouteMap Posted on September 19, 2025 in geo · gpx · bike Bikerouter.de and Onroutemap.de are great tools to plan your long-distance, multi-day bikepacking adventures. Read More Using SQLite with JSON Data Posted on October 13, 2024 in sql · sqlite Using SQLite to store, query and modify JSON data with full flexibility. Uson JSON columns works best, if you need to support a flexible datamodel and during prototyping. Read More Tenant Isolation in Snowflake for ML - Operational Patterns Posted on March 12, 2024 in architecture · snowflake · sql Hands-on patterns for operating Snowflake-backed ML platforms at scale. It covers tenant data duplication strategies, environment promotion workflows, ML experimentation with real customer data under strict controls, and operational trade-offs between cost, safety, and velocity. Read More Exploring Mountain Huts with SPARQL and Wikidata Posted on December 23, 2023 in python Utilize SPARQL and Wikidata to efficiently query and retrieve data on mountain huts based on specified latitude and longitude coordinates. Read More Tenant Isolation in Snowflake Posted on October 16, 2023 in architecture · snowflake · sql Multi-tenancy is an architectural approach in which a single software system or data platform serves multiple independent customers (tenants), while ensuring that each tenant’s data, workloads, and configurations remain logically or physically isolated according to defined boundaries. Snowflake offers different options to achive tenant isolation. Read More Blue Yonder at PyCon.DE 2023 Posted on April 25, 2023 in python · conference It's been now 10 years ago when Blue Yonder started the first sponsoring of a python conference at Europython Florence. Since then we have been either sponsoring and/or organizing at least one python event per year. Read More Using Docker multi-stage builds to compile turbodbc with PyArrow support on Debian 11 Posted on December 16, 2022 in python · til · docker Using a docker multistage to build turbodbc with pyarrow support Read More Beautiful Leaflet Markers with Folium and Font Awesome Posted on December 4, 2022 in python · pydata · visualization · til TIL how to use fontawesome markers with folium. Read More Scale-Aware Rating of Count Forecasts Posted on December 1, 2022 in pydata · python · meetup Forecasts crave a rating that reflects the forecast's quality in the context of what is possible in theory and what is reasonable to expect in practice. Read More Python Support in Snowflake Posted on November 16, 2022 in python · sql · snowflake · pydata Snowflake offers different ways to access and call python from within their compute infrastructure. This post will show how to access python in user defined functions, via stored procedures and in snowpark. Read More Convert the Himalayan Database to SQLite Posted on January 10, 2021 in python · sql · mountain · sqlite Conversion of the Himalayan database of the legendary Elizabeth Hawley from FoxPro to SQLite. Read More Azure Synapse SQL On-Demand OPENROWSET Common Table Expression with SQLAlchemy Posted on September 27, 2020 in python · sql · pydata · azure Using SQLAlchemy to create openrowset common table expressions for Azure Synapse SQL-on-Demand Read More DuckDB vs. Azure Synapse SQL on-demand with Parquet Posted on May 25, 2020 in python · parquet · pydata · pandas · azure Inspired by Uwe Korns post on DuckDB this post shows how to use Azure Synapse SQL-on-Demand to query parquet files with T-SQL on a serverless cloud infrastructure. Read More Using turbodbc to access Azure Synapse SQL-on-demand endpoints Posted on May 25, 2020 in python · sql · pydata · azure Azure Synapse SQL-on-Demand offers a web client, the desktop version Azure Data studio and odbc access with turbodbc to query parquet files in the Azure Data Lake. Read More Azure Data Explorer and Parquet Files in Azure Blob Storage Posted on February 1, 2020 in python · pydata · azure · parquet Last summer Microsoft has rebranded the Azure Kusto Query engine as Azure Data Explorer. While it does not support fully elastic scaling, it at least allows to scale up and out a cluster via an API or the Azure portal to adapt to different workloads. It also offers parquet support out of the box which made me spend some time to look into it. Read More Understanding Predicate Pushdown at the Row-Group Level in Parquet with PyArrow and Python Posted on January 19, 2020 in python · pydata · parquet · arrow · pandas Apache Parquet is a columnar file format to work with gigabytes of data. Reading and writing parquet files is efficiently exposed to python with pyarrow. Additional statistics allow clients to use predicate pushdown to only read subsets of data to reduce I/O. Organizing data by column allows for better compression, as data is more homogeneous. Better compression also reduces the bandwidth required to read the input. Read More Azure Data Lake Storage Gen2 with Python Posted on January 11, 2020 in python · pydata Microsoft has released a beta version of the python client azure-storage-file-datalake for the Azure Data Lake Storage Gen 2 service with support for hierarchical namespaces. Read More Archive © Peter Hoffmann - About - RSS Feedenen1772200235https://peter-hoffmann.com

ଆପଣଙ୍କର ସାଇଟ୍ ସଂପାଦନ କରନ୍ତୁ?

ତୁମେ କଣ କରୁଛ?