Feb 2026, long time no post

There are various poor excuses why I have not posted in a long time. But the Downloads and script files page has had quite a few additions.

The latest pwScripter (formerly known as SQLite-OLE) has been uploaded. It can be downloaded from here pwscripter. It uses SQLite 3.51.2 so it is up-to-date (2026-02-17).

In addition, if you browse YouTube for PlodWare you will find 24 videos relating to PlodWare / pwScripter and even some Arduino related projects.

New pwScripter

The latest pwScripter (formerly known as SQLite-OLE) has been uploaded. It can be downloaded from here pwscripter. It uses SQLite 3.46.1 so it is up-to-date (2024-09-18).

There is also a new web page for downloads.

In addition, if you browse YouTube for PlodWare you will find 11 videos relating to PlodWare / pwScripter.

Another year gone, another update

I have extensively reworked my application known as PlodWare-SQLite-OLE, and decided to rename it to pwScripter. It can be downloaded from here pwscripter.  It uses SQLite 3.46.0

The rework, pwScripter, is not 100% compatible with previous versions, so I need to update some command scripts and web help pages.

There is also a new version of PlodWare-MetaData-Tagger. This is a pwScripter script of just over 8000 lines (after empty lines and comments have been removed) that is compressed, encoded and inserted in to a pwScripter executable, thus creating a standalone excutable that can be downloaded here PlodWare-MetaData-Tagger

The full script for PlodWare-MetaData-Tagger is available here pws-metadata-tagger

Over the year I have added a fair bit of content using PHP and HTML to this web site, without using WordPress. See Alternative Content

Yet another PlodWare SQLite-OLE update

The latest version (2022-03-21) has the newest SQLite (3.38.1).

Not to sure why I did it, but I have have included the SQLite loadable extension append.vfs

I might find a good use for it, it seems interesting.

I have also made it possible to use the SQLite run-time loadable extension functionality . There is a PWBasic command to switch the functionality on/off (default is off), whilst the actual accessing of the target run-time loadable extension is controlled using a SQLite command .  I tested this with various extensions ( including: uuid, SpatiaLite/mod_spatialite).

Almost retired 2021-09-23

As part of a mini-celebration, I have uploaded the latest PlodWare SQLite-OLE application.

I have been uploading software since about 2000, although no-one appears interested (except me).

But it does cause me to think about “what is a digital world”. The logic/reasoning/psychology of writing a web site is intriguing.
If it achieves nothing else, writing this web site does encourage me to reflect.

SQLite-OLE 2019-09-13

Updated version available.

Main new features:

Have added to the command line interpeter commands to find (InstrRex ) text, and to replace (ReplaceRex) text using regular expressions. The underlying regexp code is the open source Pcre2 “C” libary.

The SQLite loadable extension module (regexp.c) to support a regular expression as part of a WHERE clause has been added

SQLite-OLE 2019-08-07

Updated version available.

Main new features:

  • In the “Edit Field”, you can select a block of text and send it to the command line interpret ( select the text, double right mouse click, select required option from the pop-up menu).
  • In the “Edit Field”, a limited text find function is available.
  • These edit field features are also supported in the fields: “User macros”, “System macros”, “Report field” and “Help”.

For details about the following SQLite options and loadable extensions please refer to the SQLite web site.

The SQLite engine has been complied with the following options:

  • JSON1
  • FTS5

The following loadable extensions are included:

  • csv
  • fileio