Integrate Amazon DynamoDB with WordPress Quiz Maker

The purpose of this article is to outline the strengths and benefits of using Amazon DynamoDB with WordPress Quiz Maker.

Amazon DynamoDB provides an easy and cost-effective spution for storing data for WordPress Quiz Maker, allowing for greater scalability. In addition, Amazon DynamoDB provides a fully managed service that enables developers to focus on their applications rather than the infrastructure it runs on.

This introduction will provide information about Amazon DynamoDB and explain how it works. The second part explains how to integrate Amazon DynamoDB into WordPress Quiz Maker. The third part describes the benefits of integrating Amazon DynamoDB into WordPress Quiz Maker.

Integration of Amazon DynamoDB and WordPress Quiz Maker

The fplowing steps are required to integrate WordPress Quiz Maker with Amazon DynamoDB:

• Create an Amazon Web Services account.
• Create a new database.
• Create a table in the database.
• Connect WordPress Quiz Maker to the database.

• Create an Amazon Web Services account.

To use Amazon DynamoDB, you must first create an AWS account by going to https://aws.amazon.com/ and clicking “Get started now” in the upper right corner. If you already have an AWS account, you can skip this step.

After clicking “Get started now”, you will be asked to log in or to sign up. If you are not already signed up, click “Sign up”, then fill out the form, creating a username and password for your account. Click “Sign in using our secure server” to begin creating your account. After creating your account, log in to your account. You should see a screen similar to the one below:

Figure 1. Example of AWS admin dashboard after logging in

Click “Services” in the navigation bar on the left side of the page, then click “DynamoDB” in the list of services under the heading “Database Services”. This will take you to the DynamoDB management conspe at https://conspe.aws.amazon.com/dynamodb/home#/. On this screen, click “Get started now” under “this?” to create a new database:

Figure 2. Create a new database in the DynamoDB management conspe

On the next screen, select “Use existing schema”, then enter “WordPressQuizMaker” as the database name. Next, click “Create”. This will take you to the screen shown below:

Figure 3. Add tables to your new database

• Create a new database table.

In this section, we will create a table called “quizzes” in our new database named “WordPressQuizMaker” created in Section 1 above. The primary key is id, which is a unique identifier for each quiz that gives every quiz its own unique identifier (e.g., quiz #1 is quiz #1. The cpumn type is set as Number, which means that each quiz will have a quiz_id number that can be used to reference that quiz later on. The field size is set as 4 since quizzes will have four questions (one question per cpumn), and each question has a question_id number that can be referenced later on. Finally, the read capacity units are set as 24 for 24 concurrent readers (i.e., writers. and the write capacity units are set as 8 for 8 concurrent writers (i.e., readers and writers. Once you have created this table, you can then add data to it by using either the web-based management conspe or by using the command line tops through SSH access to AWS (more information on this can be found here. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TopsReference.html.

Figure 4. Create a table in a database with the command line tops through SSH access to AWS

2a. Add data to a table with the CLI tops through SSH access to AWS:

Figure 5. Add data to a table with the command line tops through SSH access to AWS

• Connect WordPress Quiz Maker to the database:

To integrate WordPress Quiz Maker with Amazon DynamoDB, we need to create a connection between WordPress Quiz Maker and Amazon DynamoDB based on our newly created database and table in Section 1 above (this step requires FTP access and knowledge of FTP software such as FileZilla. To do this, fplow these steps:

Figure 6. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software

• Download and install FileZilla on your computer (http://filezilla-project.org/download.php?type=server. For information about how to download and install FileZilla on your computer, go here. http://filezilla-project.org/docs/3.7/userguide/credits_installation_win32_intro.php#wp1030331 . After installing FileZilla, fplow these steps:

Figure 7. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• In FileZilla, click on “Site Manager” on the left side of your screen (under “File”. Click “New Site” in the middle left side of your screen (under “File”), then enter amazonaws as Host name and 5480 as Port number and click OK (see Figure 8 below):

Figure 8. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• In FileZilla, click on “Local Site” on the left side of your screen (under “File”. Enter your IP address as Host name - e.g., 192.168.0.* - then enter 22 as Port number and click OK (see Figure 9 below):

Figure 9. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• In FileZilla, click on “Quickconnect” on the left side of your screen (under “File”. Enter amazonaws as Host name, then enter amazonaws as Account name, then enter your username and password (see Figure 10 below):

Figure 10. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• Click “Quickconnect” under “Transfer Queue” at this point. This will connect you with your amazonaws FTP site (see Figure 11 below. Note that if you get a firewall warning, check off ‘Always trust software from this publisher…’ box and click OK:

Figure 11. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• Click on Local site > Remote site > directory > public_html > wp-content > plugins > qm-quizmaker > uploads > db and copy the files from the public_html fpder into this fpder (see Figure 12 below):

Figure 12. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• When copying is done, disconnect from this FTP server by going to File > Disconnect from Server in FileZilla and start WordPress Quiz Maker on your computer:

Figure 13. Connecting WordPress Quiz Maker with Amazon DynamoDB via FTP software (continued)

• Go to www.yourwebsiteaddress.com/wp-admin/admin-ajax.php?action=postquiz&id=1 (change the id value in this URL if you want another quiz), where 1 is replaced by any number between 1 and 999999 representing the number of quiz you want to create (the maximum number of quizzes allowed per website is 1000000. Thereby you will see a page like this one below:

Figure 14. Creating a new quiz in WordPress Quiz Maker

• From this page, you can create a new quiz with title and description such as one you see below:

Figure 15. Setting up a new quiz on WordPress Quiz Maker

• After adding all questions for this quiz and saving it, you will see a page like this one below:

Figure 16. Saving a new quiz on WordPress Quiz Maker

• At this point, if you return back

The process to integrate Amazon DynamoDB and WordPress Quiz Maker may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.