Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="azhrei_fje" data-source="post: 4294267" data-attributes="member: 12966">Methinks perhaps he didn't look closely enough. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" />  Of course, The Man has already seen this thread and responded.I'm curious about the database itself.  Will it be usable on a real computer, say a Unix/Linux server?  Or is this something that will only run on a PC?  (Obviously, I'd use the first and pass on the second. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" />)I would also be interested in the final schema for this project.  For example, in the spell header there's an entry for Level.  Will the data be free form text or perhaps a foreign key to another table?  I'm thinking of the concerns between the performance of searching a text field vs. having to update relational indexes.  Also, how do you have some spells have Effect, others having Area, and yet others with Target?  Do you create columns by those names and leave some fields with NULLs?  Or do you create two columns, one which contains the type of effect from the three listed above, and a second column which has the value?  There are definite usability/performance concerns...Just curious.</blockquote>

Verification