Push MySQL Data to an Algolia Index from the JS Client

Raphael Terrier
InstructorRaphael Terrier
Share this video with your friends

Social Share Links

Send Tweet
Published 6 years ago
Updated 5 years ago

We’ll learn how to push a small amount of data from a local MySQL database to an Algolia index. The first step is to connect to the DB using the mysql package, then select all records from the DB and finally push them to Algolia using the JS API client.

Instructor: [00:00] Another common-use case would be to push some data from a database. Here, we'll use MySQL as an example. On a MySQL server running locally, we have previously created an actors table containing 500 rows.

[00:15] The columns are mirroring our attributes from our previous example -- name, rating, imagePath, alternativeName, and ID. Now we need to connect the MySQL server. Here, we'll use the MySQL package, providing the host, user, password, and database we want to target.

[00:41] Preparing the query, select star from actors_sml. Then, we simply call the addObjects method, passing in the records fetched from our database. Heading back to the dashboard and refreshing the index, we can see that our 500 actors are there.

egghead
egghead
~ 11 minutes ago

Member comments are a way for members to communicate, interact, and ask questions about a lesson.

The instructor or someone from the community might respond to your question Here are a few basic guidelines to commenting on egghead.io

Be on-Topic

Comments are for discussing a lesson. If you're having a general issue with the website functionality, please contact us at support@egghead.io.

Avoid meta-discussion

  • This was great!
  • This was horrible!
  • I didn't like this because it didn't match my skill level.
  • +1 It will likely be deleted as spam.

Code Problems?

Should be accompanied by code! Codesandbox or Stackblitz provide a way to share code and discuss it in context

Details and Context

Vague question? Vague answer. Any details and context you can provide will lure more interesting answers!

Markdown supported.
Become a member to join the discussionEnroll Today