tostore

3.1.2

Fixed

• Urgently fixed cache update issues for new key-value update operations (e.g., setMany) introduced in 3.1.1.
• Urgently fixed cache update issues for new table batch update operations (e.g., batchUpdate) introduced in 3.1.1.
• Fixed glibc statvfs FFI struct field padding on 64-bit Linux to prevent memory heap corruption and crashes when retrieving disk free space.

Changed

• Improved comprehensive benchmark testing for all new interfaces to prevent similar issues in future releases.

Fixed

• Urgently fixed cache update issues for new key-value update operations (e.g., setMany) introduced in 3.1.1.
• Urgently fixed cache update issues for new table batch update operations (e.g., batchUpdate) introduced in 3.1.1.
• Fixed glibc statvfs FFI struct field padding on 64-bit Linux to prevent memory heap corruption and crashes when retrieving disk free space.

Changed

• Improved comprehensive benchmark testing for all new interfaces to prevent similar issues in future releases.

Fixed

• Fixed upsert validation for numeric unique keys
• Optimized database lifecycle resilience during space switching and closure.

Added

• Added batchUpdate bulk update interface.
• Added db.kv namespace for advanced Key-Value operations (e.g., db.kv.get(), db.kv.clear(), db.kv.count(), db.kv.setMany()).

Changed

• Standardized the database shutdown and cleanup pipeline for improved stability.
• Improved documentation navigation compatibility
• Optimized memory cleanup
• Optimized count() performance
• Enhanced system table protection to prevent accidental manual deletion/clearing of critical internal tables.
• Optimized query channel performance, significantly improving the performance of data operations including queries, bulk inserts, and bulk updates.
• Optimized resource-aware scheduling for improved resource management.
• Optimized dense computation and parallel thread scheduling for better isolate dispatch efficiency and high-volume batch processing performance.
• Optimized very large update and delete operations.

Fixed

• Fixed upsert validation for numeric unique keys
• Optimized database lifecycle resilience during space switching and closure.

Added

• Added batchUpdate bulk update interface.
• Added db.kv namespace for advanced Key-Value operations (e.g., db.kv.get(), db.kv.clear(), db.kv.count(), db.kv.setMany()).

Changed

• Standardized the database shutdown and cleanup pipeline for improved stability.
• Improved documentation navigation compatibility
• Optimized memory cleanup
• Optimized count() performance
• Enhanced system table protection to prevent accidental manual deletion/clearing of critical internal tables.
• Optimized query channel performance, significantly improving the performance of data operations including queries, bulk inserts, and bulk updates.
• Optimized resource-aware scheduling for improved resource management.
• Optimized dense computation and parallel thread scheduling for better isolate dispatch efficiency and high-volume batch processing performance.
• Optimized very large update and delete operations.

3.1.0

Added

• Added support for key-value TTL expiration automatic cleanup via setValue(..., {Duration? ttl, DateTime? expiresAt})
• Added support for key-value data state monitoring via db.watchValue and db.watchValues to facilitate UI refreshing
• Added some semantic queries: support whereTrue、whereFalse、whereEmpty、whereNotEmpty、whereStartsWith、whereEndsWith

Changed

• Optimized benchmark tests
• Optimized documentation and multi-language

Fixed

• Fixed global config cache state leakage between different database instances in the same process.

Added

• Added support for key-value TTL expiration automatic cleanup via setValue(..., {Duration? ttl, DateTime? expiresAt})
• Added support for key-value data state monitoring via db.watchValue and db.watchValues to facilitate UI refreshing
• Added some semantic queries: support whereTrue、whereFalse、whereEmpty、whereNotEmpty、whereStartsWith、whereEndsWith

Changed

• Optimized benchmark tests
• Optimized documentation and multi-language

Fixed

• Fixed global config cache state leakage between different database instances in the same process.

3.0.9
Changed
Optimized upsert handling for concurrently executed records when the primary key and unique key contain the same value
Optimized WebAssembly build support on the Web platform
Optimized table structure migration validation
Improved table structure migration and integrity check error reporting, providing detailed failure reasons
Optimized documentation and multi-language
Fixed
Fixed an issue where composite index queries could fall back to table scans

Changed

• Optimized upsert handling for concurrently executed records when the primary key and unique key contain the same value
• Optimized WebAssembly build support on the Web platform
• Optimized table structure migration validation
• Improved table structure migration and integrity check error reporting, providing detailed failure reasons

Fixed

• Fixed an issue where composite index queries could fall back to table scans

3.0.8

Added

• Added aggregation functions: sum(), avg(), min(), max()
• Added groupBy(), having(), distinct() query support
• Added Agg helper for inline aggregation in select()
• Added tableExists API to check whether a table is defined in the database schema (space‑agnostic)
• Added query('table').exists() chain API for efficient existence checks based on conditions without loading full records
• Added table schema TTL configuration and automatic expiration cleanup for time-based data
• Added pure memory mode (ToStore.memory()), providing ultra-high performance for scenarios like data caching, temporary computation, or diskless environments

Fixed

• Fixed count() consistency with write buffer and index scan paths
• Fixed type cast error in aggregation return values

Changed

• Changed license from MIT to Apache License 2.0
• Optimized watch() with adaptive debounce to coalesce high-frequency data change notifications, avoiding redundant re-queries under burst writes
• Optimized batchInsert insertion performance for large-scale batch write scenarios
• Optimized Windows performance

Added

• Added aggregation functions: sum(), avg(), min(), max()
• Added groupBy(), having(), distinct() query support
• Added Agg helper for inline aggregation in select()
• Added tableExists API to check whether a table is defined in the database schema (space‑agnostic)
• Added query('table').exists() chain API for efficient existence checks based on conditions without loading full records
• Added table schema TTL configuration and automatic expiration cleanup for time-based data
• Added pure memory mode (ToStore.memory()), providing ultra-high performance for scenarios like data caching, temporary computation, or diskless environments

Fixed

• Fixed count() consistency with write buffer and index scan paths
• Fixed type cast error in aggregation return values

Changed

• Changed license from MIT to Apache License 2.0
• Optimized watch() with adaptive debounce to coalesce high-frequency data change notifications, avoiding redundant re-queries under burst writes
• Optimized batchInsert insertion performance for large-scale batch write scenarios
• Optimized Windows performance

Added

• Added aggregation functions: sum(), avg(), min(), max()
• Added groupBy(), having(), distinct() query support
• Added Agg helper for inline aggregation in select()
• Added tableExists API to check whether a table is defined in the database schema (space‑agnostic)
• Added query('table').exists() chain API for efficient existence checks based on conditions without loading full records
• Added table schema TTL configuration and automatic expiration cleanup for time-based data
• Added pure memory mode (ToStore.memory()), providing ultra-high performance for scenarios like data caching, temporary computation, or diskless environments

Fixed

• Fixed count() consistency with write buffer and index scan paths
• Fixed type cast error in aggregation return values

Changed

• Changed license from MIT to Apache License 2.0
• Optimized watch() with adaptive debounce to coalesce high-frequency data change notifications, avoiding redundant re-queries under burst writes
• Optimized batchInsert insertion performance for large-scale batch write scenarios
• Optimized Windows performance

3.0.5
Added
Added ToCrypto for encrypting specific field values
Added batchUpsert for batch upsert operations
Added atomic condition judgment expressions for conditional updates and logic in expressions
Changed
Intelligent workload scheduling for more stable behavior under very large data volumes
Adjusted upsert API: removed chained query conditions; use atomic condition expressions for conditional upsert logic
switchSpace and close: added keepActive / keepActiveSpace options to manage active space for “keep login state” and “logout” scenarios, avoiding extra open-then-switch flow; opening with default space can use stored active space so the first open lands in the last used space
Optimized constraint and migration prompt wording and consistency
Standardized README and translation docs (multi-space, login state, and close examples)
Optimized documentation
Optimized initialization loading
Fixed
Fixed Windows file handle issues caused by atomic replacement and stream reading
Fixed vulnerability where the system could treat numeric values as bigint by default
Fixed numerical precision issues on Web

Added

• Added ToCrypto for encrypting specific field values
• Added batchUpsert for batch upsert operations
• Added atomic condition judgment expressions for conditional updates and logic in expressions

Changed

• Intelligent workload scheduling for more stable behavior under very large data volumes
• Adjusted upsert API: removed chained query conditions; use atomic condition expressions for conditional upsert logic
• switchSpace and close: added keepActive / keepActiveSpace options to manage active space for “keep login state” and “logout” scenarios, avoiding extra open-then-switch flow; opening with default space can use stored active space so the first open lands in the last used space
• Optimized constraint and migration prompt wording and consistency
• Standardized README and translation docs (multi-space, login state, and close examples)
• Optimized documentation
• Optimized initialization loading

Fixed

• Fixed Windows file handle issues caused by atomic replacement and stream reading
• Fixed vulnerability where the system could treat numeric values as bigint by default
• Fixed numerical precision issues on Web

3.0.3

Added

• Added ToCrypto for encrypting specific field values
• Added batchUpsert for batch upsert operations
• Added atomic condition judgment expressions for conditional updates and logic in expressions

Changed

• Adjusted upsert API: removed chained query conditions; use atomic condition expressions for conditional upsert logic
• switchSpace and close: added keepActive / keepActiveSpace options to manage active space for “keep login state” and “logout” scenarios, avoiding extra open-then-switch flow; opening with default space can use stored active space so the first open lands in the last used space
• Optimized constraint and migration prompt wording and consistency
• Standardized README and translation docs (multi-space, login state, and close examples)

Fixed

• Fixed Windows file process occupancy issue
• Fixed vulnerability where the system could treat numeric values as bigint by default

3.0.2

Added

• Added foreign key support with comprehensive relationship management and referential integrity enforcement
• Added atomic expression update operations for efficient batch data modifications
• Added AES encryption support for critical data including logs, indexes, and table data, with device fingerprint binding for enhanced security
• Added data change listeners for arbitrary queries, enabling automatic UI refresh when data changes
• Added cursor-based pagination support for efficient large dataset navigation

Changed

• Enhanced WAL (Write-Ahead Logging) and journal recovery mechanisms to handle catastrophic failures, power outages, and premature application shutdowns, ensuring data integrity through comprehensive benchmark testing
• Enhanced transaction handling with improved reliability and performance
• Optimized storage space usage, reducing data footprint
• Improved pure Dart environment support for better server-side compatibility
• Refined partitioning strategy with B+ tree, implementing file-level tree node structures to support TB and PB-scale data volumes on edge devices
• Optimized parallel scheduling mechanism for better resource utilization and performance
• Enhanced TreeCache caching mechanism for improved memory efficiency and access speed
• Improved UI responsiveness and smoothness across various operations

Added

• Added foreign key support with comprehensive relationship management and referential integrity enforcement
• Added atomic expression update operations for efficient batch data modifications
• Added AES encryption support for critical data including logs, indexes, and table data, with device fingerprint binding for enhanced security
• Added data change listeners for arbitrary queries, enabling automatic UI refresh when data changes
• Added cursor-based pagination support for efficient large dataset navigation

Changed

• Enhanced WAL (Write-Ahead Logging) and journal recovery mechanisms to handle catastrophic failures, power outages, and premature application shutdowns, ensuring data integrity through comprehensive benchmark testing
• Enhanced transaction handling with improved reliability and performance
• Optimized storage space usage, reducing data footprint
• Improved pure Dart environment support for better server-side compatibility
• Refined partitioning strategy with B+ tree, implementing file-level tree node structures to support TB and PB-scale data volumes on edge devices
• Optimized parallel scheduling mechanism for better resource utilization and performance
• Enhanced TreeCache caching mechanism for improved memory efficiency and access speed
• Improved UI responsiveness and smoothness across various operations

Removed

• Removed automatic query cache management. A more efficient caching mechanism is now in place, making it unnecessary for non-large-scale data scenarios.

Changed

• Optimized UI smoothness and responsiveness for large-scale data insertion, deletion, and updates.
• Improved performance for limit, sorting, and pagination.
• Feat: Intelligent idle task mechanism for optimized power consumption and data safety on mobile devices.

Fixed

• Fixed a path issue that occurred when using a custom dbName.
• Fixed an issue where parallel searches would return prematurely upon finding a result.
• Fixed an issue where key changes during initialization would not be logged.

Changed

• Refactored the value matching engine for more precise and efficient algorithm implementation.
• Adjusted the return type of setValue to DbResult for a more consistent and informative result model.
• Optimized compute performance by refining task distribution and resource management.
• Fine-tuned the query optimizer for better execution plan generation and improved query performance.
• Enhanced benchmark tests and data view.

Added

• Added DataType.json to support JSON and Map data types.
• Added benchmark tests to simulate production environments with hundreds of thousands of concurrent operations (insert, update, delete, query) across multiple tables. This enables one-click validation of all database APIs and functional integrity, enhancing reliability.
• Added a data view for a more direct and intuitive data manipulation experience.

Changed

• Optimized space management.

Added

• Implemented a unified parallel computing scheduler to manage and execute concurrent tasks efficiently.
• Introduced noQueryCache method to allow explicit disabling of the query cache for individual queries.
• Added performance testing and one-click validation for all database interfaces, enabling comprehensive automated integrity checks.

Changed

• Optimized CPU-intensive operations by offloading them to background isolates, ensuring a smooth UI experience while maximizing computational throughput.
• Enhanced memory management with granular scheduling for multi-level cache systems.
• Re-architected indexing algorithms for improved scalability and performance with large-scale datasets.
• Significantly improved the throughput of write and delete buffers for high-volume data operations.
• Refined query cache mechanisms for better performance and control.

Fixed

• Resolved a memory overflow issue in the caching system when handling ultra-large datasets.

Changed

• Optimized cache cleanup logic for large-scale data scenarios.
• Refined B+Tree node splitting algorithm to handle high-volume index data more robustly.
• Optimized retrieval algorithms for binary search and range queries.

Fixed

• Addressed an issue in the query cache cleanup mechanism.

Added

• Added DefaultValueType to support default values that automatically fill current timestamp

Changed

• Enhanced B+Tree index structure for optimized retrieval efficiency and data access speed
• Improved data repair mechanisms for better consistency and reliability
• Optimized hash calculation algorithm for table structure comparison
• Improved overall system stability and reliability with comprehensive testing under high-load conditions

Fixed

• Fixed issues during index deletion process

Added

• Implemented comprehensive intelligent parallel processing mechanism for database operations, boosting performance by several times
• Added advanced computational models for cparallel processing
• Introduced dynamic resource allocation system for optimized memory management
• Enhanced buffering mechanism with predictive data loading capabilities

Changed

• Completely redesigned index architecture for faster data retrieval and reduced latency
• Optimized buffer management with improved write/delete handling
• Enhanced memory usage through dynamic allocation based on workload patterns
• Refined error handling and recovery processes for increased reliability

Fixed

• Resolved concurrency issues in high-load environments

Added

• Added useQueryCache and clearQueryCache APIs for fine-grained developer control over query caching
• Enhanced query capabilities with new condition, whereCustom methods and QueryCondition builder
• Implemented support for infinitely nestable complex query conditions with fully customizable data retrieval logic

Changed

• Optimized indexing algorithms for improved data retrieval performance
• Enhanced parallel processing mechanism for data migrations, increasing migration efficiency
• Improved documentation examples with additional complex query scenarios

Fixed

• Fixed issue where primary keys were not properly included in regular field indexes
• Resolved JOIN operation failures when primary and foreign keys had different types
• Implemented automatic repair for corrupted index structures, improving system stability

Changed

• Adjusted whether to delete backup files and whether to compress backup files when restoring them

Fixed

• Fixed the zip compression issue of backup files on the web platform

Changed

• Adjust document example

Fixed

• Fixed string comparison issue where values with and without quotes weren't being matched comparison
• Improved query execution for secondary indexes when handling string values
• Fixed empty results when querying non-primary index fields with quoted string values

Added

• Cross-platform support for Web, Linux, Windows, Mobile, and Mac platforms
• Neural network-inspired distributed architecture with interconnected node topology
• Efficient data partitioning mechanism for distributed processing
• Isolate parallel processing for improved read/write operations with dynamic workload balancing
• Multi-node computational network for parallel data operations
• Resource-aware distributed processing framework
• Distributed primary key algorithms (sequential, timestampBased, datePrefixed, shortCode)
• Support for unlimited node expansion with adaptive scaling
• Intelligent schema migration with precise table/field rename detection and automatic data migration
• Stream query interface (streamQuery) for efficient large data processing
• ChaCha20Poly1305 encryption algorithm for secure table data encoding/decoding
• Startup caching mechanism for faster application launch
• Enhanced data retrieval capabilities with optimized indexing and search patterns

Changed

• Complete architecture overhaul to support network-based distributed processing
• Enhanced cross-platform storage abstraction with efficient data distribution
• Intelligent workload distribution across computational nodes

Changed

• Optimized large file handling with chunked storage support

Fixed

• Fixed file path handling issues in cross-platform environments

Changed

• Improved auto increment setting validation and handling
• Enhanced data type validation with better error messages
• Added automatic primary key type conversion for auto increment
• Fixed DateTime serialization and validation
• Improved error handling in file operations

Breaking Changes

• Renamed renameTo to renameTable
• Changed field operation naming to be more consistent:
  • dropField -> removeField
  • dropIndex -> removeIndex

Enhancements

• Improved schema migration logic
• Optimized file operations using FileManager

Bug Fixes

• Fixed transaction handling in schema operations

• Update topics in pubspec.yaml
• Fix data type conversion in DataStoreImpl

Added

• Added automatic schema upgrade support through schemas parameter
• Added chainable schema update operations for table structure modifications
• Added comprehensive example for schema upgrades and migrations

Changed

• Improved table structure upgrade mechanism
• Enhanced documentation with schema upgrade examples
• Optimized constraint checking

Added

• Added upsert() for auto upsert data
• Supports both where conditions and primary key matching
• Chain-style API consistent with other operations
• Added array data type for storing List values
• Added array comparison and sorting support
• Optimized array type validation

• Added multi-language documentation support (日本語, 한국어, Español, Português, Русский, Deutsch, Français, Italiano, Türkçe)
• Reorganized documentation structure under docs/translations directory

Changed

• Optimized multi-space switching
• Refined documentation examples