[Fofredux-devel] Design feedback: saved searches

[Andrew T. (nilspace) <nil...@us...>]

I'm implementing the "saved searches" for FoFRedux and wanted to get
some feedback since I'm adding a database table.

There will be the following columns: id, name, search term. with a
future column perhaps for a foreign key of the user to whom the search
belongs.

The search term will be the actual php parameter string. E.g.
>> category=3D1,14,28&feed=3D8,14&term=3Dprius hack NOT breaks

this makes it very easy to use a search as it is a single DB select
and then applied directly to the URL wihtout more complex parsing of
terms each request of the search.

This may then get named: "Working Prius Hacks", An RSS feed would be
able to be gen'd or a view on this:

>> view.php?search=3D4

Also, a user can use this saved search as a basis for a new search criteria=
:
Search: free
using search: "Working Prius Hacks"

The UI will provide a user to checkbox select (or multi-select from a
list?) any categories, or feeds, and enter a complex search criteria.

Does this design seem to cover our desired features, now and for the
future (multi-users imparticular)? Should a user be able to search on
feed/item metadata (search for all items with dc:creator =3D "Bill
Gates" or geo: within bounds 50 miles of (30, -50.3)?


Andrew

--
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA