Using SQLite with Tcl - Updates

Page 16 of 41
[prev] [next]

The naive way to insert data is to build an SQL statement manually

  set fd [open bigfile.txt]
  set content [read $fd]
  close $fd
  set qcontent [string map {' ''} $content]
  db eval "INSERT INTO t1 VALUES(1,2,'$qcontent')"

Error prone - lots of syntax to get right

Requires copying the content multiple times

Does not work if the content contains \000