{"repo":"venkat1017/SQLight","free":true,"listed":false,"github":"https://github.com/venkat1017/SQLight","clone":"git clone https://github.com/venkat1017/SQLight.git","description":"Demo and other details can be found here","language":"Go","stars":37,"topics":["database","go","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLight A lightweight SQLite clone with a modern web interface and CLI Features • Installation • Usage • Documentation • Contributing • License 📋 Overview SQLight is a lightweight SQLite clone implemented in Go that provides a simple yet functional database system with persistent storage. It features both a modern web interface and a traditional command-line interface, making it versatile for different use cases. This project demonstrates core database concepts including SQL parsing, query execution, transaction management, and persistent storage while maintaining a clean, user-friendly interface. ✨ Features 🖥️ Dual Interface Support - Modern Web Interface with real-time query execution and interactive table browsing - Traditional Command Line Interface for script-based and terminal operations 📊 SQL Command Support - CREATE TABLE - Create tables with specified columns and data types - INSERT INTO - Insert records into tables - SELECT - Query records with support for WHERE clauses and column selection - DELETE - Remove records with WHERE clause filtering - More commands coming soon! 🔄 Data Types - INTEGER - Whole numbers - TEXT - String values - More types coming soon! 🛠️ Advanced Features - Transaction Support for atomic operations - Case-insensitive SQL command and table/column name handling - WHERE Clause Support with multiple conditions using AND - String Value Handling with support for both single and double quotes - Persistent Storage using JSON - Data Type Validati","default_branch":null,"files":null,"tree":[],"storefront":"/r/venkat1017","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/venkat1017/SQLight/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."}