# Pack Ann: proSQLite 2.0

**URL:** https://swi-prolog.discourse.group/t/pack-ann-prosqlite-2-0/7697
**Category:** Pack
**Created:** [August 15, 2024, 7:55pm UTC](https://swi-prolog.discourse.group/t/pack-ann-prosqlite-2-0/7697 "2024-08-15T19:55:08Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![nicos](https://avatars.discourse-cdn.com/v4/letter/n/7feea3/32.png) [@nicos](https://swi-prolog.discourse.group/u/nicos)
#### Post date: [August 15, 2024, 7:55pm UTC](https://swi-prolog.discourse.group/t/pack-ann-prosqlite-2-0/7697/1 "2024-08-15T19:55:08Z")

</div>

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](http://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

> **[Nicos Angelopoulos](https://stoics.org.uk/~nicos/)**
>
> logic programming

[1] project page: [SQLite for Prolog.](https://stoics.org.uk/~nicos/sware/prosqlite)  
[2] github page: [GitHub - nicos-angelopoulos/prosqlite: An SWI-Prolog interface to SQLite](https://github.com/nicos-angelopoulos/prosqlite)