
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
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 saltwater 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 saltwater 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
| <-- __Chronological__ --> | <-- __Thread__ --> |