top of page
Search


Managing a Relational Database for a Python Project
On a recent project I was responsible for developing the tooling, processes and automation for managing PostgreSQL database schema...
Finn Andersen
Nov 11, 20241 min read
10 views
0 comments


My SQLServer Schema Manager library
I finally got around to publishing a handy tool I developed a long time ago - It lets you define the entire structure of a SQLServer DB...
Finn Andersen
Oct 19, 20241 min read
2 views
0 comments


Using Python and AWS to secure tickets to Printworks' closing weekend events
While in London I intended to go to an event at the iconic Printworks venue, which is known for hosting electronic music raves. However,...
Finn Andersen
Apr 28, 20232 min read
35 views
0 comments


What's the fastest way to read a CSV file with Pandas 2.0?
I did some performance testing of the different engines and options of Pandas 2.0's read_csv() function, and wrote an article about the resu
Finn Andersen
Apr 27, 20231 min read
3 views
0 comments


How doeso Panda’s read_csv() function actually work?
I dove into the internals of the updated read_csv() function in Pandas 2.0 to see how the different engines and configuration options work.
Finn Andersen
Apr 27, 20231 min read
5 views
0 comments


How to Scale a Monolithic Django Project — Without Microservices
I wrote an article exploring ways to approach software architecture decisions when scaling up a complex application.
Finn Andersen
Mar 4, 20231 min read
7 views
0 comments


Analyzing and Optimizing Database interactions with Django and pyodbc
Recently I performed some investigation into the database interaction activity of the Django-based data platform I lead in order to...
Finn Andersen
Feb 1, 20231 min read
2 views
0 comments


A Guide to Pandas Extension Types and How to Create Your Own
Pandas Extension Types allow adding cool new capabilities to the popular Python data processing library
Finn Andersen
Feb 1, 20231 min read
3 views
0 comments
bottom of page