Skip to content

LakeDB v1.0.0-beta.5.0

Choose a tag to compare

View all tags
@DavLagoHern DavLagoHern released this 01 Aug 14:37
· 46 commits to main since this release
v1.0.0-beta.5.0
4d062c1

LakeDB 1.0.0 Beta 5.0

Beta 5 brings immediate SQL feedback into the editor. Common syntax mistakes
are detected locally while you type, with precise markers, short explanations
and safe quick fixes. Optional AI correction can help with errors that need
more context, while QuerIA remains focused on generating reviewable queries
from natural-language requests.

Local SQL diagnostics

  • Detect common MySQL and MariaDB syntax problems without executing the query
    or contacting an AI service.
  • Highlight the relevant line or token and explain unclosed quotes, comments
    and parentheses, misplaced or missing commas, incomplete clauses, clause
    order, keyword mistakes and several malformed expressions.
  • Offer local quick fixes only when the replacement is unambiguous.
  • Analyze with a short debounce in a worker so typing remains responsive.

Optional AI correction

  • Choose Resolve with AI from an editor diagnostic to receive a brief
    explanation and complete corrected SQL for review.
  • Apply the proposed SQL explicitly, copy it or discard it. LakeDB never runs
    the corrected statement automatically.
  • After a MySQL or MariaDB execution error, keep the original server message
    visible and optionally request an explanation with corrected SQL to copy.
  • QuerIA remains the separate query-generation experience. AI correction is a
    focused action for SQL already present in the editor.

Faster large-table browsing

  • Table pages no longer wait for an exact COUNT(*), avoiding expensive full
    counts before the first rows appear on very large tables.
  • Browse up to 10,000 rows interactively. LakeDB clearly marks when more rows
    exist and recommends adding filters or using the complete export workflow.
  • Changing filters, sorting or rows per page keeps pagination responsive
    without issuing a background exact count.
  • Complete CSV, JSON Lines and SQL exports remain available for datasets beyond
    the interactive browsing window.

Compatibility, privacy and data

Existing connections, credentials, workspaces, saved queries, history and
QuerIA settings are retained. No user database is migrated or modified.

Local diagnostics do not send SQL anywhere. AI correction is contacted only
after an explicit action and can temporarily process the SQL, a reported
database error and limited metadata for referenced tables. Database
credentials, table rows and query results are never sent, and correction
requests are not retained by LakeDB Service.

Packages are prepared for macOS Apple Silicon, Windows x64 and Linux x64. This
pre-1.0 beta uses an ad-hoc macOS signature and is not notarized; Windows
packages remain unsigned and may show a first-launch warning.

Report reproducible problems in
GitHub Issues
or share general feedback in
GitHub Discussions.

Assets 14
Loading