Re: [sqlite] Efficient updating of arbitrary columns.

2008-10-14 Thread D. Richard Hipp
On Oct 14, 2008, at 4:26 PM, Peter van Hardenberg wrote: > Hi all, > > We're using SQLite to back the media collection in Songbird, and our > database includes a table which often has a varying set of columns > updated. At the moment, I'm using a set of prepared statements that > look like

[sqlite] Efficient updating of arbitrary columns.

2008-10-14 Thread Peter van Hardenberg
Hi all, We're using SQLite to back the media collection in Songbird, and our database includes a table which often has a varying set of columns updated. At the moment, I'm using a set of prepared statements that look like this: UPDATE table SET columnN = ? WHERE table_id = ?; I talked with