Skip to content

cmdsqlite-v1.3.32bit windows

Choose a tag to compare

@thrive4 thrive4 released this 10 Mar 17:23
· 31 commits to main since this release
809eb7d
  • 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