This document lists all notable changes to the functionality of Airsequel.

Our version numbers are based on the Haskell package versioning policy.

2022-12-16 - v0.4.0.1

• Handle columns with double quotes in their name correctly
• Show number of filled cells in delete column dialog
• Show correct version number via status API endpoint
• Show spinner while SQL query is executing

2022-12-12 - v0.4

• Edit database schema via UI

  • Button on landing page to create new database from scratch

  • Support adding, renaming and deleting tables

    

  • Support adding, renaming, and deleting columns

  • Support renaming a database

• Allow SQL write queries in Free edition

• Add dashboards with 3 chart types

  • Bar charts
  • Line charts
  • Single value

  

• Improve spreadsheet UI

  • Add new column type “single-select”

    

  • Collapsible columns for better overview in big tables

    

  • Automatically picks unused rowid name (one of rowid, _rowid_, or oid)

• Improve SQL editor

  • Add button to create a view from executed query
  • Show documentation for SQLite functions
  • Replace tab character in SQL query editor with 2 spaces
  • Allow more functions and prevent executing unavailable functions

• Encode column names with Double-X-Encoding to allow any Unicode string as name

  

  Check out our announcement blog post for the Double-X-Encoding for more information.

• New and overhauled documentation page at docs.airsequel.com

• New database settings page

  • Add environment setting and show badge next to Airsequel logo with current environment

    

  • Add button to regenerate the database ID

• Extend example database with views and dashboards

• Confirmation dialog for all destructive actions

• Better error handling and error popups