A foreign data wrapper is an extension available in PostgreSQL that allows you to access a table or schema in one database from another. Foreign data wrappers can serve all sorts of purposes:
For this example, we’ll use the databases
foreigndb. I want to access a table
postgres=# \lList of databasesName…
Using movie metadata to find thematically-linked films with natural language processing.
Click here to read part 1, which deals with popularity recommenders.
Have you ever browsed a website that’s recommended something to you? Whether it’s Facebook suggesting you add someone as a friend, Amazon proclaiming that they think you’ll enjoy a specific product, or Hulu suggesting a new TV show, recommender systems are widely used by websites to drive traffic and sales.
Recommender systems. What are they, and why should you care?
Well, it turns out, everywhere uses recommender systems these days. The New York Times, Reddit, YouTube, and Amazon (to name a few) all make use of these systems in various ways to drive traffic and sales, and bring you, the user, what you’re looking for.
When people think of movie recommenders, they’ll most frequently think about Netflix, whose algorithm is such to keep users coming back again and again to watch new and exciting things.
I decided to make my own recommender system, so that I could recommend myself new…
Backend developer (Go, Python, SQL) and data engineer, who is learning all the time.