Honestly, the easiest is Google Sheets. Tables on separate tabs, or in separate Google Sheets that are all linked and referenced using each document's Google ID.What is an easy to use relational database these days?
If you use an electronic log book, how do you handle entries that require a signature- like your annual CI and entries that need to be done for your Transponder test (and IFR certification if required)?
What is an easy to use relational database these days?
Relational Databases are just a collection of flat databases (ie. spreadsheets).
What got me thinking about it was that I create a word processing document for each maintenance or inspection activity and write out what I did while I'm doing it. Then I print it and glue it into the aircraft log. I do sign the work off in the log. I just got to thinking that the word document was the record I look up, using the computer, when I want to look back at the record of work - for example, to see when I replaced those brake pads. The little logbook just sits in the locked file cabinet. Steve
My question is in regards to aircraft log requirements in the US. Is there a similar document that records daily flight activity, or is it just a maintenance log?
Well, mostly because 90% of us aren't software developers who want to hack around to create a database interface or learn to write sql queries.For those still reading: Any database can build you whatever spreadsheet output you want. This is not true the other way around. Unless you build your spreadsheets like database tables, but why would we do that?
There's nothing magical about database tables... They're just spreadsheets with specific columns. Any set of spreadsheets can be turned into a database if desired
The integrity of the data is controlled by whatever tests you create in the database that validate the data at time of entry. That's equally possible in a spreadsheet... Cells can offer you drop-down lists of options, for example, or you can apply a formula to validate the entry in each cell.That's just not true. Database tables are integrity driven. Spreadsheets generally don't concern themselves with the integrity of the data.