Posts marked with “mysql”
SQL Windowing Functions
Structured Query Language, or SQL, was a boring, ho-hum declarative programming language for many years until the fairly recent additions of common table expressions and windowing functions. CTEs and windowing functions turn SQL into a much more robust programming language which provides increased power for your SQL queries. Most popular databases have them and as […]
Masterful Code Management – August 2018
In this issue: Xdebug, Freelancing, Parsing text, MySQL Generated Columns, Gitflow, PhpStorm, and more.
MySQL Generated Columns, Views, and Triggers
Databases often have neat features that go unnoticed or lightly used that could make your life as a developer much easier. This article started its path to print at the php[tek] 2018 conference with a discussion on generated columns in MySQL. Several attendees seemed to need extra guidance and this article is an attempt to […]
MySQL Without The SQL—Oh My!
Could you be working on a project without a database administrator to set up relational tables, indexes, and schemas? Or are you tired of embedding ugly lines of SQL in your pristine PHP code? There is new hope for you.
MySQL Without The SQL—Oh My!
Do you work on projects where you begin coding before knowing what your data looks like? Or are you part of the vast majority of developers who have had little or no training in database theory, relational calculus, Structured Query Language, or sets? Could you be working on a project without a database administrator to […]
July 2016 – Harnessing Magic
The July 2016 issue of php[architect] magazine is ready to download! Some things just work like magic This month we look at regular expressions, cryptography, PHP references, and function programming to help you demystify how they work and add them to your arsenal of solutions. Also in this issue, we look at using the Mailchimp […]
June 2016 – Decoupled by Design
The June 2016 issue of php[architect] magazine is now available! Less tightly coupled code is easier to debug and re-use. This month we look at techniques to decouple different aspects of your code: including using asynchronous & distributed workers, transducers, middleware, and secure web services. Also in this issue, we have a library to use […]
December 2015 Issue: Winter Tooling
The December issue of php[architect] magazine is now available. This month’s issue packs a variety of tools for all your project needs. In this issue, you’ll learn how to Profile your applications to identify bottlenecks, see how the FigDice engine offers a novel approach to templates, why you should be using the MySQL native driver, […]
Crystal Starting to Form
Martin Rusev is developing a new database query library for PHP 5. The project shows promise, but it has some distance to go before it competes with other available libraries.
