Compiling and running sqlite3-rsync
Today I heard about the [sqlite3-rsync](https://sqlite.org/draft/rsync.html) command, currently available in a branch in the SQLite code repository...
426 words
|
2 minutes
Docker Fundamentals and Containers
Day 31 of 90 Days of DevOps - Docker Fundamentals and Containers. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.
354 words
|
2 minutes
Logging users out of Auth0
If you [implement Auth0](https://til.simonwillison.net/auth0/oauth-with-auth0) for login, you may be tempted to skip implementing logout. I started...
290 words
|
1 minute
GitOps and Declarative Infrastructure
Day 30 of 90 Days of DevOps - GitOps and Declarative Infrastructure. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
215 words
|
1 minute
Using lsof on macOS
`lsof` stands for "list open files". Here are some very basic usage notes for the version that ships with macOS.
390 words
|
2 minutes
struct endianness in Python
TIL the Python standard library [struct](https://docs.python.org/3/library/struct.html) module defaults to interpreting binary strings using the en...
307 words
|
2 minutes
IaC Testing and Validation
Day 29 of 90 Days of DevOps - IaC Testing and Validation. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
417 words
|
2 minutes
Using psutil to investigate "Too many open files"
I was getting this intermittent error running my Datasette test suite:
110 words
|
1 minute
Configuration Management at Scale
Day 28 of 90 Days of DevOps - Configuration Management at Scale. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
359 words
|
2 minutes
Upgrade Postgres.app on macOS
I've been using [Postgres.app](https://postgresapp.com/) to run PostgreSQL on my Mac for years. I like that it's easy to install, gives me a task t...
245 words
|
1 minute
Adding project links to PyPI
I spotted a neat looking project links section on https://pypi.org/project/ExifReader/
124 words
|
1 minute
Ansible Vault and Security
Day 27 of 90 Days of DevOps - Ansible Vault and Security. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
1340 words
|
7 minutes
Browse files (including SQLite databases) on your iPhone with ifuse
I spotted an intriguing note in the release notes for [osxphotos 0.51.7](https://github.com/RhetTbull/osxphotos/releases/tag/v0.51.7):
353 words
|
2 minutes
Styling an HTML dialog modal to take the full height of the viewport
I've been experimenting with the HTML [dialog element](https://developer.mozilla.org/en-US/docs/Web/HTML/Element/dialog) recently, for example in m...
1147 words
|
6 minutes
Writing Playwright tests for a Datasette Plugin
I really like [Playwright](https://playwright.dev/) for writing automated tests for web applications using a headless browser. It's pretty easy to ...
904 words
|
5 minutes
Making HTTP calls using IPv6
Tiny TIL today: I learned how to make an HTTP call to an IPv6 address. The trick is to enclose the address in the URL in square braces:
67 words
|
1 minute
Compressing an animated GIF with gifsicle or ImageMagick mogrify
Tip via Mark Norman Francis [on Twitter](https://twitter.com/cackhanded/status/1423526489623044098):
298 words
|
1 minute
Ansible Roles and Galaxy
Day 26 of 90 Days of DevOps - Ansible Roles and Galaxy. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
306 words
|
2 minutes
Adding a Datasette ASGI app to Django
[Datasette](https://datasette.io/) is implemented as an ASGI application.
386 words
|
2 minutes
Updating stable docs in ReadTheDocs without pushing a release
I use [ReadTheDocs](https://readthedocs.org/) for several of my projects. It's fantastic: among other things, it makes it easy to publish the docum...
2107 words
|
11 minutes
Ansible Introduction and Playbooks
Day 25 of 90 Days of DevOps - Ansible Introduction and Playbooks. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
643 words
|
3 minutes
Calculating the size of a SQLite database file using SQL
I learned this trick today while [browsing the code](https://github.com/tersesystems/blacklite/blob/main/blacklite-core/src/main/resources/com/ters...
397 words
|
2 minutes
Terraform Modules and Best Practices
Day 24 of 90 Days of DevOps - Terraform Modules and Best Practices. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
388 words
|
2 minutes
Terraform Resources and State Management
Day 23 of 90 Days of DevOps - Terraform Resources and State Management. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.
519 words
|
3 minutes