It's alive!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
harrisonad
Forum Contributor
Posts: 288
Joined: Fri Oct 15, 2004 4:58 am
Location: Philippines
Contact:

It's alive!

Post by harrisonad »

One day, my coleauge and I had a simple debate about a database termilogogy, 'live'. I said that a live database is the original one, not the backup. But he wants to add that it must be used by everyone to be live.

As a background, our company got lots of databases stored and handled by MySQL Server. They usually use VB 6 to process them. But I, being their intranet programmer, set-up a MySQL to locally to their intranet server, to store transactions that is of the site's use, such as guestbooks, birthdays, and techical support. I backup this db twice a week.

In view of all these, I insists that my MySQL database is live. Am i correct? or he is?
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

I consider a live database to be the one that is used by the target audience. If I've got a development database that is a duplicate of a database used to run a website, then I would consider the database running the website to be the 'live' copy.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
AnarKy
Forum Contributor
Posts: 119
Joined: Tue Nov 02, 2004 1:49 am
Location: South Africa

Live

Post by AnarKy »

My definition of a Live DB is one which gets used by the users….
Directly or indirectly (via web interface, etc)
It does have to be in use, and must not be the backup,
but it does not have to be used bay all the users
(think of a distributed environment). :?

:idea: The data that is stored in the DB may help determine this…
Is the data test data or data duplicated exactly from another DB?
If so then it is not live!

It seems that the actual site in use, stores info into your DB directly.
If this is the case, then yours is a Live DB. Else, it is a backup DB.

Hope that helped 8)
User avatar
harrisonad
Forum Contributor
Posts: 288
Joined: Fri Oct 15, 2004 4:58 am
Location: Philippines
Contact:

Post by harrisonad »

My appreciation renders to you masters. I am enlightened by you explanation. Thanks.
Post Reply