Change is hard at first, messy in the middle, and gorgeous at the end.—Robin Sharma PHP Architect is going through change, and we hope you follow us for the adventure.

As shocking as this may be, not every team has a dedicated database administrator. I’ve never worked on a team that has had someone solely focused on making sure our queries are performant, and our tables are structured perfectly with all the forms of normalization being applied. Like many developers, I have had to learn […]

Interested in NoSQL document databases, but discouraged by a lack of a standard query language? Let’s put the SQL back in NoSQL. In this article, let’s explore how a NoSQL document database models data and how SQL can be used to query data without schemas or tables.

PostgreSQL has roughly one-quarter of the market share of MySQL, and I’d guess that PHP projects favor MySQL even more. But PostgreSQL deserves some love from the PHP community too. PostgreSQL is open source with a simpler license that’s closer to PHP’s license. As RDBMS technology, PostgreSQL has always been more advanced than MySQL. Don’t you wish MySQL supported check constraints? Sequences? Recursive queries, common table expressions, and window functions?

If you’ve only ever used a framework to do data-driven or object-oriented programming, you might not know as much as you think. Read why it’s important to learn object-oriented programming and SQL…even if your framework does all the heavy lifting for you.

Is generating a PHP application to access a database a good development process?