Database
-
Deal with Common Types of SQLAlchemy Exceptions for Running SQL Queries in Python
When working with databases using SQLAlchemy, many developers may simply catch the base exception SQLAlchemyError, or worse, the base Python Exception. This is not a good practice because it makes the code work like a black box and we cannot anticipate what types of exceptions can be raised. In this post, we will introduce some… Continue reading
-
Important MySQL Data Definition Language (DDL) commands we should know for managing our tables
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 lowercase and uppercase queries and… Continue reading
-
Some Tips for Using DBeaver — A Universal Database Tool
DBeaver is a universal database administration tool that can be used to manage all kinds of relational and NoSQL databases. DBeaver has both a community edition (CE) which is free and open-source and a commercial enterprise edition (EE). The community edition supports all kinds of relational databases such as MySQL, PostgreSQL, Oracle, etc. The enterprise… Continue reading