<?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: Better Call Sohal</title>
    <description>The latest articles on DEV Community by Better Call Sohal (@bettercallsohal).</description>
    <link>https://dev.to/bettercallsohal</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%2F4211257%2Fa873e4b5-49a6-49a5-b652-0a9336b5c9b8.jpg</url>
      <title>DEV Community: Better Call Sohal</title>
      <link>https://dev.to/bettercallsohal</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/bettercallsohal"/>
    <language>en</language>
    <item>
      <title>Why I Built a 100% Offline Insurance Broker Suite with Tauri &amp; SQLite (No Cloud, Zero Subscriptions)</title>
      <dc:creator>Better Call Sohal</dc:creator>
      <pubDate>Tue, 27 Oct 2026 15:27:44 +0000</pubDate>
      <link>https://dev.to/bettercallsohal/why-i-built-a-100-offline-insurance-broker-suite-with-tauri-sqlite-no-cloud-zero-subscriptions-3kpk</link>
      <guid>https://dev.to/bettercallsohal/why-i-built-a-100-offline-insurance-broker-suite-with-tauri-sqlite-no-cloud-zero-subscriptions-3kpk</guid>
      <description>&lt;p&gt;For the past 8 months, I’ve been building &lt;strong&gt;PelSure&lt;/strong&gt; — an offline-first Windows desktop suite designed specifically for independent insurance brokers and small agencies.&lt;/p&gt;

&lt;p&gt;Most insurance agency management systems (AMS) like Applied Epic or EZLynx follow a predictable pattern:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;$150 to $500 per month &lt;em&gt;per seat&lt;/em&gt;.&lt;/li&gt;
&lt;li&gt;All confidential client data lives in someone else's cloud.&lt;/li&gt;
&lt;li&gt;500 MB+ bloated Electron installers that chew through RAM.&lt;/li&gt;
&lt;li&gt;Total vendor lock-in with tedious migration paths.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;I wanted to challenge that entire model. Independent brokers shouldn't have to surrender their client books or pay thousands of dollars a year just to quote policies and keep track of renewals.&lt;/p&gt;

&lt;p&gt;Here is the technical and architectural breakdown of how I built an offline-first alternative that runs in an &lt;strong&gt;8 MB footprint&lt;/strong&gt;.&lt;/p&gt;




&lt;h2&gt;
  
  
  🛠️ The Tech Stack
&lt;/h2&gt;

&lt;p&gt;Instead of bundling Chromium and Node.js via Electron, I went with &lt;strong&gt;Tauri 2.0&lt;/strong&gt;:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Desktop Shell:&lt;/strong&gt; Tauri 2.0 (Rust backend leveraging system native WebView2)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Frontend:&lt;/strong&gt; React 18 + TypeScript + Tailwind CSS&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Database:&lt;/strong&gt; Local SQLite powered by Drizzle ORM&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;State Management:&lt;/strong&gt; Zustand&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Icons:&lt;/strong&gt; Phosphor Icons (enterprise design system)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Packaging:&lt;/strong&gt; NSIS Windows Installer (~9.6 MB total download)&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  Why Local SQLite Over Cloud SaaS?
&lt;/h2&gt;

&lt;p&gt;In insurance brokerage, &lt;strong&gt;data sovereignty is everything&lt;/strong&gt;. Brokers handle confidential commercial records, vehicle fleets, health details, and premium schedules. Regulations like UK GDPR, Singapore MAS, and India DPDPA place immense liability on data breaches.&lt;/p&gt;

&lt;p&gt;By using local SQLite:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Zero telemetry &amp;amp; zero third-party leakage:&lt;/strong&gt; Data literally never leaves the broker's Windows hardware.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Instant reads and writes:&lt;/strong&gt; Complex multi-insurer premium comparisons execute in single-digit milliseconds without network latency.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;True offline capability:&lt;/strong&gt; Brokers working on site or in remote areas can quote, issue schedules, and manage books with zero internet connection.&lt;/li&gt;
&lt;/ol&gt;




&lt;h2&gt;
  
  
  Key Features Shipped
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Multi-Insurer Quoting Matrix:&lt;/strong&gt; Instant side-by-side premium breakdown across Motor, Fire, Marine, and Personal Accident policies.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;5-Lane Master Migration Center:&lt;/strong&gt; Spreadsheet ingestion engine with Zod schema validation that imports from Excel, CSV, EZLynx, Applied Epic, or HawkSoft with auto-deduplication.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Direct WhatsApp Schedule Dispatch:&lt;/strong&gt; Generates schedule summaries and deep-links directly into desktop WhatsApp to message clients with one click — zero SMS gateway fees.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Local Document Generator:&lt;/strong&gt; Generates print-ready proposal PDFs and receipts locally inside the WebView.&lt;/li&gt;
&lt;/ol&gt;




&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%2F4lxssmy054ue59g8umvo.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%2F4lxssmy054ue59g8umvo.png" alt=" " width="800" height="431"&gt;&lt;/a&gt; Free Beta for Independent Brokers&lt;/p&gt;

&lt;p&gt;The core desktop application is &lt;strong&gt;100% free forever&lt;/strong&gt; for independent brokers.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Website &amp;amp; Installer:&lt;/strong&gt; &lt;a href="https://pelsure.peltelldesignco.com/" rel="noopener noreferrer"&gt;https://pelsure.peltelldesignco.com/&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;SourceForge:&lt;/strong&gt; &lt;a href="https://sourceforge.net/projects/pelsure/" rel="noopener noreferrer"&gt;https://sourceforge.net/projects/pelsure/&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Beta Access:&lt;/strong&gt; Use promo code &lt;strong&gt;&lt;code&gt;BETA100&lt;/code&gt;&lt;/strong&gt; on checkout for 100% free access to the plugin ecosystem (first 100 seats).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Would love feedback from the dev community on our offline-first architecture and performance!&lt;/p&gt;

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