You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Steven vanZyl dff73207fc Got the scraper working 1 month ago
public Pretty and renamed 1 month ago
views Pretty and renamed 1 month ago
.gitignore Getting started 1 month ago
Gemfile Getting started 1 month ago
Gemfile.lock Getting started 1 month ago
LICENSE Add LICENSE 1 month ago
README.md MVP with emphasis on M 1 month ago
Rakefile Got the scraper working 1 month ago
db.rb Got the scraper working 1 month ago
kitsu.rb Got the scraper working 1 month ago
main.rb Got the scraper working 1 month ago
sample.env MVP with emphasis on M 1 month ago

README.md

HowsTheDub

A simple website where users can rate the dub of anime.

Powered by Ruby and Sinatra with a PostgreSQL database.

Install dependencies with rake deps. Before that ensure that you have ruby-devel and pg_config installed.

Run with rake run and access on http://localhost:4567

Configuration is done through environment variables or through the .env file in development.

Schema

Database schema outline

shows List of shows and their dub scores

  • id: integer, unique PK
  • title: text, full show title
  • slug: text, URL slug based on title
  • tr_titles: JSON, map of language codes to alternate tr_titles
  • dub_langs: JSON, map of language codes to booleans of if there is a dub in that lanugage
  • scores: JSON, map of language codes to integer dub rating scores

votes Used to mark votes and IPs to combat spam

  • id: integer, unique PK
  • show_id: foreign key, the ID of the show this vote was for
  • ip: inet, the IP that voted for this show
  • vote_type: integer, the weight of the vote either positive or negative