Home

smartTODO Wiki

Database

Entity Relationship Diagram available here:

https://dbdiagram.io/d/620711f785022f4ee57f9deb

How to set up database triggers:

https://x-team.com/blog/automatic-timestamps-with-postgresql/

API links

• Google Knowledge Graph API

  • Returns classifying information based on search terms.
  • https://developers.google.com/knowledge-graph/reference/rest/v1/
    • Can specify query types ie ProductModel, Movie, TVSeries, Book
    • No API key yet

• WolframAlpha

  • Returns tons of classifying information based on search terms
  • API Explorer https://products.wolframalpha.com/api/explorer/
    • Use options Plain Text, JSON
    • Check queryresult.datatypes
    • Good for books, movies, tv shows
    • Logan has API key