simonw/sqlite-history

Issues

• Doesn't it actually make more sense to encode the mask as a binary blob?

  #12 opened 24 days ago by sevenrats
  0

• Document how to handle alter table

  #8 opened a year ago by simonw
  3

• Save more space by storing deltas between versions using Fossil's delta encoding algorithm?

  #11 opened a year ago by ar-jan
  1

• Functions for restoring tables or individual rows

  #4 opened a year ago by simonw
  1

• Possible to track history at arbitrary times? User-specified `_update` time

  #10 opened a year ago by etjones
  0

• Try saving space by not creating full duplicate history row until first edit

  #7 opened a year ago by simonw
  8

• Alternatives to a sequential version and optimising for UPDATE speed

  #9 opened a year ago by metamoof
  0

• Store changed timestamp in ms since the epoch, not seconds

  #6 opened a year ago by simonw
  2

• Can't handle tables with a column called "order" or other reserved words

  #2 opened a year ago by simonw
  2

• --all option confused by FTS tables

  #5 opened a year ago by simonw
  4

• Documentation should show the SQL triggers

  #3 opened a year ago by simonw
  1

• Initial design for a change tracking system for SQLite tables

  #1 opened a year ago by simonw
  40