#machinelearning#gamedev#python#php
Building a game bot with machine learning
One of the things I enjoy about agentic coding is being able to work on those projects that sat...
Lawrence Cooke10 min read
Articles by @mrpercival
Browse the latest writing surfaced through DevArt.
Lawrence Cooke10 min read
#webdev#design#ai
Navigating the new web design landscape
Before generative AI, websites lived and died by SEO. The goal was simple: include the right words,...
Lawrence Cooke3 min read
#ai#development#php
Elevating your agentic coding
As we move from traditional coding into agentic coding, there’s a real learning curve. To truly...
Lawrence Cooke5 min read
#development#management#webdev
The cognitive bottleneck: rethinking velocity for AI-assisted development
Moving from traditional coding to agentic coding requires a large mindset shift. As a developer,...
Lawrence Cooke6 min read
#ai#development#webdev
Setting up Claude Code for success
When first starting a new project using Claude Code, it is easy to jump ahead, diving straight into...
Lawrence Cooke8 min read
#postgres#webdev#sql#postgressql
Partial Indexes in PostgreSQL
Partial indexes are refined indexes, used to target specific access patterns. Instead of indexing...
Lawrence Cooke3 min read
#ai#php#webdev
Journey into Claude Code
Using AI in your daily development process requires a shift in how you think about writing...
Lawrence Cooke4 min read
#php#postgres#postgressql
Using TF-IDF Vectors With PHP & PostgreSQL
Vectors in PostgreSQL are used to compare data to find similarities, outliers, groupings,...
Lawrence Cooke6 min read
#postgres#postgressql#sql
How To Use Materialized Views
There are times when a query takes a long time to run. While indexes and good query design often...
Lawrence Cooke5 min read
#mysql#sql#mariadb
Optimizing SQL Queries
When writing queries, we should always take time to find the best way to write the query. Sometimes...
Lawrence Cooke5 min read
#php#beginners#flightphp#slimframework
Slim and Flight PHP Framework Comparison
Why use a micro framework? On social media, often new PHP devs ask "What framework should...
Lawrence Cooke6 min read
#developers#webdev#productivity#programmers
Web Developer Burnout
A Little Background Back when I started my web developer journey, everything was much...
Lawrence Cooke7 min read
#postgres#perl#python
Creating Custom Functions In PostgreSQL
In PostgreSQL, custom functions can be created to solve complex problems. These can be written using...
Lawrence Cooke4 min read
#postgressql#postgres#mysql#perl
Migrating from MySQL to PostgreSQL
Migrating a database from MySQL to Postgres is a challenging process. While MySQL and Postgres do a...
Lawrence Cooke8 min read
#postgres#sql#postgressql#webdev
Postgres Arrays
What are Postgres arrays? Arrays are columns that can hold multiple values. They are...
Lawrence Cooke4 min read
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...
Lawrence Cooke6 min read
#mysql
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...
Lawrence Cooke4 min read
#sql#mysql#beginners
SQL Database Index Basics
If you are just starting out on your SQL database journey, you may be wondering what indexes are and...
Lawrence Cooke10 min read
#sql#mysql#mariadb
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...
Lawrence Cooke4 min read
#sql#mysql#database#datascience
SQL Common Table Expressions and Window functions
Sometimes when writing queries for reporting purposes, the queries required to manipulate the data...
Lawrence Cooke7 min read
#sql#mysql
Using MySQL Variables
MySQL variables are a handy way to store data from a row, so that it can be used in calculations with...
Lawrence Cooke6 min read
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...
Lawrence Cooke4 min read
#php#dependencyinjection#fatfreeframework
Dependency Injection with Fat Free Framework
What is Fat Free Framework? Fat Free Framework is an easy to set up, lightweight framework...
Lawrence Cooke7 min readAdvertisement