awesome-repositories.com
Blog
awesome-repositories.com

Découvrez les meilleurs dépôts open-source grâce à notre recherche par IA.

ExplorerRecherches sélectionnéesAlternatives open sourceLogiciels auto-hébergésBlogPlan du site
ProjetÀ proposNotre méthodologiePresseServeur MCP
Mentions légalesConfidentialitéConditions d'utilisation
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·
coleifer avatar

coleifer/sqlite-web

0
View on GitHub↗
4,117 stars·399 forks·Python·MIT·12 vues

Sqlite Web

sqlite-web est une application web basée sur Python qui fournit une interface utilisateur graphique pour parcourir, interroger et éditer des fichiers de base de données SQLite. Il fonctionne comme un outil de gestion de base de données qui permet aux utilisateurs de manipuler les données de table et de gérer les schémas via un navigateur web plutôt que d'utiliser une ligne de commande ou des scripts SQL bruts.

L'application inclut des utilitaires pour la migration de données, permettant l'importation et l'exportation du contenu de la base de données via des formats de fichiers JSON et CSV. Elle fournit également un accès distant sécurisé aux bases de données via un contrôle d'accès par mot de passe et un chiffrement SSL.

Le projet couvre des capacités administratives plus larges incluant la gestion de connexion à la base de données, l'administration de schéma pour modifier les tables et les colonnes, et la prise en charge du déploiement via des services WSGI.

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.

Historique des stars

Graphique de l'historique des stars pour coleifer/sqlite-webGraphique de l'historique des stars pour coleifer/sqlite-web

Recherche par IA

Explorez plus de dépôts awesome

Décrivez vos besoins en langage naturel — l'IA classe des milliers de projets open source sélectionnés par pertinence.

Start searching with AI

Alternatives open source à Sqlite Web

Projets open source similaires, classés selon le nombre de fonctionnalités partagées avec Sqlite Web.
  • datlechin/tableproAvatar de datlechin

    datlechin/TablePro

    4,471Voir sur GitHub↗

    TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL and NoSQL databases. It functions as a unified workspace that integrates a code-centric SQL editor with schema visualization tools, allowing developers to manage complex data models and execute queries across diverse database engines. The application distinguishes itself through an agentic AI integration layer that connects language models directly to database tools, enabling automated query generation, optimization, and error fixing with configurable approval gates. It features

    Swift
    Voir sur GitHub↗4,471
  • pylons/pyramidAvatar de Pylons

    Pylons/pyramid

    4,086Voir sur GitHub↗

    Pyramid is a Python web framework and WSGI toolkit designed for building web applications. It functions as a URL routing engine that maps incoming HTTP requests to specific view callables using both pattern-based routing and hierarchical resource tree traversal. The framework is distinguished by its hybrid dispatch system, allowing developers to combine regular expression URL matching with the ability to resolve requests by navigating a tree of nested objects. It implements a flexible component architecture that supports application registry management, deferred configuration execution, and t

    Pythonpylonspyramidpython
    Voir sur GitHub↗4,086
  • outerbase/studioAvatar de outerbase

    outerbase/studio

    5,818Voir sur GitHub↗

    Studio is a containerized SQL database management tool that provides a browser-based graphical interface for executing queries and managing data across various SQL databases. It consists of a specialized query editor and a graphical administration interface designed for web-based database administration. The project features a high-performance SQL query editor with auto-completion and function hints for running multiple database commands simultaneously. It includes a visual schema editor for creating and modifying table columns and a record editor that stages and previews changes before they

    TypeScript
    Voir sur GitHub↗5,818
  • pawelsalawa/sqlitestudioAvatar de pawelsalawa

    pawelsalawa/sqlitestudio

    6,428Voir sur GitHub↗

    SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

    Ccppdatabasedatabase-management
    Voir sur GitHub↗6,428
Voir les 30 alternatives à Sqlite Web→

Questions fréquentes

Que fait coleifer/sqlite-web ?

sqlite-web est une application web basée sur Python qui fournit une interface utilisateur graphique pour parcourir, interroger et éditer des fichiers de base de données SQLite. Il fonctionne comme un outil de gestion de base de données qui permet aux utilisateurs de manipuler les données de table et de gérer les schémas via un navigateur web plutôt que d'utiliser une ligne de commande ou des scripts SQL bruts.

Quelles sont les fonctionnalités principales de coleifer/sqlite-web ?

Les fonctionnalités principales de coleifer/sqlite-web sont : Web-Based Database Browsers, Schema Administration, Data Schema Management, SQL Database Management, SQLite Database Management, SQLite Integration, SQL Data Exporters, Bulk Data Migrations.

Quelles sont les alternatives open-source à coleifer/sqlite-web ?

Les alternatives open-source à coleifer/sqlite-web incluent : datlechin/tablepro — TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL… pylons/pyramid — Pyramid is a Python web framework and WSGI toolkit designed for building web applications. It functions as a URL… outerbase/studio — Studio is a containerized SQL database management tool that provides a browser-based graphical interface for executing… pawelsalawa/sqlitestudio — SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a… kuzudb/kuzu — Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data… answerdotai/fasthtml — FastHTML is a full-stack Python web framework designed for building interactive web applications using pure Python. It…