coleifer/sqlite-web
Sqlite Web
sqlite-web ist eine Python-basierte Webanwendung, die eine grafische Benutzeroberfläche zum Durchsuchen, Abfragen und Bearbeiten von SQLite-Datenbankdateien bietet. Sie fungiert als Datenbank-Management-Tool, das es Benutzern ermöglicht, Tabellendaten zu manipulieren und Schemata über einen Webbrowser zu verwalten, anstatt Kommandozeilen- oder rohe SQL-Skripte zu verwenden.
Die Anwendung enthält Utilities für Datenmigration, die den Import und Export von Datenbankinhalten via JSON- und CSV-Dateiformaten ermöglichen. Sie bietet zudem sicheren Remote-Zugriff auf Datenbanken durch Passwort-Access-Control und SSL-Verschlüsselung.
Das Projekt deckt breitere administrative Funktionen ab, einschließlich Datenbank-Verbindungsmanagement, Schema-Administration zur Modifikation von Tabellen und Spalten sowie Unterstützung für das Deployment via WSGI-Services.
Features
- Web-Based Database Browsers - Provides a web-based interface to browse table data and perform manual CRUD operations.
- Schema Administration - Allows defining and modifying SQLite table structures, columns, and indexes through a graphical interface.
- Data Schema Management - Enables defining and modifying the database structure, including creating and altering tables and columns.
- SQL Database Management - Acts as a management tool for relational database instances, allowing schema and data manipulation.
- SQLite Database Management - Provides a complete suite of tools for managing, querying, and editing SQLite databases via a web browser.
- SQLite Integration - Connects directly to SQLite database files using a native driver for query execution.
- SQL Data Exporters - Converts SQLite table contents into portable CSV or JSON file formats.
- Bulk Data Migrations - Facilitates the movement of SQLite table data to and from external JSON or CSV files.
- Database Connection Management - Manages the lifecycle of connections by loading and unloading SQLite database files at runtime.
- External File Imports - Allows loading information from JSON or CSV files directly into database tables.
- File-Based Data Exports - Provides utilities to export database content into portable JSON and CSV file formats.
- Web-Based Database Clients - Offers secure, password-protected remote access to SQLite databases via a web browser.
- Request Authentication Middleware - Uses middleware to intercept HTTP requests and verify password credentials before granting access.
- Python Web Frameworks - Built as a server-side Python web application to provide a GUI for local database files.
- Flask Framework Implementations - Implemented as a web application using the Flask framework to handle routing and template rendering.
- Template-Driven Rendering - Generates the user interface by injecting database schema and row data into server-side HTML templates.
- Web - Listed in the “Web” section of the Awesome Sqlite awesome list.
