# SQLiteDatabaseManager

**Repository Path**: LinRaise/SQLiteDatabaseManager

## Basic Information

- **Project Name**: SQLiteDatabaseManager
- **Description**: SQLite DatabaseManager is a SQLite Database IDE. A free graphical user interface, that allows to perform several database tasks, its light and great for beginners.
- **Primary Language**: C#
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2018-09-09
- **Last Updated**: 2022-04-24

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQLiteDatabaseManager
**SQLite DatabaseManager** is a SQLite Database IDE. A free graphical user interface, that allows to perform several database tasks, its light and great for beginners.

![Main Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/mainScreen.PNG)

## Features

* Create SQLite connections.
* Create SQLite database files.
* Create Database objects (tables, indexes, triggers, views)
* Execute SQL statements:
    DDL (Data Definition Language)
    DML (Data Manipulation Language)
    DQL (Data Query Language)
* Open and Save .sql files.

## Table of Contents

<!-- toc -->
- [Creating SQLite Connection](#creating-sqlite-connection)
- [Creating SQLite Database Files](#creating-sqlite-database-files)
- [Creating Tables](#creating-tables)
- [Creating Indexes](#creating-indexes)
- [Creating Triggers](#creating-triggers)
- [Creating Views](#creating-views)

# Creating SQLite Connection 

![Create Connection Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/createConnection.PNG)

Feature to add to your connections any existing SQLite database file you have. Currently only works with (.sqlite) extension files

# Creating SQLite Database Files

![Create Connection Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/createDatabase.PNG)

Feature to create a SQLite database file, you have to select the location of the file and input the name of the database.

# Creating Tables

![Create Connection Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/createTable.PNG)

Module to create a table in the current selected database, set a table Name and add columns.
This form has one tab to see the generated DLL, which you can analyze before creating the table.

# Creating Indexes

![Create Connection Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/createIndex.PNG)

The create trigger module allows the developer to add indexes to the selected table. To access this module expand the desired table, right click on the option Indexes and 'Create index'

# Creating Triggers

![Create Connection Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/createTrigger.PNG)

The create trigger module allows the developer to add triggers to the selected table. To access this module expand the desired table, right click on the option Triggers and 'Create trigger'

# Creating Views

![Create Connection Screenshot](https://github.com/Vicra/SQLiteDatabaseManager/blob/master/GithubImages/createView.PNG)

Create views module allows you to create a view on the SQLite database, to create a view right click on the Views option and select the 'Create View' item.


## Icons Attributions

- Icons made by [Freepik](https://www.freepik.com/) from www.flaticon.com 
- Icons made by [Smash Icons](https://smashicons.com/) from www.flaticon.com 
- Icons made by [Pixel Buddha](https://www.flaticon.com/authors/pixel-buddha) from www.flaticon.com 
- Icons made by [Dave Gandy](https://fontawesome.com/?from=io) from www.flaticon.com