Lawrence Cooke articles - 16 total
Using TF-IDF Vectors With PHP & PostgreSQL
Vectors in PostgreSQL are used to compare data to find similarities, outliers, groupings,...
How To Use Materialized Views
There are times when a query takes a long time to run. While indexes and good query design often...
Optimizing SQL Queries
When writing queries, we should always take time to find the best way to write the query. Sometimes...
Slim and Flight PHP Framework Comparison
Why use a micro framework? On social media, often new PHP devs ask "What framework should...
Web Developer Burnout
A Little Background Back when I started my web developer journey, everything was much...
Creating Custom Functions In PostgreSQL
In PostgreSQL, custom functions can be created to solve complex problems. These can be written using...
Migrating from MySQL to PostgreSQL
Migrating a database from MySQL to Postgres is a challenging process. While MySQL and Postgres do a...
Postgres Arrays
What are Postgres arrays? Arrays are columns that can hold multiple values. They are...
Updating legacy code to php 8.x
When you have really old code, while it might work on php 7.4, getting it ready for php 8 is a...
Improving the performance of LIMIT,OFFSET in MySQL
When using medium or large datasets, the use of LIMIT can be a performance bottle neck. The reason...
SQL Database Index Basics
If you are just starting out on your SQL database journey, you may be wondering what indexes are and...
Finding the best SQL query for the task.
Each time we write a SQL query, we are faced with having to find a solution that solves a specific...
SQL Common Table Expressions and Window functions
Sometimes when writing queries for reporting purposes, the queries required to manipulate the data...
Using MySQL Variables
MySQL variables are a handy way to store data from a row, so that it can be used in calculations with...
Using HTMX To Solve Server Side Issues
Recently I came across an issue where users were getting error 500s on a page that was a list of...
Dependency Injection with Fat Free Framework
What is Fat Free Framework? Fat Free Framework is an easy to set up, lightweight framework...