Apache is a free and open-source cross-platform web server software.
SPIP is a content management system written in PHP that uses one or more databases like SQL, SQLite or PostgreSQL.
Varnish is a reverse caching proxy.