Introduction
SQLite Online Editor is an open-source web-based tool designed to simplify database management tasks. It allows users to easily connect to a folder, create, update, and delete databases, as well as manage tables, schemas, and data. The tool also features a SQL editor for executing custom queries, making it an ideal solution for developers and database administrators alike.
Getting Started
- Clone the repository from GitHub:
git clone <https://github.com/gautamkmahato/Sql-Editor-App> - Navigate to the project folder:
cd project-folder - Install dependencies:
npm install - Start the development server:
npm run dev
Connect to Folder
To connect to a folder, use the "Select Folder" option from the dashboard. This allows you to specify the directory where your SQLite databases are located.
Create New Database
You can create a new database by navigating to the "Databases" section and selecting the "Create New Database" option. Provide a name for your database and click "Save."
Create New Table
Use the "Create Table" feature in the "Tables" section to define a new table. Specify the table name, columns, and data types, then click "Create."
Check Schema
To view the schema of a table, select the table from the list and click on "View Schema." This will display the table's structure, including columns and data types.
SQL Editor
The SQL Editor allows you to execute custom SQL queries directly within the application. Use the query input field to write your SQL commands and click "Run" to execute them.
Add Data
To add data to a table, select the table from the list and click "Add Row." Fill in the required values for each column and save the changes.
Update Data
Update existing data by selecting a table, choosing a row to edit, and modifying the values. Save the changes to apply the updates.
Delete Data
Delete data from a table by selecting the rows you want to remove and clicking "Delete." Confirm the action to complete the process.
Delete Table
To delete a table, navigate to the "Tables" section, select the table, and click "Delete Table." Confirm the action to remove the table permanently.
Delete Database
Delete a database by going to the "Databases" section, selecting the database, and clicking "Delete Database." Confirm the deletion to complete the process.