sqlite_utils Python library - sqlite-utils sqlite-utils.datasette.io sqlite-utils is primarily a cli tool for sqlite operations such as enabling full text search, and executing searches, but it also has a nice python api that is exposed and pretty straightforward to use. This returns a generator object that you can ite…
Archive
All published posts
2605 posts
latest post 2026-10-24
Publishing rhythm
Aug 14 – Aug 20, 20233 years ago
Note
Note
External Link levelup.gitconnected.com Use prettier to format all files in a directory. By default prettier does not write, it just echos out the format that it would do. Give it the and it will write the changes to the files. I just used this on my thoughts repo.
Note
GitHub - simonw/datasette-render-markdown: Datasette plugin for rendering Markdown Datasette plugin for rendering Markdown. Contribute to simonw/datasette-render-markdown development by creating an account on GitHub. GitHub · github.com datasette really does everything doesn’t it!
Note
GitHub - simonw/shot-scraper: A CLI utility for taking screenshots of websites, recording video demos and scraping sites using JavaScript A CLI utility for taking screenshots of websites, recording video demos and scraping sites using JavaScript - simonw/shot-scraper GitHub · github.com Daaaang, this is such an elegant…
Note
shot-scraper: automated screenshots for documentation, built on Playwright shot-scraper is a new tool that I’ve built to help automate the process of keeping screenshots up-to-date in my documentation. It also doubles as a scraping tool—hence the name—which I … Simon Willison’s Weblog · simonwillison.net An interesting…
Aug 7 – Aug 13, 20233 years ago
Featured this weekLink
I’m really excited about SHARK-Studio, an amazing project by nod-ai. It’s worth exploring! SHARK Studio – Web UI for SHARK+IREE High Performance Machine Learning Distribution
Link
The work on AMD-SHARK-Studio by nod-ai. AMD-SHARK Studio – Web UI for SHARK+IREE High Performance Machine Learning Distribution
Note
I’d never given this much thought, but there are so many guides that are complete guides for beginner workflows, but once you get beyond beginner there is likely no manual for what you are trying to do in programming. There is no guide that will tell you the best way to get your companies salesforce data, alongside of…
Note
HTML Over The Wire | Hotwire Hotwire is an alternative approach to building modern web applications without using much JavaScript by sending HTML instead of JSON over the wire. hotwired.dev An alternative approach to building modern web withhout heavy js and json, but instead html over the wire, keeping the logic in th…
Note
How do I post form data using Curl? To post form data to the server using Curl, you can use one of two command line options: -F (--form) or -d (--data). ReqBin · reqbin.com How to pass form data with curl, give it the d.
Note
Vue.js Vue.js - The Progressive JavaScript Framework vuejs.org A super handy reference to the vuejs lifecycle.
Note
How to Use HTML to Open a Link in a New Tab Tabs are great, aren't they? They allow the multitasker in all of us to juggle a bunch of online tasks at the same time. Tabs are so common now that, when you click on a link, it's likely it'll ope... freeCodeCamp.org · freecodecamp.org Most of the time when creating links in…
Note
Create Models with a Many-to-Many Link - SQLModel SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness. sqlmodel.tiangolo.com Creating many to many relationships with sqlmodel requires a LinkTable Model. The link model will keep track of the linked id’s between each of the models.
Note
External Link stackoverflow.com I went down the route of leveraging the extention in htmx, but later realized that this completely breaks browsers/users who do not wish to use javascript. While most of the web would feel quite broken with javascript disabled, I don’t want to contribute to that without good reason. Taki…
Note
GitHub - chebykinn/sedmario: NES Super Mario Bros level 1 written in pure sed! NES Super Mario Bros level 1 written in pure sed! Contribute to chebykinn/sedmario development by creating an account on GitHub. GitHub · github.com 🤯 NES Super Mario Bros level 1 written in pure sed, this is madmess.
Jul 31 – Aug 6, 20233 years ago
Note
External Link github.com neovim stopped formatting on save for me awhile ago and I have just been dealing with it. looks like there may have been an api change, idk. I had to make this update.4
Note
Debugging | pywebview Build GUI for your Python program with JavaScript, HTML, and CSS pywebview.flowrl.com How to enable debug mode in pywebview.
Note
`ValueError: Constraint must have a name` in alembic 1.10.0 · Issue #1195 · sqlalchemy/alembic Describe the bug ValueError: Constraint must have a name in alembic 1.10.0. Expected behavior Migration succeeds. To Reproduce Please try to provide a Minimal, Complete, and Verifiable example, wit... GitHub · github.com Afte…
Note
![[None]] Since using alembic I have been just running out a new revision checking its content and deleting it if its empty, today I learned there is an command to check for operations that need to be created.
Note
API — Jinja Documentation (3.1.x) jinja.palletsprojects.com 🤯 jinja comes with a loader to templates! Defihnitely need to look at this for, as is till one of the biggest hot spots.
Note
API — Jinja Documentation (3.1.x) jinja.palletsprojects.com I’ve definitely been missing out on setting up a proper jinja loader on a few projects, I need to lean on this a bit more. The path can be relative or absolute. Relative paths are relative to the current working directory.
Note
Nice intro into tailwind, I definitely started grasping some of the concepts after watching Brad.
Note
GitHub - wagoodman/dive: A tool for exploring each layer in a docker image A tool for exploring each layer in a docker image. Contribute to wagoodman/dive development by creating an account on GitHub. GitHub · github.com Really cool tui to inspect docker imaages that runs with docker.
Note
Gzip/Brotli Compression Test | GiftOfSpeed Check if Gzip or Brotli compression is working on your website. giftofspeed.com A nice tool to check compression on a public url.
Note
Read a Range of Data - LIMIT and OFFSET - SQLModel SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness. sqlmodel.tiangolo.com Implement paging in sqlmodel with where, limit, and offset.
Note
DuckDB vs. MotherDuck: When to Move to the Cloud | Kestra DuckDB is fast and free. MotherDuck adds cloud storage, collaboration, and scale. Here kestra.io duckdb is a new in process database that has been making its rounds in analytics for its high performance in those applications. Mother duck is a centeralized server…
Jul 24 – Jul 30, 20233 years ago
Featured this weekLink
Just starred nvim-dbee by kndndrj. It’s an exciting project with a lot to offer. Interactive database client for neovim
Link
Looking for inspiration? sqlite-migrate by simonw. A simple database migration system for SQLite, based on sqlite-utils
Link
The work on textual-paint by 1j01. 🎨 MS Paint in your terminal.
Note
Textual - Center things Textual is a TUI framework for Python, inspired by modern web development. Textual Documentation · textual.textualize.io How to center things in textual. Textual has a very unique way of styling text user interfaces for the terminal using css. If you know css it feels natural. @willmcgugan, has…
Note
Client Challenge pypi.org Super useful way to show a tree view of an s3 bucket’s structure!
Note
External Link stackoverflow.com How to sort results from a sqlalchemy based orm. I needed this to enable paging on my thoughts api.
Note
GitHub - kndndrj/nvim-dbee: Interactive database client for neovim Interactive database client for neovim. Contribute to kndndrj/nvim-dbee development by creating an account on GitHub. GitHub · github.com A neovim database client that I need to check out.
Note
Relocating the Docker root directory If the space in the file system where the Docker root directory is located is not adequate and cannot be increased, you must relocate the directory. ibm.com A very straightforward guide to moving your docker data, such as container storage to a different location. In my case I wante…
Note
GitHub - containers/aardvark-dns: Authoritative dns server for A/AAAA container records. Forwards other request to host's /etc/resolv.conf Authoritative dns server for A/AAAA container records. Forwards other request to host's /etc/resolv.conf - containers/aardvark-dns GitHub · github.com I ran into some dns issues whi…
Note
Podman - ArchWiki wiki.archlinux.org I kept running into limits in the number of subuid and subgid’s I had on my system by default. As always thank the arch wiki guide for having the most comprehensive yet consice guide to setup podman. What I needed to do to fix the error.
Note
TestDisk Step By Step CGSecurity · cgsecurity.org is an amazing command line utility (interactive tui) that just saved me a hard drive that was filled with data, but every machine that I plugged it into told me that it was completely unpartitioned.
Note
Textual - Using Rich Inspect to interrogate Python objects Textual is a TUI framework for Python, inspired by modern web development. Textual Documentation · textual.textualize.io I love rich inspect. It’s one of my most often used features of rich. It gives you a great human readable insight into python object instanc…
Note
Reasons to avoid Javascript CDNs Wesley Aptekar-Cassels · blog.wesleyac.com And this is why we don’t run cdn in prod, respect your users who can’t control where the assets are stored. There are so many fast static hosting providers out there, if you are worried about performance reasons use one of those to self host.
Note
How to Manage 'Systemd' Services and Units Using 'Systemctl' in Linux Systemctl is a systemd utility which is responsible for Controlling the systemd system and service manager. Systemd is a collection of system management daemons, utilities and libraries which serve... How to Manage ‘Systemd’ Services and Units Using…
Note
How to fix ZFS pool not importing at boot You have probably tried Stack Exchange and reddit at this point, so what do you have to lose?./techtipsy · ounapuu.ee Hacky solution to get to work on boot right away. This has been an issue that has plagued my system for months and no matter what dependencies I add in it never…
Note
External Link stackoverflow.com In flask apps I often get a 404 for routes with a trailing slash. This Stack Overflow post shows how to configure flask to allow trailing slashes on some or all routes.
Note
Deleting Specific Lines in a File with sed or yq — Nick Janetakis We Nick Janetakis · nickjanetakis.com sed can be a tricky beast, I often stumble when trying to pipe into it. Next time I need to use sed, I should reference this article by Nick Janetakis. He makes it looks much easier than my experience has been, and i…
Note
External Link htmx.org json-enc extension converts url encoded form values into json encoded data, this is very useful for fastapi to have the same interface for htmx and curl type of interfaces.
Note
Header Parameters - FastAPI FastAPI framework, high performance, easy to learn, fast to code, ready for production fastapi.tiangolo.com Getting request headers in fastapi has a pretty nice stetup, it allows you to get headers values as function arguments, I was able to use headers to detect if a request was made from h…
Note
GitHub - 1j01/textual-paint::art: MS Paint in your terminal.:art: MS Paint in your terminal. Contribute to 1j01/textual-paint development by creating an account on GitHub. GitHub · github.com 1j01 created a complete working clone of ms paint in the terminal using the textual framework. It’s incredible.
Note
Dear Red Hat… featuring Jeff Geerling (Changelog & Friends #7) Red Hat's decision to lock down RHEL sources behind a subscription paywall was met with much ire and opened opportunity for Oracle to get a smack in and SUSE to announce a fork with $10 million beh… Changelog · changelog.com Loved this explanation about all…
Note
sqlite-utils now supports plugins sqlite-utils 3.34 is out with a major new feature: support for plugins. sqlite-utils is my combination Python library and command-line tool for manipulating SQLite databases. It recently celebrated... Simon Willison’s Weblog · simonwillison.net As the title states sqlite-utils now supp…
Note
Great short explaination of session vs token authentication.
Note
Form Data - FastAPI FastAPI framework, high performance, easy to learn, fast to code, ready for production fastapi.tiangolo.com Getting form data inside of fastapi was not intuitive to me at first. Everything I had used in fastapi leaned on pydantic models. Form data comes in differently and needs collected differently…
Note
Usage | pywebview Build GUI for your Python program with JavaScript, HTML, and CSS pywebview.flowrl.com I am creating this post from a desktop app that I created in 3 lines.
Note
Column INSERT/UPDATE Defaults — SQLAlchemy 1.4 Documentation docs.sqlalchemy.org sqlalchemy server_defaults end up as defaults in the database when new values are inserted.
Note
Template Designer Documentation — Jinja Documentation (3.1.x) jinja.palletsprojects.com A feature of jinja that I just discovered is including sub templates. Here is an example from the docs. And inside of my thoughts project I used it to render posts. note that post_item. html automatically inherits the post variable.
Note
Templates - FastAPI FastAPI framework, high performance, easy to learn, fast to code, ready for production fastapi.tiangolo.com A guide to add Jinja2Templates to fastapi.
Note
</> htmx ~ Documentation htmx gives you access to AJAX, CSS Transitions, WebSockets and Server Sent Events directly in HTML, using attributes, so you can build modern user interfaces with the simplicity and power of hypert... htmx.org A complete reference of all of the htmx swapping methods.
Note
External Link stackoverflow.com I am trying to use htmx on a new fastapi site for my thoughts, and have been hitting this error. What is happening I have an htmx component that gets the current users name, but if they are not logged in the backend redirects to a login form. But for some reason when the front end gets t…
Note
gistfile1.txt text [registries.search] registries = ['docker.io'] functions. You might get errors like: Various documentation (redhat blog entries, pages) say that dockerhub is a default, but without this step it’s clearly not. By default podman will not pull images from docker.io and will need setup. This guide worked…
Note
External Link htmx.org Using templates with htmx requires the client-side-templates extension, and the template engine to be loaded in a tag. example htmx using templates.
Note
Static Files - FastAPI FastAPI framework, high performance, easy to learn, fast to code, ready for production fastapi.tiangolo.com Mounting static files in fastapi.
Note
#javascript" playlabel="Play: HTMX looks pretty neat #coding #javascript "> Love the poling example with hx-trigger=‘every 1s’.
Note
First-class session support in FastAPI · Issue #754 · fastapi/fastapi Is your feature request related to a problem All of the security schemas currently supported by FastAPI rely on some sort of "client-server synergy", where, for instance, the client is expected to... GitHub · github.com Here is a snippet provided by…
Note
External Link duckdb.org Harlequin is a pretty sweet example of what textual can be used to create. Its a terminal based sql ide for DuckDB.
Note
Redirecting… duckdb.org To persist data in duckdb you need to first make a connection to a duck db database. Then work off of the connection rather than.
Note
Redirecting… duckdb.org duckdb can just query any pandas dataframe that is in memory. I tried running it against a list of objects and got this error. Great error message that gives me supported types right in the message.
Note
pytest-subtests unittest subTest() support and subtests fixture PyPI · pypi.org pytest-subtests is a package to register multiple subtests within a similar test function.
Note
A nice codepen reference for dark forms. I am using it for my thoughts chrome extension.
Note
![[None]] When setting up a new machine, vm, docker image you might be installing command line tools from places like pip. They will often put executables in your directory, but by default your shell is not looking in that directory for commands. To solve this you need to add that directory to your $PATH. To make this…
Note
GitHub - doyensec/wsrepl: WebSocket REPL for pentesters WebSocket REPL for pentesters. Contribute to doyensec/wsrepl development by creating an account on GitHub. GitHub · github.com Very inspiring textual project to check out how they set up the ui. Their intro video has a pretty epic dev experience.
Note
https://t.co/km5m7k6Pb0 #doyensec #appsec #websockets #burpsuite" loading=“lazy”> Doyensec (@Doyensec) on X Announcing wsrepl, the WebSocket testing tool from Doyensec! This intuitive tool is super easy to use and makes automation around WebSockets simple! Check out our blog for the details and download… X (formerly Tw…
Note
Filter Data - WHERE - SQLModel SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness. sqlmodel.tiangolo.com When fetching pydantic models from the database with sqlmodel, and you cannot select your item by id, you probably need to use a where clause. This is the sqlmodel way of doing…
Note
URL Decoding query strings or form parameters in Python | URLDecoder URL Decode online. URLDecoder is a simple and easy to use online tool for decoding URL components. Get started by typing or pasting a URL encoded string in the input text area, the tool will automa... urldecoder.io In order to turn url encoded links b…
Note
encodeURIComponent() - JavaScript | MDN The encodeURIComponent() function encodes a URI by replacing each instance of certain characters by one, two, three, or four escape sequences representing the UTF-8 encoding of the character (will... MDN Web Docs · developer.mozilla.org In order to send data that includes special…
Note
🛠️ Installation | LazyVim You can find a starter template for LazyVim here lazyvim.org Lately in 2023 I have been leaning on lazyvim for my new setups where I am not necessarily ready to drop my full config. It’s been pretty solid, and comes with a very nice setup out of the box, the docs are pretty fantastic as well.
Note
Prime reviews an article with some hot takes about python being slow and quirky, but good enough for a lot of things. Especially data applications that have libraries written in C.
Note
@changelog) on X — 🗣️ @kelseyhightower on his demos: That happy path gets people out of their chairs. They’re going back to the computer, like: “Yo, I’m gonna try it right now.” Come on… I’d rather have that. And I’ll take the bit of criticism that comes with it." loading=“lazy”> Changelog ( @changelog) on X 🗣️ @kelsey…
Note
@chriscoyier) on X — I was unaware of `text-wrap: pretty;` I knew about the (new/cool) — but sometimes that's a bit… too much. I feel like it's nice on headers but not smaller type. Here's what I mean." loading=“lazy”> Chris Coyier ( @chriscoyier) on X I was unaware of I knew about the (new/cool) — but sometimes that's…
Note
Full-text search - Datasette documentation docs.datasette.io Enable full-text search in sqlite using sqlite-utils.
Note
sqlite-utils command-line tool - sqlite-utils sqlite-utils.datasette.io I want to like jq, but I think Simon is selling me on sqlite, maybe its just me but this looks readable, hackable, editable, memorizable. Everytime I try jq, and its 5 minutes fussing with it just to get the most basic thing to work. I know enough…
Note
sqlite-utils command-line tool - sqlite-utils sqlite-utils.datasette.io insert a json array directly into into sqlite with sqlite-utils.
Note
LZone LZone - Cheat Sheets for Sysadmin / DevOps / System Architecture lzone.de A nice cheat sheet for jq. jq looks so nice, but it so quickly gets overwhelming on how to select what you want. I was able to make a jq contains query.
Calendar data could not load. Try again.