raihan-uddin

MeiliSearch

⚡ Lightning Fast, Ultra Relevant, and Typo-Tolerant Search Engine 🔍

Github | Website

Get Started

1. Install MeiliSearch
2. Version
3. Indexes
   • Get Indexes
   • Create Index

raihan-uddin

Multiple PHP version install in Ubuntu. Apache2, Apache. Changing php version using .htaccess & keeping or settingup using separe virtual host for each php version.

Commands and points are below

sudo apt-get install software-properties-common -y
sudo add-apt-repository ppa:ondrej/php
sudo apt-get update -y

raihan-uddin

Prerequisites You should already have Apache installed and serving web pages before following this guide.

This guide was tested on Ubuntu 24.04, Ubuntu 22.04, Ubuntu 20.04 and Ubuntu 18.04, though it should also be useful for other Debian-based systems.

If you need to install Apache on Ubuntu, please see:

1. Add Repository The software-properties-common package is required to add Ondřej’s PHP repository, which will allow us to download co-installable versions of PHP.

raihan-uddin

I use linux ( ubuntu ) as my Primary Environment. Recently, I had to import a very large Mysql dump file (40.5GB .sql) in my local environment. Normally, it was taking couple of hours (4/5 hours). I would be happy with that ( as we dont need to import db regularly), but my dump file had couple of errors which was inturrpting import process.

So keeping the following notes for my personal usage. But that might help others also.

Below are the steps to follow, to speed up the process.

# OPEN THIS FILE

sudo gedit /etc/mysql/my.cnf

raihan-uddin

Activate Windows 8, 8.1, 10 and 11 Pro for Free

A guide how to get and activate Windows 8, 8.1, 10 and 11 Pro for free!

NOTE

If you see the Windows keyboard button in this guide; and you can't find it on your keyboard, you likely have/had Windows 10 which has the button . If you can't find that one, you likely have a PC that has been upgraded to Windows 8/8.1/10/11 from Windows 8.1/8/7/Vista/XP and other ones. If you have one of those, refer the Windows key button to as yours. A list of them is below:

Windows key buttons

- Windows 11

- Windows 10

raihan-uddin

$transaction = Yii::app()->db->beginTransaction();
try {
    if (!$model->save()) {
        throw new Exception('Model cannot be saved.');
    }
    if (!$anothermodel->save()) {
        throw new Exception('Anothermodel cannot be saved.');
    }

    $transaction->commit();

raihan-uddin

SET FOREIGN_KEY_CHECKS = 0;
/* Drop Tables */

DROP TABLE IF EXISTS calendar CASCADE;

/* Create Tables */

CREATE TABLE calendar (
  id               DATE       NOT NULL,
  year                  SMALLINT   NOT NULL,

raihan-uddin

DELIMITER $$
  CREATE EVENT employeeResign
  ON SCHEDULE EVERY 2 MINUTE
  DO
  BEGIN
  
	DECLARE done INT DEFAULT FALSE;
    DECLARE rowId INT;
    DECLARE employeeId INT;

raihan-uddin

ALTER TABLE `employees` ADD `last_increment_date` DATE NULL DEFAULT NULL AFTER `signature_by`, ADD `last_increment_amount` DOUBLE NULL DEFAULT NULL AFTER `last_increment_date`;
ALTER TABLE `employees` CHANGE `contact_end` `contact_end` DATE NULL DEFAULT NULL;




ALTER TABLE `complain_sheet2` CHANGE `qc_remarks` `qc_remarks` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

raihan-uddin

https://averagelinuxuser.com/after-installing-ubuntu-20-04/
https://ubuntuhandbook.org/index.php/2021/10/top-things-ubuntu-21-10-desktop/

php multiple version on same time
https://devanswers.co/run-multiple-php-versions-on-apache/

php switch version
https://tecadmin.net/install-php-ubuntu-20-04/