Data Table Block

Allow users to search and filter your data

Why add a data table block?

Not all data is sensitive. Perhaps your website is a resource for the public and you want to share data with other people, or maybe you want to share research or figures with your web visitors as part of your content marketing strategy. FortressDB blocks offer a convenient way of doing this.

It takes less than a minute to add a block to your page. The FortressDB plugin gives you full control of who, if anyone, can view the data in the block on your website. This control also extends to creating, updating or deleting the block in the back end.

Your block will only show data if the user has the correct role, and you can choose the “Not logged in” option for data you want to display to all web visitors and are happy letting the general public read.

Million rows example

Try out our Million Rows Demo to see how the data table block allows users to search large data sets quickly and easily. This includes compound searches, for example, filtering by both country and age fields.

We suspect that one million rows of data is far more than you’ll need for most projects, but FortressDB can manage vast and complex data sets, giving you the capacity to scale up to many millions of rows if you want to!

These are the block settings used to generate this table.

Is FortressDB fast?

FortressDB is optimized for speed and works incredibly fast. Your web visitors and users won’t need to wait around to interact with our blocks. FortressDB plays much the same role as a CDN, but instead of serving images or videos to web visitors, FortressDB serves data, fast.

Data structure

More efficient than traditional CPTs or ACFs, FortressDB uses a superior infrastructure compared with the WordPress database design.

In WordPress, whether you are working with blog posts, pages, media, categories or custom posts types, WordPress stores all content as posts. This creates bloated tables with lots of joins – effectively cross-referencing within the same table – which slows performance in WordPress sites.

FortressDB solves this problem by storing each new form or data table as a separate entity, and the result brings much faster performance.

Adding a data table block

It’s easy to add a data table block to a WordPress website. In the Gutenberg editor, simply search for “FortressDB” and select the data table block. There are 3 settings:

  1. Select which table you want to search
  2. Select how many rows per page
  3. Optionally, select or deselect which fields you want to show

Read more: Help docs for adding a data block