Install Python3 on Ubuntu
A quick tutorial for installing Python from its official source on Ubuntu with sqlite3 support.
Blog#
SQLAlchemy mixin in method
If I'm not wrong, the SQLAlchemy official doc provides some examples to explain how to share a set of common columns, some common table options, or other mapped properties, across many classes. But I cannot find how to share common methods (e.g. your customized to_dict() method). This post will just show you a POC to achieve this goal by using Python Mixin.
Fast TCP port check in Powershell
The Test-NetConnection cmdlet is great and verbose but too slow if the remote port to check is not opened. This is due to its timeout setting and cannot be modified. In this port, I will show you a custom function that leverages the power of System.Net.Sockets.TcpClient to accelerate the port test.
Troubleshooting Python Twine Cannot Upload Package On Windows
Python has several tools to upload packages to PyPi or some private Artifactory locations. The mostly used one should be twine. Although twine is not a Python originate tool, but it's officially recommended by Python.org.
Filtering In Pandas Dataframe
Pandas dataframe is like a small database, we can use it to inject some data and do some in-memory filtering without any external SQL. This post is much like a summary of this StackOverflow thread.
Git Cheat Sheet
This is not a complete Git cheat sheet for everyone, this is just a personal cheat sheet for some often forgotten git commands.
Using Python SQLAlchemy session in multithreading
SQLAlchemy DB session is not thread safe. In this post, I will show you 2 ways to use it in a multithreading context.
Creating Custom Python Request Auth Class
When you need to use a complicated, or a non-standard API authentication method, or your dev and prd environments don't use the same API authentication method, it might be better to create a Python requests auth method to reduce your work.
Creating Multiple Redis Instance Services On Windows
Even Salvatore Sanfilippo (creator of Redis) thinks it's a bad idea to use multiple DBs in Redis. So we can install as many Redis instances as the number of DBs we need. This post will show you how to create multiple Redis instance as Windows service on the same Windows server.
Setting Pwsh Invoke-WebRequest Proxy
Different than Windows Powershell, Powershell Core doesn't use the system proxy setting on Windows. This post will show you an one-line command to set Powershell Core web cmdlets proxy.