Learn handy tools in Python to manage your data in various ways — Python is an object-oriented programming language and there are various ways to represent data as objects. Simple objects can be represented by dictionaries with key-value pairs. And more complex ones can be represented by some special data classes including namedtuple, data class, and Pydantic models. In this post, we will…

Learn different ways to debug your Dockerized API code — Nowadays, it’s a good practice to Dockerize our Python API code running as microservices, which can make the code easier to develop, deploy, and maintain. During the development or maintenance stages, we often need to debug our code that doesn’t run properly. We cannot use the traditional PDB library to…

Learn to build a functional search engine with both backend and frontend quickly — Autocomplete search (search as you type) is a very user-friendly feature implemented on almost all websites providing search services. Users can see results popping up as they type. …

Learn to use triggers efficiently in MySQL to keep track of important tables — In MySQL and any relational databases, a trigger is some code that is executed automatically when some event is fired. Depending on the event, there are triggers that are run before or after a table row is inserted, updated, or deleted. In this post, we will introduce how to use…

Learn common database managing commands as a data engineer — As a data engineer, checking and updating the schemas of tables is our bread and butter. There are plenty of tutorials online already but few of them focus on the conventions that should be followed. SQL is very flexible and can work in a “robust” way. You can use both…

Learn to add standard command-line interfaces for your Python programs using argparse — When writing executable Python programs, we should always add some command-line arguments to make them easier to use. Most users will run the program with the -h or--help option to see the usage instructions of the program. A native way to parse command-line arguments is by using sys.argv. However, it’s…

Learn a standard way to connect dockerized applications to GCP Cloud SQL instances — Cloud SQL on the Google Cloud Platform (GCP) is a great service if you want to host your relational databases in the cloud. There are some standard ways to connect to Cloud SQL from your GCP resources like Cloud Run, Compute engine, etc. …

Learn to write robust Python code with proper exception handling — Error or exception handling in Python may seem pretty simple to us, as we just need to use try and except to catch the exception and deal with it. Yes, it is simple to use. However, some bad habits of dealing with exceptions can make our code buggy and difficult…

Learn different ways to send emails in Python and trigger GCP Cloud Functions — It’s common to send emails programmatically in an application. For example, emails can be sent to developers when critical API errors occur. Besides, emails need to be sent out to users automatically for registration, password reset, or service confirmation. In this post, we will introduce different ways to send emails…