#Psequel gui windows code#
The bundled rootkit_detector addon is hard-coded to MySQL (this is developed for experts and bakes in assumption of mysqli due to running outside of Composr the code can be customised to other backends as required).We only do minimum version check for MySQL (MySQL is the only serious database backend that tends to not support basic stuff until recent versions!).
#Psequel gui windows how to#
The database repair cleanup tool is only for MySQL (we use this to help test our upgrade code works perfectly, or to make it easier for 3rd-party developers who don't know how to correctly code to our database meta-system it is not required and SQL structure dump comparison will work as a substitute in most cases).Documentation is written with MySQL in mind, particularly tutorials relating to installation, performance, and maintenance (however experienced system/database administrators will be able to adapt instructions to the systems they use without too much trouble).Commandr-fs feature for listing when tables were last updated is only for MySQL (other database backends tend to not provide last-updated timestamps for tables).Certain esoteric performance optimisations for certain cases of large amounts of data are only for MySQL (the MySQL support is heavily optimised for a wide range of high load scenarios similar Postgres optimisations will be made as client requirements come up).Some non-bundled addons marked as requiring MySQL (at the time of writing nothing significant).Automatic database creation when installing, if installing using a MySQL admin account.The following parts of our ecosystem are MySQL-specific: Usage is likely of most interest to technical organisations that are standardising on Postgres. It is much more sophisticated than MySQL, although it also tends to be stricter in a number of ways, more technical, and not as available on shared hosting. Postgres is a very high quality Open Source database backend developed by developers working for a number of different companies. We expect in practice Postgres 8.4+ is supported (we use subquery string joining in 8.4 as an alternative to MySQL's GROUP_CONCAT function). We tested on Postgres 9.6.3 across our whole test set and all screens and blocks, with both multi-lang-content on and off. Postgres has been tested for Composr v10.0.x under a commercial relationship (starting with 10.0.5). Inside a commercial relationship whatever extra testing and bug fixing is required will be done under that relationship, and fixes put back into the mainline version of Composr. Different database systems vary in all kinds of surprising and subtle ways. However officially only MySQL is supported outside of a commercial relationship, due to the significant effort testing across new versions of Composr and the database backends involved. This tutorial provides some advice targeted towards PostgreSQL (also known simply as 'Postgres').Ĭomposr has internal 'support' for many different databases backends and is intentionally written with a combination of simple common-denominator SQL and use of an abstraction API.
0 kommentar(er)
