in reply to SQLite function .import not working

I was wondering if there is a way to use the .commands via DBI:: rather then resorting to a system call etc?
  • Comment on Re: SQLite function .import not working

Replies are listed 'Best First'.
Re^2: SQLite function .import not working
by ikegami (Patriarch) on Jun 02, 2010 at 00:59 UTC
    I believe it's possible to add driver-specific methods to DBI database handles, but no one has ported sqlite's functions.
      They're not part of sqlite, they're part of the sqlite shell program
        I know. I said sqlite, not SQLite. I said method, not SQL statement.
Re^2: SQLite function .import not working
by Anonymous Monk on Jun 02, 2010 at 00:47 UTC
    No. Those are special commands for the sqlite shell. Yes, you could rewrite the program using perl with DBI.