LLMs and Freewill

During the late 1900s (1997) I learned about this theoretical concept called artificial intelligence, in high school. I asked my cousin (a CS college grad) about it. He explained that AI is a research field that is trying emulate a human brain but with a computer program. I wondered if that would be a nuisance? For instance, while I’m studying I get distracted and decide to start watching TV (Freewill?). What if the computer did the same?...

January 5, 2024 · 2 min

Postgresql and Underscore

TL;DR: Underscore is a matching character in LIKE queries to match a single character. I’m using Postgresql for one of my projects to store some python package metadata. Canonical python packages must be all lowercase and should not use underscores (_) but instead should use hyphens (-) as delimiters. It is just a recommendation and not enforced by PyPI or pip. I wanted to check how many packages in my database were using underscores....

December 20, 2023 · 1 min

sqlite-utils + litecli

sqlite-utils is a CLI tool for manipulating SQLite databases. I’ve used sqlite-utils and shot-scraper in the past to port my blog from PostHaven to this static site. Recently sqlite-utils added plugin support and Simon the creator of sqlite-utils wrote a few plugins to showcase the plugin system. One of them is a sqlite-utils-litecli plugin which launches an interactive shell with litecli. One obvious advantage is litecli has auto-completion and syntax highlighting which is a huge improvement over the default sqlite3 shell....

July 26, 2023 · 1 min

Python at Netflix

Zoran and I were guests on the Talk Python Podcast to discuss how Python is used at Netflix. The host of the podcast Michael Kennedy was well prepared with the background context and led the conversation in interesting ways. We got to cover a ton of different use cases at Netflix that use Python. I got to talk about some of my favorite OSS projects (bpython, pdb++, dbcli etc). We ran out of time before we could talk about pickley but we did mention it during the episode....

June 30, 2023 · 1 min

Finding the most frequent value in a SQLite column

I have a table with a list of trails that I’ve biked. I wanted to find out which trail I’ve biked the most. I used the following SQL query to find out: SELECT name, count(name) AS ct FROM trails GROUP BY name ORDER BY ct DESC LIMIT 5 This gave me the 5 trails I’ve biked the most. Translated to SQLAlchemy. from sqlalchemy import func def most_common_trails(db: Session): return ( db....

June 9, 2023 · 1 min