http://www23.brinkster.com/pilotlogbook/index.htm
I’ve begun to create a web based electronic logbook. Right now I’m using a Microsoft Access database and ASP pages for the front end. Everything is more or less functional at this point. It is a relational database so there are database rules. For example, if you enter in the airplane N12345 and have it stored as the airplane used in a flight then you can’t remove the airplane without removing the flight. That will make sense to computer people! Some of the error handling with respect to these rules is not pretty yet. I also have not built the tools for querying the database to get customized report. That’s a simple process but I want to make sure I’m storing the data in a logical way before I start that. I pulled some aircraft types and airports from FAA databases. Add some if you want, in the final version I’ll likely include all airports in the US and all planes in the FAA’s database at DUATS.
What I’d like is some input from pilots on the information being stored (I did not accommodate gliders / seaplanes) it’s easy to add in later. Go ahead and enter in some data and take a look. Please don’t try and intentionally mess up the application! It IS NOT intended to be secure at this point. Security is something I’ll add in later on. You will not prove anything by hacking the logbook. I'll just take it down, keep it to myself and you'll get bad karma.
Of course I’m happy to provide all the code to anybody who wants it. Post a public message here and I’ll zip the files and make a link to them on the site.
I’ll skip posting instructions on using it as I think it’s relatively intuitive and hopefully you guys will be able to make sense of the menus.
If its something everyone likes I may also make it a multi-user application so folks can use it for free and perhaps I’ll find a pilot site to host it for free.
http://www23.brinkster.com/pilotlogbook/index.htm
I’ve begun to create a web based electronic logbook. Right now I’m using a Microsoft Access database and ASP pages for the front end. Everything is more or less functional at this point. It is a relational database so there are database rules. For example, if you enter in the airplane N12345 and have it stored as the airplane used in a flight then you can’t remove the airplane without removing the flight. That will make sense to computer people! Some of the error handling with respect to these rules is not pretty yet. I also have not built the tools for querying the database to get customized report. That’s a simple process but I want to make sure I’m storing the data in a logical way before I start that. I pulled some aircraft types and airports from FAA databases. Add some if you want, in the final version I’ll likely include all airports in the US and all planes in the FAA’s database at DUATS.
What I’d like is some input from pilots on the information being stored (I did not accommodate gliders / seaplanes) it’s easy to add in later. Go ahead and enter in some data and take a look. Please don’t try and intentionally mess up the application! It IS NOT intended to be secure at this point. Security is something I’ll add in later on. You will not prove anything by hacking the logbook. I'll just take it down, keep it to myself and you'll get bad karma.
Of course I’m happy to provide all the code to anybody who wants it. Post a public message here and I’ll zip the files and make a link to them on the site.
I’ll skip posting instructions on using it as I think it’s relatively intuitive and hopefully you guys will be able to make sense of the menus.
If its something everyone likes I may also make it a multi-user application so folks can use it for free and perhaps I’ll find a pilot site to host it for free.
http://www23.brinkster.com/pilotlogbook/index.htm
