Technical Blogs and Discussion Board

Estimating the development timeline for an API when SQL queries are ready

Estimating the development timeline for an API when SQL queries are ready involves evaluating several factors. Here’s a step-by-step approach: 1. Define API Scope Number of Endpoints: Count how many API endpoints need to be created. Complexity per Endpoint: Consider if endpoints are simple (e.g., a single query) or complex (e.g., require multiple queries or custom logic). Authentication…

Read More

Fatal Error: Allowed Memory Size of 134217728 Bytes Exhausted

Fatal Error: Allowed Memory Size of 134217728 Bytes Exhausted error in my web application, while accessing a page. To solve this issue, we have to do a configuration change in php.ini of our web server. Follow these steps to update memory limit to resolve this error from the Mac/Ununtu terminal: Determine PHP version from terminal…

Read More

AI usage in CRM applications

AI has become instrumental in CRM applications, enhancing customer experience, automating processes, and improving decision-making. Here are key areas where AI can make a difference in CRM systems: Personalized Customer Interactions: AI can analyze customer data (purchase history, browsing behavior, preferences) to deliver tailored product recommendations and targeted content. It enables predictive personalization, where the…

Read More

How to check and change innodb buffer pool size in mysql database

 The InnoDB buffer pool size in MySQL determines how much memory is allocated to store frequently accessed data and indexes. To check and change it, follow these steps:   1. Check Current InnoDB Buffer Pool Size     a. Log in to MySQL         mysql -u root -p     b. Run the Following Query   …

Read More

How to get the auto incremented id after adding the data in mysql

 In one of the project we were working on, we had a situation, where we need to add a record to the table of the database. The added record id is auto incremented in database. This id needs to added to another table with some more data. Now the issue here is how to get…

Read More

Setting of Auto backup of Mysql database in a laravel project

 When we work on any database project, it’s always good to set up autoback of the database on daily basis. We can set up a cron job for backing up a MySQL database in a Laravel project, follow these steps:   1. Create a Laravel Artisan Command Run the following command to create a custom Artisan…

Read More