Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #12509 > unrolled thread
| Started by | "M. Strobel" <sorry_no_mail_here@nowhere.dee> |
|---|---|
| First post | 2014-01-02 23:11 +0100 |
| Last post | 2014-01-04 19:48 +0100 |
| Articles | 4 — 3 participants |
Back to article view | Back to comp.lang.php
thank you, richard@noreply "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2014-01-02 23:11 +0100
Re: thank you, richard@noreply richard <noreply@example.com> - 2014-01-02 20:16 -0500
Re: thank you, richard@noreply Denis McMahon <denismfmcmahon@gmail.com> - 2014-01-03 17:46 +0000
Re: thank you, richard@noreply "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2014-01-04 19:48 +0100
| From | "M. Strobel" <sorry_no_mail_here@nowhere.dee> |
|---|---|
| Date | 2014-01-02 23:11 +0100 |
| Subject | thank you, richard@noreply |
| Message-ID | <bim6flF4rm6U1@mid.uni-berlin.de> |
Most often the apparent nonsense of your questions was getting in my nerves. But today I really laughed my ass off. And youse guys keep up the good work! /Str.
[toc] | [next] | [standalone]
| From | richard <noreply@example.com> |
|---|---|
| Date | 2014-01-02 20:16 -0500 |
| Message-ID | <1wa28ss79xvi0$.1k2rg5thtarp6.dlg@40tude.net> |
| In reply to | #12509 |
On Thu, 02 Jan 2014 23:11:01 +0100, M. Strobel wrote: > Most often the apparent nonsense of your questions was getting in my nerves. > > But today I really laughed my ass off. > > And youse guys keep up the good work! > > /Str. You're welcome. I earned the title "Lord of the Bull!" quite well thank you.
[toc] | [prev] | [next] | [standalone]
| From | Denis McMahon <denismfmcmahon@gmail.com> |
|---|---|
| Date | 2014-01-03 17:46 +0000 |
| Message-ID | <la6t0o$lf9$2@dont-email.me> |
| In reply to | #12509 |
On Thu, 02 Jan 2014 23:11:01 +0100, M. Strobel wrote: > And youse guys keep up the good work! Following on, may I present: A brief comparison and examination of the differences between contemporary database theory and richardian database theory, as shown by dissecting a typical database structure according to each theory of database design. A "contemporary" events calendar database: Tables: table 'events', one record for each event: id / date / event_name / location_id (locations.id) table 'locations', one record for each location: id / name / address / phone / manager_id (people.id) table 'people', one record for each person (be they an event attendee or location manager or both): id / name / address / phone table 'attendees', one linking record for each attendee for each event they attend: event_id (events.id) / attendee_id (people.id) The "Richardian" version of the same events calendar database: table 'calendar_YYYY': One table for each calendar year with one record for each attendee for each event: Date / Event / Location / Location address / Location Phone / Location manager name / Location manager phone / Attendee name / Attendee phone / Attendee address Note especially the duplication of event and location information across multiple records where an event has multiple attendees, as well as the duplication of attendee information across multiple records where an attendee attends multiple events. Note also that if a location manager is also an event attendee, it is necessary to run multiple updates eg to change their phone detail. -- Denis McMahon, denismfmcmahon@gmail.com
[toc] | [prev] | [next] | [standalone]
| From | "M. Strobel" <sorry_no_mail_here@nowhere.dee> |
|---|---|
| Date | 2014-01-04 19:48 +0100 |
| Message-ID | <bir3ckF5obsU1@mid.uni-berlin.de> |
| In reply to | #12532 |
Am 03.01.2014 18:46, schrieb Denis McMahon: > On Thu, 02 Jan 2014 23:11:01 +0100, M. Strobel wrote: > >> And youse guys keep up the good work! > > Following on, may I present: > > A brief comparison and examination of the differences between > contemporary database theory and richardian database theory, as shown by > dissecting a typical database structure according to each theory of > database design. > > A "contemporary" events calendar database: > > Tables: > > table 'events', one record for each event: > > id / date / event_name / location_id (locations.id) > > table 'locations', one record for each location: > > id / name / address / phone / manager_id (people.id) > > table 'people', one record for each person (be they an event attendee or > location manager or both): > > id / name / address / phone > > table 'attendees', one linking record for each attendee for each event > they attend: > > event_id (events.id) / attendee_id (people.id) > > The "Richardian" version of the same events calendar database: > > table 'calendar_YYYY': One table for each calendar year with one record > for each attendee for each event: > > Date / Event / Location / Location address / Location Phone / Location > manager name / Location manager phone / Attendee name / Attendee phone / > Attendee address > > Note especially the duplication of event and location information across > multiple records where an event has multiple attendees, as well as the > duplication of attendee information across multiple records where an > attendee attends multiple events. Note also that if a location manager is > also an event attendee, it is necessary to run multiple updates eg to > change their phone detail. > Do not complain about the Richardian version. It looks like he dropped using a database, because it was too complicated, and started using hand crafted arrays instead. So there is progress. Now he should realize that he should drop that because he is making too many typing errors. There is still plain HTML. /Str.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.php
csiph-web