Visual SQLite

Visual SQLite

Visual SQLite is a simple and complete SQLite 3 database processor. It simplifies your work with SQLite. The user friendly GUI lets you manage all the data in a convenient way. It allows you to manage all database structures (tables, indexes and triggers), to modify a table schema. This application is a replacement for the SQLite command-line tool. Version 1.5 may include unspecified updates, enhancements, or bug fixes.

Do you know about any visual development tool such as Microsoft Access or FileMaker but that uses SQlite as database engine?

I’m looking for a Windows desktop software (or easy programming language) with which I can build a database application that uses SQLite.

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information…

The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems [1] [2] [3] and as a long-term archival format for data [4]. There are over 1 trillion (1e12) SQLite databases in active use [5].

SQLite source code is in the public-domain and is free to everyone to use for any purpose.

The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive. This document provides a brief introduction on how to use the sqlite3 program.

Start the sqlite3 program by typing “sqlite3” at the command prompt, optionally followed by the name the file that holds the SQLite database (or ZIP archive). If the named file does not exist, a new database file with the given name will be created automatically. If no database file is specified on the command-line, a temporary database is created and automatically deleted when the “sqlite3” program exits.

On startup, the sqlite3 program will show a brief banner message then prompt you to enter SQL. Type in SQL statements (terminated by a semicolon), press “Enter” and the SQL will be executed.

Features

• Query SQLite databases and view results in a table (also supports dot commands like .tables, .schema, ecc).
• Export query results to json, csv and html.
• Sidebar explorer: list databases, tables, views and columns.
• Autocompletion for SQLite keywords, table and views names, column names (autocompletion is available for an SQL document once its bound to a database, to bind an sql document to a database use the command SQLite: Use Database)
• Grammar support for SQLite keywords. This is available for documents with language sqlite. You can mark a document as an sqlite document adding -- sqlite in the first line.