search

amusselm / rvgs_gamelist

A web app to keep track of the Reno Video Game Symphoy's Game Quest
2 stars 0 forks source link

Full text search for games #27

Open amusselm opened 9 years ago

amusselm commented 9 years ago

It would be nice if users could search for a game by it's title.

snoogans775 commented 8 years ago
  1. to retain the id of the games, as well as any other values which traces back to the user that made the list, the search function could be a loop which checks through an array of all the arrays containing game values. This array could be useful for any search based on platform/user/other info
  2. I have made a PHP mockup which relates all lists in a database to IGDB.com by title, running several checks for misspellings, capitalization errors, etc. it does not work but when it does it will be pretty cool. Does django store values in a database or in arrays? If database, then it would be super easy to migrate the code over.
amusselm commented 8 years ago

It's stored in a database. PostgreSQL has functionality to index things for text searching.

If you'd like, I can dump the production database from my server as a bunch of SQL statements for your use.

On Mon, Mar 14, 2016 at 3:26 AM, snoogans775 notifications@github.com wrote:

1.

to retain the id of the games, as well as any other values which traces back to the user that made the list, the search function could be a loop which checks through an array of all the arrays containing game values. This array could be useful for any search based on platform/user/other info 2.

I have made a PHP mockup which relates all lists in a database to IGDB.com by title, ding several checks for misspellings, capitalization errors, etc. it does not work but when it does it will be pretty cool. Does django store values in a database or in arrays? If database, then it would be super easy to migrate the code over.

— Reply to this email directly or view it on GitHub https://github.com/amusselm/rvgs_gamelist/issues/27#issuecomment-196243455 .