Skip to content

Releases: ffasbend/sqlEditor

v1.0.3: update changelog

02 Apr 06:15

Choose a tag to compare

Added

  • Live server now hosted on Github Pages (https://ffasbend.github.io/sqlEditor/)
  • Support for MS Access wildcards (* and ?) in pattern-matching queries (LIKE queries) was added.
  • Help button and help text added.

Fixed

  • Use sql.js v1.13.0 to avoid problems while loading wasm from sql server
    (file is ./node_modules/sql.js/dist/sql-wasm.wasm after installing sql.js from npm)
  • Error in db data was fixed (wrong town name).
  • Smaller font-size for select box on small mobile devices.

Changed

  • Use Github Pages for live site
  • Change to relative website path in vite
  • Change favicon

v1.0.2

26 Feb 12:04

Choose a tag to compare

Fixed

  • configure monaco editor to work with vite (use vite-plugin-monaco-editor)
  • remove unused node packages

Online SQL Editor - MS Access features added

25 Feb 21:56

Choose a tag to compare

Added

  • MS Access date literals are now also accepted (and converted to SQL date format internally).
  • MS Access parameter queries are now supported (values can be entered in popup window).

Changed

  • Current query is re-evaluated when the current database is changed.

Fixed

  • Dates in sample db's have been fixed (time part of date has been deleted).
  • Times in sample db's have been fixed (date part of time has been deleted).

SQL Online Editor for 1GCG

25 Feb 15:24

Choose a tag to compare

  • First, use select box (on top) to select an existing database.
  • SELECT queries have live updates (with error messages).
  • INSERT, UPDATE and DELETE queries must be executed with the button RUN SQL.