<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: alexnguyen</title>
    <description>The latest articles on DEV Community by alexnguyen (@alexnguyen03).</description>
    <link>https://dev.to/alexnguyen03</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3571855%2F2036607a-4231-403a-abee-7bae81427810.png</url>
      <title>DEV Community: alexnguyen</title>
      <link>https://dev.to/alexnguyen03</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/alexnguyen03"/>
    <language>en</language>
    <item>
      <title>Zentro v0.10.0: Open-Core SQL IDE Built with Go + Wails</title>
      <dc:creator>alexnguyen</dc:creator>
      <pubDate>Sat, 24 Oct 2026 03:45:41 +0000</pubDate>
      <link>https://dev.to/alexnguyen03/zentro-v0100-open-core-sql-ide-built-with-go-wails-3ob1</link>
      <guid>https://dev.to/alexnguyen03/zentro-v0100-open-core-sql-ide-built-with-go-wails-3ob1</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fnh67ghwjvniqgvp444y6.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fnh67ghwjvniqgvp444y6.png" alt=" " width="800" height="336"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;I've been building Zentro, a desktop SQL IDE (Windows, macOS, Linux) that's organized around projects rather than loose connections. It supports PostgreSQL, MySQL, SQL Server and SQLite, and it's written in Go + Wails on the backend with React + TypeScript on the frontend, shipping as a single executable.&lt;/p&gt;

&lt;p&gt;With v0.10.0 (released 2026-10-23), the &lt;strong&gt;core is now open source under GPL-3.0-only&lt;/strong&gt;: &lt;a href="https://github.com/ZentroIDE/Zentro" rel="noopener noreferrer"&gt;https://github.com/ZentroIDE/Zentro&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What "open core" means here (and what it doesn't)
&lt;/h2&gt;

&lt;p&gt;To be precise, because this is easy to oversell:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Open (GPL-3.0):&lt;/strong&gt; the free core of the IDE, in the public repo. The git history there starts at this release.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Closed (commercial):&lt;/strong&gt; &lt;strong&gt;Pro&lt;/strong&gt; is a separate layer on top, under a commercial license. Its source is not in the public repo.&lt;/li&gt;
&lt;li&gt;So Zentro is &lt;em&gt;not&lt;/em&gt; fully open source. It's open core, similar in spirit to how JetBrains or Grafana split things.
## Two downloads&lt;/li&gt;
&lt;/ul&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;&lt;/th&gt;
&lt;th&gt;Zentro (official)&lt;/th&gt;
&lt;th&gt;Zentro Community Edition (CE)&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Contents&lt;/td&gt;
&lt;td&gt;Free core + Pro features (unlocked by a plan or the 30-day trial)&lt;/td&gt;
&lt;td&gt;Free core only, built from the public source&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Where&lt;/td&gt;
&lt;td&gt;zentro-ide.com/downloads and GitHub releases&lt;/td&gt;
&lt;td&gt;GitHub releases only (&lt;code&gt;zentro-ce-*&lt;/code&gt;)&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Updates&lt;/td&gt;
&lt;td&gt;In-app auto-update&lt;/td&gt;
&lt;td&gt;None, download new versions manually&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Built by&lt;/td&gt;
&lt;td&gt;Private release system, Windows binaries code-signed&lt;/td&gt;
&lt;td&gt;GitHub Actions in the public repo, from the release tag; &lt;strong&gt;unsigned&lt;/strong&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Most people should pick the official build: it's free, needs no account, and includes the Pro trial. CE is for people who want a binary built publicly from source they can read. Since CE is unsigned, Windows SmartScreen and macOS Gatekeeper will warn on first launch. CE has no Pro code and no updater.&lt;/p&gt;

&lt;h2&gt;
  
  
  Pro trial and the AI assistant
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;30-day Pro trial for everyone&lt;/strong&gt;, started inside the app, no card, no invite. It replaces the old early-access program.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;The AI assistant with your own API key (BYOK) is completely free&lt;/strong&gt;, including the MCP server for external agents. Only the query statistics panel is Pro.&lt;/li&gt;
&lt;li&gt;The data-protection rule for AI (the model only sees schemas you allow, ADR 0017) applies to every plan.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What else is new in v0.10.0
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Activity panel &amp;amp; background jobs:&lt;/strong&gt; CSV import and whole-table export run as cancellable jobs with live progress; a Jobs tab and a Server Sessions tab (view and kill sessions on the database itself).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Bigger AI assistant:&lt;/strong&gt; new chat with history and streaming; SQL checking, query plan explanations, schema comparison across environments, impact lookup when changing a schema, table/index stats; MCP server for outside agents.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;SSH tunnels and per-connection TLS control&lt;/strong&gt; (minimum TLS version, legacy ciphers when a server needs them).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Driver-specific connection strings&lt;/strong&gt; (&lt;code&gt;postgres://&lt;/code&gt;, &lt;code&gt;mysql://&lt;/code&gt;, &lt;code&gt;sqlserver://&lt;/code&gt;) with examples and correct defaults.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Integrated terminal&lt;/strong&gt; (local or SSH) in the bottom panel.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;ERD:&lt;/strong&gt; auto-layout (dagre), minimap, pan/zoom shortcuts, layout reset.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;SQL editor:&lt;/strong&gt; custom SQL grammar, schema-aware highlighting (tables, columns, aliases), a Colors page with preview, a T-SQL-aware formatter.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Keyboard navigation:&lt;/strong&gt; explorer tree and results grid, tab jumping via command palette, chord shortcuts, Enter/F2 to edit cells. Ctrl+Tab now jumps to the most recently used tab, browser-style.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Security:&lt;/strong&gt; paid plans are only granted from verified, signed entitlements.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Try it / tell me what's broken
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Download: &lt;a href="https://zentro-ide.com/downloads" rel="noopener noreferrer"&gt;https://zentro-ide.com/downloads&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Source: &lt;a href="https://github.com/ZentroIDE/Zentro" rel="noopener noreferrer"&gt;https://github.com/ZentroIDE/Zentro&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Docs: &lt;a href="https://docs.zentro-ide.com" rel="noopener noreferrer"&gt;https://docs.zentro-ide.com&lt;/a&gt;
This is a one-person project. Contributions need a CLA, and for larger PRs please open an issue first. Bug reports and ideas go in the repo's Issues and Discussions.&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>opensource</category>
      <category>sql</category>
      <category>solofounder</category>
      <category>database</category>
    </item>
  </channel>
</rss>
