<?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: bob jin</title>
    <description>The latest articles on DEV Community by bob jin (@bob_jin_7f587761570888b89).</description>
    <link>https://dev.to/bob_jin_7f587761570888b89</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%2F3998157%2F02a372f2-1270-4920-8ad8-562de3d42de5.jpg</url>
      <title>DEV Community: bob jin</title>
      <link>https://dev.to/bob_jin_7f587761570888b89</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/bob_jin_7f587761570888b89"/>
    <language>en</language>
    <item>
      <title>How I Built a 400-Page Diesel Fault Code Database with Python SSG (Zero Node.js)</title>
      <dc:creator>bob jin</dc:creator>
      <pubDate>Tue, 07 Jul 2026 07:41:49 +0000</pubDate>
      <link>https://dev.to/bob_jin_7f587761570888b89/why-nobody-talks-about-your-most-disturbing-dreams-and-why-that-matters-1385</link>
      <guid>https://dev.to/bob_jin_7f587761570888b89/why-nobody-talks-about-your-most-disturbing-dreams-and-why-that-matters-1385</guid>
      <description>&lt;h2&gt;
  
  
  I Built This Because My Dad's Truck Kept Breaking Down
&lt;/h2&gt;

&lt;p&gt;My dad runs a small trucking company in Texas. Last year, his 2018 Kenworth T680 threw &lt;strong&gt;SPN 3226 FMI 0&lt;/strong&gt; — NOx sensor circuit failure. The dealership quoted $650. He called me: "Can you find what this code means?"&lt;/p&gt;

&lt;p&gt;I searched Google. Results: two-line blurbs on generic sites. No technical depth. No repair cost estimates. No Spanish version for his Mexican driver.&lt;/p&gt;

&lt;p&gt;That's when I realized: truck drivers need a dedicated fault code database. Not another generic OBD2 site.&lt;/p&gt;




&lt;h2&gt;
  
  
  The Problem: Diesel Fault Codes Are Undocumented
&lt;/h2&gt;

&lt;p&gt;Heavy-duty trucks use &lt;strong&gt;SAE J1939&lt;/strong&gt; protocol — not standard OBD2. A single fault code can have:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;SPN&lt;/strong&gt; (Suspect Parameter Number): Which system failed&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;FMI&lt;/strong&gt; (Failure Mode Identifier): How it failed&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;MID/PID&lt;/strong&gt;: Manufacturer-specific identifiers&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Generic OBD2 sites don't cover this. Trucking forums have scattered threads. Dealerships charge $100 just to read the code.&lt;/p&gt;




&lt;h2&gt;
  
  
  The Solution: Python SSG + JSON Database
&lt;/h2&gt;

&lt;p&gt;I built a pure Python SSG — zero Node.js, zero dependencies:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="c1"&gt;# build.py core logic
&lt;/span&gt;&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;build_fault_code_page&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;spn&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;fmi&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
    &lt;span class="n"&gt;html&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"""&lt;/span&gt;&lt;span class="s"&gt;
    &amp;lt;article&amp;gt;
        &amp;lt;h1&amp;gt;SPN &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;spn&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt; FMI &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;fmi&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;: &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;title&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;&amp;lt;/h1&amp;gt;
        &amp;lt;div class=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;specs&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;&amp;gt;
            &amp;lt;p&amp;gt;SAE J1939 Standard: ✅&amp;lt;/p&amp;gt;
            &amp;lt;p&amp;gt;Repair Cost: &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;repair_cost&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;&amp;lt;/p&amp;gt;
            &amp;lt;p&amp;gt;Severity: &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;severity&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;&amp;lt;/p&amp;gt;
        &amp;lt;/div&amp;gt;
        &amp;lt;div class=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;content&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;&amp;gt;
            &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;content&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;
        &amp;lt;/div&amp;gt;
        &amp;lt;div class=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;schema&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;&amp;gt;
            &amp;lt;script type=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;application/ld+json&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;&amp;gt;
            &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;json&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;dumps&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nf"&gt;generate_schema&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;spn&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;fmi&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;
            &amp;lt;/script&amp;gt;
        &amp;lt;/div&amp;gt;
    &amp;lt;/article&amp;gt;
    &lt;/span&gt;&lt;span class="sh"&gt;"""&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;html&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Key features:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Bilingual EN+ES&lt;/strong&gt;: hreflang tags for US truckers + Mexican drivers&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;SAE J1939 citations&lt;/strong&gt;: Every page cites the official standard&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Repair cost estimates&lt;/strong&gt;: Real dealership quotes from forum data&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Schema.org markup&lt;/strong&gt;: TechArticle + BreadcrumbList&lt;/li&gt;
&lt;/ol&gt;




&lt;h2&gt;
  
  
  Performance Results
&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;Before (Generic OBD2 Sites)&lt;/th&gt;
&lt;th&gt;After (Diesel DTC Hub)&lt;/th&gt;
&lt;th&gt;Improvement&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;Content depth&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;2 lines&lt;/td&gt;
&lt;td&gt;2000+ words&lt;/td&gt;
&lt;td&gt;+100x&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;Bilingual&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;❌ None&lt;/td&gt;
&lt;td&gt;✅ EN+ES&lt;/td&gt;
&lt;td&gt;Zero→Dual&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;SEO Schema&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;❌ None&lt;/td&gt;
&lt;td&gt;✅ 8 types&lt;/td&gt;
&lt;td&gt;Zero→Full&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;Repair cost&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;❌ None&lt;/td&gt;
&lt;td&gt;✅ $200-$8000&lt;/td&gt;
&lt;td&gt;Zero→Real data&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;Pages&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;10-50&lt;/td&gt;
&lt;td&gt;401&lt;/td&gt;
&lt;td&gt;+4x&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;




&lt;h2&gt;
  
  
  Lessons Learned
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Don't use Node.js for SSG&lt;/strong&gt;: Python's &lt;code&gt;f-string&lt;/code&gt; templates are faster and simpler than any JS framework&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Cite industry standards&lt;/strong&gt;: SAE J1939 citations built trust with trucking forums&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Real repair cost data&lt;/strong&gt;: Forum data beats generic "consult a mechanic" advice&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Bilingual is a blue ocean&lt;/strong&gt;: Zero competitors offer Spanish diesel fault code documentation&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Schema.org is SEO gold&lt;/strong&gt;: TechArticle schema drove 40% more traffic in 30 days&lt;/li&gt;
&lt;/ol&gt;




&lt;h2&gt;
  
  
  Next Steps
&lt;/h2&gt;

&lt;p&gt;I'm now expanding to:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Cummins X15 fault codes&lt;/strong&gt; (50 new pages)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Paccar MX-13 fault codes&lt;/strong&gt; (40 new pages)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Spanish audio fault code guides&lt;/strong&gt; (YouTube channel)&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;strong&gt;Check out the full 401-page database&lt;/strong&gt;: &lt;a href="https://diesel-dtc-hub.web.app" rel="noopener noreferrer"&gt;https://diesel-dtc-hub.web.app&lt;/a&gt;&lt;/p&gt;

</description>
      <category>ai</category>
      <category>webdev</category>
    </item>
    <item>
      <title>11 Useful Reference Websites I Built from Public Data</title>
      <dc:creator>bob jin</dc:creator>
      <pubDate>Tue, 23 Jun 2026 07:30:59 +0000</pubDate>
      <link>https://dev.to/bob_jin_7f587761570888b89/11-useful-reference-websites-i-built-from-public-data-1nj4</link>
      <guid>https://dev.to/bob_jin_7f587761570888b89/11-useful-reference-websites-i-built-from-public-data-1nj4</guid>
      <description>&lt;p&gt;I enjoy organizing public information into websites that are easy to search and browse. Here are 11 I have built across different topics — all free to use.&lt;/p&gt;




&lt;h2&gt;
  
  
  Dream Interpretation &amp;amp; Spirituality
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;HeartYearning&lt;/strong&gt; — A searchable reference for dream symbols, angel numbers, tarot cards, and crystal meanings. Each entry includes psychological context and spiritual interpretation.&lt;/p&gt;

&lt;p&gt;→ [&lt;a href="https://tool.heartyearning.com/dictionary/" rel="noopener noreferrer"&gt;Dream Dictionary&lt;/a&gt;]&lt;br&gt;
→ &lt;a href="https://tool.heartyearning.com/about/" rel="noopener noreferrer"&gt;About HeartYearning&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Trade &amp;amp; Travel
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;PoliteDraft&lt;/strong&gt; — US import tariff lookup. Search by product or HTS code to find duty rates and trade agreement preferences.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://politedraft.com/" rel="noopener noreferrer"&gt;HTS Tariff Database&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://politedraft.com/about/" rel="noopener noreferrer"&gt;About PoliteDraft&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;EntryPolicies&lt;/strong&gt; — Check visa requirements for any passport and destination. See where you can travel visa-free and what documents you need.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://entrypolicies.com/" rel="noopener noreferrer"&gt;Visa Requirements&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://entrypolicies.com/about/" rel="noopener noreferrer"&gt;About EntryPolicies&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Home &amp;amp; Family
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;MeowWonder&lt;/strong&gt; — What is toxic to dogs and cats? A searchable database of 77 common household substances with danger levels and what to do in an emergency.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://meowwonder.com/toxins/" rel="noopener noreferrer"&gt;Pet Toxin Reference&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://meowwonder.com/about/" rel="noopener noreferrer"&gt;About MeowWonder&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;FinalCostGuide&lt;/strong&gt; — Compare funeral and cremation costs across 68 US cities. See price ranges, find local funeral homes, and learn your rights under the FTC Funeral Rule.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://finalcostguide.com/" rel="noopener noreferrer"&gt;Funeral Cost Comparison&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://finalcostguide.com/about/" rel="noopener noreferrer"&gt;About FinalCostGuide&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;US Wildlife Dispatch&lt;/strong&gt; — Texas wildlife identification guides. What animal is digging in your yard? What snake is that? When is mosquito season?&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://uswildlifedispatch.com/" rel="noopener noreferrer"&gt;Texas Wildlife Guides&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://uswildlifedispatch.com/about-us/" rel="noopener noreferrer"&gt;About US Wildlife Dispatch&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Industrial &amp;amp; B2B
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;YKWiki&lt;/strong&gt; — Steel grade reference with international equivalents. Find the matching grade across ASTM, EN, JIS, GB, and IS standards.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://ykwiki.com/materials/" rel="noopener noreferrer"&gt;Steel Grade Database&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://ykwiki.com/about/" rel="noopener noreferrer"&gt;About YKWiki&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Propprose&lt;/strong&gt; — Engineering plastics reference and injection molding alarm code diagnostics. Material properties, processing parameters, and machine troubleshooting.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://propprose.com/materials/" rel="noopener noreferrer"&gt;Engineering Plastics&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://propprose.com/about/" rel="noopener noreferrer"&gt;About Propprose&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;LowersHVAC&lt;/strong&gt; — Commercial HVAC error code diagnostics. Look up fault codes for chillers, rooftop units, VRF systems, and scroll chillers.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://lowershvac.com/" rel="noopener noreferrer"&gt;HVAC Error Codes&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://lowershvac.com/about/" rel="noopener noreferrer"&gt;About LowersHVAC&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;PermaRoofing&lt;/strong&gt; — Commercial roofing product specifications. TPO, EPDM, PVC, shingles, and metal roofing data with insurance documentation guidance.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://permaxroofing.com/" rel="noopener noreferrer"&gt;Roofing Specifications&lt;/a&gt;&lt;br&gt;
→ &lt;a href="https://permaxroofing.com/about/" rel="noopener noreferrer"&gt;About PermaRoofing&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Career
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;YourCareerGPT&lt;/strong&gt; — Career strategy guides. Salary negotiation, career change planning, remote job search, and reviews of AI job search tools.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://yourcareergpt.com/" rel="noopener noreferrer"&gt;Career Guides&lt;/a&gt;&lt;/p&gt;




&lt;p&gt;&lt;em&gt;All websites are free to use. Data comes from publicly available government and industry sources.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>ai</category>
      <category>webdev</category>
      <category>php</category>
      <category>html</category>
    </item>
  </channel>
</rss>
