MSGraphDBSynchronizer v2025.06.06.1203

New in v2025.06.06.1203

** SQLite WAL Mode & Timestamp Improvements**

• ** SQLite WAL Mode**: Enhanced concurrent access support for Metabase and other BI tools
• ** Improved Timestamp Handling**: Proper timestamp column types across all databases for perfect sortability
• ** Smart Field Detection**: Automatic timestamp field detection by name patterns and content
• ** Performance Optimizations**: Enhanced WAL configuration with optimized cache settings
• ** Enhanced Logging**: Better visibility into column type assignments and database operations

Database Compatibility & BI Tools

SQLite WAL Mode enables concurrent access for business intelligence tools:

• Metabase: Connect directly to SQLite database while service is running
• Grafana: Real-time dashboards with SQLite data source
• Power BI: Import data without service interruption
• Tableau: Live connections supported

Timestamp Handling ensures proper sorting across all databases:

• SQLite: \DATETIME\ columns with ISO 8601 format
• PostgreSQL: \TIMESTAMPTZ\ columns with timezone support
• MSSQL: \DATETIME2\ columns with high precision

Installation

1. Download the appropriate binary for your platform
2. Extract the archive
3. Configure \config.json\ with your settings
4. Run the binary

What's Changed

• Enhanced SQLite WAL mode configuration with performance optimizations
• Improved timestamp column type detection and normalization
• Smart field name detection for automatic timestamp handling
• Better concurrent access support for BI tools
• Enhanced logging for database operations

Full Changelog: https://github.com/gracesolutions/MSGraphDBSynchronizer/compare/v2.0.0...v2025.06.06.1203