News and interviews about the latest happenings in the PHP and Web development world. Hosted by Manuel Lemos of the PHPClasses.org site and other guest hosts. It is recorded in MP3 format at least once a month in the beginning of each month.
Future of PDO, PHP Classes Ideas, Scan Documents into PDF, Tools for Code Quality - 3 minutes - Lately in PHP 95 By Manuel Lemos The Lately in PHP podcast is back with a new format that is more direct to the point, thanks to the feedback from our audience.
Read this article, watch a 3-minute video, or listen to episode 95 of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 3 through September 9.
Make SQL Queries Run Faster Using the EverSQL MySQL Query Optimization Tool - 4 minutes - Lately in PHP Podcast Episode 93 Part 6 By Manuel Lemos Slow SQL queries are one of the factors that can make sites slower and cause harm to the user experience.
Fortunately, optimization tools can suggest small changes in your database schema that can make your SQL queries run much, so your Web sites can provide a much better user experience.
EverSQL is one of those optimization tools that can suggest effective changes for databases stored in MySQL servers or some other server compatible with MySQL, such as MariaDB.
Read this article, watch a 4-minute video, or listen to part 6 of episode 93 of the Lately in PHP podcast to learn how to optimize your MySQL database using the EverSQL tool for free.
How to Help the EverSQL Tool Optimizing MySQL SQL Queries More Efficiently by Passing It Your MySQL Database Metadata - 4 minutes - Lately in PHP Podcast Episode 93 Part 5 By Manuel Lemos The EverSQL tool is excellent for suggesting optimizations for SQL queries for your applications that use MySQL.
That tool must first obtain the structure of your database tables to suggest good optimizations. You can get that structure by executing a SQL query that extracts the database metadata.
Read this article, watch a 4-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to extract your MySQL database metadata to help the EverSQL tool to optimize your application SQL queries for free.
Introduction on How to Use the EverSQL MySQL Query Optimizer Tool for Free - 3 minutes - Lately in PHP Podcast Episode 93 Part 4 By Manuel Lemos When you want to optimize SQL queries to optimize an application that uses MySQL, you can use "manual" methods. These methods require good SQL query optimization knowledge. If you need to optimize many SQL queries, doing it "manually" may also take time.
One way to optimize SQL queries without requiring you to learn so much about optimization is to use a SQL query optimization tool. Optimization tools also take you much less time to optimize many queries than if you try manually.
Read this article, watch a 3-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to optimize MySQL SQL queries without much knowledge and faster than if you try to do it manually.
How to Use Simple MySQL Monitoring Tools for Free to Find the Slowest Queries that You Should Optimize First - 2 minutes - Lately in PHP Podcast Episode 93 Part 3 By Manuel Lemos When you want to optimize the performance of a MySQL-based application, you should try to optimize first the slowest queries that affect the application's performance.
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
How to Find MySQL Slow Queries in a Production Server by Activating the Slow Query Log - 2 minutes - Lately in PHP Podcast Episode 93 Part 2 By Manuel Lemos When you want to optimize a MySQL database application in production, you should figure out the slowest queries in that environment.
Enabling the MySQL slow query log can help you figure out the slowest SQL queries to optimize first. You can do that in a production environment, but you need to take extra care with how you enable the slow query log to avoid causing harm to the application.
Read this article, watch a 2-minute video, or listen to part 2 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log in a production environment in a safe way.
Find MySQL Slow Queries by Activating the Slow Query Log - 7 minutes - Lately in PHP Podcast Episode 93 Part 1 By Manuel Lemos One of the factors that may make a Web application slow is the speed of execution of database queries executed by the application back-end code.
If you optimize the database queries that are the slowest, it may make a lot of impact on the speed of an application.
The first step in optimizing the slowest database queries is to find which are the slowest queries. Using MySQL as the database server, you can find the slowest queries by activating the slow query log.
Read this article, watch a 7-minute video, or listen to part 1 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log.
How to Discover What PHP Code You Should Optimize First to Improve the Performance of a Real Web Application Using a Monitoring Tool By Manuel Lemos A profiling tool can be handy to find the parts of your application code that are slow and that you need to optimize.
If there are many parts of your application that you need to optimize, the next decision is which parts you should work to optimize first.
Fortunately, some profiling tools can help you figure out which parts of your application you need to optimize first.
Please read this short article to learn how to use the Scout Application Performance Monitoring tool to determine which parts of a Laravel or Symfony application you should optimize to achieve the most significant performance improvements sooner.
How to Update PHP Version Using Methods and Tools the PHP Community Uses - 3 minutes - Lately in PHP Podcast Episode 92 Part 10 By Manuel Lemos Every time you need to solve a problem, you may realize there may be several approaches to solve that problem. Each way has its advantages and disadvantages.
This fact shows why it is helpful to learn from other developers what approach they use to solve a problem that you also want to solve.
Read this article, watch a 3-minute video, or listen to part 10 of episode 92 of the Lately in PHP podcast to learn about other methods and tools different developers use to upgrade PHP versions.
How to Use a PHP Monitoring System with Email Notification to Verify a Version Upgrade - 3 minutes - Lately in PHP Podcast Episode 92 Part 9 By Manuel Lemos When you make changes to a site or another aspect of your site production environment, there is always a chance that some parts may not work well after you complete the changes due to unexpected consequences.
Often these consequences cause your site's PHP code to trigger errors. These errors may start appearing after you do a PHP version upgrade.
One way to determine if there were errors after you made production environment changes is to monitor PHP errors and send emails for the new PHP errors that started to appear.
Read this article, watch a 3-minute video, or listen to part 9 of episode 92 of the Lately in PHP podcast to learn how to monitor your PHP errors quickly and be notified by email, so you can fix the environment that causes the errors.
How to Verify If a PHP Version Upgrade Really Succeeded - 2 minutes - Lately in PHP Podcast Episode 92 Part 8 By Manuel Lemos Having tests to verify if a PHP version upgrade succeeded is excellent, but unfortunately, that is not enough because there are always aspects of the consequences of the version upgrade that we are not fully aware of initially.
So it is expected that some fixes may be necessary after a PHP version upgrade. Still, you may not even be aware of all the fixes you may need to do after the upgrade.
This situation is where other human beings can help you complete the quality control of the PHP version upgrade process.
Read this article, watch a 2-minute video, or listen to part 8 of episode 92 of the Lately in PHP podcast to learn how you can use the help of other human beings to assure the control of the quality of your applications after a PHP version upgrade.
The Right Order to Execute the Steps to Upgrade to a New PHP Version - 2 minutes - Lately in PHP Podcast Episode 92 Part 7 By Manuel Lemos One of the reasons why certain version upgrades went wrong is that you do the version upgrade process steps in the incorrect order.
You can determine the correct order by the more critical steps you need to do first because you can only do the following steps when you complete the crucial steps.
Read this article, watch a 2-minute video, or listen to part 7 of episode 92 of the Lately in PHP podcast to learn the correct order of the steps to perform a PHP version upgrade.
How to Test Your Application Features in Practice During a PHP Version Upgrade - 4 minutes - Lately in PHP Podcast Episode 92 Part 6 By Manuel Lemos After you have planned all the steps of a PHP version upgrade process, it is time to execute the planned steps.
Read this article, watch a 4-minute video, or listen to part 6 of episode 92 of the Lately in PHP podcast to learn how to test your application features in practice during a PHP version upgrade using reliable testing tools.
What Are Your App Features to Test First Before a PHP Version Upgrade - 3 minutes - Lately in PHP Podcast Episode 92 Part 5 By Manuel Lemos Testing a PHP application may require that you test a lot of features. Therefore you need to define the order of the features that you will test.
First, you need to define the most critical features of your PHP application to verify if they are working as expected early on in the testing process.
Read this article, watch a 3-minute video, or listen to part 5 of episode 92 of the Lately in PHP podcast to learn how to determine which are the most critical features you should test first during a PHP version upgrade testing process.
How to Setup a Development Environment to Test a PHP Version Upgrade - 3 minutes - Lately in PHP Podcast Episode 92 Part 4 By Manuel Lemos The first thing you need to do to start an upgrade of a PHP version is to set up a development environment where you can test if your application continues to work well with the new PHP version.
Read this article, watch a 3-minute video, or listen to part 4 of episode 92 of the Lately in PHP podcast to learn how to set up a machine to test if your PHP applications work as expected after the PHP upgrade version.
How to Plan a PHP Version Upgrade Successfully - 11 minutes - Lately in PHP Podcast Episode 92 Part 3 By Manuel Lemos Upgrading to a new PHP version can be a complex task that may fail due to the lack of planning on how to solve each problem of each step of the upgrading job.
Please read this article, watch an 11-minute podcast video or listen to the audio of part 3 of episode 92 of the Lately in PHP podcast to learn how to plan a PHP version upgrade process so it can conclude successfully.
When Is the Right Time to Update to a New PHP Version - 5 minutes - Lately in PHP Podcast Episode 92 Part 2 By Manuel Lemos When you consider updating your applications to use a new PHP version, many available versions are available.
Updating too soon or too late to a newer version of PHP may cause problems of instability or security in their applications.
Please read this article, watch a 5-minute podcast video or listen to the audio of part 2 of episode 92 of the Lately in PHP podcast to learn about criteria that you can use to do a safe version update.
How to Become a Better PHP Developer Listening to Quick Tips from the Lately in PHP Podcast in Spotify By Manuel Lemos Many PHP developers appreciate learning by getting quick PHP tips that do not take much time to learn and are very useful.
Nowadays, the Lately in PHP podcast aims to provide those quick tips in video, audio, or text articles.
Those who prefer the audio format can now listen to the Lately in PHP podcast on Spotify either using the mobile application or accessing the Spotify Web site.
Read this short article to learn how you can follow the Lately in PHP podcast without missing an episode on Spotify.
Why You Need to Choose the Right Moment to Upgrade to a New PHP Version - 4 minutes - Lately in PHP Podcast Episode 92 Part 1 By Manuel Lemos Every developer depends on several types of software applications to run their applications to do their work. Examples of those software applications are PHP, a database server, a Web server, and an operating system.
Newer versions of these software applications are released to improve their features and fix their bugs to benefit the community of developers that use them in their projects.
Upgrading too soon or too late to a newer version of a software tool that you need may cause problems of instability or security in their applications.
Please read this article, watch a 4-minute podcast video or listen to the audio of part 1 of episode 92 of the Lately in PHP podcast on why it is essential to carefully choose the right time to upgrade to a newer version of PHP or those software tools.
10 Pieces of PHP Developer Advice in 2022: Advice #10: How to Have a Better PHP Developer Career Learning While You Give Advice to Other Developers - 4 minutes - Lately in PHP Podcast Episode 90 Part 10 By Manuel Lemos One of the best ways to learn in practice is to help others solve their problems.
This learning method works well because when you try to solve other people's problems, you also learn more about possible solutions.
Read this article, watch a 4-minute podcast video or listen to the audio of part 10 of episode 90 of the Lately in PHP podcast on how to advise yourself and other PHP developers to evolve in your PHP developer career.
10 Pieces of PHP Developer Advice in 2022: Advice #9: How Can You Be More Productive as PHP Developers by Using Good Time Management Method and Tools - 6 minutes - Lately in PHP Podcast Episode 90 Part 9 By Manuel Lemos If you want to have an excellent quality of life, you need to spend your time doing most of the time activities that you love.
To do those activities you love, you need to plan well how you spend your time, splitting your time well between activities you do for yourself, your spouse, family, friends, and PHP developer work.
The best way to plan well how you use your time is to use good time management tools and methods.
Read this article, or watch a 6-minute podcast video or listen to the audio of part 9 of episode 90 of the Lately in PHP podcast to learn how to do good time management with suggested methods and tools.
10 Pieces of PHP Developer Advice in 2022: Advice #8: How Can You Find Compatible Partners to Collaborate on Your Business of PHP Products or Services - 6 minutes - Lately in PHP Podcast Episode 90 Part 8 By Manuel Lemos Many developers want to become business owners and sell their products or services. Some try to collaborate with partners to split the work and move on faster.
Sometimes they fight with the partner and split. This situation happens because they are not compatible with their chosen partners.
There is a means to determine if you are compatible with other people before you even start talking with other people to become a partner.
Read this article, watch a 6-minute podcast video, or listen to part 8 of episode 90 of the Lately in PHP podcast to learn how to determine if another person is compatible with you to collaborate in a successful business.
10 Pieces of PHP Developer Advice in 2022: Advice #7: How Can You Make Money Selling Better Versions of Your Open Source Software - 6 minutes - Lately in PHP Podcast Episode 90 Part 7 By Manuel Lemos Becoming a successful owner of a software company is the advice given in this podcast episode.
Many developers are employees or contractors who work for companies of other people that are business owners.
An employee works for one customer that is his employer's company.
A contractor may work for several customer companies.
A business owner may have much more customers. Therefore, the business owner can make much more money than an employee or a contractor.
Read this article, watch a 6-minute podcast video, or listen to part 7 of episode 90 of the Lately in PHP podcast to learn how to make more money by becoming an Open Source software business owner.
10 Pieces of PHP Developer Advice in 2022: Advice #6: How Can a Developer Have a Balanced Personal Life with Great Quality - 7 minutes - Lately in PHP Podcast Episode 90 Part 6 By Manuel Lemos Every need developer needs to have a good quality of life to have productive when he does his work.
To have an excellent quality of life, you need to have five kinds of love in your life. Finding these kinds of love is the advice given in part 6 of the Lately in PHP podcast episode 90.
Read this article, watch a 7-minute podcast video, or listen to this podcast episode to learn more about having an excellent quality of life.
10 Pieces of PHP Developer Advice in 2022: Advice #5: How to Find a Mentor to Learn From His Experience Faster - 8 minutes - Lately in PHP Podcast Episode 90 Part 5 By Manuel Lemos All developers should learn every day to evolve in their careers. A developer can learn by himself by practicing a lot. A faster way to evolve is to learn from another developer with more experience.
A mentor is a person that has more experience than you. So you can ask for help to learn more from a mentor.
Finding a good mentor who will help you evolve faster is the advice given in part 5 of the Lately in PHP podcast episode 90.
Read this article, watch a 4-minute podcast video, or listen to this podcast episode to learn more about finding a good mentor.
10 Pieces of PHP Developer Advice in 2022: Advice #4: Share Nice Tutorial Articles that Other Developers Want to See to Learn from You - 4 minutes - Lately in PHP Podcast Episode 90 Part 4 By Manuel Lemos Every developer needs to learn how to solve programming problems to become a better developer.
If you are good at solving a programming problem, you will be more appreciated if you share what you learned to solve that problem.
Teaching in a way that is efficient to pass your programming knowledge is a problem that you need to solve.
Many developers try to teach what they know using tutorial articles. Unfortunately, not every developer knows how to create good tutorial articles that help other developers solve the programming problems they know how to solve.
Fortunately, there is an excellent method to teach how to solve any problem. The explanation of that method is the advice given in part 4 of the Lately in PHP podcast episode 90.
Read this article, watch a 4-minute podcast video, or listen to this podcast episode to learn more about this teaching method using tutorial articles.
10 Pieces of PHP Developer Advice in 2022: Advice #3: Share Reusable Classes with Simple Documentation and Example Code - 3 minutes - Lately in PHP Podcast Episode 90 Part 3 By Manuel Lemos Sharing PHP code projects with simple examples and documentation will help you to have your project more users because users need to learn about the benefits and how to use the project before they decide to use it.
The explanation about this advice to any PHP developer is the main topic of part 3 of the Lately in PHP podcast episode 90.
Read this article, watch a 3-minute podcast video or listen to this podcast episode to learn more about the importance of using a readable and consistent coding style.
10 Pieces of PHP Developer Advice in 2022: Advice #2: Use a Readable PHP Coding Style - 3 minutes - Lately in PHP Podcast Episode 90 Part 2 By Manuel Lemos Using a PHP coding style that is readable and consistent in all your PHP projects is a significant factor in increasing the chances of your PHP Open Source project being adopted and used by other PHP developers.
The explanation about this advice to any PHP developer is the main topic of part 2 of the Lately in PHP podcast episode 90.
Read this article, watch a 3-minute podcast video or listen to this podcast episode to learn more about the importance of using a readable and consistent coding style.
10 Pieces of PHP Developer Advice in 2022: Advice #1: Be a Good Community Member Sharing Your Open Source Work in Community Sites By Manuel Lemos A few months ago, the PHP Classes site completed 22 years of existence thanks to thousands of developers of the PHP community that shared their work on the site and many hundreds of thousands of other developers that benefited from contributors' work.
While the site is getting closer to celebrating its 23rd anniversary, I am publishing a series of small articles to give ten pieces of advice on becoming a better PHP developer by following modern and efficient practices.
This article is a way that I found to retribute to you that helped make the PHP Classes site a fantastic community of PHP developers.
One type of advice is about technical practices. A different kind of advice is about your quality of life as an individual that participates in society. Other advice is about good business practices.
Read this article to learn about the more exciting advice types for you.
How to Become a PHP Hero Fulfilling the Dreams of Other Developers - 29 Minutes of the Lately in PHP Podcast Episode 89 part 5 By Manuel Lemos A hero is a person that helps others have a better life with good quality and makes it viable for them to fulfill their dreams.
Becoming a hero for other developers is one of the main topics commented on by Manuel Lemos and Mike Stowe of the NomadPHP fame in the fifth part of episode 89 of the Lately in PHP podcast.
Listen to the podcast, watch the video with manually edited subtitles in English, read the transcript to learn more about how you can become a hero to other developers.
How the PHP Classes Marketplace Will Bring More Freedom and Pleasure to Many PHP Developers - 18 Minutes of the Lately in PHP Podcast Episode 89 part 4 By Manuel Lemos The PHP Classes site Marketplace will allow many PHP developers to sell their products and services to many users who visit the site.
This way, developers may work for themselves and the customers of their products and services. They will have more freedom and pleasure to be PHP developers.
The plan for the PHP Classes marketplace is one of the main topics commented on by Manuel Lemos and Mike Stowe of the NomadPHP fame in the fourth part of episode 89 of the Lately in PHP podcast.
Listen to the podcast, watch the video with manually edited subtitles in English, read the transcript to learn more about this exciting plan for the PHP Classes marketplace.
How to Motivate Developers to Collaborate in Your PHP Projects - 29 Minutes of the Lately in PHP Podcast Episode 89 part 3 By Manuel Lemos Successful projects around Open Source technologies require a lot of collaboration between many developers.
Knowing how to motivate so many developers around a PHP-based project is one of the main topics commented on by Manuel Lemos and Mike Stowe of the NomadPHP fame in the third part of episode 89 of the Lately in PHP podcast.
Listen to the podcast, watch the video with manually edited subtitles in English, read the transcript to learn more about these exciting PHP community topics.
How to Turn an Open Source PHP Project into Your Own Business - 14 Minutes of the Lately in PHP Podcast Episode 89 part 2 By Manuel Lemos Many developers publish their work as Open Source projects to share them with many other developers.
Turning an Open Source project into a successful business is one of the main topics commented on by Manuel Lemos and Mike Stowe of the NomadPHP fame in the second part of episode 89 of the Lately in PHP podcast.
They also have commented on why they have not yet upgraded all their projects to use PHP 8.
Listen to the podcast, watch the video with manually edited subtitles in English, read the transcript to learn more about these exciting PHP community topics.
How to Manage a PHP Project that Will Have a Long Life - 10 Minutes of the Lately in PHP Podcast Episode 89 part 1 By Manuel Lemos PHP is a project started many years ago. The PHP Classes site also started a long time ago.
The secret of the long life of these projects is related to the attitude of the PHP developers that started them and many others that collaborated to its success.
The attitude of the developers that participated in these PHP projects is one of the main topics commented on by Manuel Lemos and Mike Stowe of the NomadPHP fame in the first part of episode 89 of the Lately in PHP podcast.
Listen to the podcast, watch the video with manually edited subtitles in English, read the transcript to learn more about these exciting PHP community topics.
Call For Help in Making a Better PHP Podcast By Manuel Lemos As you may be aware, recently we restarted recording new episodes of the lately in PHP podcast.
Now we want to make it better with your help. Therefore we need that you collaborate by filling a very small survey on which you tell us what questions do you have about PHP and related topics that you would like us to answer, so you can learn what you need to know to be a more successful PHP developer.
Read this small article with an explanation on how you can participate in this small survey.
Improving Your PHP 8 Function Parameters Using Trailing Commas: The Wonderful PHP 8 Features and Changes Part 6 - 8 Minutes Lately in PHP Podcast Episode 88 By Manuel Lemos PHP 8.0 introduces a new improvement that allows PHP developers to add a trailing comma to the last parameter of function calls.
Manuel Lemos and Samuel Adeshina comment specifically about the benefits of PHP 8 function parameter lists using trailing commas in the sixth part of this podcast episode.
Listen to the podcast, watch the video with manually edited subtitles in English, read the transcript to learn more about these exciting PHP 8 topics, and find where to buy the original PHP elePHPants shown in the podcast video.