#alpin #buch

Peter Hoffmann Peter Hoffmann

Georg Bayerle schildert in seinem Buch der Alpen Apell den Konflikt zwischen der immer weitergehenden Erschließung und dem Versuch den Naturraum Alpen zu bewahren. Read More


#python

Peter Hoffmann Peter Hoffmann

Extending Mistune 3 to parse inline wikilinks. Read More


#geo #gpx #bike

Peter Hoffmann Peter Hoffmann

Bikerouter.de and Onroutemap.de are great tools to plan your long-distance, multi-day bikepacking adventures. Read More


#python

Peter Hoffmann Peter Hoffmann

Utilize SPARQL and Wikidata to efficiently query and retrieve data on mountain huts based on specified latitude and longitude coordinates. Read More


#python #conference

Peter Hoffmann Peter Hoffmann

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




#pydata #python #meetup

Peter Hoffmann Peter Hoffmann

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 #sql #snowflake #pydata

Peter Hoffmann Peter Hoffmann

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


#python #sql #mountain

Peter Hoffmann Peter Hoffmann

Conversion of the Himalayan database of the legendary Elizabeth Hawley from FoxPro to SQLite. Read More


#python #sql #pydata #azure

Peter Hoffmann Peter Hoffmann

Using SQLAlchemy to create openrowset common table expressions for Azure Synapse SQL-on-Demand Read More


#python #parquet #pydata #pandas #azure

Peter Hoffmann Peter Hoffmann

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


#python #sql #pydata #azure

Peter Hoffmann Peter Hoffmann

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


#python #pydata #azure #parquet

Peter Hoffmann Peter Hoffmann

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


#python #pydata #parquet #arrow #pandas

Peter Hoffmann Peter Hoffmann

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


#python #pydata

Peter Hoffmann Peter Hoffmann

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


#python #meetup #conference

Peter Hoffmann Peter Hoffmann

Python Meetup with two talks about python usage in a data science environment and the different stages of a python package in this environment. Read More


#rust #meetup #conference

Peter Hoffmann Peter Hoffmann

Rust Meetup in the new Blue Yonder office in Hamburg Read More


#python #talk

Peter Hoffmann Peter Hoffmann

JDA ICON 2019 was all about technology, APIs, AI (Artificial Intelligence) and ML (Machine Learning). Read More


#exasol #azure #pydata #talk

Peter Hoffmann Peter Hoffmann

Exasol on Microsoft Azure – automatic deployment in less than 30 minutes Read More


#python #conference

Peter Hoffmann Peter Hoffmann

PyCon.DE 2018 is over. Second time in a row we organized it in ZKM Karlsruhe. Next year PyCon.DE will move to Berlin. Read More