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.
Currently a work in progress to provide a simple SQLite management studio.
Single database instance SQL syntax editor with executions. Start with SQLite engine, System.Data.Sqlite.
Simple DB object explorer to display: tables, views, etc.
Save project as solutions to be more IDE like.
- 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.
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.
src- Main project written in WinForms (soon to be deprecated)test-ava- Test bench for multi-platform codebase written in Avaloniatest-wpf- Test bench written in WPF
Our current editor is AvalonEdit.
Other editors considered:
| Editor | Framework | Notes |
|---|---|---|
| ScintillaNET | WinForms | |
| RoslynPad GitHub | WPF | Port of AvalonEdit |
| AvaloniaEdit | Avalonia | Port of AvalonEdit |