Thoughts, tutorials, and insights on software development.
This is the tiniest SQL query builder implemented as a single function. It pads spaces automatically and produces pure SQL with no new syntax.
List of paper sizes including ISO 216 standard sizes and common envelope sizes with dimensions in points.
Flow-based programming (FBP) is a programming paradigm that defines applications as networks of black box processes, which exchange data across predefined connections. Here is a comprehensive list of resources.
Wordpress is great for starting and quickly prototyping websites. Once the website gets established though, Wordpress is not a good fit. Here are the benefits of moving to Laravel.
MySQL 5.7 introduced more advanced support for timestamps. Here is how to update timestamp fields when migrating from MySQL 5.6 to 5.7 in Laravel.
The latest MySQL 5.7.1 install without prompting for root password on Ubuntu 18.04 server. Here is how to change the MySQL root password manually.
Here is how to manually check if a password validates against specific business rules in .NET using regular expressions.
There are now multiple options to store files in the cloud - Amazon S3, Google Cloud Storage, Microsoft Azure Blob Storage, DigitalOcean Spaces. Here is a pricing comparison.
Here is a small yet cute configuration function for PHP projects. It allows you to access configuration variables via dot notation with optional default values.
Its the first half of 2018 but we can see a lot of development in the prices of virtual private servers. The main one being DigitalOcean going back on top and eating the competition by slashing their prices in half.
Transactions are vital part of modern databases. Here is how to use transactions in .NET Entity Framework 6 and above.
Here are some handy JavaScript functions to filter Arrays in SQL-like fashion, including selectOne and selectWhere methods.
