Modified PostgreSQL with Babelfish extensions packaged for Windows and Linux.
Link to documentation.
2024-07-29
WiltonDB 3.3 update (version 11.15.1) is released for Windows and Linux.
Bugfixes:
CHECK CONSTRAINTS
hint support with bcp and related fixes (#2628)- query parameters of type
binary(8)
are no longer confused withrowversion
type (#24) - resolve correct
INFORMATION_SCHEMA
views in T-SQL inline blocks (#28)
Windows build changes:
- Windows authentication support with SSPI (#18)
- support adding backtraces to error messages in server log if debuginfo files available in
<install_dir>/symbols
directory.wiltondb3.3_debug_11.15.1.msi
installer is provided that includes debuginfo files files. Note, running server with backtraces enabled may be up to 1.5 times slower than normal runs.
2024-06-30
WiltonDB 3.3 update (version 10.14.1) is released for Windows and Linux.
Microsoft Visual C++ Redistributable update:
Before installing this update on Windows it is necessary to update Microsoft Visual C++ Redistributable package to version 14.40.33810.0
or later. Latest version of MSVC 2022 compiler has introduced incompatibility with older versions of Redistributable package (details: 1, 2), when running on older version of Redistributable package WiltonDB may randomly crash with the following message:
Faulting application name: postgres.exe, version: 15.0.4.24180, time stamp: 0x66803d50
Faulting module name: MSVCP140.dll, version: 14.36.32532.0, time stamp: 0x04a30cf0
Exception code: 0xc0000005
Fault offset: 0x0000000000012f58
Faulting application path: C:\Program Files\WiltonDB Software\wiltondb3.3\bin\postgres.exe
Faulting module path: C:\Windows\SYSTEM32\MSVCP140.dll
Bugfixes:
OpenSSL
library is updated to version3.0.14
that includes one low-severity security fix- a number of fixes backported from upstream Babelfish. To apply the changes related to string literals handling in
COALESCE
function to existing DB clusters, it is necessary to upgradebabelfishpg_common
extension to version3.3.3
by running the following SQL on Postgres connection (default port5432
):
ALTER EXTENSION "babelfishpg_common" UPDATE TO '3.3.3'
Notable changes:
- this update introduces support for jTDS JDBC driver. Note,
useCursors
jTDS option is not supported - cursors are supported when used directly through JDBC API (excludingcursor.last()
call) DEFAULT
keyword is supported as a parameter to T-SQL function and procedures.
2024-05-16
WiltonDB 3.3 update (version 8.13.1) is released for Windows and Linux.
Bugfixes:
- this release includes a fix to CVE-2024-4317 from upstream PostgreSQL 15.7. To apply the fix to existing DB clusters it is necessary to run
<installdir>/share/fix-CVE-2024-4317.sql
script on Postgres connection (default port5432
) - #2540 fix is backported from upstream Babelfish. It fixes the problem when altering a table to add a column with
DEFAULT NEWID()
makes the values all the same value which is not the correct behaviour. To apply the fix to existing DB cluster it is necessary to run the following SQL on Postgres connection (default port5432
):
ALTER EXTENSION "babelfishpg_common" UPDATE TO '3.3.2'
Notable changes:
- support for
ALTER AUTHORIZATION ON DATABASE::<dbname> TO <login-name>
(#1954) is backported from upstream Babelfish. It allows to easily create login-owned databases, see details on Logins and users wiki page - support for
FOR JSON AUTO
(#2243) is backported from upstream Babelfish - default TDS debug logging, which was creating multiple log records for every connection, is disabled; this behaviour can be controlled by changing
babelfishpg_tds.tds_debug_log_level
system parameter from0
(disabled) to3
(max verbosity)
2024-04-15
WiltonDB 3.3 update (version 7.12.1) is released for Windows and Linux.
Changes:
- a number of fixes in BCP import area (#2422, #2455, #2462, #2468, #2486)
- mimalloc allocator is added on Windows to improve ANTLR memory handling, this makes DB connection initialization 10-15% faster
- system_stats extension is included with Windows installer and Linux packages, see details about its usage in Database-monitoring
2024-03-29
Initial version of WiltonDB Data Transfer GUI tool is released.
WiltonDB 3.3 update (version 6.11.1) is released for Windows. This update includes a Windows-only fix to intermittent problem with BCP imports (#13).
2024-03-17
WiltonDB 3.3 update (version 5.10.1) is released for Windows and Linux.
This update includes two notable bugfixes from upstream Babelfish - #1957 and #2017. The former one introduces additional CASTs
in babelfishpg_common
extension, its version is bumped from 3.3.0
to 3.3.1
. When performing the upgrade from previous versions of WiltonDB 3.3 (using existing DB cluster), it is necessary to run the following SQL on Postgres connection (port 5432
by default):
ALTER EXTENSION "babelfishpg_common" UPDATE TO '3.3.1'
2024-03-02
WiltonDB 3.3 update (version 4.9.1) is released for Windows and Linux.
With this update Linked Servers and OPENQUERY functionality is now supported in Linux packages the same way it works on Windows (issue #9).
This update includes bugfixes to issues #10 and #11. This requires minor changes to stored procedures and views in babelfishpg_tsql
extension, its version is bumped from 3.3.0
to 3.3.1
. When performing the upgrade from previous versions of WiltonDB 3.3 (using existing DB cluster), it is necessary to run the following SQL on Postgres connection (port 5432
by default):
ALTER EXTENSION "babelfishpg_tsql" UPDATE TO '3.3.1'
2024-02-23
WiltonDB 3.3 update (version 4.7.1) is released for Windows.
This update includes support for Linked Servers and OPENQUERY.
2024-02-12
WiltonDB 3.3 update (version 4.6.1) is released for Windows and Linux.
With this update plain ZIP bundle is provided for Windows that can be used to set up and run WiltonDB under non-privileged user.
This update includes a security fix from PostgreSQL 15.6 and a critical fix from BABEL_3_3_STABLE
branch of the upstream Babelfish.
2024-01-17
Initial version of WiltonDB Backup GUI tool is released. Description about it is added to documentation along with more broad article about backup and restore.
2023-12-31
WiltonDB 3.3 update (version 3.5.1) is released.
This update includes security fixes from PostgreSQL 15.5 and critical fixes from BABEL_3_3_STABLE
branch of the upstream Babelfish.
The update is released for Windows and Linux including Ubuntu 23.10 (in preparation for Ubuntu 24.04 LTS) and a stable version for Fedora x86_64.
2023-11-15
WiltonDB is covered on postgresql.org.
2023-11-05
Initial version of WiltonDB 3.3 is released for Windows and Linux.
WiltonDB is released under the Apache-2.0 or PostgreSQL license at your choice. Use is permitted under either license.