Skip to content

SQLite Administrator. A query editor first approach! Written in C# and open source.

License

Notifications You must be signed in to change notification settings

xenoinc/SQLiteAdmin

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

67 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQLite Admin

Copyright 2017-2019 (C) Xeno Innovations, Inc.

WARNING: Prototype in progress!

SQLite Admin is a lightweight management studio for SQLite databases, powered by .NET.

The long-term goal is to be able to manage a DB's tables, edit views, merge DBs, encrypt (ADO.NET), etc. . This is a complete rework of XI's internal project started back on 2011-06-17.

Project Status

Currently a work in progress to provide a simple SQLite management studio.

Milestones

1: Basic editor

Single database instance SQL syntax editor with executions. Start with SQLite engine, System.Data.Sqlite.

2: Object Explorer

Simple DB object explorer to display: tables, views, etc.

3: Solutions

Save project as solutions to be more IDE like.

Ungroomed Features

  • Multi-DB Management - Ability to manage multiple database connections in a single project
  • Selectable Engines - Ability to choose which SQLite engine to execute from
  • Multi-platform - Rework core system to be Mono compliant and run on multiple platforms.

Source Code

The main project resides in the src folder.

Great admin tools come with great editors, which is why we're using AvalonEdit. The current hurdle is that this framework (using WinForms) is not easily testable which is why I'd like to move to an MVVM approach written in C#. Since AvalonEdit is written using WPF, this may be our natural progression.

Main Code and Test Benches

  • src - Main project written in WinForms (soon to be deprecated)
  • test-ava - Test bench for multi-platform codebase written in Avalonia
  • test-wpf - Test bench written in WPF

Syntax Highlighting

Our current editor is AvalonEdit.

Other editors considered:

Editor Framework Notes
ScintillaNET WinForms
RoslynPad GitHub WPF Port of AvalonEdit
AvaloniaEdit Avalonia Port of AvalonEdit

About

SQLite Administrator. A query editor first approach! Written in C# and open source.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages