Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DB enhancements #103

Open
1 of 10 tasks
bgv2 opened this issue Oct 19, 2020 · 0 comments
Open
1 of 10 tasks

DB enhancements #103

bgv2 opened this issue Oct 19, 2020 · 0 comments
Labels
enhancement New feature or request

Comments

@bgv2
Copy link
Member

bgv2 commented Oct 19, 2020 •
edited
Loading

  • remove the usage column
  • create an index Create an SQLite index for faster queries #41
  • Put the database in another repo, and use NPM to link it to this repo.
  • Add a column in the DB to say who contributed the quote Add a column in the DB to say who contributed the quote #86
  • Empty new quotes.csv when the quotes are successfully added.
  • Use the norm method to make sure dots and capitalization don't matter when getting an author picture.
  • Add a second source row for stuff like the book or song the quote is from, and put "book" or "song" at the start so that the bot can replace it with an emoji.
  • last row could be "extra data" with JSON encoded data
  • categorize the quotes. A tags column could have tags separated by :
  • recreate the table so that is auto increments
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bgv2