[Hpr] Community news and many-to-many db relationships
Hello list. I am sending this to the list as an easier way to include Dave and Ken and because it might amuse others. I haven't been party to the 'discussions' between Dave and Ken about database strategies other than some remarks in past community news 'casts in which Ken mentioned many-to-many relationships. I have to say I think from Ken's remarks in the latest community news 'cast that Dave is probably right and Ken's description of comma-seperated fields in tables sound like enough to make Mr Codd spin in his grave. With this in mind I am going to turn the email I sent to Ken into a podcast. I will use SQLite as an RDBMS as it's the world's most used system of that ilk, and the easiest to set up and run. I'll also use Perl to automate some of the table definitions, data insertion and extraction etc. It sounds like I might have to split it into more than one show, the first to define some stuff and explain about SQLite, subsequent show(s) to talk about many-to-many, entity relationship diagrams etc. Now I have to go and have a lie down after hearing mention of comma-seperated data in table columns, yuck. Mike Ray -- Michael A. Ray Analyst/Programmer Witley, Surrey, South-east UK The box said: 'install Windows XP, 7 or better'. So I installed Linux Interested in accessibility on the Raspberry Pi? Visit: http://www.raspberryvi.org/ From where you can join our mailing list for visually-impaired Pi hackers ___ Hpr mailing list Hpr@hackerpublicradio.org http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
Re: [Hpr] Community news and many-to-many db relationships
On 7/7/2014 2:20 PM, Mike Ray wrote: Hello list. I am sending this to the list as an easier way to include Dave and Ken and because it might amuse others. I haven't been party to the 'discussions' between Dave and Ken about database strategies other than some remarks in past community news 'casts in which Ken mentioned many-to-many relationships. I have to say I think from Ken's remarks in the latest community news 'cast that Dave is probably right and Ken's description of comma-seperated fields in tables sound like enough to make Mr Codd spin in his grave. With this in mind I am going to turn the email I sent to Ken into a podcast. I will use SQLite as an RDBMS as it's the world's most used system of that ilk, and the easiest to set up and run. I'll also use Perl to automate some of the table definitions, data insertion and extraction etc. It sounds like I might have to split it into more than one show, the first to define some stuff and explain about SQLite, subsequent show(s) to talk about many-to-many, entity relationship diagrams etc. Now I have to go and have a lie down after hearing mention of comma-seperated data in table columns, yuck. Mike Ray Mike, please do. This is exactly what HPR is about. I wouldn't mind if it turned into a series on databases. Regards, -- Kevin B. O'Brien zwil...@zwilnik.com If there are no dogs in Heaven, then when I die I want to go where they went. -- Will Rogers ___ Hpr mailing list Hpr@hackerpublicradio.org http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
[Hpr] Orca
Just a quick heads-up...Jonathan Nadau didn't write Orca. http://en.wikipedia.org/wiki/Orca_%28assistive_technology%29 Currently the project is led by Joan-Marie Diggs. Not another person who is in the habit of using the adjectives 'alpha' and 'stable' in the same sentence. -- Michael A. Ray Analyst/Programmer Witley, Surrey, South-east UK The box said: 'install Windows XP, 7 or better'. So I installed Linux Interested in accessibility on the Raspberry Pi? Visit: http://www.raspberryvi.org/ From where you can join our mailing list for visually-impaired Pi hackers ___ Hpr mailing list Hpr@hackerpublicradio.org http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
