Dieter Kedrowitsch
November 24th 03, 08:07 PM
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
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