"PHP’s prepared statements (for database access) are fantastic. Not only do they help secure your database queries, but they’re also particularly more efficient for larger products. However, there are a couple issues that appear to make these methods less flexible than we’d hope. For one, we must utilize the bind_result method, and pass in a specific number of variables. However, what happens when this code is within a class, and we won’t immediately know how many variables to pass? Luckily, there’s a solution!"

"WireIt is an open-source javascript library to create web wirable interfaces for dataflow applications, visual programming languages, graphical modeling, or graph editors."

Redis is an open-source, in-memory, key-value data store. This article goes over how new startup http://forrst.com is using Redis to store counts on likes and comments to reduce database queries in activity streams.

"An open source software involvement engine. For developers, we provide tools to demonstrate and broaden their experience and expertise in the open source community. Our vision is to make the open source community better connected, more productive, and ultimately well rewarded for its expertise."

Great little site if your looking to contribute to an open source project, but your not sure what you want to work or how to get started.

"Vimcasts publishes regular screencasts about the Vim text editor. Episodes are kept short - typically less than 5 minutes, never more than 10. The aim is to provide something in each episode that you can take away and use."

"If you’re a web developer on the go, you may sometimes find the need to test some code, fix an error, or manage remote files when you’re away from your desktop. If you have an Android device, you’re in luck, as the Market has a smattering of handy free apps that are perfect for the on-site programmer or dabbling hobbyist."

"As you build out your application, scalability will start become an issue. You will find yourself making queries to the database every page load cost you precious cpu and load time. The trick is to cache frequently used data so that a database query is not necessary, reducing the overhead on your server."

Mercurial is a modern, open source, distributed version control system, and a compelling upgrade from older systems like Subversion. In this user-friendly, six-part tutorial, Joel Spolsky teaches you the key concepts.

"Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table. In this article we will examine two models for dealing with hierarchical data in MySQL"