Basic querying of the catalog

martinatime / SuperDeDuper_archived

A program for cataloging, updating, and reducing duplicates of MP3 files

1 stars 0 forks source link

Basic querying of the catalog #10

Open martinatime opened 11 years ago

martinatime commented 11 years ago

Provide the ability for a user to query the data in the catalog database. This should provide:

the ability to determine what attributes/fields are searchable
the ability to search for values for any of the searchable fields
the ability to signify partial matches (think "LIKE" in SQL)

There will be more functionality as an enhancement.

evnjones commented 11 years ago

I'm assuming we'll want to keep the query syntax simple for the end user. Using a SQL-based datastore will require an extra translation of the entered query into an SQL statement. Using Lucene may allow us to skip the translation step and use the Lucene query language as the end user's query syntax

martinatime commented 11 years ago

Yes, the assumption is that we needed a simple way for the user to query the data with more advanced querying as an enhancement. If Lucene gives a very easy to use syntax then that is awesome. Otherwise, we would need to develop a layer in between so that simple queries are well...simple.