AbiData v1.5.0

What's Changed

• docs(planning): theme cohesion and UI polish plan by @AbishYoung in #146
• feat(web): theme cohesion W1, token harmonisation and materials by @AbishYoung in #148
• feat(web): overlay polish (W3) by @AbishYoung in #147
• feat(web): inputs and editors polish (W5) by @AbishYoung in #150
• feat(datasheet): one-row toolbar with More overflow; single record count by @AbishYoung in #149
• feat(web): pages, cards and charts polish (W4) by @AbishYoung in #151
• ci: pin actions to commit SHAs and stop persisting checkout credentials by @AbishYoung in #157
• fix(blogs): keep a post take-down in force when the post's slug changes by @AbishYoung in #152
• fix(apps): pin nested saved queries and required shared modules on approval by @AbishYoung in #153
• fix: cap public app request bodies and bound report generation memory by @AbishYoung in #154
• fix(forms): limit ui.open_url to web, mail and same-server links by @AbishYoung in #155
• sec: tighten the app CSP and send HSTS on https installs by @AbishYoung in #156
• docs: security review of changes since v1.3.1 by @AbishYoung in #158
• docs: dark-theme screenshots, light set on the site, ADR 0023 by @AbishYoung in #161
• fix(deps): build with Go 1.27.3 (GO-2026-6809) by @AbishYoung in #160
• chore(release): v1.5.0 by @AbishYoung in #162

Full Changelog: v1.4.0...v1.5.0

AbiData v1.4.0

What's Changed

• chore(deps): bump github.com/go-chi/chi/v5 from 5.3.2 to 5.4.0 by @dependabot[bot] in #105
• feat(web): Sylvan Atelier palette and materials (ADR 0021, 1/4) by @AbishYoung in #106
• feat(site): public website on GitHub Pages by @AbishYoung in #119
• docs: community health files by @AbishYoung in #120
• docs: every PR bumps the patch; releases are minor versions and special fix patches by @AbishYoung in #121
• feat(reports): extended formatting engine (ADR 0018 slice 1) by @AbishYoung in #110
• feat(reports): typography, accounting borders, shading, conditional formatting (ADR 0018 slice 2) by @AbishYoung in #113
• feat(reports): live draft preview without saving (ADR 0018 slice 4) by @AbishYoung in #115
• feat(export): typed, formatted Excel workbooks (ADR 0020, part 1) by @AbishYoung in #111
• feat(web): tactile controls and jewel kinds (ADR 0021, 2/4) by @AbishYoung in #116
• feat(datasheet): smart paste type coercion (ADR 0019, 2/5) by @AbishYoung in #112
• feat(web): animated line-art wildlife (ADR 0021, 3/4) by @AbishYoung in #118
• feat(web): record sheet drag-to-dismiss (ADR 0022 slice 2) by @AbishYoung in #109
• feat(reports): reports.generate for job automation (ADR 0018 slice 6) by @AbishYoung in #117
• feat(datasheet): multi-MIME clipboard copy with headers (ADR 0019, 1/5) by @AbishYoung in #108
• feat(web): swipeable record cards (ADR 0022 slice 1) by @AbishYoung in #107
• docs: revamp the README by @AbishYoung in #124
• feat(datasheet): paste HTML tables, header detection and column mapping (ADR 0019, 3/6) by @AbishYoung in #122
• feat(reports): intelligent pagination (ADR 0018 slice 3) by @AbishYoung in #114
• feat(web): alive motion engine, ADR 0021 as built (4/4) by @AbishYoung in #123
• feat(datasheet): lookup resolution and keyed upsert paste (ADR 0019, 4/5) by @AbishYoung in #128
• feat(datasheet): range fill and direct paste; ADR 0019 as built (5/5) by @AbishYoung in #129
• feat(web): pull-to-refresh (ADR 0022 slice 3) by @AbishYoung in #125
• docs: re-shoot screenshots in the Sylvan Atelier theme by @AbishYoung in #134
• feat(export): resolve lookup columns to display text (ADR 0020, part 2) by @AbishYoung in #126
• feat(export): export dialog options for Excel and selected records (ADR 0020, part 3) by @AbishYoung in #135
• docs(adr): ADR 0020 as built by @AbishYoung in #137
• feat(reports): direct PDF download and data export (ADR 0018 slice 5) by @AbishYoung in #131
• docs(adr): ADR 0018 as built, repeated-header e2e by @AbishYoung in #136
• feat(web): touch-first inputs (ADR 0022 slice 4) by @AbishYoung in #127
• feat(web): long-press multi-select (ADR 0022 slice 5) by @AbishYoung in #130
• feat(export): lookup options in the export dialog (ADR 0020, part 4) by @AbishYoung in #138
• feat(web): bottom dock and FAB (ADR 0022 slice 6) by @AbishYoung in #132
• docs(adr): ADR 0022 as built by @AbishYoung in #133
• feat(reports): continued note on repeated group headers in PDF downloads by @AbishYoung in #139
• docs: final screenshot re-shoot (Sylvan Atelier, ADRs 0018-0022) by @AbishYoung in #140
• feat(web): shell cockpit polish by @AbishYoung in #141
• feat(web): Whispering Pines banner, owl tilt, kind badge, tooltip drift by @AbishYoung in #142
• feat(datasheet): console header polish and animated count tickers by @AbishYoung in #143
• docs: final theme screenshots; fix pine banner proportions by @AbishYoung in #144
• chore(release): v1.4.0 by @AbishYoung in #145

Full Changelog: v1.3.1...v1.4.0

AbiData v1.3.1

What's Changed

• docs(adr): mark ADR 0015 implemented by @AbishYoung in #87
• feat(files): export attachment file names and import mapping note (ADR 0011) by @AbishYoung in #88
• feat(datasheet): pinned quick-add row (Phase 4.1) by @AbishYoung in #89
• Security fixes from the v1.3.0 survey by @AbishYoung in #94
• feat(cli): abidata migrate-backend (ADR 0012 Phase 5) by @AbishYoung in #98
• feat(queries): SQL dialect hints in the console and editors (ADR 0012 Phase 5) by @AbishYoung in #103
• docs: PostgreSQL operations guide; ADR 0012 Phase 5 as built by @AbishYoung in #104
• feat(import): geo point from latitude and longitude columns (ADR 0010) by @AbishYoung in #91
• feat(export): GeoJSON export for tables with a geographic field (ADR 0010) by @AbishYoung in #93
• feat(datasheet): multi-column sorting with rank badges (Phase 4.2) by @AbishYoung in #90
• feat(import): GeoJSON FeatureCollection import (ADR 0010) by @AbishYoung in #95
• docs(adr): mark ADR 0010 implemented by @AbishYoung in #97
• feat(datasheet): column freezing (Phase 4.3) by @AbishYoung in #92
• feat(datasheet): range selection, TSV copy, validated paste (Phase 4.4) by @AbishYoung in #96
• feat(datasheet): column profiling dialog (Phase 4.5) by @AbishYoung in #99
• feat(datasheet): conditional formatting rules (Phase 4.6) by @AbishYoung in #100
• docs(planning): Phase 4 status and as-built notes by @AbishYoung in #101
• ci: Go suite on PostgreSQL 17/18 and e2e on PostgreSQL (ADR 0012 Phase 5) by @AbishYoung in #102

Full Changelog: v1.3.0...v1.3.1

AbiData v1.3.0

What's Changed

• fix(ci): support uploading assets to existing releases in release workflow by @AbishYoung in #80
• feat(datasheet): active filter pills bar and modifier popover by @AbishYoung in #82
• feat(collab): rich messaging markdown and cross-workspace recent palette objects by @AbishYoung in #81
• release: v1.2.0 — Phase 2: Information Clarity & Team Collaboration by @AbishYoung in #83
• feat(mobile): touch navigation gestures, pagination dots, and keyboard dismissal by @AbishYoung in #84
• feat(forms): Forms runtime accordions & collapsible sections (Phase 3 Workstream 3.2) by @AbishYoung in #85
• release: v1.3.0 — Phase 3: Mobile Touch Fluidity & Form Composition by @AbishYoung in #86

Full Changelog: v1.1.0...v1.3.0

v1.1.0 — Phase 1: Query Console Ergonomics & Datasheet Selection Aggregation

Highlights in v1.1.0

Query Console Power Ergonomics (Phase 1, Workstream 1.1)

• Monaco SQL Editor: Replaced basic <textarea> with a high-performance Monaco SQL editor supporting full SQL syntax highlighting, keyword autocomplete, light/dark theme coordination (abidata-light / abidata-dark), line numbers, and clean vertical rhythm.
• Universal Mod+Enter Execution: Bound Mod+Enter (Ctrl+Enter / Cmd+Enter) query execution across the Monaco SQL editor, visual QBE designer canvas, and QBE field grid.
• Inline Error Markers & Navigation: Parses SQLite and PostgreSQL syntax errors into precise coordinates, rendering red error squiggles directly in Monaco with an interactive "Go to line X, col Y" button in the error banner.

Datasheet Selection Status Bar Aggregation (Phase 1, Workstream 1.2)

• Real-Time Statistical Summary: Instant client-side aggregation displaying Count, Sum, Average, Min, and Max in the footer status bar whenever multiple cells or rows are selected.
• Smart Type Awareness: Robust parsing for numbers and currency (including ten-thousandths integer scaling and formatted strings) while gracefully handling non-numeric data, blanks, and nulls.
• Accessibility: Polite ARIA live announcements (role="status", aria-live="polite") with clean tabular styling and divider layout.

AbiData v1.0.0

What's Changed

• Fix the data race that fails CI's Go tests by @AbishYoung in #1
• Datasheet scrolling, report text, columnar reports, split demos, context menus by @AbishYoung in #2
• Public apps: publish forms and reports behind a secret link (ADR 0014) by @AbishYoung in #3
• dbx layer, migration split and PostgreSQL sandbox spike (ADR 0012 phases 0–1) by @AbishYoung in #5
• Generate import/export SQL and catalog DDL through sqlgen (ADR 0013 phases B–C) by @AbishYoung in #4
• Set up Dependabot by @AbishYoung in #6
• README: new features and refreshed screenshots by @AbishYoung in #7
• Parse builder expressions as AbiData expressions (ADR 0013 Phase D) by @AbishYoung in #8
• Register system-table SQL as named statements (ADR 0013 Phase E) by @AbishYoung in #9
• Layered, change-aware testing (ADR 0016) by @AbishYoung in #10
• PostgreSQL renderer, _lib and differential tests (ADR 0013 Phase F, part 1) by @AbishYoung in #11
• Web UI review and modernisation (ADR 0015) by @AbishYoung in #12
• PostgreSQL text is binary; abi_ci only where SQLite says NOCASE by @AbishYoung in #13
• PostgreSQL DDL for user tables (ADR 0013 Phase F part 2) by @AbishYoung in #14
• Read JSON on PostgreSQL (ADR 0013 Phase F part 3) by @AbishYoung in #15
• Build and change JSON on PostgreSQL (ADR 0013 Phase F part 4) by @AbishYoung in #17
• Resolve open Dependabot and CodeQL alerts by @AbishYoung in #16
• typeof, quote, unhex, timediff on PostgreSQL; SQLite's number text (ADR 0013 Phase F part 5) by @AbishYoung in #18
• printf and format on PostgreSQL (ADR 0013 Phase F part 6) by @AbishYoung in #19
• Admin schema on PostgreSQL (ADR 0012 Phase 2 part 1) by @AbishYoung in #20
• Admin store on PostgreSQL (ADR 0012 Phase 2 part 2) by @AbishYoung in #22
• PostgreSQL configuration, backend lock and startup checks (ADR 0012 Phase 2 part 3) by @AbishYoung in #25
• Workspace system tables on PostgreSQL (ADR 0012 Phase 3 part 1) by @AbishYoung in #26
• Make the staging sort memory-cap test deterministic by @AbishYoung in #28
• Workspace manager on PostgreSQL (ADR 0012 Phase 3 part 2) by @AbishYoung in #27
• ADR 0017: user blogs (proposed) by @AbishYoung in #24
• Start new scripts and jobs from example templates by @AbishYoung in #23
• Query canvas: keep React Flow's measured sizes so a join drag survives a re-render by @AbishYoung in #21
• Schema changes on PostgreSQL (ADR 0012 Phase 3 part 3) by @AbishYoung in #29
• Type conversions on PostgreSQL; key cached statements by schema (ADR 0012 Phase 3 part 4) by @AbishYoung in #30
• Usernames (ADR 0017 phase 1) by @AbishYoung in #31
• Records on PostgreSQL (ADR 0012 Phase 3 part 5) by @AbishYoung in #32
• User SQL and saved queries on PostgreSQL (ADR 0012 Phase 3 part 6) by @AbishYoung in #33
• Blog workspaces and provisioning (ADR 0017 phase 2) by @AbishYoung in #34
• Reports on PostgreSQL, and SQLite's NULL order (ADR 0012 Phase 3 part 7) by @AbishYoung in #35
• Blog Markdown pipeline and post rules (ADR 0017 phase 3, part 1) by @AbishYoung in #36
• Blog authoring API (ADR 0017 phase 3, part 2) by @AbishYoung in #38
• Blog authoring UI (ADR 0017 phase 3, part 3) by @AbishYoung in #39
• Lua db on PostgreSQL; files and forms on both backends (ADR 0012 Phase 3 part 8) by @AbishYoung in #37
• Public blogs install switch and read model (ADR 0017 phase 4, part 1) by @AbishYoung in #40
• Public blog pages (ADR 0017 phase 4, part 2) by @AbishYoung in #42
• The rest of the services' suites on PostgreSQL (ADR 0012 Phase 3 part 9) by @AbishYoung in #41
• Public blog images and JSON (ADR 0017 phase 4, part 3) by @AbishYoung in #43
• The HTTP API suite on PostgreSQL (ADR 0012 Phase 3 part 10) by @AbishYoung in #44
• Lua query builder: db.select, db.update, db.delete (ADR 0013 §8) by @AbishYoung in #46
• Blog moderation API (ADR 0017 phase 5, part 1) by @AbishYoung in #45
• Bump the go-minor group with 2 updates by @dependabot[bot] in #48
• Bump pdfjs-dist from 6.3.289 to 6.4.299 in /tests/e2e in the e2e-minor group by @dependabot[bot] in #49
• Bump golangci/golangci-lint-action from 8 to 9 by @dependabot[bot] in #52
• Bump actions/cache from 4 to 6 by @dependabot[bot] in #56
• Bump docker/setup-buildx-action from 3 to 4 by @dependabot[bot] in #51
• Bump docker/setup-qemu-action from 3 to 4 by @dependabot[bot] in #53
• Bump docker/build-push-action from 6 to 7 by @dependabot[bot] in #54
• ci(dependabot): ignore TypeScript >=6 and Node >=25 major bumps by @AbishYoung in #57
• User blogs moderation UI, Atom feed, cover images, UI polish, and docs (ADR 0017 phases 5–7) by @AbishYoung in #58
• PostgreSQL soft DB size quota, portable archive interchange, backups/restore, and serve wiring (ADR 0012 Phase 3.11 & Phase 4) by @AbishYoung in #59
• ci: bump actions (checkout@v7, setup-go@v7, setup-node@v6, upload-artifact@v6, download-artifact@v7) by @AbishYoung in #65
• feat(workspaces): enhance member candidates, role clarity, and published apps on cards by @AbishYoung in #66
• refactor(demo): separate Northwind Traders and Biosecurity Watch sample projects by @AbishYoung in #67
• feat(script): expand safe Lua host modules across foreign APIs, DB, UI, and data analysis by @AbishYoung in #68
• feat(messages): add internal direct and workspace messaging with threaded replies by @AbishYoung in #69
• docs: revamp README for 1.0.0 release, refresh screenshots, and ready semantic versioning by @AbishYoung in #70
• fix(ci): fix release workflow dependencies and web build pipeline by @AbishYoung in #71
• fix(cmd): add Windows file lock support and disable release matrix fail-fast by @AbishYoung in #72

New Contributors

• @AbishYoung made their first contribution in #1
• @dependabot[bot] made their first contribution in #48

Full Changelog: https://github.com/AbishYoung/AbiData/commits/v1.0.0