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

• Frontend: React 19, Vite
• UI Framework: HeroUI, Tailwind CSS 4
• Backend: Tauri 2 (Rust)
• Database: SQLite (via rusqlite)
• Icons: Lucide React
• Charts: Recharts

🚀 Getting Started

Prerequisites

• Node.js (Latest LTS)
• Rust
• Tauri Dependencies

Installation

1. Clone the repository:

   git clone https://github.com/yourusername/db-visualizer.git
   cd db-visualizer

2. 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.