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

A simple cross-platform desktop application to view and edit sqlite databases.

License

Notifications You must be signed in to change notification settings

dan-koller/sqlite-viewer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.