Database Servers
One of the two or three most successful open source middleware categories, open source databases run some of the largest websites out there. These systems generally don't have the enterprise-level scalability of their larger commercial cousins, but they do the job exceptionally well.
- PostgreSQL is an object-relational database system that originally developed out of the Ingres project at UC-Berkeley. It was transformed over the years into the SQLized Postgres95 by a couple of grad students at Berkeley, then finally became PostgreSQL in 1996. It is said to be the most standards-compliant of any open source SQL implementation.
- MySQL -- Originally a quasi-commercial system, MySQL went GPL and is now probably more popular than PostgreSQL.