blakeNaccarato

Python project setup on MacOS

Here are two ways to set up a Mac for Python projects, assuming VSCode is already installed. The "new way" is much easier, but you may not have access to uv for some reason, so the "old way" is also shown.

The new way

Install uv.

curl -LsSf https://astral.sh/uv/install.sh | sh

blakeNaccarato

The Data Wrangler VSCode extension column summaries can show a histogram of the distribution of data in a column, but this summary is not particularly useful for time series data like sensor signals.

• If not installed, install the Data Wrangler VSCode extension
• If sparklines is not installed in the environment to be used by Data Wrangler, use e.g. uv to add the sparklines package to the project's dev dependency group

uv add --dev sparklines

• Open a data file, e.g. a CSV in VSCode and click the "Open in Data Wrangler" button in the tab ribbon

blakeNaccarato

Change the sheets 'Regularly' with SQLModel and XLWings

This Gist features two-way interactions between an Excel spreadsheet and a SQLite database exported from the Regularly Android app (APK available from other sources), enabling synchronization and updating of chores in the app. This writeup goes in a few different directions, so feel free to poke around:

• The usage guide is brief, but links to more details for all skill levels.
• Jump into changing the sheets for a tour of the kind of end-user code that carefully-prepared SQLModel models facilitate.
• See behind the scenes in the database model deep dive, powered by SQLModel, with special handling of quirks and gotchas.
• See the Excel and CSV data models for data model philosophy, and a few cool features:
  • A `Datac

blakeNaccarato

VSCode Data Wrangler setup

• Install Data Wrangler VSCode extension
• Install uv

powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"

• Create a folder e.g. hello_world

blakeNaccarato

Windows Sunshine/Moonlight monitor config

Scripts and guide to automatic monitor configuration when streaming with Sunshine/Moonlight on Windows.

• Click "Download ZIP" in the top-right corner of this Gist, and extract scripts to e.g. C:/ (or a directory of your choosing)
• Download MultiMonitorTool
• Place scripts and MultiMonitorTool.exe in a directory next to your scripts, or add the tool to your system $PATH
• Modify your Sunshine "Do command" and "Undo command"

blakeNaccarato

My contributions in selected PRs, issues, and discussions

Selected contributions:

• microsoft/python-type-stubs: Incorrect return type on matplotlib.pyplot.subplot_mosaic
• iterative/dvc: plots: support svg
• w4po/ExplorerTabUtility: Version 2.0 detected as trojan by windows defender
• w4po/ExplorerTabUtility: Thanks for the great tool, loving v2! However, Windows quarantines it as a "trojan", code signing may help
• [microsoft/pylance-release: Feature request: Implement GitHub Action to set up and run pyright exactly as Pylance would do in VSCode](#microsoftpylance-release-feature-request-implement-github-action-to-set-up-and-run-pyright-exactly-as-pylance-would-do-in-

blakeNaccarato

Omnivore acquisition (2024-10-29T06-47-27)

• https://www.reddit.com/r/ObsidianMD/comments/puhl8v/sharing_articles_to_obsidian/
• https://www.reddit.com/r/selfhosted/comments/1geymmu/omnivoreapp_is_joining_elevenlabs_users_have/ludn0cw/
• Not easily forkable: omnivore-app/omnivore#25
• Readwise and instapaper may be pricey comparables? Wallabag with PikaPods?
• A sarcastic post about Omnivore's acquisition @[email protected] 🔗 https://mastodon.social/users/hynek/statuses/113389308364035896 Omnivore’s journey has just become incredible

blakeNaccarato

blakeNaccarato

Isolated script for syncing .env with e.g. a tool.my_tool.env table in pyproject.toml.

Download env.py to your project directory containing a pyproject.toml with a table named tool.dev.env and use uv run this tool in an isolated environment.

uv run env.py

Or you can invoke the script directly from a pinned commit revision of this Gist on Windows,

blakeNaccarato

"""Get fits and errors."""

from functools import partial
from warnings import catch_warnings

from numpy import array, diagonal, full, inf, isinf, linspace, nan, sqrt, where
from scipy.optimize import OptimizeWarning, curve_fit
from scipy.stats import t

# Docs: https://docs.scipy.org/doc/scipy/reference/generated/scipy.optimize.curve_fit.html