Releases: mridoni/gixsql
v1.0.21dev
This is a new pre-release for GixSQL, that adds a few new features. For now only the autoconf-enabled source package and the binary pakages for Debian 10/11/12 are released for testing.
The packages are signed with my GPG private key. The corresponding public key ([email protected] or [email protected]), fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
A summary of new features and fixes:
- Logs can be rotated (parameters are: GIXSQL_LOG_ROTATE, GIXSQL_LOG_ROTATE_MAX_SIZE, GIXSQL_LOG_ROTATE_MAX_FILES, more documentation will follow)
- The size of indicator for VARYING fields can be set at runtime with an environment variable (GIXSQL_VARYING_LEN_SZ_SHORT) that must coincide with the size specifying when preprocessing (a new parameter -N/--varying-length-size has been added to gixpp). See here: #54 (comment)
- The handling of continuation lines has been fixed
- Several pull requests by @GitMensch have been merged (thanks!!) that fix some memory bugs here and there
Contributors
Assets 10
v1.0.20b
Update: New RHEL8/AlmaLinux compatibile packages are available (package version is 1.0.20b-4); these should solve some install/link problems
This is a new release for GixSQL, that adds SSL connection support for PostgreSQL and introduces some long-needed internal refactoring that separates the parser from the code generator in the preprocessing library.
The packages are signed with my GPG private key. The corresponding public key ([email protected] or [email protected]), fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Moreover, the Windows binary installers have been signed with my code-signing certificate, for an added level of trust.
Binary packages available
- Windows x64 installer (MSVC + MinGW)
- Windows x64 installer (MinGW only)
- Windows x86 installer (MSVC + MinGW)
- Windows x86 installer (MinGW only)
- Windows x86 "portable"
- Windows x64 "portable"
- Linux x64 (Ubuntu 20.04/22.04, Debian 10/11, RHEL/AlmaLinux/Centos 8.x)
The RHEL/AlmaLinux/Centos 8.x package needs the EPEL repository to be enabled.
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
- Added SSL connection support for PostgreSQL
- Preprocessor components have been refactored, parser and generator are now two different modules
v1.0.20a
This is a new release for GixSQL, that adds COBOL NULL-indicator support for all the drivers.
The packages are signed with my GPG private key. The corresponding public key ([email protected] or [email protected]), fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Moreover, the Windows binary installers have been signed with my code-signing certificate, for an added level of trust.
Binary packages available
- Windows x64 installer (MSVC + MinGW)
- Windows x64 installer (MinGW only)
- Windows x86 installer (MSVC + MinGW)
- Windows x86 installer (MinGW only)
- Windows x86 "portable"
- Windows x64 "portable"
- Linux x64 (Ubuntu 20.04/22.04, Debian 10/11)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
- Added COBOL NULL-indicator support for all the drivers
v1.0.20
This is a new release for GixSQL, that brings, among the other fixes, a lot of internal changes that have eliminated some memory leaks and should make the runtime libraries in general more stable and less memory-hungry. Debian 10/11 packages have been added and the test suite is now documented.
These latest packages, including the "portable" releases are "ready to go" on Windows: they already include all the client libraries and their dependencies. On Linux the package manager will take care of that.
The packages are signed with my GPG private key. The corresponding public key ([email protected] or [email protected]), fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Moreover, the Windows binary installers have been signed with my code-signing certificate, for an added level of trust.
Binary packages available
- Windows x64 installer (MSVC + MinGW)
- Windows x64 installer (MinGW only)
- Windows x86 installer (MSVC + MinGW)
- Windows x86 installer (MinGW only)
- Windows x86 "portable"
- Windows x64 "portable"
- Linux x64 (Ubuntu 20.04/22.04, Debian 10/11)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
- Fixed "re-align COBOL_TYPE_UNSIGNED_BINARY code to use switch ready" (#136)
- Fixed "SIGSEGV on cursor close" (#135)
- Fixed "change SqlVar::type to enum enhancement New feature or request" (#124)
- Fixed "testsuite adjustments - running with analyzers / code instrumentation" (#122)
- Fixed "FR for USAGE VARRAW alias to VARYING" (#120)
- Fixed "leak in dbi->fetch_one and potentially other places" (#111)
- Fixed "Return more details on the actual error instead of "invalid column data"" (#109)
- Fixed "FR gixpp option handling: add alias for source basename" (#53)
- Modified scanner/parser to improve handling of subqueries
- Added Debian 10/11 binary packages
- Added GitHub Actions workflow for easier testing
- The test suite is now documented
- SQLCA is now set on success (PR #137 by Simon Sobisch)
- The gixsql wrapper now uses the correct directory for SQLCA (PR #134 by Simon Sobisch)
- Fixed Windows binary packaging: dependencies are now correctly selected and included
v1.0.20dev1
This is a new pre-release for GixSQL, that brings, among the other fixes, a lot of internal changes that have eliminated some memory leaks and should make the runtime libraries in general more stable and less memory-hungry. Debian 10/11 packages have been added and the test suite is now documented.
The packages are signed with my GPG private key. The corresponding public key ([email protected] or [email protected]), fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Moreover, the Windows binary installers have been signed with my code-signing certificate, for an added level of trust.
Binary packages available
- Windows x64 (MSVC + MinGW)
- Windows x64 (MinGW only)
- Windows x86 (MSVC + MinGW)
- Windows x86 (MinGW only)
- Windows x86 "portable"
- Windows x64 "portable"
- Linux x64 (Ubuntu 20.04/22.04, Debian 10/11)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
- Fixed "re-align COBOL_TYPE_UNSIGNED_BINARY code to use switch ready" (#136)
- Fixed "SIGSEGV on cursor close" (#135)
- Fixed "change SqlVar::type to enum enhancement New feature or request" (#124)
- Fixed "testsuite adjustments - running with analyzers / code instrumentation" (#122)
- Fixed "FR for USAGE VARRAW alias to VARYING" (#120)
- Fixed "leak in dbi->fetch_one and potentially other places" (#111)
- Fixed "Return more details on the actual error instead of "invalid column data"" (#109)
- Fixed "FR gixpp option handling: add alias for source basename" (#53)
- Modified scanner/parser to improve handling of subqueries
- Added Debian 10/11 binary packages
- Added GitHub Actions workflow for easier testing
- The test suite is now documented
- SQLCA is now set on success (PR #137 by Simon Sobisch)
- The gixsql wrapper now uses the correct directory for SQLCA (PR #134 by Simon Sobisch)
Known issues
The Windows installers do not allow to select how (or if) the Microsoft VC++ runtime should be installed. This feature, already included in the installer for Gix-IDE, will ship with the final version of v1.0.20.
v1.0.19
This is a new release for GixSQL, that mainly re-implements autocommit and updatable cursor support, and fixes a few bugs. For information on how these two features work, look at the (updated) documentation, where a specific section has been added.
The packages are signed with my GPG private key. The corresponding public key ([email protected] or [email protected]), fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Moreover, the Windows binary installers have been signed with my code-signing certificate, for an added level of trust.
Another point of attention is the fact that the new packages are being built with GitHub Actions: the building and packaging process is entirely reproducible using the workflows supplied in this repository. This also means that - internally - development has been moved entirely from a SVN-based setup to Git/GitHub: some long-term work will still take place internally (at first), but updates on GitHub will be quicker and more frequent.
(By the way: I have added a new e-mail address to my key because I started to sign the binary installers with a code signing certificate, and it just seemed "prettier" to use for the e-mail contact a domain that I own instead of a generic GMail address.)
Binary packages available
- Windows x64 (MSVC + MinGW)
- Windows x64 (MinGW only)
- Windows x86 (MSVC + MinGW)
- Windows x86 (MinGW only)
- Windows x86 "portable"
- Linux x64 (Ubuntu 20.04)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
v1.0.18b
This is a "hotfix" release for GixSQL, that fixes a few issues.
The packages are signed with my GPG private key. The corresponding public key ([email protected], fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Please note: as of v1.0.18 there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-).*
Binary packages available
- Windows x64 (MSVC + MinGW)
- Windows x64 (MinGW only)
- Windows x86 (MSVC + MinGW)
- Windows x86 (MinGW only)
- Windows x86 "portable"
- Linux x64 (Ubuntu 20.04)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
v1.0.18a
This is a "hotfix" release for GixSQL, that fixes a few issues.
The packages are signed with my GPG private key. The corresponding public key ([email protected], fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Please note: as of v1.0.18 there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-*).
Binary packages available
- Windows x64 (MSVC + MinGW)
- Windows x64 (MinGW only)
- Windows x86 (MSVC + MinGW)
- Windows x86 (MinGW only)
- Windows x86 "portable"
- Linux x64 (Ubuntu 20.04)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
- Changed logging system initialization to avoid possible crashes
- Fixed some spelling problems in the documentation
- Fixed some memory leaks in the runtime
- Solution for "sqlstate by driver may set 00000 for errors (in GixSQL?)" (#114)
- Additional fix for "codegen / logic issue for "GIXSQLCursorDeclareParams" (#88)
- Allowing variable with level 77/78 in the parser
v1.0.18
x86 Windows packages for these release have several problems, please use v1.0.18a
This is a maintenance release for GixSQL, that fixes a few issues and adds some new features, notably two new database drivers (Oracle and SQLite). Check the documentation for generic and driver-specific usage notes.
The packages are signed with my GPG private key. The corresponding public key ([email protected], fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Please note: there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-*).
Binary packages available (as usual on the release page on GitHub):
- Windows x64 (MSVC + MinGW)
- Windows x64 (MinGW only)
- Windows x86 (MSVC + MinGW)
- Windows x86 (MinGW only)
- Windows x86 "portable"
- Linux x64 (Ubuntu 20.04)
There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.
A summary of new features and fixes:
- Added new Oracle driver, based on ODPI
- Added new SQLite driver
- All the drivers have been updated and now implement the complete set of supported features
- Solution for "PG: issue with prepared statements" (#99)
- Solution for "PCursors cannot be re-opened after close" (#98)
- Solution for "libgixpp: setStatus is called for errors without DBI parm passed - sets SQLERRM" (#94)
- Solution for "error handling (especially for 07001)" (#92)
- Solution for "show-stopper bug in pgsql_prepare" (#91)
- Solution for "PREPARE does not work with VARLENGTH groups (ocesql compat)" (#79)
- Partial solution for "PREPARE does not work with VARLENGTH groups (ocesql compat)" (#68)
- Solution for "The PostgreSQL driver needs START TRANSACTION before using cursors" (#14)
- Solution for "FR: support EXEC SQL VAR" (#21)
- Fixed a bug in "problems with "codegen / logic issue for "GIXSQLCursorDeclareParams" (#88)
- Solution for "FR: allow mapping of "NoRecCode"' (#95) - added --no-rec-code parameter to gixpp
- Tokens in the parser have been labeled to improve diagnostics (pulled PR #96 by @GitMensch)
- Fixed COMP-3 handling in drivers other than PostgreSQL
- Rewrote the test suite (still MSTest-based) to dynamically generate a matrix of test to be run on the various platforms/database drivers
- Added options for parameter generation in gixpp (-a was removed)
- Added new GIXSQL_FIXUP_PARAMS option for runtime, to automatically convert parameter format in prepared statements
- "Native" cursors are now the default for the PostgreSQL driver
- "Smart" cursor initialization is now the default for all cursors, including those declared in WORKING-STORAGE (-L was removed from gixpp), should fix #101
- Removed dynamic cursor emulation from the ODBC driver when using PostgreSQL
Contributors
Assets 16
v1.0.18.dev2
This is a pre-release for GixSQL. It fixes a few issues and adds two new databases drivers (Oracle and SQLite). The next "standard" release (presumably v1.0.18) will have feature parity for all database drivers.
The package is signed with my GPG private key. The corresponding public key ([email protected], fingerprint 70E4 08CF B89B 5FA8 32E4 5292 EFDC 94BD 5260 B939) has been published on pgp.mit.edu and keyserver.ubuntu.com and is available at https://github.com/mridoni.gpg
Note: there have been changes both in the preprocessing engine and in the runtime libraries, including the external interfaces, so source code compiled with older versions of GixSQL MUST be re-preprocessed and recompiled to work with the new libraries.
Fixes and new features:
- Added new Oracle driver, based on ODPI
- Added new SQLite driver
- Solution for "PG: issue with prepared statements" (#99)
- Solution for "PCursors cannot be re-opened after close" (#98)
- Solution for "libgixpp: setStatus is called for errors without DBI parm passed - sets SQLERRM" (#94)
- Solution for "error handling (especially for 07001)" (#92)
- Solution for "show-stopper bug in pgsql_prepare" (#91)
- Solution for "PREPARE does not work with VARLENGTH groups (ocesql compat)" (#79)
- Partial solution for "PREPARE does not work with VARLENGTH groups (ocesql compat)" (#68)
- Solution for "The PostgreSQL driver needs START TRANSACTION before using cursors" (#14)
- Solution for "FR: support EXEC SQL VAR" (#21)
- Fixed a bug in "problems with "codegen / logic issue for "GIXSQLCursorDeclareParams" (#88)
- Fixed COMP-3 handling in drivers other than PostgreSQL
- Rewrote the test suite (still MSTest-based) to dynamically generate a matrix of test to be run on the various platforms/database drivers