SQLiter: A Web-Based SQLite Database Editor with Go Backend and React Frontend

Introduction

SQLiter is a powerful web-based SQLite database editor designed to provide a comprehensive interface for browsing, editing, and managing SQLite databases. It features a robust Go backend and a modern React frontend, all packaged conveniently as a single executable. SQLiter offers advanced capabilities for data manipulation, querying, and schema management, making it an ideal tool for developers and data analysts. Key features include full CRUD operations, advanced filtering and sorting, a powerful SQL editor with syntax highlighting, and data export options.

Installation

Getting started with SQLiter is straightforward, whether you prefer using Docker or building from source.

Using Docker

To quickly deploy SQLiter with Docker:

# Build the Docker image
docker build -t sqliter .

# Run with your database
docker run -p 2826:2826 -v /path/to/your/database.db:/data/database.db sqliter --db /data/database.db

Building from Source

For those who prefer to build the application directly:

# Build everything using task commands
task build

# Run with your database
./sqliter --db example.db

Alternatively, you can build the frontend and backend manually:

1. Build the frontend:

   cd web
   npm install
   npm run build
   cd ..
   

2. Build the Go application:

   go build -o sqliter ./cmd/main.go
   

3. Run the application:

   ./sqliter --db your-database.db
   

Examples

Once SQLiter is running, typically accessible at http://localhost:2826, you can begin interacting with your SQLite databases.

Working with Data

• Viewing Data: Select any table from the left sidebar to display its contents in the main area.
• Editing Cells: Double-click any cell directly in the table to edit its value inline.
• Adding Rows: Use the green row at the bottom of the table or click the "Add Row" button to insert new records.
• Filtering: Click the "Filters" button to reveal column-specific filters, allowing you to narrow down your data.
• Sorting: Click column headers to sort data in ascending, descending, or unsorted order.
• Bulk Operations: Select multiple rows using checkboxes to perform batch actions.

SQL Editor

The integrated SQL Editor provides a powerful environment for custom queries:

1. Navigate: Go to the SQL Editor tab.
2. Write Query: Enter your SQL query in the editor, which supports syntax highlighting and auto-completion.
3. Execute: Press Ctrl+Enter or click "Run Query" to execute your SQL.
4. View Results: The results will be displayed in a formatted table below the editor.
5. Export: If needed, export the query results to CSV format.

Why Use SQLiter?

SQLiter stands out as a comprehensive and user-friendly solution for SQLite database management. Its modern web-based interface, built with React and Tailwind CSS, ensures a responsive and intuitive user experience. The application's single executable design simplifies deployment, while its Go backend provides efficient performance. With features like full CRUD operations, intelligent inline editing, advanced filtering with persistence, multi-level sorting, and a robust SQL editor, SQLiter empowers users to efficiently explore, manipulate, and maintain their SQLite databases. It's an excellent choice for anyone needing a powerful yet accessible SQLite GUI.

Links

• GitHub Repository: ronreiter/sqliter