Autoplay

    Push MySQL Data to an Algolia Index from the JS Client

    Raphael TerrierRaphael Terrier

    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.

    algoliaAlgolia
    Code

    Code

    Become a Member to view code

    You must be a Member to view code

    Access all courses and lessons, track your progress, gain confidence and expertise.

    Become a Member
    and unlock code for this lesson
    Transcript

    Transcript

    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.

    Discuss

    Discuss