UAV::Pilot is a Perl library for controlling UAVs. It currently works with the Parrot AR.Drone, with plans to expand to others in the future.
The current library supports basic commands, such as takeoff, pitch, roll, yaw, vert speed, and land. All the preprogrammed flight animations are also in place.Navigation data and video are not yet supported–see the ROADMAP file for future plans.
Github repository: https://github.com/frezik/UAV-Pilot
Most DBI tutorials will show you how to use
execute(). Something like this:
my $sth = $dbh->prepare( 'INSERT INTO table (foo, bar) VALUES (?, ?)' ) or die ...;
$sth->execute( 1, 2 ) or die ...;
Most of us write DBI this way when we don't use DBIx::Class or some other abstraction layer (or we use
$dbh->do(), but it won't end up changing my point). For most databases, the above is fine.
On SQLite, you can lose data that otherwise would have gone in fine.