Selfscovery / WordPress / Live Databases

Selfscovery Live Databases

Free WordPress add-on · Version 1.0.0

A quiz built in Selfscovery from a database table shows the results saved with it. With this add-on, your WordPress site ranks the whole table each time a visitor finishes the quiz instead, so new and changed rows count straight away.

Download selfscovery-live-databases.zip

What you need

  • The Selfscovery Quizzes plugin, version 0.9.0 or newer, installed and active.
  • A MySQL 8.0.17+ or MariaDB 10.6+, Postgres, or Snowflake database your WordPress server can reach. Postgres needs PHP’s pgsql or pdo_pgsql extension; Snowflake needs PHP’s openssl extension (most hosts have both).
  • A read-only login for that database. The add-on shows the SQL to create one.

Set it up

  1. In WordPress, open Plugins → Add New Plugin → Upload Plugin, choose selfscovery-live-databases.zip, then Install Now and Activate.
  2. Open Selfscovery → Live rankings and add a login for the database, with the same database name as in the app. For Snowflake, the page makes a key for your site and shows the SQL to run once in Snowsight.
  3. In the app, turn on Live results in the quiz’s Database settings, then publish it to your site (again, if you published it before installing the add-on).

How it stays safe

  • Visitors never send SQL. The app writes the ranking when you publish, and visitors only send their answers, as query parameters.
  • Your site signs in with a separate, read-only login, stored encrypted with your site’s security keys. Nothing is sent to us.
  • If the database can’t answer within a few seconds, the quiz shows its saved results.
  • Anyone can take a published quiz, so give the login access to only the tables your quizzes use.

It’s a separate download because the WordPress.org plugin directory, where Selfscovery Quizzes is listed, doesn’t accept plugins that run database queries sent to them. Quizzes from WooCommerce stores rank live with Selfscovery Quizzes alone.

Questions

See Build a quiz from a database, or email [email protected].