<?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: Aditya Kumar</title>
    <description>The latest articles on DEV Community by Aditya Kumar (@aditya_ku).</description>
    <link>https://dev.to/aditya_ku</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%2F2278939%2F5109a4f3-51a9-478a-8b45-550afda17c78.png</url>
      <title>DEV Community: Aditya Kumar</title>
      <link>https://dev.to/aditya_ku</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/aditya_ku"/>
    <language>en</language>
    <item>
      <title>Sequill: A Free, Private SQLite Editor &amp; Schema Designer That Runs in Your Browser</title>
      <dc:creator>Aditya Kumar</dc:creator>
      <pubDate>Sun, 01 Nov 2026 09:53:05 +0000</pubDate>
      <link>https://dev.to/aditya_ku/sequill-a-free-private-sqlite-editor-schema-designer-that-runs-in-your-browser-2jp9</link>
      <guid>https://dev.to/aditya_ku/sequill-a-free-private-sqlite-editor-schema-designer-that-runs-in-your-browser-2jp9</guid>
      <description>&lt;h2&gt;
  
  
  Why I built it
&lt;/h2&gt;

&lt;p&gt;Every time I needed to look inside a &lt;code&gt;.sqlite&lt;/code&gt; or &lt;code&gt;.db&lt;/code&gt; file, I had two options: install a desktop app, or upload the file to some random website and hope it wasn't stored somewhere. Neither felt right for a quick look at a database.&lt;/p&gt;

&lt;p&gt;So I built &lt;a href="https://sequill.adibitz.com" rel="noopener noreferrer"&gt;Sequill&lt;/a&gt;, a SQLite editor and visual schema designer that runs entirely in your browser tab. No server, no upload, no account. It just launched on &lt;a href="https://www.producthunt.com/products/sequill" rel="noopener noreferrer"&gt;Product Hunt&lt;/a&gt;, and I wanted to share how it works with the dev.to community.&lt;/p&gt;

&lt;h2&gt;
  
  
  What Sequill is
&lt;/h2&gt;

&lt;p&gt;Sequill is two tools sharing the same set of databases: a &lt;strong&gt;SQLite Editor&lt;/strong&gt; and a &lt;strong&gt;Schema Designer&lt;/strong&gt;. Open a file in one and it shows up in the other instantly.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Free.&lt;/strong&gt; No paid tier, no trial, no feature gates.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Zero bytes uploaded.&lt;/strong&gt; There is no backend. Your database stays on your device.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;No account.&lt;/strong&gt; Open the page and start working.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Offline.&lt;/strong&gt; After the first visit, the whole app, including the database engine, is cached.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Installable.&lt;/strong&gt; It's a PWA, so you can add it to your desktop or phone.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Real SQLite.&lt;/strong&gt; It runs the official SQLite 3.54 build compiled to WebAssembly, so files are fully compatible with every other SQLite tool.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Mobile friendly.&lt;/strong&gt; The editor has its own phone layout, with tables tucked into a drawer.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What you can do with it
&lt;/h2&gt;

&lt;h3&gt;
  
  
  The SQLite Editor
&lt;/h3&gt;

&lt;p&gt;The editor is a fast data grid sitting directly on top of the database. Sorting, filtering and searching all run inside SQLite itself, not in JavaScript, so results are always accurate.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Browse:&lt;/strong&gt; virtualised rows for big tables, multi-column sort, search across every column, and filters with 15 conditions combined with AND or OR.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Explore:&lt;/strong&gt; pin or hide columns, follow foreign keys to the referenced row, open a row inspector, and preview BLOBs and formatted JSON.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Edit in place:&lt;/strong&gt; double-click a cell or just start typing, set NULL in one action, and paste straight from a spreadsheet. Nothing is written until you hit save.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Write SQL:&lt;/strong&gt; a console with autocomplete that knows your tables and columns, &lt;code&gt;Ctrl+Enter&lt;/code&gt; to run, query plans, saved queries, and timing for every run.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Import and export:&lt;/strong&gt; open &lt;code&gt;.sqlite&lt;/code&gt; or &lt;code&gt;.db&lt;/code&gt; files, import CSV and JSON, export tables or query results as CSV, JSON or SQL, or download a full SQL dump.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Move to a server DB:&lt;/strong&gt; generate SQL for PostgreSQL, MySQL and MariaDB, so you can prototype in SQLite and migrate later.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Press &lt;code&gt;Ctrl+K&lt;/code&gt; anywhere to jump to any table, view or action. And if you just want to play around, load the built-in Sample Shop database.&lt;/p&gt;

&lt;h3&gt;
  
  
  The Schema Designer
&lt;/h3&gt;

&lt;p&gt;The designer draws your database as a diagram: every table is a card and every foreign key is a line. You can also change the schema visually.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Add a table and name it.&lt;/li&gt;
&lt;li&gt;Add columns. New ones show in green so you can see what changed.&lt;/li&gt;
&lt;li&gt;Drag from a column to another table to create a foreign key.&lt;/li&gt;
&lt;li&gt;Save. Everything is applied in a single transaction.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;It also has one-click auto-arrange, focus mode for a single table, colour-coding, and saved drafts per database. SQLite can't alter every part of a table in place, so when a change needs it, Sequill safely rebuilds the table for you.&lt;/p&gt;

&lt;h2&gt;
  
  
  How it works under the hood
&lt;/h2&gt;

&lt;p&gt;Sequill has no backend at all. It's a set of static files, and everything happens in the browser.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;SQLite compiled to WebAssembly.&lt;/strong&gt; The core is the &lt;a href="https://sqlite.org/wasm/doc/trunk/index.md" rel="noopener noreferrer"&gt;official SQLite WASM build&lt;/a&gt;. Since it's the real engine and not a reimplementation, every query and schema change behaves exactly like native SQLite.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A Web Worker.&lt;/strong&gt; SQLite runs off the main thread, so scrolling the grid, typing in the console or dragging tables never freezes, even during a heavy query.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;OPFS for storage.&lt;/strong&gt; Databases are stored in the &lt;a href="https://developer.mozilla.org/en-US/docs/Web/API/File_System_API/Origin_private_file_system" rel="noopener noreferrer"&gt;Origin Private File System&lt;/a&gt;. It gives the worker fast, file-like access, so SQLite reads and writes real files instead of holding everything in memory.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Header parsing without the engine.&lt;/strong&gt; The landing page's "Try your own file" reads a database's header and first page directly, showing page size, encoding, journal mode, SQLite version and tables instantly.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Offline-first PWA.&lt;/strong&gt; Every asset, including the WASM engine, is cached after the first visit.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Next.js, exported as static files&lt;/strong&gt; for the UI.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The design principles were simple: privacy by architecture rather than by promise, let SQLite do the work instead of re-implementing it in JS, and stage every change until you save.&lt;/p&gt;

&lt;h3&gt;
  
  
  A few honest trade-offs
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;When you open a file, Sequill copies it into OPFS. Your original file is never modified.&lt;/li&gt;
&lt;li&gt;If you clear the site's data, your databases go with it. Sequill requests persistent storage, but always download a copy of anything important.&lt;/li&gt;
&lt;li&gt;Only one tab can use the database at a time, because the OPFS storage handle is exclusive.&lt;/li&gt;
&lt;li&gt;The size limit is your browser's storage quota for the site, and very large exports are limited by memory.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Who it's for
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Developers who need to quickly inspect or fix a &lt;code&gt;.db&lt;/code&gt; file from an app, test or mobile build.&lt;/li&gt;
&lt;li&gt;Anyone prototyping a schema in SQLite before moving it to Postgres or MySQL.&lt;/li&gt;
&lt;li&gt;People working with sensitive data who can't upload files to an online tool.&lt;/li&gt;
&lt;li&gt;Students learning SQL who want a playground without installing anything.&lt;/li&gt;
&lt;/ul&gt;

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

&lt;p&gt;I'm adding &lt;strong&gt;MCP (Model Context Protocol)&lt;/strong&gt; support so AI assistants can read your schema, run queries and help explore your data, with you in control of access. I also plan to support &lt;strong&gt;local AI agents&lt;/strong&gt;, so you can generate queries or get schema help without sending your database to the cloud. If you have ideas for what an AI agent should do with your databases, I'd love to hear them.&lt;/p&gt;

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

&lt;p&gt;Sequill is live and free at &lt;a href="https://sequill.adibitz.com" rel="noopener noreferrer"&gt;sequill.adibitz.com&lt;/a&gt;. Pick a file, start an empty database, or load the sample shop. Nothing to install, no account to create.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://sequill.adibitz.com/app" rel="noopener noreferrer"&gt;Open the editor&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://sequill.adibitz.com/vis" rel="noopener noreferrer"&gt;Open the schema designer&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.producthunt.com/products/sequill" rel="noopener noreferrer"&gt;Sequill on Product Hunt&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;It launched on Product Hunt today, so an upvote would mean a lot. More than that, I'd really like your feedback: what's missing, what's broken, and what would make you use it every day. Drop it in the comments below.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Originally published on &lt;a href="https://adibitz.com/blog/sequill-free-sqlite-editor-schema-designer-browser" rel="noopener noreferrer"&gt;adibitz.com&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>webdev</category>
      <category>database</category>
      <category>sql</category>
      <category>nextjs</category>
    </item>
    <item>
      <title>Sending Emails with Gmail using API</title>
      <dc:creator>Aditya Kumar</dc:creator>
      <pubDate>Sun, 27 Oct 2024 06:12:26 +0000</pubDate>
      <link>https://dev.to/aditya_ku/sending-emails-with-gmail-using-api-3c8p</link>
      <guid>https://dev.to/aditya_ku/sending-emails-with-gmail-using-api-3c8p</guid>
      <description>&lt;p&gt;We're going to build an API that use Google App Script to send emails utilizing the Gmail API.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://github.com/adixoo/send-email-using-gmail/blob/main/code.gs" rel="noopener noreferrer"&gt;Github Code&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Prerequisites
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Basic JavaScript knowledge&lt;/li&gt;
&lt;li&gt;Basic API knowledge &lt;/li&gt;
&lt;li&gt;A Google Account&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  How to Build
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;&lt;a href="https://docs.google.com/spreadsheets/?usp=sheets_alc&amp;amp;authuser=0" rel="noopener noreferrer"&gt;Open Google Sheets&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Now click on &lt;code&gt;Blank Spreadsheet&lt;/code&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.amazonaws.com%2Fuploads%2Farticles%2Fa1lprajkqpr03c11vpk8.png" alt="Google forms home page" width="800" height="450"&gt;
&lt;/li&gt;
&lt;li&gt;This will create a Blank Spreadsheet. In my case I am naming it &lt;code&gt;Email API&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;Now click on &lt;code&gt;Extensions&lt;/code&gt; and then select &lt;code&gt;Apps Script&lt;/code&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.amazonaws.com%2Fuploads%2Farticles%2Fvkqpd9p2ob4fduzdu01o.png" alt="Google form spreadheet" width="800" height="450"&gt;
&lt;/li&gt;
&lt;li&gt;Now it will open a code editor. Name your project if you want.&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.amazonaws.com%2Fuploads%2Farticles%2Fxhldzz3m5vu37xdnd66s.png" alt="app script code editor" width="800" height="450"&gt;
&lt;/li&gt;
&lt;li&gt;Copy and paste the &lt;a href="https://github.com/adixoo/send-email-using-gmail/blob/main/code.gs" rel="noopener noreferrer"&gt;code&lt;/a&gt; from Github. Press &lt;code&gt;Ctrl + S&lt;/code&gt; to save the code.&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Click on &lt;code&gt;Deploy&lt;/code&gt;, and then &lt;code&gt;New Deployment&lt;/code&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.amazonaws.com%2Fuploads%2Farticles%2Fa0t81i6rgywbhnwx1j17.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.amazonaws.com%2Fuploads%2Farticles%2Fa0t81i6rgywbhnwx1j17.png" alt="web app deployment" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Now &lt;code&gt;Select Type&lt;/code&gt; and then &lt;code&gt;Web App&lt;/code&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.amazonaws.com%2Fuploads%2Farticles%2F9uopc45iysacay8fqxgr.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.amazonaws.com%2Fuploads%2Farticles%2F9uopc45iysacay8fqxgr.png" alt="deployment 1" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;You have to fill some details here.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Description: Write anything you want&lt;/li&gt;
&lt;li&gt;Executes as : Me (your email)&lt;/li&gt;
&lt;li&gt;Who has access: Anyone&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;After filling details click on &lt;code&gt;Deploy&lt;/code&gt; and authorize application. &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.amazonaws.com%2Fuploads%2Farticles%2Fck1o3elz59uit9e2a3tu.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.amazonaws.com%2Fuploads%2Farticles%2Fck1o3elz59uit9e2a3tu.png" alt="deployment 2" width="800" height="450"&gt;&lt;/a&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.amazonaws.com%2Fuploads%2Farticles%2Frymv6xu71q9a9a590p7a.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.amazonaws.com%2Fuploads%2Farticles%2Frymv6xu71q9a9a590p7a.png" alt="deployment 3" width="800" height="450"&gt;&lt;/a&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.amazonaws.com%2Fuploads%2Farticles%2F04cnsbrhv1ymb3f242yf.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.amazonaws.com%2Fuploads%2Farticles%2F04cnsbrhv1ymb3f242yf.png" alt="deployment 4" width="800" height="450"&gt;&lt;/a&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.amazonaws.com%2Fuploads%2Farticles%2Fhoddu8pjztgcez8i2mkk.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.amazonaws.com%2Fuploads%2Farticles%2Fhoddu8pjztgcez8i2mkk.png" alt="deployment 5" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Now your project is deployed. Copy the URL and make a post request using postman or your project. &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.amazonaws.com%2Fuploads%2Farticles%2F71ay4zg0aavrcbltjnrs.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.amazonaws.com%2Fuploads%2Farticles%2F71ay4zg0aavrcbltjnrs.png" alt="deployed url" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Make sure to include while making a &lt;code&gt;POST&lt;/code&gt; request.&lt;/p&gt;

&lt;p&gt;&lt;code&gt;Content-Type: JSON&lt;/code&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"email"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"subject"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="nl"&gt;"body"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Thanks for reading!&lt;/p&gt;

</description>
      <category>webdev</category>
      <category>api</category>
      <category>google</category>
      <category>programming</category>
    </item>
  </channel>
</rss>
