Posts marked with “database”

MySQL Without The SQL—Oh My!

by · July 13, 2018


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.


February 2014 php[architect] Magazine Released: Databases

by · February 19, 2014


Before I got into coding I had no concept of what a database was, except that it was a place to store “data.” After reading about “tables” and “relations” I could visualize it better. Later, after working with databases for a few years, I can totally grok it. For years, relational databases were king. Now, […]


Full-text Search with SQLite

by · November 12, 2011


Full-text search with SQLite is so ridiculously easy to implement, there are only two valid reasons you haven’t done it yet. The first is you don’t need the full-text capability, and the second is you didn’t know it could be done. Here are the steps in full: Ensure full-text search is enabled (see below) Create […]


The NoSQL Hype Curve is Bending

by · December 29, 2010


The hype of 2010 was clearly NoSQL.


MySQL, PostgreSQL Release Milestones

by · September 20, 2010


MySQL and PostgreSQL make promising new releases.


Zend Db 2.0 Kicks Off

by · June 25, 2010


Ralph Schindler has started the ball rolling on requirements for Zend Db for Zend Framework 2.0.  He announced on the ZF Contributors mailing list:   Requirements have been solicited from both community members in various conversations, as well as looking through the issue tracker for feature requests that have been on the backlog due to […]


PostgreSQL 9.0 beta released

by · May 5, 2010


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?


First beta of Doctrine 2 released

by · April 28, 2010


Doctrine 2’s first beta release is out. We will take a look at how this Orm lets you almost ignore the existence of a database.


Using a framework? Why you should still learn OO and SQL

by · April 27, 2010


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.


Oracle PHP Generator

by · April 19, 2010


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