4 ms·

Maybe a silly question but what is the point of an insert-only table. Surely it must be read/used in some capacity ? Do they mean "insert heavy"?

• brianwawok 6y ago
  Means not updated. Say Www visitor logs. No reason to ever update a previous log. What happened happened.
  • PudgePacket 6y ago
    .
    • CameronNemo 6y ago
      Selects would still work. But non insert DML would be disallowed I assume (delete, update).
• blattimwind 6y ago
  Data is only inserted, not changed or deleted.
  • PudgePacket 6y ago
    .
    • 22c 6y ago
      You seem to be missing that data can still be read after it is insterted, provided it is not updated. So think if more like WORM rather than write-only.
      • deleted 6y ago
        [deleted]
    • sandGorgon 6y ago
      for compliance. you want this behavior to be enforced at the database level so that any buggy code does not edit a previous row.
      • deleted 6y ago
        [deleted]