<?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: Annie </title>
    <description>The latest articles on DEV Community by Annie  (@anni_ca810d4bec9917f).</description>
    <link>https://dev.to/anni_ca810d4bec9917f</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%2F3888211%2Ff5a70915-1805-4e54-9e6c-488c4cb08450.png</url>
      <title>DEV Community: Annie </title>
      <link>https://dev.to/anni_ca810d4bec9917f</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/anni_ca810d4bec9917f"/>
    <language>en</language>
    <item>
      <title>Use two keys to ingest SEC Form D amendments</title>
      <dc:creator>Annie </dc:creator>
      <pubDate>Fri, 20 Nov 2026 14:41:17 +0000</pubDate>
      <link>https://dev.to/anni_ca810d4bec9917f/use-two-keys-to-ingest-sec-form-d-amendments-1oa5</link>
      <guid>https://dev.to/anni_ca810d4bec9917f/use-two-keys-to-ingest-sec-form-d-amendments-1oa5</guid>
      <description>&lt;p&gt;AI disclosure: This tutorial and its example code were produced with an AI agent for Startup Funding Tracker. The example data is synthetic.&lt;/p&gt;

&lt;p&gt;If you import SEC Form D data, an accession number is a good primary key for a &lt;strong&gt;filing&lt;/strong&gt;. It is a bad key for a &lt;strong&gt;funding event&lt;/strong&gt;. A new Form D and its later amendment have different accession numbers. They can still describe the same offering, with the newer notice reporting a revised total.&lt;/p&gt;

&lt;p&gt;That distinction affects both ingestion and analytics. Retrying a download should never create a second filing record. Reading an amendment should never cause a dashboard to add two snapshots of the same sale.&lt;/p&gt;

&lt;h2&gt;
  
  
  Store filing identity and offering identity separately
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Field&lt;/th&gt;
&lt;th&gt;What to store&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;accession&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Unique key for the document. Keep its original source URL.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;issuer_cik&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;SEC issuer identifier. One issuer can have multiple offerings.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;prior_accession&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;The prior filing reference when available on an amendment.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;offering_id&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;A resolved key shared by notices that describe the same offering.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;accepted_at&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;EDGAR acceptance time normalized to UTC. Keep the first-sale date separately.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;amount_sold&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;The filing's reported cumulative amount, stored as an exact number.&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Start a new offering for an original notice. For an amendment with a prior reference, walk the chain until it reaches a known original. Keep the amendment unresolved if a predecessor is missing from the import. A fallback guess based on the CIK alone can silently merge separate financings by the same company.&lt;/p&gt;

&lt;p&gt;The &lt;a href="https://www.sec.gov/data-research/sec-markets-data/form-d-data-sets" rel="noopener noreferrer"&gt;SEC's Form D Data Sets&lt;/a&gt; are convenient for backfills. Retain links to EDGAR because a flattened extract is not a substitute for the original notice.&lt;/p&gt;

&lt;h2&gt;
  
  
  Compute changes after resolving the chain
&lt;/h2&gt;

&lt;p&gt;In this example, each tuple has a normalized UTC timestamp, accession, resolved offering key, and reported amount sold in whole dollars. The first notice establishes the baseline. A later filing can increase it, leave it unchanged, or revise it down.&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="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;offering_changes&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;filings&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;seen&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="kt"&gt;set&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;latest&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;accepted_at&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;accession&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;offering_id&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;amount&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="nb"&gt;sorted&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;filings&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;accession&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="n"&gt;seen&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
            &lt;span class="k"&gt;continue&lt;/span&gt;
        &lt;span class="n"&gt;seen&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;add&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;accession&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;offering_id&lt;/span&gt; &lt;span class="k"&gt;is&lt;/span&gt; &lt;span class="kc"&gt;None&lt;/span&gt; &lt;span class="ow"&gt;or&lt;/span&gt; &lt;span class="n"&gt;amount&lt;/span&gt; &lt;span class="k"&gt;is&lt;/span&gt; &lt;span class="kc"&gt;None&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
            &lt;span class="k"&gt;yield&lt;/span&gt; &lt;span class="n"&gt;accession&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"needs review"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="kc"&gt;None&lt;/span&gt;
            &lt;span class="k"&gt;continue&lt;/span&gt;

        &lt;span class="n"&gt;previous&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;latest&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;offering_id&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="n"&gt;latest&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;offering_id&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;amount&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;previous&lt;/span&gt; &lt;span class="k"&gt;is&lt;/span&gt; &lt;span class="kc"&gt;None&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
            &lt;span class="k"&gt;yield&lt;/span&gt; &lt;span class="n"&gt;accession&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"initial snapshot"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;amount&lt;/span&gt;
        &lt;span class="k"&gt;else&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
            &lt;span class="n"&gt;delta&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;amount&lt;/span&gt; &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="n"&gt;previous&lt;/span&gt;
            &lt;span class="n"&gt;label&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s2"&gt;"downward revision"&lt;/span&gt; &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;delta&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt; &lt;span class="k"&gt;else&lt;/span&gt; &lt;span class="s2"&gt;"reported change"&lt;/span&gt;
            &lt;span class="k"&gt;yield&lt;/span&gt; &lt;span class="n"&gt;accession&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;label&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;delta&lt;/span&gt;


&lt;span class="n"&gt;filings&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
    &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"2026-01-15T12:00:00Z"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"example-a"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"offering-1"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;600_000&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"2026-02-10T12:00:00Z"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"example-b"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"offering-1"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;900_000&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"2026-02-24T12:00:00Z"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"example-c"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"offering-1"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;850_000&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"2026-03-12T12:00:00Z"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"example-d"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="kc"&gt;None&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;200_000&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;]&lt;/span&gt;

&lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;change&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="nf"&gt;offering_changes&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;filings&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="k"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;change&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;('example-a', 'initial snapshot', 600000)
('example-b', 'reported change', 300000)
('example-c', 'downward revision', -50000)
('example-d', 'needs review', None)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The latest known total for the resolved offering is 850,000. Summing three reported totals would count the same securities repeatedly. A downward revision is a change in the reported amount, so keep it separate from any claim that an investor received a refund. The &lt;a href="https://www.sec.gov/data-research/statistics-data-visualizations/regulation-d-offerings" rel="noopener noreferrer"&gt;SEC's Regulation D statistics methodology&lt;/a&gt; likewise uses incremental amounts for successive amendments to the same offering.&lt;/p&gt;

&lt;p&gt;For an incremental pipeline, rebuild the affected offering when a missing predecessor arrives. That keeps an out-of-order import from permanently changing the interpretation of a notice. Make the transformation replayable from the filing records, including the decisions that resolved the offering IDs.&lt;/p&gt;

&lt;p&gt;For a live example of navigating from an issuer to its filing, &lt;a href="https://startupfundingtracker.com/" rel="noopener noreferrer"&gt;Startup Funding Tracker&lt;/a&gt; has daily U.S. startup Form D notices and links to source filings.&lt;/p&gt;

</description>
      <category>python</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>I built a free SaaS directory MAQTOOB with 2,000+ tools</title>
      <dc:creator>Annie </dc:creator>
      <pubDate>Mon, 20 Apr 2026 05:16:19 +0000</pubDate>
      <link>https://dev.to/anni_ca810d4bec9917f/i-built-a-free-saas-directory-maqtoob-with-2000-tools-36eg</link>
      <guid>https://dev.to/anni_ca810d4bec9917f/i-built-a-free-saas-directory-maqtoob-with-2000-tools-36eg</guid>
      <description>&lt;p&gt;If you have ever spent hours googling "best CRM for small business" or "top project management tools" and ended up with 47 tabs open and no clear answer, you know the problem.&lt;/p&gt;

&lt;p&gt;I built &lt;a href="https://maqtoob.com" rel="noopener noreferrer"&gt;MAQTOOB&lt;/a&gt; to solve it.&lt;/p&gt;

&lt;h2&gt;
  
  
  What is MAQTOOB?
&lt;/h2&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.amazonaws.com%2Fuploads%2Farticles%2Fm3wuv35pfkavgm99whwp.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%2Fm3wuv35pfkavgm99whwp.png" alt=" " width="800" height="453"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;MAQTOOB is a free SaaS directory that helps entrepreneurs, freelancers, and small teams find the right software for their business. No paywalls, no gated content, no "book a demo to see pricing." Just browse, compare, and pick.&lt;/p&gt;

&lt;p&gt;We currently have &lt;strong&gt;2,000+ tools&lt;/strong&gt; across &lt;strong&gt;100+ categories&lt;/strong&gt; — from CRM and project management to accounting, HR, customer service, and more.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why I built this
&lt;/h2&gt;

&lt;p&gt;I was running a small business and needed to find tools for different parts of the operation. Every time I searched, I ended up on review sites that either:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Ranked tools based on who paid the most&lt;/li&gt;
&lt;li&gt;Required me to sign up before showing anything useful&lt;/li&gt;
&lt;li&gt;Had outdated information from 3 years ago&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;I wanted something simple: a clean directory where I can browse by category, compare features and pricing side by side, and make a decision in minutes instead of days.&lt;/p&gt;

&lt;p&gt;So I built one.&lt;/p&gt;

&lt;h2&gt;
  
  
  How it works
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;For users (free):&lt;/strong&gt;&lt;/p&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.amazonaws.com%2Fuploads%2Farticles%2F3iilu41xq7tja9g8v1n5.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%2F3iilu41xq7tja9g8v1n5.png" alt=" " width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Browse 100+ categories or search for what you need&lt;/li&gt;
&lt;li&gt;Compare tools side by side — features, pricing, and details&lt;/li&gt;
&lt;li&gt;Visit the vendor's website and get started&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;No sign-up required to browse. No ads blocking the content.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;For SaaS vendors (also free):&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;If you have a SaaS product, you can &lt;a href="https://maqtoob.com/login/" rel="noopener noreferrer"&gt;submit it to MAQTOOB&lt;/a&gt; for free. Your tool gets listed in the relevant category and becomes discoverable by thousands of users who are actively looking for software solutions.&lt;/p&gt;

&lt;h2&gt;
  
  
  Some numbers
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;2,000+ tools listed&lt;/li&gt;
&lt;li&gt;100+ software categories&lt;/li&gt;
&lt;li&gt;Top categories: Collaboration &amp;amp; Productivity (474 tools), Call Center Software (149), Content Management (87), HR Tools (72), Business Management (63)&lt;/li&gt;
&lt;li&gt;100% free to use and submit&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Who is this for?
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Entrepreneurs&lt;/strong&gt; looking for affordable tools to run their business&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Freelancers&lt;/strong&gt; who need the right software without enterprise pricing&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Small teams&lt;/strong&gt; comparing options before committing&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;SaaS founders&lt;/strong&gt; who want free exposure to potential customers&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What makes MAQTOOB different from G2 or Capterra?
&lt;/h2&gt;

&lt;p&gt;Good question. G2 and Capterra are great, but they are built for enterprise buyers. MAQTOOB is built for small businesses and solo founders who just want to find a good tool without the noise.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;No gated content&lt;/li&gt;
&lt;li&gt;No requirement to leave your email before seeing results&lt;/li&gt;
&lt;li&gt;Clean, simple browsing experience&lt;/li&gt;
&lt;li&gt;Focused on tools that are actually useful for small teams&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Check it out
&lt;/h2&gt;

&lt;p&gt;If you are a SaaS founder, you can submit your tool for free. If you are looking for software, just browse and compare.&lt;/p&gt;

&lt;p&gt;I would love to hear your feedback. What categories would you like to see more of? What features would make this more useful for you?&lt;/p&gt;

&lt;p&gt;Drop a comment below or reach out at &lt;a href="mailto:info@maqtoob.com"&gt;info@maqtoob.com&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>saas</category>
      <category>listing</category>
      <category>directory</category>
    </item>
  </channel>
</rss>
