Our extensions require a minimum of Joomla 3.7.0 and we test all our extensions with the latest versions of Joomla as they become available. If you use an older version of Joomla 3 we can provide older versions of our paid extensions on request. We no longer supply versions for Joomla 2.5.
We recommend that you keep your site up to date with the latest version of Joomla. From time to time security issues emerge, and sites that are not updated may be attacked once details of the problem are published. In general you can assume that our extensions work on new releases of Joomla, but if your site is critical to your business you should have a test site where you can test upgrades before implementing them in your live site.
There's a useful table of Joomla versions and support dates at http://docs.joomla.org/Joomla!_CMS_versions
All of our extensions have been fully tested and work well in the Joomla 4 Beta versions. We test with the latest Beta releases as they become available and apply fixes as needed. As yet there is still no firm release date for Joomla 4. The Joomla Project Roadmap has more information.
We develop and test our extensions on PHP 7.4 and 8.0. We will try to maintain compatibility with PHP 5.6 for as long as possible, but we no longer test on it.
By now you really should be using PHP 7. Sites run faster with PHP 7, and Joomla 4 requires it. All of our extensions also work with PHP 8, but we think it's still too soon to use PHP 8 on a live site because many other extensions have not yet been tested with it.
There's a useful table of PHP versions and support dates at https://www.php.net/eol.php
Our extensions run with MySql and MariaDB. We do not test on SQL Server or PostgreSQL, and we don't allow our extensions to install on them.
Joomla 4 has dropped support for SQL Server, and we expect Joomla to eventually drop support for PostgreSQL.