in reply to Re: Re-indexing a SQL resultset by id
in thread Re-indexing a SQL resultset by id
It seems to me that your database design (or the name of the 'id' column) is broken if you have non-unique ID's.FALSE:
and now:CREATE TABLE students id PRIMARY KEY SERIAL firstname TEXT lastname TEXT ; CREATE TABLE classes id PRIMARY KEY SERIAL name text ; CREATE TABLE student_classes studentid INT classid INT ;
Will you get several instances of each id? Yes? Is the database design un-normalized? No. Conclusion. There are reasonable queries leading to multiple instances of certain fields by which one might want to collate results. In this case, I might want a hash keyed by student id and an array ref of all results with that student id. Call it "collation".SELECT * FROM student_classes;
The mantra of every experienced web application developer is the same: thou shalt separate business logic from display. Ironically, almost all template engines allow violation of this separation principle, which is the very impetus for HTML template engine development.
-- Terence Parr, "Enforcing Strict Model View Separation in Template Engines"
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Re-indexing a SQL resultset by id
by Juerd (Abbot) on Jul 09, 2011 at 23:42 UTC |
In Section
Seekers of Perl Wisdom