Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re^4: Want your query_string() sorted or unsorted?

by markjugg (Curate)
on Aug 13, 2009 at 22:09 UTC ( [id://788455]=note: print w/replies, xml ) Need Help??

in reply to Re^3: Want your query_string() sorted or unsorted?
in thread Want your query_string() sorted or unsorted?

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.

  • Comment on Re^4: Want your query_string() sorted or unsorted?

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://788455]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (3)
As of 2024-07-25 15:04 GMT
Find Nodes?
    Voting Booth?

    No recent polls found

    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.