Relational Databases Explained How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases. Architecture Databases
Database Sharding Explained More features, active users, and data are collected daily. Your database is slowing your application. Many people don't understand database sharding, which could solve their difficulties. This article explains database sharding, its benefits, including how to use it and when not to. Architecture Databases
Better SQLAlchemy Introduction We heavily use SQLAlchemy behind the scenes at Tiqets . As one of the most powerful and well-featured ORMs out there, it works well for small and big projects alike. However, as projects start to grow, the abstractions provided by the helpful ORM affect performance. The Tiqets back-end is persisted in Postgres across hundreds of tables. Among all these tables and their relationships, it’s easy to end up writing inefficient ORM queries, or reinventing the wheel where the ORM could have been used in a cleaner way. Python Databases Development
Database integration tests with Pytest, SQLAlchemy and Factory Boy with Faker Python Development Databases
How to delete or remove a MySQL/MariaDB user account on Linux/Unix In this quick tutorial, you will learn how to delete ore remove user account in MySQL or MariaDB database on Linux or Unix-like system. Databases
Advanced SQLAlchemy Features You Need To Start Using If you are Python developer and you work with SQL databases, then SQLAlchemy is most likely a library you are familiar with. It’s a powerful, yet flexible toolkit for working with SQL in Python with lots of features. Some of these features like ORM and basic queries are common knowledge, but there are quite a few features you might not know about and should definitely be taking advantage of. So, let’s se how to leverage things like hybrid properties, nested queries, table metadata, dialects and more! Python Development Databases
Raw SQL vs Query Builder vs ORM After reading this article, you will know when to use raw SQL, a query builder and an ORM. You will also know how to use each of them in Python. All of the code in this article is runnable. You just need to initialize the database and add environment variables. Python Development Databases
How Reset root password in MySQL and MariaDB How Reset root password in mysql and mariadb - generic instructions If you assigned a root password in MySQL or MariaDB previously but have forgotten it, you can assign a new password. The following sections provide generic instructions for that apply to any system. On any platform, you can reset the password using the mysql client (but this approach is less secure): Stop the MySQL or MariaDB server ~]$ /etc/init. Databases Linux
How To Save MySQL query output to file or export to CSV Answers to a few questions about Mysql or MariaDB databases: How To Save MySQL/MariaDB query output to file or export to CSV? How to list MySQL database table column names without the table formatting? How to log the output from an entire MySQL client session? Databases
phpmyadmin - how recovery error (HY000/1698): Access denied for user 'root'@'localhost' When I try login as a root user to my mariadb (mysql) database in phpmyadmin on my linux debian stretch, I got this error message: mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost' Debian Linux Databases