Limitations

Please read this before you start.

• Premium Data Services & WAFs: Premium data services do not work behind the Sucuri WAF. We attempted to contact Sucuri but did not receive a response. This limitation may also apply to other security tools. Please contact us if you have any questions.
• Server IP Address: Your server's IP address must be registered to your license. This service is not available for local IP addresses.
• Encryption: Communication between your WordPress server and our data server is encrypted. However, you are responsible for encrypting the connection between your server and your own database. Contact us if you need assistance.
• Connection Delay: Connecting to our data (proxy) server may introduce a delay. The duration depends on your server's location, and a remote database connection can add further delay. You must determine if the delay is acceptable for your use case.
• Performance Tip: To improve performance, you can use the Data Explorer to copy a remote table (from either a remote database or a data file) to your local WordPress database. This is a paid feature. Note that copied tables are not automatically updated.
• Text Columns: Text columns are truncated after 1024 characters.

Remote Database Connection Limitations

• Data Type Conversion: Remote data types not available in MariaDB/MySQL are automatically converted. Please verify your column data types before setting up updates.
• Primary Keys: Tables are created on our data server without a primary key, as remote primary keys are not recognized. You must add a primary key manually (using the Query Builder or Data Designer) to enable transactions.

Remote Data File Limitations (CSV, JSON, XML)

• Automatic Table Creation: Tables are created automatically by inferring column data types and lengths from your data file. If an update interval is enabled and new data exceeds the defined column length, the update will fail. You will be notified via the plugin dashboard and/or email. To resolve this, you may need to recreate the table or modify the column's length (using the Query Builder or Data Designer).
• Primary Keys & Indexes:
  • For tables created from CSV files, you can add a primary key or unique index to enable transaction support (insert, update, delete). Changes cannot be written back to the original remote CSV file.
  • Do not create primary keys or indexes on tables created from JSON or XML files, as this will cause errors.