v0.31.0
LatestBuild
- build(winget): use standalone wingetcreate.exe (Appx unsupported on PS7)
- build(winget): submit generated manifests instead of wingetcreate update
Chores
- chore(aur): update dora to 0.30.3
Changelog
Dora changelog
Release notes for Dora v0.36.0 and earlier versions, synced from shipped desktop builds.
v0.32.0
v0.33.0
Bug Fixes
- fix(release): ship arm64-only Homebrew cask, add tap docs
- fix(studio): keep the connection dropdown open across repeated deletes
- fix(backend): give every query a unique id so concurrent submissions don't clobber each other
Chores
- chore(aur): update dora to 0.32.0
- chore(marketing): drop the postbuild SEO audit
Features
Refactoring
- refactor(studio): extract command palette internals, move palette to Ctrl+K
- refactor(marketing): derive the whole palette from one brand hue
v0.34.0
Bug Fixes
- fix(docs): remove duplicate H1 from doc bodies
Chores
- chore(aur): update dora to 0.33.0
Documentation
- docs(installation): document Winget and APT install channels
Features
- feat: refresh Dora promo and analytics
v0.35.0
v0.35.1
Chores
- chore(aur): update dora to 0.35.0
Documentation
- docs(readme): lead with compressed demo tour, tighten intro
v0.36.0
v0.30.3
Features
- DuckDB-backed local file queries (CSV, Parquet, JSON) now run in a separate helper process instead of being linked into the main app binary, keeping the heavy engine out of the core download
Bug Fixes
- the SQL and ORM editors now load reliably in packaged builds — Monaco and its fonts are fully self-hosted instead of being fetched from a CDN that the app's content-security policy blocked, which previously left the editor stuck on a blank loading state with mis-spaced text in release builds
- connection-refused errors now name the host that could not be reached instead of showing a generic message
Performance
- data-viewer edits now apply instantly — optimistic updates no longer flash back to the stale value before the save lands
Styling
- a single 12-blade radial spinner is now used everywhere a loading indicator appears
v0.30.2
Features
- Privacy mode can now mask cell values in database results, including grids, SQL results, and runner output (#182)
Bug Fixes
- Debian/Ubuntu install instructions and apt repository generation now use the current GitHub Pages path
Chores
- Updated the Tauri updater plugin to 2.10.1
- Changelog data generation now skips the empty Unreleased placeholder
v0.30.1
Bug Fixes
Chores
- chore(aur): update dora to 0.30.0
Features
v0.30.0
Features
- spin up a local MySQL container straight from the Docker manager — MySQL joins PostgreSQL, MariaDB, and CockroachDB as a one-click provisionable engine, with version presets, auto-detected free port, connect-in-data-viewer, SQL seeding, and Compose export
- the bundled `docker-compose.databases.yml` now covers every server engine Dora can talk to locally — PostgreSQL, MySQL, MariaDB, CockroachDB, and libSQL/sqld — for testing against a real database in one `docker compose up`
- ORM cockpit — link a project folder, detect its Drizzle or Prisma schema, compare it against the live database, and preview a dialect-correct migration; drift is grouped per table and flagged safe/review/destructive, with destructive and review statements gated behind explicit opt-in before the SQL is handed to the console
- connect a Cloudflare D1 database with an API token and pick it from your account — a native HTTP query engine, no local file required (#139, #150)
- connect a PlanetScale database with a service token and pick a branch (#141, #149)
- connect a Vercel Postgres store with a token and pick it from your account (#147)
- connect a Xata database with a key and pick it from your account (#140, #148)
- Neon connections are now branch-aware — pick a branch when a project has more than one (#142, #156)
- keep multiple database connections open at once, each with its own isolated tab group; a connection tab bar above the table tabs switches between them (with status dots and per-connection close), and switching preserves each connection's open tabs, active tab, filters and scroll state. Cycle connections with `Ctrl+Shift+[` / `Ctrl+Shift+]` (#96)
- hardened Turso, Supabase, and Neon connect flows with account visibility — Turso gains robust CLI detection and in-app sign-in, and each provider shows "Connected as", a refresh button, paginated project/organization lists, and clearer empty and error states
Bug Fixes
- AI provider errors now use clear, consistent copy across all providers (Groq, OpenAI, Anthropic, Gemini, Ollama): rate limits, invalid keys, missing models, and an offline Ollama daemon each surface an actionable message instead of a raw HTTP status and response body (#82)
- the AI rate-limit message includes a retry hint so the user knows to wait and try again (#82)
- data-grid optimistic cell edits no longer flash back to the stale value before the save lands
- the sidebar no longer blanks out when you rename, duplicate, or drop a table
Performance
- the marketing home page ships ~24.7 kB less gzipped JS on first load (-8.6%) by deferring the animation engine until after hydration; first paint is pure CSS so there is no perceived change
Documentation
- AI Keys settings now spell out that Groq/OpenAI/Anthropic/Gemini need an API key while Ollama runs locally with no key, pointing to `docs/ai-providers.md` for setup (#82)
- new end-user installation guide with a full platform matrix (macOS Apple Silicon/Intel, Windows, Linux packages, and the AUR)
- new connection guides for Cloudflare D1 and Xata, plus ORM Cockpit and ORM Runners guides on doradb.app/docs
Closed issues
- ORM & migration cockpit (Pillar 2) — tracking #143, Wave A schema IR + introspection #144, Wave B parsers + folder linking + diff engine #145, Wave C/D migration generation + cockpit UI #146
- Cloudflare D1 connector #139
- Xata connector #140
- PlanetScale connector #141
- Branch-aware connects for PlanetScale and Neon #142
- Documentation — docs site at doradb.app/docs #130, installation & distribution matrix #131, provider & dialect reference #132, serverless & hosted provider showcase #133, full feature showcase #134
v0.29.0
Bug Fixes
- fix(backend): replace high-risk unwrap/panic with error propagation
- fix(studio): resolve strictNullChecks violations
CI/CD
- ci: lower asset count floor to 9 after dropping Intel-macOS build
- ci: bump bun pin to 1.3.14 and add tsc --noEmit typecheck gate
Chores
- chore(ts): enable strictNullChecks for studio and desktop
Features
- feat(marketing): add 15 hosted-provider connection guides for SEO
- feat(connections): Fly.io proxy hint in connection dialog
- feat(connections): first-class presets for 10 hosted providers
- feat(prisma-runner): Prisma ORM Runner — write & execute Prisma client queries natively (#137)
- feat(connections): hosted/serverless provider support + Supabase integration (#128)
- feat(connections): one-click Supabase OAuth + reliable pooler host
- feat(marketing): feature-showcase polish + Prisma runner showcase
- feat(studio): connection dialog, docker view & Supabase flow refinements
- feat(database-studio): drop column support
v0.28.0
Features
- add source metadata layer (`describeConnectionSource`, `getSourceCaps`, `isUiActionVisible`) so UI visibility follows connection capabilities instead of engine string checks
- open CSV, JSON, Parquet, TSV, and NDJSON as readonly **data files** (DuckDB-backed sessions) with health indicators, recovery actions, and connection summaries
- **Save as DuckDB** — materialize active data-file sessions into editable `.duckdb` files
- **Import files** — import CSV/JSON/Parquet as physical tables in native DuckDB file connections
- open SQLite and DuckDB files as editable embedded databases
- drag tabs to reorder them (pinned tabs stay grouped first) (#105)
- open tabs are persisted and restored across relaunch (#98)
- binary/blob cells now show inline hex for small values and a `<type — size>` summary (with magic-byte detection) for large ones, instead of a bare byte count (#90)
- data-grid filters can be joined with OR via an AND/OR toggle, not only AND (#102)
- JSON/CSV/SQL export now respects the active filters and sort order instead of dumping the whole table or just the loaded page (#99)
- back up a database to a `.sql` dump and restore from one via the data-grid actions menu (#103)
- "Fix with AI" on a failed query sends the query and error to the AI assistant (#104)
Reliability
- recover gracefully from missing or moved data-file sources when reopening a connection
- clearer failure copy for save/import paths (no active files, destination conflicts, partial imports, schema refresh warnings)
Fixes
- schema-visualizer SVG and PNG export now follows the active theme instead of always exporting dark-theme colours (#112)
- cancelling a Postgres query no longer logs benign "channel closed" error noise (#83)
- SQL console loading shell and editor surfaces now use a themed `--editor` token, so they no longer render a black rectangle in light and non-dark themes (#114)
- data-grid column headers show a tooltip with the full column name and type, but only when the label is actually truncated (#115)
- database-studio empty states no longer re-fire their entrance animation on every tab switch, removing the zoom/flicker (#113)
- AI provider status dot is no longer colour-only — it uses a filled vs hollow shape plus `aria-pressed`/`aria-label` for screen readers (#116)
- SQLite `VACUUM`, `DETACH DATABASE`, and some `PRAGMA` forms no longer fail to run — they are classified via a keyword fallback when the AST parser rejects them (#94)
Documentation
- README support matrix and **Local files** section explaining database files vs data files
- add `docs/ai-providers.md` — per-provider setup, recommended models, key storage, and troubleshooting (#91)
Tooling
Internal
- remove unused `DisabledFeature`/`NotImplemented` components and the deprecated `database-studio/api.ts` (#95)
- drop the inaccurate PgBouncer scaffold comment in `types.rs` now that `use_simple_query` is fully wired (#92)
- model statement execution result as an enum instead of a `returns_values` bool, making page/column state unrepresentable for non-row-returning queries (#93)
v0.27.0
Features
- add multi-provider AI support for OpenAI, Anthropic, Gemini, Groq, and Ollama
- add encrypted API key storage, provider/model selection, and usage history
- add in-app Ollama setup flow with installer, runtime helpers, and model management
- feed live table indexes into assistant schema context
- extract Dora Studio into `@dora/studio` for desktop and marketing web demo
- render shared Studio at `/app` and refresh marketing landing with live demos and release-aware downloads
- add `Ctrl+Shift+B` to toggle the AI assistant from the Studio keyboard flow
Bug Fixes
- preserve high-precision numeric values and BIGINTs during cell editing
- fix typed Postgres/SQLite cell edit and add-record binding behavior
- improve credential-store recovery with OS-aware keyring install actions
Refactoring
- move reusable Studio experience into `packages/studio`
- rebuild marketing app-demo framing, theme polish, and deployment metadata
CI/CD
- harden release automation with generated notes, post-release changelog sync, and package-manager fan-out
- bump release line to 0.27.0 across root, desktop, Tauri, and Cargo manifests
v0.26.5
Bug Fixes
- improve connection UX and Groq chat mode handling
CI/CD
- extend asset poll budget for packaging workflows to 30 minutes
Other
- Dora follow-up stability and UI fixes
Refactoring
- redesign connection switcher with inline delete, settings panel, and sidebar polish
v0.26.4
Bug Fixes
- bump version files in package/tauri/cargo before tagging
Chores
- automate package publishing
- add generate:releasetext script
- use git-cliff for release text generation
- add release script that auto-bumps, tags, and generates release text
- release script now auto-pushes and creates GitHub release
- fix release script to push tag separately
Features
v0.26.2
Bug Fixes
- extract linux tarball binary from tauri-built .deb
v0.26.1
No release notes published for this version.
v0.26.0
Bug Fixes
- cast UPDATE value to column type during cell edits
- preserve JSON shape when editing object cells
CI/CD
- add one-shot tag-create workflow
Chores
- update dora to 0.25.0
- fix source URL to use v0.25.1 release tag
- update dora to 0.25.1
- regenerate Tauri bindings
- prune stale apps/db-tester entries from bun.lock
Features
- pooler-compatible simple-query mode and pooler detection
- pooler-compatible mode toggle in connection form
- structured SQL responses, dry run, syntax highlighting, mock backend
- dedicated settings workspace replacing popover
Performance
- backfill exact row counts when planner estimate is zero
v0.25.2
Bug Fixes
- install pinned bun archive path
- pin compatible bun archive
- use compatible bun for install
- tolerate immutable release uploads
CI/CD
- publish package manager artifacts safely
v0.25.1
Bug Fixes
- rewrite store with useReducer to fix concurrent-mode state update bug
- remove nested button, use div+sibling-buttons for tab pills
- add skip-first-row and stop-on-error toggles to import dialog
- guard empty import, clear file input on close, memoize nonPKColumns
- FK schema-qualified navigation, CSV file size guard
- use --user flag for flatpak remote-add and install on GitHub Actions
CI/CD
- add Flatpak publish workflow
Chores
- update dora to 0.2.0
- bump version to 0.25.0, add changelog entry
Documentation
- add v0.25 PRD — tabs, FK drill-down, CSV import
- add v0.25 implementation plan (9 tasks, tabs + FK + CSV)
- add v0.25.0 changelog entry to CHANGELOG.md and fix commit ref in sidebar data
Features
- chat-style AI assistant sidebar (#63)
- add tab context store with 12-tab cap
- add TabBar component with close and middle-click support
- wire TabsProvider, TabBar, and openTab into Index.tsx
- plumb FK metadata into ColumnDefinition and enrich columns in DatabaseStudio
- add FK drill-down icon, opens referenced table in new tab
- add RFC 4180 CSV parser and column mapping utilities
- add CSV import dialog with preview, column mapping, and progress
- Dora v0.25.0 — Multi-Table Tabs, FK Drill-Down & CSV Import
v0.2.2
Bug Fixes
- use analytics ingestion endpoint
- use custom analytics ingestion domain
- align database studio headers
CI/CD
- allow manual dispatch for a specific release tag
Features
- centralize analytics providers
- add native dora AUR packaging and v0.2.0 updates (#62)
Other
- detect pgbouncer=true flag and plumb use_simple_query
v0.0.117
Bug Fixes
- git-cliff config and workflow to generate proper release notes
v0.0.116
Features
- auto-generate release notes with git-cliff
v0.0.113
Features
- update desktop app and add Homebrew Cask integration
v0.0.112
Testing
- update desktop tests for schema visualizer release
v0.0.111
Chores
- release v0.0.111
Features
- addd schema visualizer
- addd schema visualizer (#61)
Refactoring
- apply consistent rustfmt styling across codebase and add row virtualizer for data grid components
v0.0.110
Bug Fixes
- disable transparent windows to prevent WebKit/Wayland crash
Documentation
- add schema visualizer + AI SQL to README, bump download links to 0.0.109
Features
- animated edges, theme-aware colors, search autocomplete
- chained schema-aware autocomplete
- multi-tab console and async row count
v0.0.109
Bug Fixes
- resolve .deb URL from release assets instead of constructing from tag version
- resolve CI lint, snap, AUR and winget failures
- escape ${srcdir}/${pkgdir} in PKGBUILD template literal
- use type instead of interface in analytics-dispatcher
Chores
- add GPG public key for apt repo signing
- cleanup lib.rs debug guard and bindings.ts docstring noise
Documentation
- add backend refactor checklist for remaining phases (5b, 5c, 4, 8)
- add product roadmap with tiered features and frontend checklist
- add keyboard shortcut UI spec using @remcostoeten/use-shortcut
Features
Refactoring
- split commands.rs by domain (phase 1) (#47)
- split storage.rs + typed Error enum (phases 2-3) (#48)
- scaffold WriteAdapter trait (phase 5a) (#49)
- add tracing + spans (phase 6) (#50)
- kill production unwraps, add clippy enforcement (phase 7) (#51)
- port mutation logic into WriteAdapter impls (#53)
- wire new error shape and type safety (phase 8)
- ConnectionRepository trait on AppState (phase 4)
- ConnectionRepository trait on AppState (phase 4) (#55)
- wire new error shape and type safety (phase 8) (#56)
- WatchAdapter trait per driver (phase 5c)
- WatchAdapter trait per driver (phase 5c) (#54)
v0.0.107
Bug Fixes
- add missing analytics-dispatcher, remove stale live-monitor test
Features
- self-hosted apt repository — sudo apt install dora
v0.0.106
Features
- v0.0.106 — global live monitor, SSH tunnels, file exports, AUR binary
v0.0.104
Bug Fixes
- harden winget release workflow
- stabilize rust tests and snap release upload
Documentation
- sync embedded homebrew tap
Features
- allow record editing
v0.0.103
Bug Fixes
- react err
- run snap workflow in destructive mode
- adopt snap metadata from build part
- skip release upload on manual snap publish
Chores
- update snap workflow, README, and snapcraft for MySQL support
- update snap workflow, README, and snapcraft for MySQL support (#46)
- opt snap workflow into node 24 actions
Features
Other
- cut v0.0.103
v0.0.102
Bug Fixes
- run snapcraft with sudo in CI
- use bun run in snap build scriptlet
- build snap binary with cargo release
Other
- prepare v0.0.102
v0.0.101
Documentation
- add homebrew installation section
Features
- add homebrew tap for dora
Other
- prepare v0.0.101
v0.1.0
Bug Fixes
- change build target to esnext to resolve CI esbuild transform error
v0.0.100
Bug Fixes
- use valid GitHub Actions commit SHAs
- use stable branch for rust-toolchain to avoid parsing issues
Chores
- pin GitHub Actions to specific commit SHAs
v0.0.98
Chores
- checkpoint current workspace before live monitor refactor
- remove bloat
- add all uncommitted changes
- release v0.0.98
Documentation
- add animated WEBP showcase to README
Features
- add live database updates
Refactoring
- replace frontend live polling with backend live monitor manager
v0.0.97
Other
- UX polish, shortcuts & cleanup
- cut v0.0.97 with type-safety fixes and docker updates
v0.0.96
Features
- mouse-promo recorder and accessibillity
- finalize Windows Tauri dev and CLI automation
- merge Windows Tauri dev, libsql-rusqlite, and CLI automation
v0.0.95
Bug Fixes
- repair changelog popover render and restore scroll
- use supported intel macOS runner
Chores
- prepare v0.0.95 and refresh changelog metadata
Features
- add rpm msi and intel macOS build target
v0.0.94
Bug Fixes
- resolve failing tests and rust compile issues
- unblock rust tests in github actions
- add postgres initdb bin path for pgtemp tests
- resolve pipeline failures (#32)
- restore cross-platform release flow and prep v0.0.94 (#33)
- use vcpkg sqlite on windows and avoid sqlite symbol clashes
- export vcpkg sqlite library paths for windows linker
Documentation
- update README with v0.0.93 download links and installation instructions
v0.0.93
Bug Fixes
- docker view sort error and save accumulated work
- resolve syntax error in database-studio.tsx
- replace native dialogs with shadcn components and clean up debug logs
- pass prebuild checks and fix production build
- correct rust-toolchain action reference and package.json syntax
Chores
- cleanup unused files and dependencies (audit)
- optimize insert_row allocation (backend round 2)
- snapshot before full system audit
- prepare v0.0.93 with comprehensive changelog
Features
- add cleanup audit tools
- performance optimizations (bundle split, zero-flash pagination, efficient IPC)
- Add Monaco Editor workers and LSP utilities to enhance code editing features.
- replace native alerts with shadcn and align bottom bars
- error handling, query history, and release-ready UI polish
- add custom shortcuts UI with persistence and dynamic bindings
- Add light/dark theme toggle, SQL snippet saving, and refactor connection snippet display.
- add typo detection with fuzzy matching
- add Drizzle-aware typo diagnostics with fuzzy suggestions
- integrate Drizzle-aware typo diagnostics across UI components
Performance
- efficient IPC layer, bundle split, monaco workers offload (#28)
v0.0.925
Bug Fixes
- improve sidebar dragging physics and animations
- sidebar resize now follows mouse in real-time instead of snapping
- propagate connection errors in test_connection
- Strip unsupported channel_binding parameter from PostgreSQL connection strings
- resolve table data loading and sort crash
- address CodeRabbit PR review comments
- lsp build issues
CI/CD
- upgrade runners to Blacksmith for 2x faster performance
- revert to standard ubuntu-latest runners
Chores
- cleanup dead/duplicate code files
- restructure frontend core
- save pending changes
- finalize resize and cleanup docs
- cleanup project structure (remove unused FE, rename docs, move test queries)
- misc fixes and improvements across desktop and api-docs
- prepare for release v0.0.9 - code style cleanup and fixes
- remove redundant api-docs project and move docs to root
- prepare release 0.0.92
- bump version to 0.0.925
Documentation
- update readme with beta feature status
- refine readme features and roadmap
Features
- add auto-fill, typo detection & validation for connection strings
- add autocomplete input with keyboard navigation
- refresh splash screen design
- add database-backed settings with theme persistence
- add sql-builder, resize-handle, UI improvements and border fixes
- add sql-builder, autocomplete and settings persistance (#1)
- implement accessible Label component and replace native labels
- implement AES-GCM encryption for connection storage
- implement get_connection method
- add context menu to saved connections
- add connection history tracking with filters
- enhance connections UI and data table UX with favorites, timestamps, sorting, pagination
- Implement command palette with global command system and persistent keyboard shortcuts.
- enhance connection string parsing, improve shortcut management, and refine UI interactions
- add command palette UI and refactor URL query string construction.
- Implement command usage tracking and persistence, add new application commands, and enhance command palette sorting based on usage history.
- Implement command palette with global command system (#4)
- add spreadsheet-like Table Browser with filtering, sorting, inline editing, and dry-run mode
- Implement dedicated table exploration view with a new `table-view` tab type and `TableBrowser` component.
- Implement schema visualization with React Flow and add back navigation to table browser.
- Implement core application structure, introduce shared UI components, and integrate Tauri commands for database management.
- Introduce unified header and logo components, refactor theme colors to hex/rgba, and add keyboard shortcuts for main view navigation.
- Introduce unified header and logo components, refactor theme co… (#6)
- Add Monaco Editor and Switchable SQL Editor components
- add database adapter trait, mutation API, and enhanced schema introspection
- add LibSQL database support for local and remote Turso connections
- add LibSQL database parsing and execution support
- Reorganize project structure and migrate existing components to a new `_old` directory layout.
- major backend upgrade
- update docs dependencies, add new desktop icons, and remove old Tauri database files.
- integrate AI service types with Specta
- expose and finalize SSH tunnel module
- implement Specta integration and generate TypeScript client
- add duplicate_row command for context menu actions
- implement snippet library with pre-made and user-created snippets
- introduce snippet categories for improved organization and filtering
- Backend API V2 & Specta Integration (#8)
- run queries via rust
- implement data provider pattern and refactor sidebar
- implement better web mock view
- implement data provider pattern for web mock view (#10)
- improve accessibillity for data viewer
- implement rust binding in FE
- implement missing desktop features
- add user theme and setting persistance
- add user theme and setting persistence (#11)
- implement SSH tunnel configuration for database connections
- SSH Tunnel configuration for database connections (#12)
- Schema Management (DDL) feature (#13)
- centralization keyboard shortcuts (#14)
- Undo/redo functionality, editor themes, DDL retrieval & dry mode (#15)
- implement changelog panel and cell improvements
- release version 0.0.9 by updating tauri config, adding release notes, and updating the README.
- Implement bulk edit and set null functionalities, and refactor … (#16)
- Redesign and reposition the DemoBanner as a fixed, floating component in the bottom-right corner.
- add Midnight, Forest, Claude Light, and Claude Dark themes with… (#19)
- Add new technical and vintage font options, remove density setting, and update Vercel deployment configurations.
- custom drizzle DSL LSP for monaco covering 100% of spec
- implement comprehensive test infrastructure\n\n- Add test scripts to package.json files\n- Configure Turbo build to depend on tests\n- Create GitHub Actions CI workflow with Postgres service\n- Migrate Rust tests to proper integration tests structure\n- Export Rust modules for testing access
- implement testing infrastructure
- implement testing suite and floating selecton bar (#20)
- sync monaco theme with ui switcher (#21)
- typo detection algorithm and testing infrastructure (#22)
- implement branding & LSP promotion helpers (#23)
- Implement theme synchronization, URL state management, and enhance data grid context menu handling. (#24)
- implement promotional LSP demo mode
- Introduce recording mode with configurable UI elements, environment variable support, and a visual overlay.
- update app logo, favicon, and sidebar branding
- Implement theme synchronization, URL state management, and enhance data grid context menu handling.
- Enhance table info dialog with PostgreSQL validation and SQL escaping, synchronize data grid focused cell, and simplify cell context menu API.
- Distinguish context menu kind in URL state, truncate large selected cell sets, and validate URL-derived table states against current table dimensions.
- introduce new application sidebar and integrate it with the database studio, including an animated toggle icon.
- implement docker container manager mvp (#25)
- enhance Docker container management with advanced creation options, connection snippets, compose export, and database seeding (#26)
- add Tauri dialog plugin and Zustand, and ignore local environment files in gitignore
- release 0.0.925 - docker manager, data seeder, build fixes
Other
- restore security and label features while keeping sidebar animations
- implement domain architecture (#5)
Refactoring
- reorganize components and enhance tabs with context menu, dnd, and pin support
- rename component-specific type aliases to Props and remove associated refactoring scripts.
- update metadata structs, fix parser compatibility, and resolve types
- Simplify web demo auto-connection logic to generically auto-select the first table.
Testing
- add comprehensive encryption tests