March 2015 In Brief

3010. Resolved the remaining issues with the PostgreSQL version of the Statprinta database so that it’s working perfectly with the application as is. This brought to the end initial evaluation of PostgreSQL with a positive result, as far as PowerBuilder applications go.

3043. Began the online help documentation for the Fanbox feature in MBDM (MoneyBooks Data Manager), after improving the form for blog posts and the one for selecting document image files.

3054. Completed the online help (CHM) documentation for the Fanbox feature in MBDM.

3172. Implemented three great improvements to the Fanbox features of MBDM: Multiple file selection for picture posts, being able to open an album directly on Fanbox from the application, and being able to do this also for a blog.

3194. Discovered a feature of one of the video player applications on the computer (KPM), being able to save video frames as picture files. This means no longer having to copy the entire screen before cutting out the required image area displayed in the video player.

3231. Discovered a useful imaging feature of the Windows Live Photo Gallery 2011 application on a Windows 7 computer: It can serve as an image format converter, letting you save a copy of an image in another format.

3253. Installed and began the evaluation of SQLite, seeing it as a single-user stand-alone database system with no support for the CREATE PROCEDURE or CREATE FUNCTION statements necessary for creating database procedures in SQL. Downloaded an ODBC driver for SQLite.

3264. Learned some more about SQLite, its being supported by scripting languages like Tcl, PHP and Python, along with its being used by the Firefox browser and some known companies including Apple. WhatsApp messages on the iPhone for instance, are saved in an SQLite database, and it was this discovery days before that that created the initial interest in SQLite.

3275. Continued evaluation of SQLite, after getting around the fake virus issue of the ODBC driver.

3301. Continued evaluation of SQLite, coming to realize that PowerBuilder’s DataWindow technology would not work well with it as the required catalog tables cannot be created in its database by PowerBuilder; they cannot be accessed by PowerBuilder, even when they were manually created in the database.

3312. Made some Tcl downloads, with a view to accessing SQLite databases with the language.