DB Resource Usage
You can use the following query to see who is using your database resources
SELECT max(user) as user, count(*) as connections_count, db from information_schema.processlist GROUP BY db order by connections_count desc;
Similar Posts
SSH Key Set Up for Multiple GitHub Accounts
A great article on how to set up and manage ssh keys for multiple github accounts/repositories SSH Keys with Multiple GitHub Accounts
Testing API Clients
Since an API client is a boundary between your code and the outside world you should write as little code as possible to implement it. The client should strictly do its job by sending a request and returning a response. That is why we don’t really test the clients themselves but rather the code that processes the response from the client.
Laravel WebSockets as a Service
Recently Beyondcode came out with a web sockets package for Laravel. For my mailroom project I decided to add push notifications when a service receives a webhook. This a great use case for Laravel WebSockets package. In this article we will take a look at how to install it as a service using Docker and use…
Contact Form Processing with PHP, MySQL, and Swift Mailer
In this article we will take a look how to process a contact form on your web page. We will collect the data from input fields, server side validate it by checking if fields are empty, put website user’s message in the database, and send a notification email to the website owner.
Magento 2 Data Migration Notes
Recently I was assigned to do data migration from Magento 1.8.1.0 to Magento 2.1.0 In this article, I will share some points you must look out for when migrating to Magento 2. There are several things you must be aware of before you start migration: Magento 2 is a memory hog. So, suggested 2GB RAM…
Complex Eloquent Query
A query below selects products that need to be updated in a remote application. It takes quantities of products in host application that are connected to source products application. On top of that it looks at all the orders that are in “Pending” status and reserves quantities for those products. SELECT products.quantity_available, connector_products.stock_id, products.id, connector_products.sku,…