Re: [MLUG] MySQL permission/advice

[Jason Gyorog <EMAIL:PROTECTED>]

Yeah, sorry about the duplication -- I read my email out of order, so I didn't see the one contrasting it with C until
after I sent that reply.

That, and now I'm convinced that this is the 'right' way to do it in MySQL. This is just like when I first learned
Java -- I hated losing the control I had with C, and I was constantly complaining that it would lead to lazy
programmers. Then, I settled down and went with the flow : )

On Fri, Oct 03, 2003 at 11:10:05AM -0500, Ross, Matthew wrote:
> > Aha, so we don't list forward references in a comment, but 
> > rather each comment has a backward reference to its parent.
> 
> As was mentioned, this is just like C, except that its the exact opposite. A database has a fixed structure and is designed to gather data. C has no fixed structure and is designed for processing information. Rather than write a complex object for each data element, it lets you write one command that gathers the information you want in a standardized format.
> 
> > So, to build a webpage from this, we'd display the new 
> > comment (newest entry with a refers_to of 0), then search for
> > all entries that refers_to that one, then recursively do the 
> > same for each of those?
> > 
> > Doesn't sound particularly efficient, but it makes sense.
> 
> Yes. The difference between this and your C programs is that you call for the child records by the name of the parent rather than asking the parent for the names of the children then calling for them by name.
> 
> Its efficient for data storage and management. In low level programming you can allocate your own memory to whatever size you want. With a database you are dealing with structured data and have to work within your set structure. It makes data retrieval more efficient, logical, and effective. Consider if you had to guess how someone structured their C objects.
> 
> 
> _______________________________________________
> members mailing list
> EMAIL:PROTECTED
> http://mlug.missouri.edu/mailman/listinfo/members

-- 
<pre>

."".   ."",  Jason Gyorog
|  |  /  /   (573)489-3960
|  | /  /    EMAIL:PROTECTED
|  |/  ;-._  http://mlug.missouri.edu/~yoda/
}  ` _/  / ; AIM: yodaleedoo
|  /` ) /  /
| /  /_/\_/\
(  ' \ '-  |
 \    `.  /
  |      |

</pre>
_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members