Support for Oracle, SQLServer and PostgreSQL

PHsPeed is continuous improving the support for databases.

As of version 1.0.6 we have tested the implementation of Oracle, SQLServer and PostgreSQL sucessfully. It is amazing to see how 'standards' are open for 'interpretation'. Every database supplier has their own set of 'features' to enhance SQL, or to perform certain tasks, like limit the resultset, or skip a certain amount of records. In PHsPeed we cache the resultset in an SQLite database to overcome issues like these and to allow a bi-directional cursor. An additional advantage is that it reduces IO on systems where the database does not reside on the webserver. Where applicable, you can disable this behaviour in the components. In master-detail relationships, the caching is set off by default for the detail dataset.

To test the database implementations, we use the developer editions of the several databases. We run them in a virtual environment so that we can simulate different happenings. But it remains a developer edition. As there are many, many ways of configuring databases, it is impossible to test them all, and it is very well likely that you need to 'fiddle' a bit with the settings to get things running. I.e. for Oracle, you can use a very simple connection string if the database is on the same system as PHsPeed. But when the database is remote, you need to connect to an Oracle client using the complex tns names. Of course, if you are in an Oracle situation, you probabely are working in an enterprise environment where all the required knowledge is available.

Important to know is that we are always prepared to help you to come around certain database installation issues, but that we cannot guarantee that we will always be able to help you out on this. Simply because we do not know your environment and you can't expect from us to dive into each and every detail. So if you are not able to connect PHsPeed to your database, or the PDO is not functioning, then try to create a small PDO based PHP application to connect to your database. If you cannot, then seek the internet for solutions, as we will not be able to help you. But if you can, then it is likely that there is an issue in PHsPeed that we certainly want to fix.

Basic setup of the supported databases is documented on our wiki. If you have additional info, then please let us know and we will update the documentation.

Happy coding!

03 Nov 2020 Blog None