I'm dealing with a dataset with 200 million rows of data. Here's a simplified form of the problem I'm facing.

My current SQL (SQLite to be precise) table looks like this

```
timestamp  foo
1          251
2          459
3          147

```

I want to add a new column `bar` with values 693, 589, 289 (in that order) to get 

```
timestamp  foo  bar
1          251  693
2          459  589
3          147  289

```

Using `UPDATE table SET new_value WHERE cond` as you can imagine is terribly slow.

I am open any solution. Even those containing recreation of the database but of course if there's a magic one liner that does the job that would be good too!