Category Archives: Tutorials
Configuring Buffer Pool Size in mySQL InnoDB Engine
We have all been there when a query to the database takes longer than usual and sometimes it feels like forever. There has been always been complaints about mysql database being slow. There are quite a few reasons for the query being slow. One of them being the buffer pool size is too small. To…
How to Install Redis Server from Source
Redis is an in-memory key-value store database. There are a few different ways to install redis-server in a Linux based system. To fit our purpose we are going to use the current (latest) stable release from REDIS.IO This process of installation is a bit complex because it requires you to build, compile and install the…
How to Easily Switch Between Python Versions in Ubuntu
It had been reported that changing the default python version with update-alternatives breaks the shell, so use it at your own risk! Recently my team has stopped supporting python 2.7 and only supports python version 3.5 and above. For testing purposes, I had to install all three (at the time of writing this post) 3.5,…
How to Install pgAdmin4 Web Application as a Service
pgAdmin is the most popular and feature-rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. Add pgadmin4 Repository To add the repository find out the release of the Linux distribution by using lsb_release -cs Create a file /etc/apt/sources.list.d/pgdg.list and add the following line to add the repository deb…
Directory Structure for Python Projects
To get started with Directory Structure I would like to quote the following lines from a well-kown python book called The Hitchhiker’s Guide to Python: Best Practices for Development by Kenneth Reitz and Tanya Schlusser. By “structure” we mean the decisions you make concerning how your project best meets its objective. We need to consider how to best leverage Python’s…