Daniel Kapitan dkapitan

## jortt_report-2026-01-20.html
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>jortt_report - Agent Session</title>
    <style>
        :root {
            --bg: #0d1117;
            --surface: #161b22;

## settings.json
{
    "workbench.colorTheme": "Monokai Pro (Filter Spectrum)",
    "python.defaultInterpreterPath": "python3",
    "explorer.confirmDragAndDrop": false,
    "explorer.confirmDelete": false,
    "positron.assistant.enable": true,
    "claudeCode.preferredLocation": "panel",
    "workbench.externalUriOpeners": {
        "http://*": "positron.viewer"
}

## justfile
show-project-size:
  uv pip list --format freeze | \
  awk -F = {'print $1'} | \
  xargs uv pip show | \
  grep -E 'Location:|Name:' | \
  cut -d ' ' -f 2 | \
  paste -d ' ' - - | \
  awk '{print $2 "/" tolower($1)}' | \
  xargs du -sh 2> /dev/null | \
  sort -hr

## get_binary.py
def get_binary(url):
    """Download binary file in memory without saving to disk."""
    from io import BytesIO
    import requests


    try:
        response = requests.get(url)

        # Raise an exception if the request was unsuccessful (e.g., 404 Not Found)

## install-pygraphviz.sh
python3 -m pip install \
                --config-settings="--global-option=build_ext" \
                --config-settings="--global-option=-I$(brew --prefix graphviz)/include/" \
                --config-settings="--global-option=-L$(brew --prefix graphviz)/lib/" \
                pygraphviz

## .zshrc
uv_poetry_install () {
    uv venv
    uv pip install --no-deps -r <(POETRY_WARNINGS_EXPORT=false poetry export --without-hashes --with dev -f requirements.txt)
    poetry install --only-root
}

## app.yaml
runtime: python
env: flex
instance_class: F2
runtime_config:
  operating_system: "ubuntu22"
  runtime_version: "3.12"

# name of app
service: some-name

## sql-workbench.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dkapitan
                / sql-workbench.ipynb
            
            
              Created
              June 25, 2024 14:34
            
              
                notebook with duckdb + jupysql + polars
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## query_pdok.py
import re
import requests
import urllib


PDOK = "https://api.pdok.nl/bzk/locatieserver/search/v3_1/free"


def query_pdok(query):
    query_params = {

## redact_patient.py
import ndjson


def redact(patient: dict) -> dict:
    for key in ["name", "telecom"]:
        patient.pop(key, None)
    return patient


with open("patient.ndjson") as f:
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>jortt_report - Agent Session</title>
	<style>
	:root {
	--bg: #0d1117;
	--surface: #161b22;
	{
	"workbench.colorTheme": "Monokai Pro (Filter Spectrum)",
	"python.defaultInterpreterPath": "python3",
	"explorer.confirmDragAndDrop": false,
	"explorer.confirmDelete": false,
	"positron.assistant.enable": true,
	"claudeCode.preferredLocation": "panel",
	"workbench.externalUriOpeners": {
	"http://*": "positron.viewer"
	}
	show-project-size:
	uv pip list --format freeze \| \
	awk -F = {'print $1'} \| \
	xargs uv pip show \| \
	grep -E 'Location:\|Name:' \| \
	cut -d ' ' -f 2 \| \
	paste -d ' ' - - \| \
	awk '{print $2 "/" tolower($1)}' \| \
	xargs du -sh 2> /dev/null \| \
	sort -hr
	def get_binary(url):
	"""Download binary file in memory without saving to disk."""
	from io import BytesIO
	import requests


	try:
	response = requests.get(url)

	# Raise an exception if the request was unsuccessful (e.g., 404 Not Found)
	python3 -m pip install \
	--config-settings="--global-option=build_ext" \
	--config-settings="--global-option=-I$(brew --prefix graphviz)/include/" \
	--config-settings="--global-option=-L$(brew --prefix graphviz)/lib/" \
	pygraphviz
	uv_poetry_install () {
	uv venv
	uv pip install --no-deps -r <(POETRY_WARNINGS_EXPORT=false poetry export --without-hashes --with dev -f requirements.txt)
	poetry install --only-root
	}
	runtime: python
	env: flex
	instance_class: F2
	runtime_config:
	operating_system: "ubuntu22"
	runtime_version: "3.12"

	# name of app
	service: some-name
	import re
	import requests
	import urllib


	PDOK = "https://api.pdok.nl/bzk/locatieserver/search/v3_1/free"


	def query_pdok(query):
	query_params = {
	import ndjson


	def redact(patient: dict) -> dict:
	for key in ["name", "telecom"]:
	patient.pop(key, None)
	return patient


	with open("patient.ndjson") as f: