SQL is one of the most ubiquitous languages for working with data (specifically tabular although that’s changing too). Whether this is due to being based on relational algebra, a fundamental math for data with relationships or whether it was just the tool that took off and kept growing years ago…

Airtable is a great product for storing data in tabular form while being intuitive and accessible for teams. PyAirtable allows us to automate CRUD operations (create, read, update, delete) from Airtable bases from our python scripts. Its a python package that wraps the Airtable API and provides an straightforward interface…

Spreadsheets… Everyone loves them right? Well, loves them until we run into something we need from them they weren’t built to solve for; then they become a mess. Layer is a product company out of Germany that intends to solve one of these issues: Teamwork. This includes tasks like report…

Overview Last week we did a brief overview of PyScript, a project allowing Python and CPython based packages like Numpy and Pands to run in the browser. This week we continue exploring PyScript with some examples of specific uses including a Wordle implementation with PyScript. The following examples are not comprehensive…

Python has had an interesting history with the browser. Projects like Brython and Skulpt have introduced browser implementations of python in Javascript before. But projects like this typically struggle with a key factor in developer excitement: packages. For example Brython is very explicit on their FAQs page that Brython supports…

DuckDB is a really interesting project aimed at being a SQLite style database with a focus on OLAP (online analytical processing). OLAP is typically associated with analytics due to its design catering to long running queries over large datasets or aggregations over joins of multiple tables with vast amounts of…

Many of us, myself included, watch a fair bit of YouTube for a number of purposes. News, learning, academic studies, background noise, music, product reviews, etc…. the list goes on. When using YouTube for a number of these topics there’s a few features that have seemed to be missing in…

Draw.io (now called diagrams.net) is by far my favorite diagramming software. As a designer and product lead, I can firmly attest Draw.io is one of the most critical software on my workbench when it comes to outlining ideas and designs. I use it for process flow diagrams when scoping projects…

Art Breeder is a unique project. It providers the ability to mix, mesh and generate art from “parent” images. This is commonly done with an increasingly popular machine learning model known as GANs (Generative Adversarial Networks) which use two primary engines, a generator and a discriminator to create images and…