just_database 0.0.1

A pure-Dart SQL database engine with in-memory storage and optional file persistence.

Changelog

0.0.1 - 2026-02-20

Added

• Initial release of just_database
• Pure Dart SQL database engine with in-memory storage
• Optional file persistence for databases
• Support for CREATE, SELECT, INSERT, UPDATE, DELETE statements
• Primary key, unique, and foreign key constraints
• Composite indexes for multi-column queries
• Automatic query-based indexing (creates indexes after 100+ queries)
• Three concurrency modes: standard, read-fast, write-fast
• Query tracking and performance monitoring
• Index metadata with hit ratios and usage statistics
• Table-level composite PRIMARY KEY and UNIQUE constraints
• Automatic indexing of foreign key columns
• Index persistence in JSON format
• DatabaseManager for managing multiple databases
• Built-in Flutter admin UI components:
  • Database management screen
  • Schema inspector
  • SQL query editor with examples
  • Settings panel
  • Query history
• DatabaseProvider for state management
• Support for INTEGER, REAL, TEXT, BOOLEAN, and BLOB data types
• AUTOINCREMENT support for primary keys
• NOT NULL and DEFAULT constraints

Features

• Smart indexing system with automatic optimization
• Configurable persistence with path_provider integration
• Material 3 UI components with theme customization
• Comprehensive error handling and validation
• Query execution time tracking
• Database size monitoring

Known Limitations

• No JOIN operations in SQL parser (manual joins required)
• No transactions in SQL syntax
• No ALTER TABLE support
• Limited aggregate functions (planned for future release)

[Unreleased]

Planned

• JOIN support (INNER, LEFT, RIGHT, FULL)
• Transaction support (BEGIN, COMMIT, ROLLBACK)
• ALTER TABLE operations
• Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• GROUP BY and HAVING clauses
• Subqueries
• Views support
• Triggers
• More index types (R-tree for spatial data)
• Query optimization hints
• Backup and restore functionality
• Database migration tools
• Performance benchmarking tools