in reply to DBI Sqlite create table dynamically

As an aside, also be aware of the BobbyTables potential if the array is populated from a potentially uncontrolled source.

--MidLifeXis

  • Comment on Re: DBI Sqlite create table dynamically

Replies are listed 'Best First'.
Re^2: DBI Sqlite create table dynamically
by dsheroh (Monsignor) on May 06, 2017 at 09:06 UTC
    Note that choroba's posted code uses $dbh->quote_identifier on the column names which should cover that concern.

    (The truly paranoid - and this is a case where being paranoid is generally a good thing! - may wish to also do their own checks on the column names, but it shouldn't be necessary unless DBD::SQLite's quote_identifier has a major bug which has somehow gone undiscovered.)

Re^2: DBI Sqlite create table dynamically
by Anonymous Monk on May 05, 2017 at 21:23 UTC
    Further advices, always look both ways when crossing the street.