Re^3: CGI.pm: Want your query_string() sorted or unsorted?


The stupid question is the question not asked
	PerlMonks

Re^3: CGI.pm: Want your query_string() sorted or unsorted?

by JavaFan (Canon)

on Aug 13, 2009 at 11:53 UTC ( #788251=note: print w/replies, xml )

Need Help??

in reply to Re^2: CGI.pm: Want your query_string() sorted or unsorted?
in thread CGI.pm: Want your query_string() sorted or unsorted?

I'm recalling that the other piece of wanting this is that the query strings will stored in a database column, and I want them in a canonical form for that, so that two identical queries in a different order will be represented the same.

That sounds like a database design disaster. Why not store the individual items of the query string as columns?

Comment on Re^3: CGI.pm: Want your query_string() sorted or unsorted?

Replies are listed 'Best First'.
Re^4: CGI.pm: Want your query_string() sorted or unsorted? by dolmen (Beadle) on Aug 13, 2009 at 12:26 UTC
Storing query string as a key is useful if you are using a database to reply smartly with HTTP status 301/302/307 (redirect) or 407s (gone) instead of bare 404s (not found).	[reply]
Re^4: CGI.pm: Want your query_string() sorted or unsorted? by markjugg (Curate) on Aug 13, 2009 at 22:09 UTC
In this case, the query string represents a "saved search", and the design has worked fairly well over time. One complication here is that some of the search values have multiple keys. If we were to use Codd's third normal form, we wouldn't have just one row per search, but a whole collection of table rows. There are definitely other cases and future cases where I could consider putting each search value it's own database column. Mark Stosberg	[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://788251]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others drinking their drinks and smoking their pipes about the Monastery: (1)

As of 2023-06-05 04:04 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?