David Jones

Added kit 58 to files area: Update to SQLite 3.53.1. Replace source_patch.c with refactored version, source_patch2.c. Patch files for the new program have a different format. Old patch files were converted to os_unix.patch2 and pragma.patch2. Replace vms_shell.c with a new program shell-vms.c, generated from the SQLite distribution's shell.c and shell.patch2. The patch technique lets us more cleanly make sqlite3_format_query_result() an external function and produce a less cluttered listing file...

Added kit 57 to the files area. This kit updates the OpenVMS VFS to version 4 to better support SQLite 3.53.0 included with the kit. From release notes: - Add vtab_analzye_update_args function to vtablib.c/.h. - Add special vmsvfs_utf8_vprintf function to vms_vfs_init.c, which is a replacement for sqlite3_vfprintf(). This function either calls vfprintf() directly to write the formatted data to the specified file or uses vsnprintf() to a temporary buffer which has UTF-8 sequences converted to DECMCS...

I added kit 56 to the files area. This one has more than usual changes, mostly to prepare for upcoming changes in the SQLite shell program. The shell in the next version defaults to 'box' mode, which output UTF-8 box-drawing characters (akin to the DEC EGS mode). The upcoming shell consolidates output into a central sqlite3_format_query_result function that I incorporated into the roquery program.

Thanks for the feedback.

I put out a new exec_convert kit (007). The main new feature is it better handles text in the spreadsheet that isn't 7-bit ASCII. .xlsx files store text using UTF8, which xlsxvtab virtual tables now decode and convert to the 8-bit DEC MCS character set byte default. If you want to disable the conversion, issue the SQL statement "SELECT xlsxvtab_config('text_convert', NULL);" prior to creating the virtual table (or first access if already defined in the schema). The default DECMCS mode can do some...

I did a routine update of the kit to use the latest SQLite release, 3.49.2. There is also an updated gstvtab virtual table kit (gstvtab_003.zip). The new gstvtab tracks the library modules so you can find out which module defines a symbol. It can now show you symbol attributes for object library symbols (but not shareable image library symbols).

I add kit 52 to the files area. It has an experiment MMS file for building with clang on X86 systems. It also fixes a bug in handling of filenames/directories which contain special characters (the kind which require quoting with '^'). The names tend to give the CRTL problems, and failure of a decc$translate_vms() can lead to a program crash.

The current kit is now 50 and comes with SQLite 3.47.0. The speedtest1 program runs dramatically faster with 3.47 than 3.46. They apparently tweaked the resident pages it the cache so speedtest1 makes 98% fewer I/O calls to the VFS.