Pack Ann: proSQLite 2.0

Announce Pack
1

There is a new version of proSQLite (2.0) on the server.

This release introduces a number of features and fixes, and
provides binaries with current SQLite executables.

  • propagation of SQLite errors
    such as locked databases
  • support for null values
    including in predicated queries
  • new version predicates
    sqlite_library_c_version/1, sqlite_library_version/1, sqlite_build/1
  • retract only of predicated tables
    option remove_predicates/1 and Prolog flag sqlite_remove_predicates
  • ability to be included in saved states
    using use_foreign_library()
  • SQL keywords as field names
    via protection of the queries
  • switch to using PL_get_file_name()
    fix provided by Jan Wielemaker

Thanks to John B Thiel for opening a number of issues on github and privately.

The server (stoics.org.uk) that hosts the pack also had an upgrade, so hopefully
there is no longer need to use insecure(true) with pack_install/2.

Enjoy,

Nicos Angelopoulos

[1] project page: SQLite for Prolog.
[2] github page: GitHub - nicos-angelopoulos/prosqlite: An SWI-Prolog interface to SQLite

1 Like