-
SQLite and Python
by Toby Ho SQLite is a lightweight SQL relational database. Although it is not built for multi-user concurrent applications, it has become a staple data storage option for mobile, desktop, and even websites for client-side storage. Chances are you’ve encountered SQLite as the default development database option for web frameworks like Django. What you might…
-
Intro to Urwid
A Python library for Terminal User Interfaces by Joseph Carboni As someone who does customer service and builds software, I’ve been building a backend API (https://github.com/shupe-carboni/backend) to handle certain services. As a matter of standard operating procedure, when I bite off a class of customer service requests to code into the API, that class of…
-
Beyond Basic Spreadsheets
Crafting Styled Spreadsheets with openpyxl If you have ever seen the inner workings of the typical small to medium-sized business, you’ve seen a deeply disturbing and upsetting reality. The backbone of our economy runs on Microsoft Excel. I have worked in one of these companies for about a decade now. In the beginning, I was…
-
From problem to Python
Developing a website monitoring tool By Joseph Carboni This is an example of using an acute business problem as an opportunity to use Python for a helpful solution – a website status monitor. An exercise in looping, making web requests, and running a python utility from the command line. (Given the nature of the problem,…
-
Fun way to learn the Python Standard Library
