ok, I have a perl program that runs a mysql database running on my laptop, but want to convert it to be the only program running on a single board computer with MariaDB at runs at startup using a command in RC Local. Once I get a prototype finalized, I want to make 20-25 copies on SD cards to put on a bunch of cheap SBC's I bought on Ebay and hand out those computers at trade shows that would allow the user to insert a USB drive with their own data, which is in an industry standard fixed width format, and run it through the program that does various data checks (and has 2 static reference files that are updated once or twice a year, both in .csv format)
I was intrigued by using SQLite, but SQLite does not seem to be able to import fixed width formats like LOAD DATA INFILE inside the MariaDB DBI driver, whereas in perl, I can do a system mount command for the USB and just use a variable in the load data statement.
So SQLite seems a non-starter. Once I get the perl script finalized, What would be the recommended way to take the EmmC card and replicate it 20X onto MicroSD cards to use in other SBC's. And after copying it over, do you need to re-issue the GRANT statement afterwards to synch up the hard-coded username/password combination in the Perl Script?
In reply to Perl DBI for MariaDB v SQLite in a Single Use SBC by justin423
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |