(Russell Kay) In the jargon-laden world of IT, new terms are created as shorthand ways of referencing or discussing otherwise cumbersome phrases. One addition to the lexicon that has gained increased popularity and use is “LAMP,” which refers to a collection of free, largely open source software th
Tag: Open Source
How do I… Install, configure and integrate PHP and MySQL on Windows?
(Scott Lowe) PHP and MySQL are a powerful combination when it comes to providing dynamic content to your user base. Get the step-by-step instructions for installing and configuring these products in a Microsoft Windows environment.
Putting Open Source Development Under the Scope
(Jay Lyman) “In a large proprietary software development environment, engineers spend four to nine hours a week in meetings. … The result of all this is to pace the engineers to the plodding pace of management, so that they can stay in control of the project,” said Josh Berkus, core team member of
Creating a Login Script for a PHP/MySQL Blogging System
In this three-part tutorial we are going to be creating an open blogging system. We are also going to provide scripts that will make it possible to switch to a closed blogging system. This article, which is the first part, will cover the creation of the login scripts for a closed system.
Refactoring MySQL Cursors
(Roland Bouman) Quite a while ago, I wrote a few articles on using MySQL cursors. This time, I will try and shed some light on why cursors are often unnecessary. To illustrate that, I will refactor a typical case of cursor usage.
MySQL developing database monitoring system
(China Martens) Developers at open-source player MySQL are set to make it easier for customers to manage the software. The company is working on a project code-named “Merlin” which continually scans a user’s database network for any likely system crashes, bottlenecks or security vulnerabilities.
BBC News Website uses MySQL to Monitor Reader Interest
Millions of people every day visit the BBC News website for their daily fix of world news and analysis. Stories from hundreds of dedicated journalists in all time zones are constantly being fed to the site, which currently attracts 35 million unique users and receives over 800 million page impressio
Pros and Cons of Descriptive Foreign Keys?
(Sheeri Kritzer) So what are the pros and cons of using descriptive foreign keys, as opposed to surrogate keys?
MySQL drops support for BerkeleyDB
(Eric Lai) Open-source database maker MySQL AB has quietly dropped support for BerkeleyDB, the embedable database Oracle acquired in February.
Open source databases taking over
(Matt Asay) Zack Urlocker is at the Gartner Open Source Summit this week, and has been hearing some good things about open source databases. Open source databases (Sleepycat, PostgreSQL, MySQL, etc.) have been around for a long time, but the analysts didn’t give them much credit because even though