SQuaLe provides an easy and very fast way to send SQL queries to a database backend. It supports load balancing over multiple connections which can be on different servers. It's very stable and provides statistics, control, and reporting through specific orders (like starting up a connection pool, shutting it down, getting statistics from that specific pool or for the whole SQuaLe instance).
| Tags | Database |
|---|---|
| Licenses | GPL |
| Operating Systems | POSIX Linux |
| Implementation | C PHP |
Recent releases


Changes: Wrong handling of GIOChannels refcounting that triggered random memory corruptions and crashes on the long run were fixed. The behavior of client timeout was fixed to correctly remove a client that connects and doesn't send an order. Upgrading is recommended, as this release is very stable.


Changes: A new communication system between the main thread and database workers has been implemented. This improvement drastically reduces the assignation time of jobs to the workers from several milliseconds to almost zero milliseconds. This is a major improvement, so upgrade is recommended.


Changes: This release fixes a connection cycling bug, some internationalization problems with Oracle with NLS_LANG being set, and support for x86_64 platforms.


Changes: This release includes a major rework of the main thread tasks. It provides a huge optimisation regarding CPU cycles consumption. It should take far less CPU than any previous release. Upgrading is seriously encouraged. This release includes support for resultset, with warning messages available for Oracle and PostgreSQL.


Changes: This release implements large file support so that the log file can grow bigger than 2GB on systems that can support it. There are documentation updates for squale-run and random cleanups in the contrib source code.