Querying for items stored in UTC that were created on a Thursday in PST
2024-02-21
This came up as [a question](https://news.ycombinator.com/item?id=26443148) on Hacker News. How can you query a SQLite database for items that were...
139 words
|
1 minute
Prometheus Setup and Configuration
2024-02-21
Day 52 of 90 Days of DevOps - Prometheus Setup and Configuration. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.
506 words
|
3 minutes
Configuring GitHub Codespaces using devcontainers
2024-02-20
[GitHub Codespaces](https://github.com/features/codespaces) provides full development environments in your browser, and is free to use with anyone ...
647 words
|
3 minutes
Quickly testing code in a different Python version using pyenv
2024-02-20
I had [a bug](https://github.com/simonw/llm/issues/82#issuecomment-1629735729) that was only showing up in CI against Python 3.8.
204 words
|
1 minute
Monitoring Strategy and Metrics
2024-02-20
Day 51 of 90 Days of DevOps - Monitoring Strategy and Metrics. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.
528 words
|
3 minutes
Search across all loaded resources in Firefox
2024-02-19
You can search for a string in any resource loaded by a page (including across HTML, JavaScript and CSS) in the Debugger pane by hitting Command+Sh...
116 words
|
1 minute
Cloud Cost Optimization
2024-02-19
Day 50 of 90 Days of DevOps - Cloud Cost Optimization. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
510 words
|
3 minutes
Multi-Cloud Strategy and Management
2024-02-18
Day 49 of 90 Days of DevOps - Multi-Cloud Strategy and Management. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
374 words
|
2 minutes
Running Datasette on Hugging Face Spaces
2024-02-18
[Julien Chaumond](https://twitter.com/julien_c/status/1700142113713758438), this morning (replying to my tweet about [my Hugging Face TheBloke mode...
773 words
|
4 minutes
Assistance with release notes using GitHub Issues
2024-02-17
I like to write the release notes for my projects by hand, but sometimes it can be useful to have some help along the way.
1025 words
|
5 minutes
Google Cloud Platform Essentials
2024-02-17
Day 48 of 90 Days of DevOps - Google Cloud Platform Essentials. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
368 words
|
2 minutes
Escaping a SQL query to use with curl and Datasette
2024-02-16
I used this pattern to pass a SQL query to Datasette's CSV export via curl and output the results, stripping off the first row (the header row) usi...
193 words
|
1 minute
Enabling a user to execute a specific command as root without a password
2024-02-16
I wanted a script running as a non-root user to be able to restart a systemd service on my Ubuntu machine without needing a password.
131 words
|
1 minute
Azure DevOps and Pipelines
2024-02-16
Day 47 of 90 Days of DevOps - Azure DevOps and Pipelines. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
500 words
|
3 minutes
Writing JavaScript that responds to media queries
2024-02-16
I wanted to change the layout of [my blog](https://simonwillison.net/) on mobile screens such that the content from the "Elsewhere" right hand colu...
255 words
|
1 minute
Azure Fundamentals and Services
2024-02-15
Day 46 of 90 Days of DevOps - Azure Fundamentals and Services. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
355 words
|
2 minutes
Trick Apple Photos into letting you access your video files
2024-02-14
I had an 11GB movie in Apple Photos (sync'd from my iPhone) and I wanted to upload it to YouTube (actually via AirDrop to another laptop first).
227 words
|
1 minute
AWS Networking - VPC and Security Groups
2024-02-14
Day 45 of 90 Days of DevOps - AWS Networking - VPC and Security Groups. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
276 words
|
1 minute
Logging OpenAI API requests and responses using HTTPX
2024-02-14
My [LLM](https://llm.datasette.io/) tool has a feature where you can set a `LLM_OPENAI_SHOW_RESPONSES` environment variable to see full debug level...
1164 words
|
6 minutes
Running self-hosted QuickJS in a browser
2024-02-14
I want to try using [QuickJS](https://bellard.org/quickjs/) compiled to WebAssembly in a browser as a way of executing untrusted user-provided Java...
763 words
|
4 minutes
Testing Electron apps with Playwright and GitHub Actions
2024-02-14
Yesterday [I figured out (issue 133)](https://github.com/simonw/datasette-app/issues/133) how to use Playwright to run tests against my Electron ap...
560 words
|
3 minutes
impaste: pasting images to piped commands on macOS
2024-02-13
I wanted the ability to paste the image on my clipboard into a command in the macOS terminal.
207 words
|
1 minute
AWS Storage Solutions - S3 and EBS
2024-02-13
Day 44 of 90 Days of DevOps - AWS Storage Solutions - S3 and EBS. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.
475 words
|
2 minutes