Convert SQL query to CSV file in Python

This function takes an SQLAlchemy query object as it’s input (SQLAlchemy is a popular Python SQL toolkit and Object Relational Mapper). It’s strength lies in not needing to hard-code column names, making it scaleable and suitable to “set-and-forget”. While developing enterprise software, every developer has surely have been faced with a client asking “how do I get the data out of the system?”, and after digging a bit deeper, it becomes clear they want the ability to save a snapshot of data as an Excel spreadsheet.

Use powershell profiles like a pro

If you do any software development in a Windows environment, you’ll be spending enough time inside the Powershell (PS) console that it will be worth customizing the PS Profile to speed up your workflow. The PS Profile is essentially a .ps1 script that is run whenever a new PS console is opened. Without going too deep into how a sysadmin might use it, the average developer will probably want to use it to quickly do a few basic things:

Search Google from the powershell console

You may have seen people walking around with those awkwardEat; Sleep; Code; Repeat; brogrammer shirts. I don’t like them - between the many other things that developing software requires, when I actually sit down to write code the workflow would more accurately be described as Code; Compile; Google Error; Repeat;. This short post explains how the below gg.ps1 Powershell script can increase your productivity by opening a chrome browser and executing a Google search straight from the Powershell console.

Automating deployment of a Hugo website to Github Pages using powershell scripts

Overview The following article describes how this blog is automatically deployed. The technology stack for this blog is: Source content written within the Hugo framework (a static website generator written in the Go language. Hosted by GitHub Pages, directly from this repository which contains the website build (the source code is in a separate repository). Cloudflare for cached content delivery (along with many other things). If the technology stack for your project is completely different, this article should still provide you with:

Event review: BrisJs - Introducing the typescript compiler; Atomic design; Scrutinising the norm

I attended the first BrisJS meetup of the year last night. This was my first time attending a “programming language-centric” meetup, and I was surprised to find around 100 people in attendance. All presenters and the majority of the crowd looked to be in their 20’s, and while the presentations didn’t have the level of polish that I would usually expect for an event of this size, I was still able to learn a few things, and more importantly, have some interesting conversations with other developers about projects they are working on and opportunities in the market.

Event review: Collaborate at RCL

I attended “Collaborate at RCL” last night, an event hosted by River City Labs, described as follows: What do you do when you have an amazing business idea, but you don’t have the skills or resources to make it happen? Help others with their ideas, and they’ll help you with yours! That’s the idea behind Collaborate @ RCL. Meet some great people, learn some new skills, and work on some fantastic businesses - all at the same time.