[tahoe-lafs-trac-stream] [tahoe-lafs] #1864: turn off the AUTOINCREMENT feature in our use of sqlite?

[tahoe-lafs]

#1864: turn off the AUTOINCREMENT feature in our use of sqlite?
-------------------------+-------------------------------------------------
     Reporter:  zooko    |      Owner:  zooko
         Type:           |     Status:  new
  enhancement            |  Milestone:  1.11.0
     Priority:  normal   |    Version:  1.9.2
    Component:  code-    |   Keywords:  sqlite design-review-needed leasedb
  storage                |
   Resolution:           |
Launchpad Bug:           |
-------------------------+-------------------------------------------------

Comment (by zooko):

 Replying to [comment:12 warner]:
 > Yeah, sounds good to me. I was unaware of this feature when I first
 wrote that schema. Let's also double-check that none of the SQL commands
 that insert rows are providing a value for `fileid`.

 Confirmed: I inspected and the {{{fileid}}} always comes from
 [source:trunk/src/allmydata/scripts/backupdb.py?annotate=blame&rev=a1a1b5bf8a6e1a09c70d4d2b618ad0c06b0f631f#L242
 get_or_allocate_fileid_for_cap()], so sqlite always creates the
 {{{fileid}}} value.

-- 
Ticket URL: <https://tahoe-lafs.org/trac/tahoe-lafs/ticket/1864#comment:13>
tahoe-lafs <https://tahoe-lafs.org>
secure decentralized storage