{"id":31181,"date":"2025-09-25T23:45:00","date_gmt":"2025-09-26T06:45:00","guid":{"rendered":"https:\/\/www.pingcap.com\/?p=31181"},"modified":"2025-12-24T00:21:55","modified_gmt":"2025-12-24T08:21:55","slug":"crowdsnap-path-to-profitability-with-tidb","status":"publish","type":"post","link":"https:\/\/www.pingcap.com\/ko\/blog\/crowdsnap-path-to-profitability-with-tidb\/","title":{"rendered":"Kill the ETL, Keep the Insight: Inside CrowdSnap\u2019s Path to Profitability with TiDB"},"content":{"rendered":"<p>Every startup founder knows that moment when a technical decision becomes a business breakthrough. For <a href=\"https:\/\/crowdsnap.ai\">CrowdSnap<\/a>, that moment came when they simplified their entire data architecture \u2013 and discovered that sometimes, less really is more.<\/p>\n\n\n\n<p>&#8220;Some of my answers are related to our story and how TiDB helped us achieve profitability,&#8221; said CrowdSnap&#8217;s founder. He shared insights from the company\u2019s journey as a B2B data analytics platform serving everyone from local governments to event organizers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Mission_Quality_Data_for_Better_Decisions\"><\/span>The Mission: Quality Data for Better Decisions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/crowdsnap.ai\">CrowdSnap<\/a>, based in Sri Lanka, operates on a simple principle: &#8220;bad data leads to bad decisions.&#8221; They&#8217;ve built their platform around data quality, validation, fraud controls, and privacy \u2013 serving market researchers, sales managers, and business owners who stake their decisions on reliable data.<\/p>\n\n\n\n<p>Their work isn&#8217;t small-scale. CrowdSnap processes government surveys collecting 200,000 to 500,000 records weekly (roughly 1-2 GB of data). They provide analytics for live events where organizers need real-time visitor insights \u2013 not tomorrow&#8217;s reports, but dashboards updating every 3 seconds during active exhibitions and conferences.<\/p>\n\n\n\n<p>&#8220;We provide visitor analytics for public exhibitions &amp; conferences and events,&#8221; the founder said. &#8220;Event organizers need to see visitor footfall, visitor analytics in their dashboards during the events.&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/static.pingcap.com\/files\/2025\/09\/01213035\/Body-1024x683.png\" alt=\"\" class=\"wp-image-29747\" srcset=\"https:\/\/static.pingcap.com\/files\/2025\/09\/01213035\/Body-1024x683.png 1024w, https:\/\/static.pingcap.com\/files\/2025\/09\/01213035\/Body-300x200.png 300w, https:\/\/static.pingcap.com\/files\/2025\/09\/01213035\/Body-768x512.png 768w, https:\/\/static.pingcap.com\/files\/2025\/09\/01213035\/Body.png 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>An example of real-time visitor analytics during a live event, where timing makes all the difference.<\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Architecture_Challenge_When_%E2%80%9CBest_Practices%E2%80%9D_Become_Bottlenecks\"><\/span>The Architecture Challenge: When &#8220;Best Practices&#8221; Become Bottlenecks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Like many startups, CrowdSnap began with what seemed like solid architectural choices:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OLTP layer: MySQL storing raw survey responses<\/li>\n\n\n\n<li>ETL\/Aggregation layer: Node.js background workers on schedules, materializing aggregate tables and caching views<\/li>\n\n\n\n<li>Reporting layer: Dashboards querying those aggregate tables<\/li>\n<\/ul>\n\n\n\n<p>&#8220;We were storing survey transactional data in one table, then used a background service to create aggregates and then store them in separate reporting tables,&#8221; the founder said. &#8220;We followed that practice to improve UX with better loading times for analytics dashboards and reports.&#8221;<\/p>\n\n\n\n<p>Most reports ran T+1 \u2013 overnight batch processing. For demanding clients, they managed 15-60 minute mini-batches, but it was a constant juggling act between data freshness and system performance.<\/p>\n\n\n\n<p>The architecture worked, but it came with hidden costs: engineering time spent on maintenance, complexity in debugging data sync issues, and fundamental limitations on how quickly they could serve client needs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Simplification_One_Database_Real-Time_Everything\"><\/span>The Simplification: One Database, Real-Time Everything<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After exploring options including ClearDB and Microsoft SQL Server, CrowdSnap made a decision that would reshape their business: they chose <a href=\"https:\/\/www.pingcap.com\/ko\/tidb-cloud-starter\/\">TiDB Cloud \uc2a4\ud0c0\ud130<\/a> for its hybrid transactional\/analytical processing (HTAP) capabilities.<\/p>\n\n\n\n<p>&#8220;In addition to HTAP, we loved how simple the setup process was, along with other modern inbuilt features such as<a href=\"https:\/\/www.pingcap.com\/ko\/ai\/\"> vector search<\/a> and dedicated prompt support,\u201d the founder said. \u201cThere was no limit to the number of concurrent connections as well.&#8221;<\/p>\n\n\n\n<p>After Crowdsnap adopted TiDB, its new system enjoyed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No background processes<\/li>\n\n\n\n<li>No separate aggregate tables<\/li>\n\n\n\n<li>Real-time aggregation on the fly<\/li>\n\n\n\n<li>Dashboards powered directly from live data<\/li>\n<\/ul>\n\n\n\n<p>The change eliminated two major system components: the background services layer and the need for dedicated servers for vector data storage.<\/p>\n\n\n\n<p>&#8220;It was an architectural change,&#8221; the founder said. &#8220;We used to store raw survey data first, aggregate it, and then store it again for dashboards as background services. Now we use a single process to store and aggregate on the fly. No background processing.&#8221;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Business_Impact_When_Technology_Enables_Growth\"><\/span>The Business Impact: When Technology Enables Growth<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For CrowdSnap, architectural simplification translated directly to business results. Removing operational overhead meant more focus on product development and client acquisition. Real-time capabilities opened doors to premium clients with demanding requirements.<\/p>\n\n\n\n<p>&#8220;As a relatively new provider I was expecting random breakdowns,&#8221; the founder said about their database choice. &#8220;But it was very reliable. Highly available.&#8221; This reliability meant fewer operational emergencies and more predictable service delivery.<\/p>\n\n\n\n<p>The founder&#8217;s reflection on profitability highlights a crucial startup lesson: sometimes the best technology choice isn&#8217;t the most sophisticated one \u2013 it&#8217;s the one that gets out of your way and lets you focus on serving customers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Looking_Ahead_AI-Powered_Insights\"><\/span>Looking Ahead: AI-Powered Insights<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/static.pingcap.com\/files\/2025\/09\/30005749\/use-case-crowdsnap-1-1024x512.png\" alt=\"\" class=\"wp-image-29741\" srcset=\"https:\/\/static.pingcap.com\/files\/2025\/09\/30005749\/use-case-crowdsnap-1-1024x512.png 1024w, https:\/\/static.pingcap.com\/files\/2025\/09\/30005749\/use-case-crowdsnap-1-300x150.png 300w, https:\/\/static.pingcap.com\/files\/2025\/09\/30005749\/use-case-crowdsnap-1-768x384.png 768w, https:\/\/static.pingcap.com\/files\/2025\/09\/30005749\/use-case-crowdsnap-1-1536x768.png 1536w, https:\/\/static.pingcap.com\/files\/2025\/09\/30005749\/use-case-crowdsnap-1.png 1800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>CrowdSnap architecture with TiDB<\/em><\/figcaption><\/figure>\n\n\n\n<p>CrowdSnap&#8217;s simplified architecture is now enabling their next phase of innovation. They&#8217;re exploring AI capabilities that would have been architecturally complex with their previous setup.<\/p>\n\n\n\n<p>&#8220;We are creating an AI-based prompting engine for SQL and AI data clustering with vector search capabilities,&#8221; the founder shared. Their roadmap includes sentiment analyzing, thematic clustering, speech, and video analyzing.<\/p>\n\n\n\n<p>These aren&#8217;t just cool features \u2013 they&#8217;re solutions to real customer problems. These include automatically categorizing survey responses, finding patterns in research data, or providing instant insights from complex datasets.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lessons_for_AI_Startups\"><\/span>Lessons for AI Startups<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>CrowdSnap&#8217;s journey offers several insights for other AI startups:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Simplicity can be a competitive advantage \u2013 complex architectures aren&#8217;t always better architectures.<\/li>\n\n\n\n<li>Real-time capabilities can unlock premium markets \u2013 government and enterprise clients often pay more for immediate insights.<\/li>\n\n\n\n<li>Operational overhead is a hidden cost \u2013 time spent maintaining infrastructure is time not spent on growth.<\/li>\n\n\n\n<li>Future-proofing matters \u2013 choosing platforms that support emerging technologies (like AI\/ML) can accelerate innovation.<\/li>\n<\/ul>\n\n\n\n<p>CrowdSnap\u2019s founder remains honest about areas for improvement, noting feedback already shared with the technical team about MySQL data dump support. He also sees opportunities in community building: &#8220;more networking sessions targeting early stage startups who actually need support. Like proper visibility, referrals, and quality networking programs.&#8221;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Bigger_Picture\"><\/span>The Bigger Picture<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>CrowdSnap&#8217;s story isn&#8217;t really about database technology \u2013 it&#8217;s about making smart choices that enable business success. Their path from complex, multi-layered architecture to elegant simplicity shows that sometimes the best solution is the one that disappears into the background, letting you focus on what really matters: building great products and serving customers.<\/p>\n\n\n\n<p>For founders navigating similar technical decisions, CrowdSnap&#8217;s experience suggests a simple question: does this technology help us serve customers better, or does it just add complexity? The answer might surprise you. CrowdSnap simplified their architecture and unlocked their next wave of AI innovation. Begin your own journey with a <a href=\"https:\/\/tidbcloud.com\/free-trial\/\"><strong>TiDB Cloud Starter trial<\/strong><\/a>.<\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Every startup founder knows that moment when a technical decision becomes a business breakthrough. For CrowdSnap, that moment came when they simplified their entire data architecture \u2013 and discovered that sometimes, less really is more. &#8220;Some of my answers are related to our story and how TiDB helped us achieve profitability,&#8221; said CrowdSnap&#8217;s founder. He [&hellip;]<\/p>\n","protected":false},"author":264,"featured_media":29742,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[199],"tags":[11,31],"class_list":["post-31181","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-customer-stories","tag-real-time-analytics","tag-tidb-cloud"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png","author_info":{"display_name":"Fang Liu","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/heidi-liu\/"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Inside CrowdSnap\u2019s Path to Profitability with TiDB<\/title>\n<meta name=\"description\" content=\"Learn how CrowdSnap simplified their complex MySQL &amp; ETL architecture with TiDB to power AI insights and achieve profitability.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/crowdsnap-path-to-profitability-with-tidb\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Inside CrowdSnap\u2019s Path to Profitability with TiDB\" \/>\n<meta property=\"og:description\" content=\"Learn how CrowdSnap simplified their complex MySQL &amp; ETL architecture with TiDB to power AI insights and achieve profitability.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/crowdsnap-path-to-profitability-with-tidb\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-26T06:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-24T08:21:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2025\/09\/30013311\/Banner-2%EF%B9%951-logo%E7%BA%AF%E4%BA%AB%E7%89%88.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Fang Liu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fang Liu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/\"},\"author\":{\"name\":\"Fang Liu\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/e85779bf9c0a6581e4b301bb43c5ed66\"},\"headline\":\"Kill the ETL, Keep the Insight: Inside CrowdSnap\u2019s Path to Profitability with TiDB\",\"datePublished\":\"2025-09-26T06:45:00+00:00\",\"dateModified\":\"2025-12-24T08:21:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/\"},\"wordCount\":994,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png\",\"keywords\":[\"Real-time analytics\",\"TiDB Cloud\"],\"articleSection\":[\"Customer Story\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/\",\"name\":\"Inside CrowdSnap\u2019s Path to Profitability with TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png\",\"datePublished\":\"2025-09-26T06:45:00+00:00\",\"dateModified\":\"2025-12-24T08:21:55+00:00\",\"description\":\"Learn how CrowdSnap simplified their complex MySQL & ETL architecture with TiDB to power AI insights and achieve profitability.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png\",\"width\":1800,\"height\":600,\"caption\":\"crowdsnap-banner\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kill the ETL, Keep the Insight: Inside CrowdSnap\u2019s Path to Profitability with TiDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/e85779bf9c0a6581e4b301bb43c5ed66\",\"name\":\"Fang Liu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2025\/08\/27201041\/20250828-095938-150x150.jpeg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2025\/08\/27201041\/20250828-095938-150x150.jpeg\",\"caption\":\"Fang Liu\"},\"description\":\"Growth Strategy\",\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/heidi-liu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Inside CrowdSnap\u2019s Path to Profitability with TiDB","description":"Learn how CrowdSnap simplified their complex MySQL & ETL architecture with TiDB to power AI insights and achieve profitability.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/blog\/crowdsnap-path-to-profitability-with-tidb\/","og_locale":"ko_KR","og_type":"article","og_title":"Inside CrowdSnap\u2019s Path to Profitability with TiDB","og_description":"Learn how CrowdSnap simplified their complex MySQL & ETL architecture with TiDB to power AI insights and achieve profitability.","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/crowdsnap-path-to-profitability-with-tidb\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2025-09-26T06:45:00+00:00","article_modified_time":"2025-12-24T08:21:55+00:00","og_image":[{"width":1800,"height":900,"url":"https:\/\/static.pingcap.com\/files\/2025\/09\/30013311\/Banner-2%EF%B9%951-logo%E7%BA%AF%E4%BA%AB%E7%89%88.png","type":"image\/png"}],"author":"Fang Liu","twitter_card":"summary_large_image","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Fang Liu","Est. reading time":"5\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/"},"author":{"name":"Fang Liu","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/e85779bf9c0a6581e4b301bb43c5ed66"},"headline":"Kill the ETL, Keep the Insight: Inside CrowdSnap\u2019s Path to Profitability with TiDB","datePublished":"2025-09-26T06:45:00+00:00","dateModified":"2025-12-24T08:21:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/"},"wordCount":994,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png","keywords":["Real-time analytics","TiDB Cloud"],"articleSection":["Customer Story"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/","url":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/","name":"Inside CrowdSnap\u2019s Path to Profitability with TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png","datePublished":"2025-09-26T06:45:00+00:00","dateModified":"2025-12-24T08:21:55+00:00","description":"Learn how CrowdSnap simplified their complex MySQL & ETL architecture with TiDB to power AI insights and achieve profitability.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png","width":1800,"height":600,"caption":"crowdsnap-banner"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/crowdsnap-path-to-profitability-with-tidb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Kill the ETL, Keep the Insight: Inside CrowdSnap\u2019s Path to Profitability with TiDB"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/e85779bf9c0a6581e4b301bb43c5ed66","name":"Fang Liu","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2025\/08\/27201041\/20250828-095938-150x150.jpeg","contentUrl":"https:\/\/static.pingcap.com\/files\/2025\/08\/27201041\/20250828-095938-150x150.jpeg","caption":"Fang Liu"},"description":"Growth Strategy","url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/heidi-liu\/"}]}},"grav_blocks":false,"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/crowdsnap-path-to-profitability-with-tidb\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"crowdsnap-banner\" src=\"https:\/\/static.pingcap.com\/files\/2025\/09\/30010413\/Banner-3%EF%B9%951-logo-ver.png\" loading=\"lazy\" width=1800 height=600 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Customer Story<\/div><\/div><h5 class=\"card-resource__title\">Kill the ETL, Keep the Insight: Inside CrowdSnap\u2019s Path to Profitability with TiDB<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/31181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/264"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=31181"}],"version-history":[{"count":5,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/31181\/revisions"}],"predecessor-version":[{"id":31194,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/31181\/revisions\/31194"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/29742"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=31181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=31181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=31181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}