Hey Dieter

I think its a fantastic idea, although this may have already been done. Alot
of work there mate. I think for praCTICAL reasons it would be better web
based as you would have more compatible users (everyone has a browser). You
will have to do some serious planning on your database. If you use a
DSN'less connection string you will be able to run the entire application
straight off a cd or hard drive without having to add any software or
applications. Just a thought. Dreamweaver has some documentation on
Connection strings, if you need any help then let me know
--
**So long, and thanks for all the fish!**





"Dieter Kedrowitsch" wrote in message
om...
I'm in the process of writing a web based Aquarium Database using PHP
as the frontend and MySQL for the DB backend and could use some input
on things that you folks think would be handy to keep in such a
database.

My goals are to keep track of my daily/weekly test results and to make
them easily available for me to look back at and search within.
Graphical charts and trend reconignition are also in the works.

After I get a basic system finished for myself, I'd like to release it
for free to the public under the GNU license and perhaps convert it
into a desktop application rather then a web based one. I prefer web
based because I have PCs all over the house (plus a DB and Web server)
and PHP it makes it easy to interface to MySQL but I know this will
be useless for most users.

So, what I'd like to know is what kind of data would you folks like to
see in such an application? This can be anything such as temperature,
pH, KH...you name it.

So far the database has four tables - Records, Tanks, Plants, and
Fish. I only own freshwater planted tanks so I have not thought about
the Marine guys but it's easy enough to add tables should they be
needed to better suit the sal****er folks.

Anyway, the Records table holds records such as pH, KH, Temp, etc.
With the data it calculates other useful stats such as CO2 (using pH
and KH). The Tanks table holds data like Take ID, Tank Name,
Description, size, type, lights, etc. Fish holds info on fish such as
Fish ID, Common Name, Scientific Name, Date Purchased, Purchase
location, current tank, medication records, etc. Same kind of info
for plants.

So anyway, what do you think? Is anyone interested in this software?
If so, please let me know what you'd like to track in the database and
I will add it! Also let me know if you prefer to have it as a desktop
app or web based app (you would need a webserver to run it on or just
install Apache and MySQL on your PC).

Thanks,
Dieter Kedrowitsch
I'm in the process of writing a web based Aquarium Database using PHP
as the frontend and MySQL for the DB backend and could use some input
on things that you folks think would be handy to keep in such a
database.

My goals are to keep track of my daily/weekly test results and to make
them easily available for me to look back at and search within.
Graphical charts and trend reconignition are also in the works.

After I get a basic system finished for myself, I'd like to release it
for free to the public under the GNU license and perhaps convert it
into a desktop application rather then a web based one. I prefer web
based because I have PCs all over the house (plus a DB and Web server)
and PHP it makes it easy to interface to MySQL but I know this will
be useless for most users.

So, what I'd like to know is what kind of data would you folks like to
see in such an application? This can be anything such as temperature,
pH, KH...you name it.

So far the database has four tables - Records, Tanks, Plants, and
Fish. I only own freshwater planted tanks so I have not thought about
the Marine guys but it's easy enough to add tables should they be
needed to better suit the sal****er folks.

Anyway, the Records table holds records such as pH, KH, Temp, etc.
With the data it calculates other useful stats such as CO2 (using pH
and KH). The Tanks table holds data like Take ID, Tank Name,
Description, size, type, lights, etc. Fish holds info on fish such as
Fish ID, Common Name, Scientific Name, Date Purchased, Purchase
location, current tank, medication records, etc. Same kind of info
for plants.

So anyway, what do you think? Is anyone interested in this software?
If so, please let me know what you'd like to track in the database and
I will add it! Also let me know if you prefer to have it as a desktop
app or web based app (you would need a webserver to run it on or just
install Apache and MySQL on your PC).

Thanks,
Dieter Kedrowitsch