https://www.wikiworld.com/index.php?action=history&feed=atom&title=PubwanChat 2026-05-06T15:04:19Z Revision history for this page on the wiki MediaWiki 1.45.1 https://www.wikiworld.com/index.php?title=PubwanChat&diff=1949&oldid=prev 2026-01-28T11:54:25Z

<p>Imported current content</p> <p><b>New page</b></p><div><br /> ==== proposition: use symbols instead of integers as identifiers.<br /> ====<br /> <br /> I see we are using integers as identifiers for our entities. Before we get too far, there are pros and cons to using symbols instead. A symbol is a unique string. If we have a unique string we need not assign unique integers.<br /> <br /> &#039;&#039;&#039;&#039;pro&#039;&#039;&#039;&#039;: tables become readable and more easily applied with simple tools.<br /> <br /> &#039;&#039;&#039;&#039;con&#039;&#039;&#039;&#039;: symbols can imply multiple meanings, e.g. fast, fast1, fast2.<br /> <br /> &#039;&#039;&#039;&#039;con&#039;&#039;&#039;&#039;: a human must choose a unique symbol<br /> <br /> &#039;&#039;&#039;&#039;pro&#039;&#039;&#039;&#039;: a unique symbol is usually obvious.<br /> <br /> &#039;&#039;&#039;&#039;con&#039;&#039;&#039;&#039;: An unique symbol is usually a point of contention between different humans. (Numbers automatically assigned avoid this issue.)<br /> ----<br /> ==== requirement: audit trail<br /> ====<br /> <br /> We are responsible for our own backups. A complete dump of structure and data in SQL is a good backup. We can keep these virbatum on the [[PubWanBackup]] calendar.<br /> </div>

imported>Import