Posts marked with “database”

Full-text Search with SQLite

by Jeremy Kendall · 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 Bill Karwin · December 29, 2010

The hype of 2010 was clearly NoSQL.

MySQL, PostgreSQL Release Milestones

by Bill Karwin · September 20, 2010

MySQL and PostgreSQL make promising new releases.

Zend Db 2.0 Kicks Off

by Bill Karwin · 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 Bill Karwin · 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 Marco Tabini · 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 Carl Anderson · 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.