{"repo":"joelseq/sqliteadmin-go","free":true,"listed":false,"github":"https://github.com/joelseq/sqliteadmin-go","clone":"git clone https://github.com/joelseq/sqliteadmin-go.git","description":"Admin tool for interacting with an embedded SQLite database","language":"Go","stars":52,"topics":["admin","admin-dashboard","golang","golang-library","sqlite","sqlite3"],"license":"MIT","category":"dashboards-admin","readme_excerpt":"SQLite Admin SQLite Admin is a Golang library and binary which enables you to easily interact with a SQLite database. It allows you to: - Browse tables and their schemas. - View table data along with adding filters, limits and offsets. - Modify individual columns in existing rows. It can either be integrated into an existing Golang backend as a library or installed as a binary. The web server can be interacted with by going to https://sqliteadmin.dev. The source code for the web UI can be found at https://github.com/joelseq/sqliteadmin-ui Motivation SQLite is very easy to add as an embedded database but it's difficult to manage the database once it's deployed in an application. Existing tools primarily focus on local SQLite files, requiring manual interaction through CLI tools or desktop applications. If your SQLite database is running embedded within an application, there are few (if any) solutions that let you inspect, query, and modify it without complex workarounds. The alternative is to use a cloud-hosted version like those provided by Turso which enables interacting with the database using tools like Drizzle Studio. This adds complexity to the setup and deployment of your application and you lose out on the value of having an embedded database. This project fills that gap by providing an easy way to view and manage an embedded SQLite database via a web UI — no need to migrate to a cloud provider or use ad-hoc solutions. Using as a library Check out the full code at exam","default_branch":null,"files":null,"tree":[],"storefront":"/r/joelseq","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/joelseq/sqliteadmin-go/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}