<?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: Shun Kimura</title>
    <description>The latest articles on DEV Community by Shun Kimura (@xxxkmsxxx).</description>
    <link>https://dev.to/xxxkmsxxx</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%2F4027357%2F8723d2e8-bb24-4981-84ad-187f73df5454.png</url>
      <title>DEV Community: Shun Kimura</title>
      <link>https://dev.to/xxxkmsxxx</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/xxxkmsxxx"/>
    <language>en</language>
    <item>
      <title>How do you sell a feature on a site with no backend?</title>
      <dc:creator>Shun Kimura</dc:creator>
      <pubDate>Mon, 20 Jul 2026 04:57:58 +0000</pubDate>
      <link>https://dev.to/xxxkmsxxx/how-do-you-sell-a-feature-on-a-site-with-no-backend-pdf</link>
      <guid>https://dev.to/xxxkmsxxx/how-do-you-sell-a-feature-on-a-site-with-no-backend-pdf</guid>
      <description>&lt;p&gt;A few weeks ago I shipped &lt;a href="https://parquetkit.com/diff" rel="noopener noreferrer"&gt;Parquet Diff&lt;/a&gt; — a tool that joins two Parquet files on a key column and shows you exactly what changed: added rows, removed rows, changed cells, and schema drift (type changes, added/removed columns). It's part of &lt;a href="https://parquetkit.com" rel="noopener noreferrer"&gt;ParquetKit&lt;/a&gt;, a Parquet viewer/SQL workbench/converter that runs 100% client-side — no upload, no backend, files never leave the browser.&lt;/p&gt;

&lt;p&gt;This week I added a paid tier to it: the free version shows you a summary and the schema diff, a $15 one-time unlock exports the full row-level report (every added/removed/changed row) as HTML or Markdown. The interesting part wasn't the feature — it was that the site has no server, and I didn't want to add one just to sell something.&lt;/p&gt;

&lt;h2&gt;
  
  
  The constraint
&lt;/h2&gt;

&lt;p&gt;&lt;code&gt;next.config.ts&lt;/code&gt; has &lt;code&gt;output: "export"&lt;/code&gt;. Static files, no API routes, no database. That's not incidental — it's the actual privacy guarantee. The pitch to users is "open DevTools, watch the network tab, your file never leaves your machine." Adding a backend to handle payments would mean either breaking that promise for the paid tier, or running two architectures side by side. Neither felt right.&lt;/p&gt;

&lt;h2&gt;
  
  
  What actually worked
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://polar.sh" rel="noopener noreferrer"&gt;Polar.sh&lt;/a&gt; turned out to have exactly the right shape for this. It's Merchant of Record (handles VAT/sales tax so I don't have to), and — the part that made this possible — its license key validation endpoint is designed to be called from an untrusted client:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight http"&gt;&lt;code&gt;&lt;span class="err"&gt;POST https://api.polar.sh/v1/customer-portal/license-keys/validate
{ "key": "...", "organization_id": "..." }
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;No auth token required. It's meant for exactly this: desktop apps, browser extensions, static sites — anything that can't hold a secret. You send the key string, you get back &lt;code&gt;granted&lt;/code&gt; / &lt;code&gt;revoked&lt;/code&gt; / &lt;code&gt;disabled&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;So the flow is: Polar-hosted checkout → buyer gets a license key by email → pastes it into the tool → the browser calls that endpoint directly → &lt;code&gt;localStorage&lt;/code&gt; remembers the result. No server on my side ever sees the request. The only thing that crosses the network for the paid tier is the license key string — never the file, never its contents. The privacy story holds for the thing you're actually paying to unlock.&lt;/p&gt;

&lt;h2&gt;
  
  
  The free tier isn't a teaser stub
&lt;/h2&gt;

&lt;p&gt;The free report (summary counts + schema diff) is a real, complete Markdown export — I didn't want "free" to mean "crippled." If the row export never sells a single unlock, the free diff tool and free report are still useful on their own, which felt like the honest way to bet on this instead of gating everything behind a wall from day one.&lt;/p&gt;

&lt;h2&gt;
  
  
  Try it
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://parquetkit.com/diff" rel="noopener noreferrer"&gt;parquetkit.com/diff&lt;/a&gt; — there's a one-click sample pair if you don't have two Parquet files handy to compare.&lt;/p&gt;

&lt;p&gt;MIT licensed: &lt;a href="https://github.com/XxxKMSxxX/parquetkit" rel="noopener noreferrer"&gt;https://github.com/XxxKMSxxX/parquetkit&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Curious what other people building small paid features on static/serverless sites have landed on — this is the first time I've shipped a paywall without writing a single line of server code, and I'm not sure it's the "right" way, just the way that kept the architecture honest.&lt;/p&gt;

</description>
      <category>webassembly</category>
      <category>duckdb</category>
      <category>showdev</category>
      <category>indiehackers</category>
    </item>
    <item>
      <title>I built a Parquet toolkit that runs entirely in the browser — here's the architecture</title>
      <dc:creator>Shun Kimura</dc:creator>
      <pubDate>Tue, 14 Jul 2026 13:24:18 +0000</pubDate>
      <link>https://dev.to/xxxkmsxxx/i-built-a-parquet-toolkit-that-runs-entirely-in-the-browser-heres-the-architecture-32h1</link>
      <guid>https://dev.to/xxxkmsxxx/i-built-a-parquet-toolkit-that-runs-entirely-in-the-browser-heres-the-architecture-32h1</guid>
      <description>&lt;p&gt;The most common thing I do with a Parquet file is embarrassingly small:&lt;br&gt;
someone sends me &lt;code&gt;events.parquet&lt;/code&gt; and I want to know what columns it has and&lt;br&gt;
eyeball twenty rows. The standard answer — spin up a notebook, import pandas,&lt;br&gt;
wait — always felt like using a forklift to open a jar.&lt;/p&gt;

&lt;p&gt;So I built &lt;a href="https://parquetkit.com" rel="noopener noreferrer"&gt;ParquetKit&lt;/a&gt;: a viewer, SQL workbench and&lt;br&gt;
set of converters for Parquet files that run 100% client-side. No upload, no&lt;br&gt;
signup, no backend. This post is about the architecture decisions that made&lt;br&gt;
that work.&lt;/p&gt;

&lt;h2&gt;
  
  
  Two engines, loaded at different times
&lt;/h2&gt;

&lt;p&gt;The core trick is refusing to pick one engine.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;hyparquet (~10 KB) handles first paint.&lt;/strong&gt; When you drop a file, the viewer&lt;br&gt;
needs schema, metadata and the first 50 rows — that's it. hyparquet is a pure&lt;br&gt;
JavaScript Parquet reader that reads the metadata footer and only the row&lt;br&gt;
ranges you actually look at, streamed with &lt;code&gt;Blob.slice&lt;/code&gt;. Opening a 1.3 GB&lt;br&gt;
file takes ~350 ms on my machine, because almost none of the file is read.&lt;br&gt;
Memory stays flat when you page through it.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;DuckDB-WASM handles everything heavy.&lt;/strong&gt; SQL queries, joins across files,&lt;br&gt;
and conversions (Parquet → CSV/JSON/JSONL, and CSV/JSONL → Parquet) all go through DuckDB running&lt;br&gt;
in a Web Worker. It's ~30 MB of WASM, so it lazy-loads only when you actually&lt;br&gt;
query or convert — the viewer never pays that cost. Files are registered with&lt;br&gt;
&lt;code&gt;registerFileHandle&lt;/code&gt;, by reference: DuckDB reads the byte ranges it needs&lt;br&gt;
instead of copying the file into memory.&lt;/p&gt;

&lt;h2&gt;
  
  
  "No backend" as a feature, not a cost saving
&lt;/h2&gt;

&lt;p&gt;The site is a Next.js static export (&lt;code&gt;output: "export"&lt;/code&gt;). There is no server&lt;br&gt;
— which means there is &lt;em&gt;nowhere to upload your file to&lt;/em&gt;. That's not a&lt;br&gt;
limitation, it's the entire privacy story: you can open DevTools, watch the&lt;br&gt;
network tab, and verify that your data never leaves the machine. Once the&lt;br&gt;
engine is cached, the tools keep working with the network disconnected.&lt;/p&gt;

&lt;p&gt;This matters for the audience I built it for: people who deal with work data&lt;br&gt;
they're not allowed to paste into random "free online converter" sites or AI&lt;br&gt;
chatbots.&lt;/p&gt;

&lt;p&gt;The same decision makes operations trivial. Hosting is a CDN. The error&lt;br&gt;
monitoring (Sentry) scrubs file names, file contents and query strings in&lt;br&gt;
&lt;code&gt;beforeSend&lt;/code&gt; — the monitoring must not undermine the privacy promise either.&lt;/p&gt;

&lt;h2&gt;
  
  
  Things that bit me
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;LZ4 has two dialects.&lt;/strong&gt; Parquet files write either LZ4 (legacy framed) or&lt;br&gt;
LZ4_RAW. The compressor package I started with silently mis-decoded LZ4_RAW;&lt;br&gt;
I swapped in lz4js and wrote round-trip tests (pyarrow writes fixtures for&lt;br&gt;
every codec, the browser reads them back in CI on real Chromium).&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Blob workers can't use relative URLs.&lt;/strong&gt; DuckDB's worker is spawned from a&lt;br&gt;
blob URL, so every asset reference inside it has to be absolute. Fine in dev,&lt;br&gt;
broken in production — the kind of bug you only catch by running e2e against&lt;br&gt;
the actual static export, which is what the CI does (Playwright against&lt;br&gt;
&lt;code&gt;serve out/&lt;/code&gt;).&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Test against the deployment artifact, not the dev server.&lt;/strong&gt; &lt;code&gt;next dev&lt;/code&gt;&lt;br&gt;
tolerates things the static export doesn't (accidental server imports, path&lt;br&gt;
assumptions). Our e2e suite only ever runs against the built &lt;code&gt;out/&lt;/code&gt;&lt;br&gt;
directory, in three browsers.&lt;/p&gt;

&lt;h2&gt;
  
  
  Try it
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://parquetkit.com/parquet-viewer" rel="noopener noreferrer"&gt;Parquet Viewer&lt;/a&gt; — has a one-click
sample dataset if you don't have a .parquet handy&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://parquetkit.com/sql" rel="noopener noreferrer"&gt;SQL Workbench&lt;/a&gt; — DuckDB SQL against your local
files&lt;/li&gt;
&lt;li&gt;&lt;a href="https://parquetkit.com/convert/parquet-to-csv" rel="noopener noreferrer"&gt;Converters&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;It's MIT licensed — the engine layer is deliberately React-free (enforced by&lt;br&gt;
ESLint) so it could become a standalone package:&lt;br&gt;
&lt;a href="https://github.com/XxxKMSxxX/parquetkit" rel="noopener noreferrer"&gt;https://github.com/XxxKMSxxX/parquetkit&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Feedback very welcome — especially on formats you'd want next (Avro? Arrow?).&lt;/p&gt;

</description>
      <category>webassembly</category>
      <category>duckdb</category>
      <category>dataengineering</category>
      <category>showdev</category>
    </item>
  </channel>
</rss>
