BatCave: Database Installation


Installing the BatCave SQL Tables

There are two primary databases that are used in the BatCave.  One database collects the real-time data from the Alfred and alfserver processes.  A second database contains the SQL queries to access this data and HTML templates to display the data.

Installing the Batcave tables on a MySQL server

NOTE:  A basic understanding of MySQL database administration is expected to be able to set up the BatCave.  Information on database administration can be found online at the MySQL website: http://dev.mysql.com/doc/mysql/en/mysql-database-administration.html.  

It is assumed that you have already chosen a database server, and have installed MySQL server.  The BatCave should work with any MySQL version from 4.1 on, but has been tested more extensively with MySQL version 4.1.7. 


Installing the Batcave tables on a PostgreSQL server

NOTE:  A basic understanding of PostgreSQL database administration is expected to be able to set up the BatCave.  Information on database administration can be found online at the PostgreSQL website: http://www.postgresql.org/docs/7.4/interactive/admin.html.  

It is assumed that you have already chosen a database server, and have installed PostgreSQL server.  The BatCave should work with any PostgreSQL version from 7.4 on, but has been tested more extensively with version 7.4.12. 

 


 

Pixar Animation Studios
(510) 752-3000 (voice)   (510) 752-3151 (fax)
Copyright © 1996- Pixar. All rights reserved.
RenderMan® is a registered trademark of Pixar.