DataChat v1.0.0

First general-availability release of DataChat. Two big leaps since v1.0.0-rc1: one-click installers for Windows and macOS and a first-run Setup Wizard so you can go from download to chat without editing config files.

Highlights

🪟 Native installers for Windows & macOS

• DataChat-Setup-1.0.0-x64.exe (Inno Setup) registers DataChat as a Windows Service running on Kestrel — no IIS required.
• DataChat-Installer-1.0.0.pkg (universal Apple Silicon + Intel) installs a LaunchAgent that starts at login.
• Self-contained .NET 8 publish — no .NET runtime install required on the target machine.
• Both installers prompt for a database choice: bundled local SQL or "use my existing server" (which hands off to the Setup Wizard).
• Windows bundled-DB path uses the official aka.ms/sql2025express bootstrapper (SQL2025-SSEI-Expr.exe) for an unattended install of SQL Server 2025 Express.
• macOS bundled-DB path runs mcr.microsoft.com/mssql/server:2025-latest via Docker Desktop.
• Tesseract OCR is bundled — Windows ships the native DLLs and downloads eng.traineddata; macOS uses brew install tesseract + the same model file, with DYLD_FALLBACK_LIBRARY_PATH wired so the .NET wrapper finds the dylib on both architectures.
• See installer/README.md for build instructions. Builds are unsigned in this release — expect SmartScreen / Gatekeeper prompts on first launch.

🪄 First-run Setup Wizard

• 3-step wizard at http://localhost:<port> on a fresh install: connection string → apply migrations → create admin user.
• New SetupStateService / ConnectionStringService detect missing connection, unreachable DB, and missing schema, and route the user accordingly.
• DatabaseHealthCheck is now setup-aware so /health reports a sane state during onboarding.

🐳 Docker support

• Multi-stage Dockerfile (.NET 8 + Tesseract OCR baked in).
• docker-compose.yml includes SQL Server with health checks and persistent volumes for keys, logs, uploads, and SQL data.
• Optimized build context via .dockerignore.

🚀 Production deployment improvements

• Automatic database migrations on startup (in non-Development or with APPLY_MIGRATIONS=true).
• Brotli/Gzip response compression.
• Graceful shutdown with a 30-second timeout and lifecycle logging.
• Custom error pages for 403/404/500.
• Kestrel configured for a 100 MB request limit (file uploads).
• Optional HTTPS via HTTPS_CERTIFICATE_PATH / HTTPS_CERTIFICATE_PASSWORD.

Bug fixes

• Data source selector now respects cleared selections.
• Fixed EF Core FirstOrDefault warnings.
• Fixed DbContext connection-closed error in CurrentUserService.

Upgrading

• From v1.0.0-rc1: pull, run migrations on startup (or set APPLY_MIGRATIONS=true). No breaking config changes.
• Fresh install: download the installer for your platform, run it, complete the Setup Wizard.

Known limitations

• Installers are unsigned this release — Authenticode signing on Windows and Developer ID notarization on macOS will follow.
• macOS bundled SQL uses Docker Desktop and inherits its licensing terms.

Full changelog

v1.0.0-rc1...v1.0.0:

• 19d745a Use SQL Server 2025 Express bootstrapper
• 6802063 Bundle Tesseract OCR with the installers
• 907e1c2 Add Windows and macOS installers
• c118e27 Update README with setup wizard and Docker documentation
• e9e0ab5 Add database setup wizard for first-run configuration
• 35c2291 Add Docker support and production deployment features

v1.0.0-rc2

Release Candidate 2

New Features

• Database Setup Wizard: First-run setup experience that guides users through:
  • Database connection configuration with test functionality
  • Automatic migration application with progress display
  • Initial administrator account creation
• Setup State Detection: Automatically detects when setup is needed (missing connection, unreachable database, pending migrations, no admin user)

Improvements

• Enhanced health checks with setup-aware status reporting
• Idempotent migrations to handle edge cases gracefully
• Connection string management with environment-specific storage

Changes Since rc1

• Added complete first-run setup wizard
• Fixed migration column conflict issue

v1.0.0-rc1

DataChat v1.0.0-rc1

First release candidate for the DataChat enterprise AI chat application with RAG capabilities.

Features

• Multi-provider LLM Support: OpenAI, Azure OpenAI, and Ollama
• RAG (Retrieval-Augmented Generation): Document ingestion with SQL Server 2025 vector search
• Personal Documents: Per-user document collections
• Data Source Selector: Per-message and per-user data source filtering
• Authentication: Local and Windows Authentication modes
• Admin Dashboard: User management, data sources, configuration, and audit logs

Production Readiness (New in this release)

• Security: SQL injection fix, rate limiting, security headers, input validation
• Resilience: Health checks, circuit breaker pattern, request queuing
• Observability: Audit logging, correlation IDs, structured file logging
• Scalability: Connection pooling, configuration caching, optimized SignalR

Requirements

• .NET 8.0
• SQL Server 2025 (for native vector search) or SQL Server 2019+ (fallback mode)
• OpenAI API key, Azure OpenAI, or Ollama instance

Getting Started

See the README for configuration instructions.