DB Visualizer
DB Visualizer is a powerful, modern, and lightweight application designed for effortless SQLite database exploration and analysis. Built with Tauri, React, and HeroUI, it provides a high-performance experience with a sleek, premium interface.
โจ Features
- ๐ Database Management: Easily import, track, and manage multiple SQLite databases.
- ๐ Deep Analysis: Automatic analysis of database content including:
- Character frequency distribution.
- Data type distribution (numeric, alphabetic, special).
- Format detection (Emails, URLs).
- ๐ Interactive Table View: Browse table data with high-speed pagination and real-time search.
- ๐ Visual Statistics: View file size, record counts, and table distribution at a glance.
- โก Background Processing: Heavy analysis tasks run in the background without freezing the UI.
๐ธ Screenshots
Dashboard: Quick access to recent databases and high-level platform statistics.
All Databases: Manage your library of SQLite files with detailed metadata and access tracking.
Import Database: Simple drag-and-drop or file selection interface for importing new databases.
Table View: High-performance data exploration with pagination and instant search.
Analytics: Deep visual insights into character frequencies and automatic data type detection.
๐ ๏ธ Tech Stack
๐ Getting Started
Prerequisites
Installation
Clone the repository:
git clone https://github.com/yourusername/db-visualizer.git
cd db-visualizer
Install dependencies:
npm install
Development
Run the application in development mode:
npm run tauri dev
Build
Build the production-ready application:
npm run tauri build
๐๏ธ Architecture
src-tauri/: Rust backend handling file system access and heavy SQLite operations.
src/: React frontend with a modular component structure.
src-tauri/src/lib.rs: Core Tauri commands and state management.
src-tauri/src/version.rs: Versioning logic exposed to the frontend.
๐ License
This project is licensed under the MIT License - see the LICENSE file for details.