XAMPP – Software Technology

The total number of lock exceeds the lock table size in MySQL

Below error when using python with sqlalchemy module and MySQL MariaDB. Error: MySQL is trying to tell you that it doesn’t have enough room to store all of the row locks that it would need to execute your query. The only way to fix it for sure is to adjust innodb_buffer_pool_size and restart MySQL. By default, thisContinue reading “The total number of lock exceeds the lock table size in MySQL”

How to connect PostgreSQL with XAMPP

This article will help you to install and Integrate PostgreSql with XAMPP for practicality use: Download the PostgreSQL installer from EnterpriseDB and follow the instruction. Assuming your XAMPP is located in D:\XAMPP; so better locate your PostgreSQL in the same folder, sample: D:\XAMPP\PostgreSQL\12. Uncomment below lines in php.ini (usually located in D:\XAMPP\php\php.ini): From:;extension=pdo_pgsql;extension=pgsqlTo:extension=pdo_pgsqlextension=pgsql Stop andContinue reading “How to connect PostgreSQL with XAMPP”