<?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: Joe Dwyer</title>
    <description>The latest articles on DEV Community by Joe Dwyer (@jmd_is_me).</description>
    <link>https://dev.to/jmd_is_me</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%2F3264342%2F53c6f842-1f43-47e8-ab1d-6d3eb539cebd.png</url>
      <title>DEV Community: Joe Dwyer</title>
      <link>https://dev.to/jmd_is_me</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/jmd_is_me"/>
    <language>en</language>
    <item>
      <title>Claude Code Replaced My Need for Copilot and Now Writes 95% of My Code</title>
      <dc:creator>Joe Dwyer</dc:creator>
      <pubDate>Thu, 17 Jul 2025 22:37:21 +0000</pubDate>
      <link>https://dev.to/jmd_is_me/claude-code-replaced-my-need-for-copilot-and-now-writes-95-of-my-code-2ao7</link>
      <guid>https://dev.to/jmd_is_me/claude-code-replaced-my-need-for-copilot-and-now-writes-95-of-my-code-2ao7</guid>
      <description>&lt;p&gt;I used ChatGPT, GitHub Copilot, and a few autocomplete plugins. They were clever, sometimes helpful, but always felt like assistants rather than collaborators. Do some basic edits, make some unit tests, consider CI/CD for my project.&lt;/p&gt;

&lt;p&gt;Then I tried Claude Code.&lt;/p&gt;

&lt;p&gt;It didn’t just help me write code. It changed how I build software.&lt;br&gt;
Today, it is my AI pair programmer working directly in VS Code, and it writes about 95 percent of the code I ship.&lt;/p&gt;

&lt;p&gt;This post breaks down how I use Claude Code every day and why I think it is the most valuable developer productivity tool available right now.&lt;/p&gt;

&lt;p&gt;What Is Claude Code?&lt;br&gt;
Claude Code is an AI coding assistant developed by Anthropic. It works inside your editor and understands your entire project structure. More than just suggesting lines, it collaborates with you across the full development process. From UX design to implementation to iteration, it supports decisions and builds alongside you.&lt;/p&gt;

&lt;p&gt;Where most tools assist reactively, Claude Code feels like a thinking partner who is fully engaged in your work.&lt;/p&gt;

&lt;p&gt;How I Use Claude Code in My Daily Workflow&lt;br&gt;
Claude Code is now a core part of how I build software. I use it every day. My workflow typically looks like this:&lt;/p&gt;

&lt;p&gt;I describe a product feature or UX flow.&lt;/p&gt;

&lt;p&gt;Claude helps shape the design and component structure.&lt;/p&gt;

&lt;p&gt;It writes most of the code, including front-end and back-end logic.&lt;/p&gt;

&lt;p&gt;I guide and review the output, asking for refinements or iterations.&lt;/p&gt;

&lt;p&gt;Claude updates the code or extends it based on my input.&lt;/p&gt;

&lt;p&gt;There is no copying between tools, no bouncing between chat interfaces and editors. I stay in one environment and move from idea to working feature much faster.&lt;/p&gt;

&lt;p&gt;Why I Use Claude Code Over Anything Else&lt;br&gt;
I still use GitHub Copilot for quick suggestions or while Claude is working on a bigger change. It is great for simple in-line edits or filling in boilerplate.&lt;/p&gt;

&lt;p&gt;But Claude Code does more than assist. It collaborates. It helps me make architectural decisions, proposes file structures, reasons about dependencies, and then implements full features in a way that matches how I think and work.&lt;/p&gt;

&lt;p&gt;It is the only tool I have used that truly feels like pair programming.&lt;/p&gt;

&lt;p&gt;Claude Helps Me Think, Not Just Code&lt;br&gt;
One of the biggest changes I have noticed is that Claude has helped me think more clearly as an engineer. It is not just helping with code. It is helping me reason through what I am building and why.&lt;/p&gt;

&lt;p&gt;I used to rely on separate tools for design discussions or high-level planning. Now, Claude Code helps me decide what to build and how to build it, and then actually does the implementation. It keeps me in flow, reduces context switching, and accelerates decision-making.&lt;/p&gt;

&lt;p&gt;A Few Practical Tips&lt;br&gt;
If you are trying Claude Code or curious about how to get more from it, here are a few things that work well in my day-to-day use:&lt;/p&gt;

&lt;p&gt;Use the VS Code extension. That is where Claude really shines. It understands your whole project.&lt;/p&gt;

&lt;p&gt;Write prompts the way you talk. Describe what you want as clearly as possible. Example: “Add a modal for editing user email with validation.”&lt;/p&gt;

&lt;p&gt;Ask for explanations. Claude will often explain its reasoning, which helps keep you aligned.&lt;/p&gt;

&lt;p&gt;Stay in the loop. It is powerful, but you still need to review and refine. Sometimes it touches more than it needs to.&lt;/p&gt;

&lt;p&gt;Control the verbosity. If it talks too much, tell it. “Be concise” or “show code only” usually works.&lt;/p&gt;

&lt;p&gt;What Could Be Better&lt;br&gt;
Claude is not perfect. There are a few places where I have to stay involved.&lt;/p&gt;

&lt;p&gt;It occasionally over-edits or makes broader changes than necessary.&lt;/p&gt;

&lt;p&gt;Sometimes the explanations are too verbose, though they help clarify intent.&lt;/p&gt;

&lt;p&gt;I still manually review and test everything before shipping, but Claude often gets me 90 percent of the way there.&lt;/p&gt;

&lt;p&gt;These are minor tradeoffs compared to the speed and clarity I gain.&lt;/p&gt;

&lt;p&gt;Real Productivity Gains&lt;br&gt;
There have been moments where Claude helped me finish something in 20 minutes that would have taken several hours. Not because I could not do it, but because it handled the repetition, the structure, and the small decisions that slow things down.&lt;/p&gt;

&lt;p&gt;It gives me time to focus on the hard parts and lets me move faster on the rest.&lt;/p&gt;

&lt;p&gt;Final Thoughts&lt;br&gt;
Claude Code is not just another dev tool. It is not just faster autocomplete. It is a shift in how development happens.&lt;/p&gt;

&lt;p&gt;It helps me design, build, and refine software from within the editor. It collaborates with context and clarity. It feels like a teammate who works fast, reasons well, and never takes a break.&lt;/p&gt;

&lt;p&gt;If you are building anything serious and not using an AI tool that understands your full codebase, you are missing a huge opportunity to change how you work.&lt;/p&gt;

&lt;p&gt;==============&lt;/p&gt;

&lt;p&gt;I’m Joe Dwyer, founder and CTO of &lt;a href="https://ledgerview.app" rel="noopener noreferrer"&gt;LedgerView&lt;/a&gt;, where I'm building AI-powered tools for accountants and bookkeepers to eliminate dirty accounting data and speed up month-end close.&lt;/p&gt;

</description>
      <category>claudecode</category>
      <category>ai</category>
      <category>developers</category>
      <category>vscode</category>
    </item>
    <item>
      <title>Why Vectorize Structured Accounting Data Instead of Relying Solely on SQL</title>
      <dc:creator>Joe Dwyer</dc:creator>
      <pubDate>Wed, 18 Jun 2025 13:47:16 +0000</pubDate>
      <link>https://dev.to/jmd_is_me/why-vectorize-structured-accounting-data-instead-of-relying-solely-on-sql-1do9</link>
      <guid>https://dev.to/jmd_is_me/why-vectorize-structured-accounting-data-instead-of-relying-solely-on-sql-1do9</guid>
      <description>&lt;p&gt;For decades, SQL has been the backbone of data querying. But as machine learning and natural language interfaces become more mainstream, a growing number of teams are asking: &lt;strong&gt;Can we make our accounting systems smarter than traditional SQL allows?&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;The answer lies in &lt;strong&gt;vectorizing structured accounting data&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;In this article, we’ll explore why product managers and engineering leads should consider vectorization for structured accounting data — especially in the age of AI. You’ll learn how it works, how to implement it, and how it opens doors that SQL simply can’t.&lt;/p&gt;




&lt;h2&gt;
  
  
  1. Why Vectorization Outperforms Rules and SQL
&lt;/h2&gt;

&lt;p&gt;Structured accounting data (invoices, journal entries, bills, etc.) maps beautifully to relational databases. But traditional SQL querying has limitations:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Exact matching bias:&lt;/strong&gt; SQL excels at filtering exact matches (e.g., &lt;code&gt;WHERE customer_name = 'Acme Deli'&lt;/code&gt;), but fails to capture similar or fuzzy concepts (&lt;code&gt;Acme Grocery&lt;/code&gt;, &lt;code&gt;Acme Delicatessen&lt;/code&gt;).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Hard to express intent:&lt;/strong&gt; Queries must be defined rigidly in WHERE clauses, often requiring joins and manual filters.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Doesn’t scale for semantic similarity:&lt;/strong&gt; You can’t easily find invoices “similar” to another invoice, or rank customers by similarity without custom logic.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Poor support for unstructured or semi-structured text:&lt;/strong&gt; Freeform text, misspellings, abbreviations, and varied naming conventions make SQL filtering brittle.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Vectorization turns these rigid fields into mathematical representations in n-dimensional space&lt;/strong&gt;:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Each record becomes a point in space&lt;/li&gt;
&lt;li&gt;Similarity becomes a geometric problem (e.g., cosine similarity)&lt;/li&gt;
&lt;li&gt;You can compare multiple dimensions — numeric, date-based, and textual — in a unified framework&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Unlike rules, which are deterministic and require explicit programming, vectors allow implicit pattern recognition. Vectors support nearest neighbor search algorithms such as HNSW (Hierarchical Navigable Small Worlds), which can perform sub-linear time lookups over large sets of multidimensional data. This makes vectorization vastly more scalable for tasks like:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Identifying similar transactions&lt;/li&gt;
&lt;li&gt;Recommending vendors or accounts&lt;/li&gt;
&lt;li&gt;Ranking entries by relevance to user input&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;With high-dimensional vectors (e.g., 768 to 1536 dimensions), the space of possible meanings is more finely grained, allowing richer and more intuitive similarity comparisons than what even the most complex SQL query could express.&lt;/p&gt;




&lt;h2&gt;
  
  
  2. Hybrid Vectorization: Example of a Purchase
&lt;/h2&gt;

&lt;p&gt;Most accounting transactions are multi-modal: they include numbers, dates, entities, and freeform text. A hybrid vectorization strategy lets you turn each part of the record into vector components:&lt;/p&gt;

&lt;h3&gt;
  
  
  Example: Purchase Transaction (JSON)
&lt;/h3&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;"vendor"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Staples Inc."&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"amount"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mf"&gt;452.80&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"date"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"2024-06-01"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"category"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Office Supplies"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"items"&lt;/span&gt;&lt;span class="p"&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;span class="p"&gt;{&lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Printer Paper"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"qty"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;5&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"unit_price"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mf"&gt;8.99&lt;/span&gt;&lt;span class="p"&gt;},&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Stapler"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"qty"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"unit_price"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mf"&gt;14.99&lt;/span&gt;&lt;span class="p"&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;span class="nl"&gt;"memo"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Monthly supplies"&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;h3&gt;
  
  
  Vectorization Process:
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Numeric fields:&lt;/strong&gt; Directly encode values (e.g., amount, quantity).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Dates:&lt;/strong&gt; Convert to days since epoch, or use sinusoidal encodings to capture seasonality.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Items:&lt;/strong&gt; Aggregate statistics (e.g., item count, avg. unit price), or embed each product name individually.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Text fields (vendor, memo):&lt;/strong&gt; Use embeddings like OpenAI’s &lt;code&gt;text-embedding-3-small&lt;/code&gt;.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Example Vector (simplified):
&lt;/h3&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;[
  452.80,               # amount
  17,                   # days since purchase
  2,                    # item count
  9.29,                 # average unit price
  ...vendor embedding...  # dense vector of 1536 floats
  ...memo embedding...    # dense vector of 1536 floats
]
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This vector captures both the &lt;strong&gt;structured&lt;/strong&gt; and &lt;strong&gt;semantic&lt;/strong&gt; nature of the purchase. You can now:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Find similar purchases&lt;/li&gt;
&lt;li&gt;Recommend categories&lt;/li&gt;
&lt;li&gt;Cluster transactions&lt;/li&gt;
&lt;li&gt;Detect anomalies&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  📊 Vector Space Diagram
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;+-------------------------------------+
|                                     |
|        ● Invoice A                 |
|      /                              |
|     /    ● Invoice B               |
|    /      \                        |
|   /        \                       |
|  ● Query     ● Invoice C           |
|                                     |
+-------------------------------------+
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This diagram shows a simplified 2D vector space. The closer two points are, the more similar their records are. In real-world applications, vectors have hundreds or thousands of dimensions.&lt;/p&gt;




&lt;h2&gt;
  
  
  3. Storing and Retrieving Vectors
&lt;/h2&gt;

&lt;p&gt;Once vectorized, the data must be stored in a way that supports fast similarity search. You have several architectural options:&lt;/p&gt;

&lt;h3&gt;
  
  
  🔹 Vector Databases
&lt;/h3&gt;

&lt;p&gt;Purpose-built for similarity search, supporting approximate nearest neighbor (ANN) search:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Examples:&lt;/strong&gt; Pinecone, Weaviate, Qdrant, Milvus&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Benefits:&lt;/strong&gt; Auto-scaling, indexing, metadata filters, and native LLM integration&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  🔹 Analytics Platforms and Lakehouses
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Examples:&lt;/strong&gt; Databricks with MLflow and Delta Lake&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Use Case:&lt;/strong&gt; Large-scale ML pipeline integration with support for embedding storage, distributed compute, and batch inference&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  🔹 In-memory Vector Search
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Examples:&lt;/strong&gt; FAISS, HNSW libraries&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Use Case:&lt;/strong&gt; Local vector search, prototyping, or offline inference&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;When choosing a storage mechanism, consider:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Indexing:&lt;/strong&gt; Fast ANN indexes (HNSW, IVF) for speed&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Metadata filtering:&lt;/strong&gt; Combine vector similarity with field-level filters (e.g., vendor = Staples)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Dimensionality:&lt;/strong&gt; Larger vectors may require more RAM and compute&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Integration:&lt;/strong&gt; Choose systems that fit your existing ML/data stack&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  4. Intent Detection and Query Understanding
&lt;/h2&gt;

&lt;p&gt;One of the most powerful use cases for vectorization is pairing it with &lt;strong&gt;LLM-powered intent understanding&lt;/strong&gt;. Let’s walk through the process:&lt;/p&gt;

&lt;h3&gt;
  
  
  🧠 Step 1: Capture User Intent
&lt;/h3&gt;

&lt;p&gt;User input:&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;"Show me trends for Staples Inc."&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;Use OpenAI’s GPT model to extract structured intent:&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;"intent"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"trend_analysis"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"target_field"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"vendor"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"target_value"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Staples Inc."&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;h3&gt;
  
  
  🧩 Step 2: Vectorize the Query
&lt;/h3&gt;

&lt;p&gt;Use the same embedding model used on the vendor field to embed "Staples Inc."&lt;br&gt;
Then, compare to precomputed vendor vectors to find the closest match (handling typos or variants).&lt;/p&gt;

&lt;h3&gt;
  
  
  📊 Step 3: Retrieve and Analyze Data
&lt;/h3&gt;

&lt;p&gt;Use the matched vendor to query related transactions:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Retrieve purchases from the last 12 months&lt;/li&gt;
&lt;li&gt;Aggregate by month&lt;/li&gt;
&lt;li&gt;Return insights, graphs, or summaries&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  🔄 Full Workflow Diagram
&lt;/h3&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;[User Query]
     ↓
[LLM → Extract Intent]
     ↓
[Vectorize Target Value]
     ↓
[Nearest Neighbor Search]
     ↓
[Retrieve Related Records]
     ↓
[Aggregate + Visualize Trends]
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This enables natural-language, intelligent querying over accounting systems — without the user needing to know SQL.&lt;/p&gt;




&lt;h2&gt;
  
  
  Final Thoughts
&lt;/h2&gt;

&lt;p&gt;While SQL is foundational to accounting systems, vectorization unlocks a new class of intelligent capabilities. From fuzzy matching to intent-driven queries and LLM integration, it empowers you to build systems that truly understand your data.&lt;/p&gt;

&lt;p&gt;By combining structured rules with flexible vector space reasoning, teams can modernize their financial applications — making them smarter, faster, and more user-friendly.&lt;/p&gt;

&lt;p&gt;Let's Connect&lt;br&gt;
&lt;a href="https://www.linkedin.com/in/dwyerjoe/" rel="noopener noreferrer"&gt;LinkedIn&lt;/a&gt;&lt;/p&gt;

</description>
      <category>accounting</category>
      <category>ai</category>
      <category>vectorsearch</category>
      <category>machinelearning</category>
    </item>
  </channel>
</rss>
