14 Releases 14 Tags

RSS Feed

• 0.1.3 75f8106ca5

  Compare

  NexaPG 0.1.3 Stable

  nessi released this 2026-02-13 09:14:17 +00:00 | 48 commits to main since this release

  Fixed

  • Query Insights: selected query no longer jumps to another/latest row after background refresh.
  • Stabilized selection logic by preserving selected item via queryid across data reloads.

  Technical

  • Query Insights refresh flow now uses stable references to avoid unintended re-selection on rerender/token refresh.
  • Selection fallback now only applies when the previously selected query no longer exists in refreshed data.

  Notes

  • No database migration required.
  • Safe patch release; redeploy/restart is sufficient.

  Downloads

  • Source Code (ZIP)
  • Source Code (TAR.GZ)
• 0.1.2 07a7236282

  Compare

  NexaPG 0.1.2 Stable

  nessi released this 2026-02-13 08:36:24 +00:00 | 53 commits to main since this release

  Added

  • New User Settings entry in the sidebar (above Logout).
  • New User Settings page at /user-settings.
  • User self-service password change flow:
    • current password verification
    • new password + confirmation
    • minimum length validation

  Backend

  • Added endpoint:
    • POST /api/v1/me/password
  • Password change security behavior:
    • rejects invalid current password
    • rejects reusing the same password
    • stores new password hashed (Argon2)
  • Added audit log event:
    • auth.password_change
  • Added request schema:
    • UserPasswordChange

  Frontend

  • New UserSettingsPage with clear error/success feedback.
  • New profile action button styling (User Settings) integrated with existing sidebar design.

  UX / Service Information Improvements

  • Automatic update checks every 30 seconds while logged in.
  • Service Information navigation button now highlights (yellow) when an update is available.
  • Service Information page visual refresh for clearer update status presentation.
  • Removed noisy audit logging for automatic service update checks.

  Release / Version Control Policy

  • Version display remains maintainer-controlled in code.
  • Update checks remain tied to official upstream release source.

  Notes

  • No DB migration required specifically for the password-change feature.
  • If upgrading from 0.1.1, normal redeploy/restart is sufficient.

  Downloads

  • Source Code (ZIP)
  • Source Code (TAR.GZ)
• 0.1.1 18d6289807

  Compare

  NexaPG 0.1.1 Stable

  nessi released this 2026-02-13 08:10:35 +00:00 | 55 commits to main since this release

  Added

  • New Service Information section in the sidebar and UI.

  • New backend endpoints for service/runtime metadata:

    • GET /api/v1/service/info
    • POST /api/v1/service/info/check

  • Persistent service info storage (service_info_settings) for:

    • latest checked version
    • update status
    • last check timestamp / error state

  • Initial Alembic migration for service info:

    • 0008_service_settings.py

  Changed

  • Update checks now use the official upstream NexaPG repository:
    • git.nesterovic.cc/nessi/NexaPG
  • Version check logic is now release-focused (latest published release), easier to manage than commit-based checks.
  • Service Information page is now read-only for end users.

  Security / Hardening

  • Removed .env-based version override.
  • APP_VERSION is no longer user-configurable via environment.
  • NexaPG version is now controlled only in code (config.py NEXAPG_VERSION).

  Docs

  • Updated README for Service Information and update-check behavior.
  • Updated .env.example to remove APP_VERSION and related mutable version settings.

  Upgrade Notes

  • Run migrations when upgrading from 0.1.0:
    • make migrate
  • Restart backend after update:
    • make down && make up
  • If you previously used APP_VERSION in .env, it is now ignored/removed by design.

  Downloads

  • Source Code (ZIP)
  • Source Code (TAR.GZ)
• 0.1.0 0445a72764

  Compare

  NexaPG v0.1.0 — Initial Public Release Stable

  nessi released this 2026-02-13 08:00:59 +00:00 | 57 commits to main since this release

  NexaPG 0.1.0 is the first public release of our PostgreSQL monitoring platform focused on practical operations, clear visibility, and modern UX.

  Highlights

  • Multi-target PostgreSQL monitoring (remote instances)

  • FastAPI backend + React frontend + PostgreSQL core DB

  • Docker Compose stack for quick deployment

  • RBAC with JWT authentication (admin, operator, viewer)

  • Target credential encryption at rest

  • Structured audit logging and backend JSON logs

  • Background polling collector with configurable interval

  • Core PostgreSQL metrics and system views:

    • pg_stat_database
    • pg_stat_activity
    • pg_stat_bgwriter / pg_stat_checkpointer compatibility handling
    • pg_locks
    • optional pg_stat_statements

  • DBA-ready Target Detail with database overview, replication/storage insights, and charts

  • Easy/DBA view mode toggle for different user skill levels

  • Query Insights with ranking, search, optimization hints, and pagination

  • Alerting system with warning/alert severities

    • built-in standard alerts
    • custom SQL alerts
    • realtime alert updates + in-app toast notifications

  • Target owner model:

    • assign responsible users per target
    • alert emails sent only to assigned owners

  • SMTP admin settings with test mail and customizable templates

  • Service Information page with release-based upstream update check

  • PostgreSQL compatibility smoke tests for versions 14 to 18

  • Notes

  • This is the baseline release and foundation for upcoming features.

  • Query Insights require pg_stat_statements on monitored targets where enabled.

  • Update detection is based on published upstream releases.

  Downloads

  • Source Code (ZIP)
  • Source Code (TAR.GZ)