cmdsqlite-v1.5.32bit windows

• added json escaping rules
• added json nested array (one deep) flattening with one line json
• added filter out system related folders when using catalog
• tweaks to .txt indexing
• added spanish

cmdsqlite-v1.4.32bit windows

• fix correct table name in sql export with queries
• fix correct filename as db name in xml main node export
• fix xml sanitation ampersand remove space
• fix rec nr counter all list types csv, sql, json etc
• fix incorrect field count empty fieldname could occure when getting fieldnames
• updated and reformated help file
• harmonize json export can now deal with select *
  no longer uses seperate select json_object(
• added list play to audioplayer (html)
  navigation player
  next arrow right
  previous arrow left
  toggle pause / play p
  volume up +
  volume down -
  seek plus .
  seek min ,
• added primitive export database exports to separate tables
  output to .sql, .csv and .xml
• added web export option for media files mp3, jpg etc
  similar to html exif but adds a file column and
  truncates file path assumes wwwroot/audio on webserver
  example output:
  exif
  {"artist":"The Beatles","title":"baby you are a rich man","album":"Magical Mystery Tour","year":"1987","genre":"rock","theme":"beatless"},
  web
  {"artist":"The Beatles","title":"baby you are a rich man","album":"Magical Mystery Tour","year":"1987","genre":"rock","file":"audio/beatless/the beatles - baby you are a rich man.mp3"},
  html exif
  The Beatlesbaby you are a rich manMagical Mystery Tourrockbeatless1987

cmdsqlite-v1.3.32bit windows

• started a baseline sqlite fts5 implementation
  import datasources csv, json, folder, xml
  and rundimentarty text and exif info specific filetypes
  issues: fts5
  'rank' is a reserved name so the fieldname needs to be renamed
  there are issues with hyphen in table names ....
• gradual implementation json data format escaping rules
  import pjson (aka pretty json), single and multi line
  with basic error handling
• started a rundementary form of disk catalog format
  drive label, folder, folder date, folder size
  example: cmdsqlite e:\ catalog
• added basic comment handling in .query comment character is # (hash)
• added a number of sample .query files
• added basic .txt import and encoding support utf16 and utf8 default 'ascii'
  list version each line of text is record
• added basic .srt import format
  file, subtitlenr, starttime, endtime, text
• added theme field to mp3 html export theme is last folder in path
  exampe: theme = 'classic' from g:\data\mp3\classic\
• added file metrics folder size, drive label, drive storage
• added support database extension .sqlite used by some applications and browsers
• removed ' in xml node names
• regression checkpath (see 1.1) fixed again
• more fixes to errorhandling csv import
• fixed incorrect table defintion xml import
• fixed preserve linefeed when converting .sql to .db
• fixed issue with numerical data in json pattern "fieldname":123
  becomes "fieldname":"123"
• issue with wstr still open freebasic/fbc#420
  temporary hack check locale if not 'en' or 'nl' use wstr
• updated sqlite3.dll v3.42.0 to v3.49.1
• updated help files and readme.md where needed
• slimmed down function explode
• tweaked getmp3tag increase speed parsing mp3 tags
• improved getfilesfromfolder and getfolders in utilfile.bas

cmdsqlite-v1.2.32bit windows

update v1.2 18/12/2023

• integrated mp3 album cover export
  from https://github.com/thrive4/util.fb.mp3cover
  added filesize and orientation image as field data
  to mp3cover.csv report
• integrated .mht convert (converts .mht to .html and .txt)
  from https://www.freebasic.net/forum/viewtopic.php?p=288025
• updated wordwrap2file some what better text formatting
• added sticky table header for data tables
  sticky tip courtesy https://codepen.io/stephen-george-west/pen/rNpjXYL
• updated help.ini with new functionality
• partial implementation json data format escaping rules

cmdsqlite-v1.1.32bit windows

update v1.1 14/09/2023

• added export meta info mp3 to other fileformats
  csv, json, sql and xml
• added export meta info mp3 album to html
• added filter table javascript
  courtesy to: https://www.w3schools.com/howto/howto_js_filter_table.asp
  partially implemented filter on specific field
• replaced sort routine for tables javascript
  significant improvements in speed and number
  of rows that can be handeled by browser
  many thanks to tofsjonas
  see: https://github.com/tofsjonas/sortable
• modified main.css less cluterd html table and other style tweaks
• fixed json export dubble first fieldname and value
  with datasource as folder plus filespec
• fixed deselect issue audio playing button html table
• fixed log creation (missing message)
• fixed appname made truncation .exe optional
  public release v1.0 06/09/2023

cmdsqlite-v1.0.32bit windows

primary release