Skip to content

Releases

Admiral v01

Admiral v01 Latest
Latest

Choose a tag to compare

View all tags
@CodeInPas CodeInPas released this 30 Aug 05:14
release_v01
e2c7fab
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

⚓ Admiral v0.1.0 — Initial Release Notes

Welcome to the initial public release of Admiral (v0.1.0)!

Admiral is a lightweight, cross-platform, native Multi-DBMS desktop administration tool built with Free Pascal and the Lazarus IDE. This initial release provides high-performance, memory-efficient, and secure database management featuring integrated geospatial mapping and local offline AI assistance.

🌟 Key Highlights in v0.1.0

🗄️ Multi-DBMS Connectivity & Security

  • Supported Database Engines: Native connectivity for SQLite 3, MySQL, MariaDB, PostgreSQL, and Firebird via ZeosDBO.
  • Integrated SSH Tunneling: Built-in encrypted local port-forwarding to securely reach remote servers without exposing public database ports.
  • Connection Profile Manager: Fast switching and persistent local storage for multiple database credentials and environments.

🗺️ Geospatial Map Viewer (lazmapviewer)

  • Automatic Coordinate Detection: Intelligently identifies coordinate fields (lat, latitude, lng, longitude, geom, etc.) in query result sets.
  • Fast Marker Rendering: Plots geographic points onto OpenStreetMap, OpenTopoMap, CyclOSM, and CartoDB tile layers.
  • Smart Auto-Fit Bounds: Calculates bounding boxes and automatically fits camera zoom levels to keep all dataset points in view.

🤖 Local AI Copilot Integration (Offline & OpenAI Compatible)

  • Private Local LLM Inference: Native integration with local model runners (llama.cpp server, Ollama, LM Studio) using GGUF models such as Qwen2.5-Coder and SQLCoder.
  • One-Click AI Diagnostic & Fix: Analyzes SQL runtime exceptions and suggests corrected syntax directly in the query editor.
  • Query Optimizer & Explainer: Refactors slow queries and generates structured documentation for complex joins and subqueries.

⚡ SQL Editor & Schema Management

  • Context-Aware IntelliSense: Instant auto-completion for tables, views, and columns triggered by typing . or pressing Ctrl + Space.
  • Native View DDL Extraction: Extracts underlying CREATE VIEW definitions with DBMS-specific safe replacement syntax (CREATE OR REPLACE VIEW / DROP VIEW IF EXISTS).
  • Non-Blocking Background Worker: Query execution runs in dedicated background threads to keep the user interface responsive.
  • Visual Query Builder, BI Charts & Explain Plan: Visual query designer, data graphing (Bar, Line, Pie), and query execution plan breakdown.

🛡️ Safety Guardrails & Advanced Tools

  • Safe Mode Guardrails: Prevents catastrophic accidental data loss with confirmation prompts for DROP, TRUNCATE, and unconstrained DELETE/UPDATE operations.
  • Interactive CLI Terminal: Built-in command-line emulator supporting internal meta-commands (\dt, \l, \d, \status) and direct SQL execution.
  • Two-Way Visual ERD Modeler: Visualizes entity relationships with forward and reverse engineering support.

📦 Downloads & Binaries

⚙️ Building from Source

To compile Admiral from source:

  • Lazarus IDE: $\ge$ v3.0 (LCL)
  • Free Pascal Compiler (FPC): $\ge$ v3.2.2
  • Required Packages (via Online Package Manager):
    • zeosdbo (v8.0+)
    • lazmapviewerpkg
    • synedit
    • bgracontrols & bgrabitmappack
Assets 3
Loading