<?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: Faruk Durgut</title>
    <description>The latest articles on DEV Community by Faruk Durgut (@frkdrgt).</description>
    <link>https://dev.to/frkdrgt</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.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F92247%2Ffd5346eb-887e-41a5-8d93-06442b2f97f7.jpeg</url>
      <title>DEV Community: Faruk Durgut</title>
      <link>https://dev.to/frkdrgt</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/frkdrgt"/>
    <language>en</language>
    <item>
      <title>I built a PostgreSQL client in Rust because DBeaver was eating my RAM</title>
      <dc:creator>Faruk Durgut</dc:creator>
      <pubDate>Mon, 16 Mar 2026 14:42:02 +0000</pubDate>
      <link>https://dev.to/frkdrgt/i-built-a-postgresql-client-in-rust-because-dbeaver-was-eating-my-ram-1eg1</link>
      <guid>https://dev.to/frkdrgt/i-built-a-postgresql-client-in-rust-because-dbeaver-was-eating-my-ram-1eg1</guid>
      <description>&lt;p&gt;My daily laptop has 8GB of RAM. Not a lot by modern standards, but enough — until I open DBeaver.&lt;/p&gt;

&lt;p&gt;DBeaver at idle: ~400MB. Add a browser, a terminal, maybe a local Docker container running Postgres, and half my RAM is gone before I've written a single query. pgAdmin wasn't much better.&lt;/p&gt;

&lt;p&gt;So I did what any reasonable developer would do: I spent my weekends building a replacement.&lt;/p&gt;

&lt;h2&gt;
  
  
  Meet Ferox
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Ferox&lt;/strong&gt; is a lightweight native desktop PostgreSQL client written entirely in Rust.&lt;/p&gt;

&lt;p&gt;No Electron. No JVM. No web engine. Just a native binary that starts in under 200ms and sits at ~25MB RAM at idle.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://github.com/frkdrgt/ferox" rel="noopener noreferrer"&gt;https://github.com/frkdrgt/ferox&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Features
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Multi-tab query editor&lt;/strong&gt; — SQL syntax highlighting, Ctrl+T for new tab, persistent query history&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Schema browser&lt;/strong&gt; — lazy-loaded tree with filter: schemas, tables, views, materialized views, foreign tables&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Data browser&lt;/strong&gt; — double-click any table to browse with server-side pagination and ORDER BY&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Visual Join Builder&lt;/strong&gt; — pick your tables, pick your columns, get ready-to-run SQL&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;EXPLAIN visualizer&lt;/strong&gt; — tree view of query plans with cost and timing per node&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Inline editing&lt;/strong&gt; — double-click a cell, edit, Enter to commit an UPDATE&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Export&lt;/strong&gt; — CSV and JSON via native OS file dialog&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  The Architecture
&lt;/h2&gt;

&lt;p&gt;The design is intentionally simple. Two threads, one channel each:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;┌─────────────────────────────┐
│     UI Thread (egui)        │
│  immediate-mode rendering   │
└────────┬──────────┬─────────┘
         │ DbCommand│ DbEvent
         ▼          ▼
┌─────────────────────────────┐
│     DB Thread (tokio)       │
│  tokio-postgres + native-tls│
└─────────────────────────────┘
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The UI thread sends &lt;code&gt;DbCommand&lt;/code&gt; variants (Execute, LoadSchemas, LoadDetails, etc.) and receives &lt;code&gt;DbEvent&lt;/code&gt; variants back (QueryResult, Tables, Error, etc.). The UI never blocks — it just renders whatever state it has and updates when events arrive.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight rust"&gt;&lt;code&gt;&lt;span class="c1"&gt;// Sending a query from UI thread&lt;/span&gt;
&lt;span class="k"&gt;let&lt;/span&gt; &lt;span class="n"&gt;_&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;self&lt;/span&gt;&lt;span class="py"&gt;.db_tx&lt;/span&gt;&lt;span class="nf"&gt;.send&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nn"&gt;DbCommand&lt;/span&gt;&lt;span class="p"&gt;::&lt;/span&gt;&lt;span class="nf"&gt;Execute&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;sql&lt;/span&gt;&lt;span class="p"&gt;));&lt;/span&gt;

&lt;span class="c1"&gt;// Receiving results in the same UI update loop&lt;/span&gt;
&lt;span class="k"&gt;while&lt;/span&gt; &lt;span class="k"&gt;let&lt;/span&gt; &lt;span class="nf"&gt;Ok&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;event&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;self&lt;/span&gt;&lt;span class="py"&gt;.db_rx&lt;/span&gt;&lt;span class="nf"&gt;.try_recv&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="k"&gt;match&lt;/span&gt; &lt;span class="n"&gt;event&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
        &lt;span class="nn"&gt;DbEvent&lt;/span&gt;&lt;span class="p"&gt;::&lt;/span&gt;&lt;span class="nf"&gt;QueryResult&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;result&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="cm"&gt;/* update state */&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
        &lt;span class="nn"&gt;DbEvent&lt;/span&gt;&lt;span class="p"&gt;::&lt;/span&gt;&lt;span class="nf"&gt;QueryError&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;msg&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;     &lt;span class="k"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="cm"&gt;/* show error   */&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
        &lt;span class="n"&gt;_&lt;/span&gt;                            &lt;span class="k"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="p"&gt;{}&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This pattern keeps egui's immediate-mode rendering smooth — no await, no blocking, no Arc&amp;gt; gymnastics.&lt;/p&gt;




&lt;h2&gt;
  
  
  Why egui?
&lt;/h2&gt;

&lt;p&gt;I wanted a pure-Rust GUI with no system dependencies beyond what Rust itself provides. &lt;code&gt;egui&lt;/code&gt; is immediate-mode (like Dear ImGui), which means the entire UI is re-rendered every frame from application state. No widget tree to manage, no data binding, no reactivity framework.&lt;/p&gt;

&lt;p&gt;For a database client this works surprisingly well — tables, scroll areas, and text inputs are all first-class citizens in egui.&lt;/p&gt;




&lt;h2&gt;
  
  
  Tech Stack
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Role&lt;/th&gt;
&lt;th&gt;Crate&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;GUI&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;egui&lt;/code&gt; + &lt;code&gt;eframe&lt;/code&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;PostgreSQL driver&lt;/td&gt;
&lt;td&gt;&lt;code&gt;tokio-postgres&lt;/code&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Async runtime&lt;/td&gt;
&lt;td&gt;&lt;code&gt;tokio&lt;/code&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;TLS&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;native-tls&lt;/code&gt; + &lt;code&gt;postgres-native-tls&lt;/code&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Syntax highlighting&lt;/td&gt;
&lt;td&gt;&lt;code&gt;syntect&lt;/code&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Config&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;serde&lt;/code&gt; + &lt;code&gt;toml&lt;/code&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;File dialogs&lt;/td&gt;
&lt;td&gt;&lt;code&gt;rfd&lt;/code&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;




&lt;h2&gt;
  
  
  Numbers
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Metric&lt;/th&gt;
&lt;th&gt;Ferox&lt;/th&gt;
&lt;th&gt;DBeaver&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;RAM at idle&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;~25 MB&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;~400 MB&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Startup&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;&amp;lt;200ms&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;5–15s&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Binary size&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;~12 MB&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;~200 MB&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;




&lt;h2&gt;
  
  
  What's Next
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Auto-complete (table names, column names, keywords)&lt;/li&gt;
&lt;li&gt;SSH tunnel support&lt;/li&gt;
&lt;li&gt;ER diagram view&lt;/li&gt;
&lt;li&gt;Multiple simultaneous connections&lt;/li&gt;
&lt;li&gt;Dark/light theme toggle&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;It's v0.1.0 and rough around the edges, but it's been my daily driver for a few weeks now. Pre-built binaries for Windows, macOS (universal), and Linux are on the releases page.&lt;/p&gt;

&lt;p&gt;If you've ever been frustrated by heavy database tools on modest hardware, give it a try.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;GitHub:&lt;/strong&gt; &lt;a href="https://github.com/frkdrgt/ferox" rel="noopener noreferrer"&gt;https://github.com/frkdrgt/ferox&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Feedback and contributions welcome.&lt;/p&gt;

</description>
      <category>rust</category>
      <category>postgres</category>
      <category>opensource</category>
      <category>showdev</category>
    </item>
  </channel>
</rss>
