MongoDB is one of the most popular NoSQL database where your data are stored in a collection. To quickly access your data from MongoDB you can execute commands on MongoDB shell and your results appear based on the given criteria. One of the commands is find() function and using this command you can easily retrieve…

Posted in MongoDB

How to make output of MongoDB’s find() readable in shell

In this tutorial I will show you how to dockerize Django MySQL app using docker compose in Linux environment. So why do you need docker compose when you have docker container? Generally it is said to be best practices when each docker container runs a process with single responsibility, but for this application you need…

Posted in Django Docker MySQL

Docker Compose – Dockerizing Django MySQL App

I am going to show how to select a row from MySQL database as randomly as possible, but not repeating it. So I am going to select unique row from the MySQL database using PHP based Codeigniter framework. The original tutorial could be found as selecting a random row every day from MySQL.

Posted in Codeigniter MySQL

Codeigniter – Select Unique Random Row Every Day From MySQL

I am going to show yo how to download PDF file from MySQL database using Spring Boot and iText library in Java programming language. Many applications require dynamic generation of PDF documents for reporting purpose, such as, generating statements for customers, readers buying online specific chapters of a book, etc. In my another tutorial I…

Posted in Java MySQL Spring Boot

How to generate PDF report from MySQL database in Spring Boot

Here I am going to show you how to download excel file from MySQL using Spring framework. Generating excel report from MySQL database has few advantages over other file formats. Most of the people you are working with in your organization are familiar with excel file format, hence it needs a short learning curve. You…

Posted in Excel MySQL Spring Boot

How to generate Excel Report from MySQL Database in Spring Boot

Introduction In this tutorial I am going to explain you how to use docker compose to dockerize your Nodejs MySQL REST API for CRUD operations. I am not going to tell you here how to build the REST CRUD application but you can always go back and check the detail tutorial on this here. I…

Posted in Docker MySQL NodeJS REST

Docker Compose – Dockerizing Nodejs MySQL REST API CRUD Example

Here I am going to show you how to create REST API CRUD example using Nodejs Express and MySQL server. CRUD means Create, Read, Update and Delete operations which are performed through REST (Representational State Transfer) resources that works on http/https protocol. REST resources or APIs work on verbs, such as, GET, POST, PUT, DELETE,…

Posted in MySQL NodeJS

NodeJS Express MySQL REST API CRUD Example

Introduction Here I am going to show you how to use docker compose for dockerizing Spring Boot Microservices MySQL app. Docker Compose is a tool for defining and running multi-container Docker applications. With Compose, you use a YAML file to configure your application’s services. Then, with a single command, you create and start all the services…

Posted in Docker Microservices MySQL Spring Boot

Docker Compose – Dockerizing Spring Boot Microservices MySQL App

Introduction It is considered to be a best practice for a container to have only one process with single responsibility. But as I am going to dockerize Python based Flask web app and MySQL server for storing data for the app, so I need two containers – one for running the app and another one…

Posted in Docker Flask MySQL Python

Docker Compose – Dockerizing Flask MySQL App

Introduction In this tutorial I am going to show you how to work with different changes or versioning maintenance on database scripts without touching the original SQL scripts. So we will only work with the changes we need at a later point of time for our database. Let’s say you have created a table through…

Posted in Database Liquibase

How versioning maintenance happens in Liquibase

Introduction This example will show you how to insert CSV data into MySQL database table directly. So I am going to create insert SQL statement for inserting data individually or I will also load the csv data directly into the MySQL table. CSV means Comma Separated Value, so it’s a plain text data. Each line…

Posted in MySQL Python

How to insert CSV data into MySQL database using Python in different ways

Here we will see how to connect to MySQL database server using Python in different ways. We need to install mysql-connector-python module to connect to MySQL database from Python programming language. We will create the connection objects in different ways and using this connection object we will be able to connect to MySQL server.

Posted in MySQL Python

How to connect to MySQL database using Python in different ways