Skip to content
This repository has been archived by the owner on Mar 12, 2024. It is now read-only.

Latest commit

 

History

History
63 lines (39 loc) · 2.44 KB

README.md

File metadata and controls

63 lines (39 loc) · 2.44 KB
Raw

Sqlite Viewer

A desktop application to view and edit sqlite databases. It is written in Java and uses the sqlite JDBC driver.

Java 11 sqlite 3 MIT license

Screenshot of the text editor

Requirements

  • JRE 11 or higher to run the application
  • JDK 11 or higher to compile the application

Install

  • Download the .jar file from the release section or
  • Clone this repository and compile it yourself using ./gradlew build

Usage

  • Load a Sqlite *.db file from disk from the menu
  • Open it by clicking Connect
  • Select the table you want to edit or view
  • Enter a SQL query in the text area and click Execute to run it
  • See the result in the area below

To get started you can download a sample file from sqlitetutorial.net here.

Known issues

  • On Unix-like systems, double-clicking the jar file does not work in certain directory structures. In this case, you can run the jar file from the command line using java -jar sqlite-viewer.jar or place the jar file somewhere else.

Unix-like systems like Linux and macOS are - unlike Windows - using the home directory as the current working directory when double-clicking a jar file.

Technologies

  • Java 11
  • Gradle 7.4.1
  • Sqlite 3

License

This project is licensed under the MIT License - see the LICENSE file for details.