[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
[phoenix-dev] Data driven content on www.eclipse.org
|
Committers,
Nathan and Wayne requested I set up a MySQL database so they can have
data-driven web pages. There is already some database access,
particularly in the downloads area, where the mirror pages are generated
from MySQL data.
We'll be expanding the database schema so that the data that I have
(project lists, country codes, etc..) can be used by your pages, and
expanded upon as needed.
To do this, here's what needs to happen:
- Local, Test and Live database environments: when testing pages in
Eclipse, your pages will connect to a local MySQL database that you need
to install. We will need to standardize on a database name. On the
server side, I will set up a test database that will be used when your
PHP pages are on phoenix.eclipse.org. The live database is already
there, and will be used when your pages are running from www.eclipse.org.
- Smart connection objects: Wayne and Nathan will develop an
eclipse.org-common class that will detect whether to use the local
database server, or the test/live server. You'll need to include() this
file to use the databases. Wayne, Nathan, can you please open a bug for
this?
- an E/R diagram. Matt and I will act as "database admins" and we'll
maintain entity/relationship diagrams of the database. When you want to
add tables or modify existing ones, get our approval by sending the
ALTER TABLE, CREATE TABLE and DROP TABLE statements to the phoenix-dev
list. We'll make sure everything jives in the big picture.
For security purposes, the database connection information is stored
outside of CVS, so none of us need to specify the username, password,
server or even which database (schema) to use. Also, to prevent
non-phoenix committers from accessing the database, the connection
object uses a trusted path mechanism which requires you to tell me
*where* your data-driven pages run from.
Once all this is set up, we'll prepare some sample code that explains
how to work with the database.
Am I missing anything?
D.
--
Denis Roy
Manager, IT Infrastructure
Eclipse Foundation, Inc.
Office: 613.224.9461 x224
Cell: 819.210.6481
denis.roy@xxxxxxxxxxx
