In this example I am going to show you how to call stored procedure in CodeIgniter 4. CodeIgniter 4 is a PHP based light weight web based framework for rapid application development. In this example I am going to use MySQL database server for storing data.

Posted in Codeigniter MySQL

How to call Stored Procedure in CodeIgniter 4

In this tutorial I am going to show you how to build CRUD application using CodeIgniter 4, MySQL and React JS framework. CRUD is an acronym that stands for Create, Read, Update and Delete operations in a particular application. So you are basically creating a record, reading single or all records, updating the existing record…

Posted in Codeigniter MySQL React JS

React CRUD Example with CodeIgniter 4 and MySQL 8

Here I am going to show you an example how to encrypt PDF to make it password protected using PyPDF2 module in Python programming language. I am not going to show you how to create a new PDF file in this example and I am going to read the existing PDF file and making this…

Posted in Python

How To Encrypt PDF As Password Protected File In Python

Introduction In this tutorial I am going to show you an example on how to watermark image with text using Python. You might have seen somewhere online portal or social network portals that some images are watermarked, because the owners of the images want to prevent misuse of the images. Here I am going to…

Posted in Python

How to watermark Image with Text using Python

In this tutorial I am going to show you how you can build an online visitor tracking system using PHP based framework CodeIgniter 4, MySQL 8 and AJAX technique. The similar system for tracking online visitors on web site, I built in past, using CodeIgniter 3 framework. As a web site owner you would like…

Posted in AJAX Codeigniter jQuery MySQL

Online Visitor Tracking System using CodeIgniter 4, MySQL 8 and AJAX

You might encounter the following issue while executing an SQL query qith Group By clause in MySQL database server. Error Type: mysqli_sql_exception #1055 Error Details: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘roytuts.visitors.access_date’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible…

Posted in MySQL

SELECT list is not in GROUP BY clause and contains nonaggregated column – mysqli_sql_exception #1055

In this example I am going to show you how to run multiple batch jobs parallelly in Spring Batch framework. Spring Batch is a lightweight, comprehensive batch framework designed to enable the development of robust batch applications vital for the daily operations of enterprise systems. Spring Batch provides reusable functions that are essential in processing…

Posted in Spring Batch Spring Boot

Spring Batch – Scheduling Multiple Jobs Parallelly

Here I am going to show an example how you can add images to word file in Python programming language. Generally you write headings, paragraphs, etc. to describe an event or something in the word file. To explain better pictorially about the same thing you need to insert or add images. python-docx is a Python…

Posted in Python Word

Add Images to Word File using Python

In this tutorial I am going to show you an example on deploying Spring Boot application to Heroku cloud. I will create a basic CRUD application with Spring Boot Data JPA and PostgreSQL/MySQL technologies. I will first show you how to perform CRUD operations locally, then deploy the same application in the Heroku cloud with…

Posted in Cloud Heroku MySQL Spring Boot

How to deploy Spring Boot Data JPA Application to Heroku Cloud

In this example I will show you installing PostgreSQL zip archive in Windows environment. I will show you how to setup username and password for your PostgreSQL database server. I am also going to show you some basic commands for listing all database, switching to another database, creating a new database, showing all tables, creating…

Posted in PostgreSQL

How to install PostgreSQL Zip Archive in Windows

I am going to discuss here CompletableFuture vs Parallel Stream in Java programming language. CompletableFuture extends Future with added advantage to allow the tasks finish in an ad hoc manner. In Parallel Stream task is divided into sub-tasks and run on separate threads to be completed faster. Both CompletableFuture and Parallel Stream were added in…

Posted in Java

Difference Between Parallel Stream and CompletableFuture in Java

I am going to show you how to convert video (MP4/AVI) clips to gif in Python programming language. Recently I was trying online to convert an avi format video file to gif and I found that there are some limitations: you cannot upload more than 50 or 100 MB file; you need to register or…

Posted in Python

How to convert Video (MP4/AVI) Clips to GIF in Python