# tcg-pocket-collection-tracker | Marcel Panse | Knowledge Base | Instagit

Application to track your Pokemon Pocket collection and find others to trade with

GitHub Stars: 139

Repository: https://github.com/marcelpanse/tcg-pocket-collection-tracker

---

## Articles

### [How the TCG Pocket Collection Tracker Builds Its React Frontend with Vite and Deploys to GitHub Pages](/marcelpanse/tcg-pocket-collection-tracker/how-is-the-react-frontend-application-built-using-vite-and-what-is-the-ci-cd-workflow-for-deploying-it-to-github-pages)

Learn how the TCG Pocket Collection Tracker builds its React frontend with Vite for optimized performance and deploys automatically to GitHub Pages using GitHub Actions CI/CD.

- Tags: how-to-guide
- Published: 2026-03-07

### [Deno Edge Functions Dependencies and Configuration in TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/what-are-the-dependencies-and-configuration-details-for-the-deno-edge-functions-as-defined-in-deno.json-and-supabase-functions)

Learn about Deno Edge Functions dependencies and configuration for the TCG Pocket Collection Tracker. Discover direct URL imports, Supabase JS, Node.js polyfills, and essential environment variables.

- Tags: architecture
- Published: 2026-03-06

### [How the cards.json Data File Is Managed and Updated in the Pokémon TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/how-is-the-cards.json-data-file-managed-and-what-is-the-process-for-scraping-or-updating-this-data-from-external-pokemon-tcg-sources)

Discover how the cards.json data file is automatically generated and updated. Learn about the Node.js scraper that extracts Pokémon TCG metadata from external sources.

- Tags: internals
- Published: 2026-03-06

### [Pack Structure Definition in TCG Pocket Collection Tracker: How Shinies and Baby Pokémon Are Tracked](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-pack-structure-definition-in-the-tcg-data-and-how-are-variations-like-shinies-and-baby-pokemon-tracked-per-expansion)

Learn how TCG Pocket Collection Tracker defines pack structures to track shiny and baby Pokémon, ensuring accurate pull rates with this essential guide.

- Tags: internals
- Published: 2026-03-06

### [How Public Collection Views Are Shared Using a Unique Friend ID While Protecting Privacy in TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/how-are-public-collection-views-shared-using-a-unique-friend-id-while-ensuring-user-privacy-and-preventing-exposure-of-sensitive-information-like-emails)

Learn how TCG Pocket Collection Tracker shares public views with a unique friend ID, protecting user privacy by avoiding email exposure. Accessible via shareable URLs.

- Tags: architecture
- Published: 2026-03-06

### [How the Supabase Trades Table Works: Structure and Status Management Explained](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-structure-of-the-supabase-trades-table-and-how-are-different-trade-statuses-e.g-pending-accepted-declined-managed)

Understand the Supabase trades table structure and how TradeStatus enum manages pending, accepted, and declined card exchanges. Learn about offerer_ended and receiver_ended flags for completion confirmation.

- Tags: internals
- Published: 2026-03-06

### [How the Trade Offer System Facilitates Creation, Negotiation, and Acceptance of Card Trades](/marcelpanse/tcg-pocket-collection-tracker/how-does-the-trade-offer-system-facilitate-the-creation-negotiation-and-acceptance-of-card-trades-between-users)

Discover how our trade offer system streamlines card trading. Learn about its architecture for creation, negotiation, and acceptance, ensuring seamless peer-to-peer exchanges.

- Tags: architecture
- Published: 2026-03-06

### [Biome Linting and Formatting Rules and Git Hook Configuration for TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/what-are-the-recommended-biome-linting-and-formatting-rules-for-this-project-and-how-are-git-hooks-configured-for-code-quality-checks)

Discover Biome linting and formatting rules and lefthook Git configuration for the TCG Pocket Collection Tracker project. Ensure code quality on commit and push.

- Tags: devops
- Published: 2026-03-06

### [One-Time Password (OTP) Email Authentication Flow with Supabase Auth in TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-detailed-authentication-flow-for-user-registration-and-login-using-one-time-password-otp-emails-via-supabase-auth)

Learn the Supabase Auth OTP email authentication flow for user registration and login. Discover how the TCG Pocket Collection Tracker uses OTP to secure your JWT session.

- Tags: internals
- Published: 2026-03-06

### [How Static Assets Are Organized and Served Efficiently from the Public Folder in a Vite-Based Frontend](/marcelpanse/tcg-pocket-collection-tracker/how-are-static-assets-like-card-images-organized-and-served-efficiently-from-the-public-folder-in-the-vite-based-frontend)

Learn how Vite efficiently serves static assets like card images from the public folder, using absolute paths for fast loading and caching in your frontend.

- Tags: how-to-guide
- Published: 2026-03-06

### [How the stats-tracker Deno Edge Function Calculates Collection Summary Insights in TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/how-does-the-stats-tracker-deno-edge-function-calculate-and-aggregate-collection-summary-insights-for-users)

Discover how the stats-tracker Deno Edge Function aggregates total cards and user counts from PostgreSQL, persisting them as a public JSON for fast frontend access in TCG Pocket Collection Tracker.

- Tags: how-to-guide
- Published: 2026-03-06

### [How User Missions Are Tracked in TCG Pocket Collection Tracker: JSON Structure and Storage Logic](/marcelpanse/tcg-pocket-collection-tracker/how-are-user-missions-tracked-within-the-application-and-what-is-the-json-structure-used-for-defining-mission-objectives-and-rewards)

Discover how the TCG Pocket Collection Tracker uses JSON to store user missions and track completions. Learn about the structure for objectives and rewards storage.

- Tags: internals
- Published: 2026-03-06

### [TCG Pocket Collection Tracker Deck Building Architecture: How Validation Rules Are Applied](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-architecture-of-the-deck-building-feature-in-the-tcg-pocket-collection-tracker-including-how-deck-validation-rules-are-applied)

Explore the TCG Pocket Collection Tracker's deck building architecture. Learn how React, Zod, and Supabase apply validation rules client-side and server-side for robust game rule enforcement.

- Tags: architecture
- Published: 2026-03-06

### [How to Implement Filtered Searches and Data Visualization in React with Virtualization for Large Collections](/marcelpanse/tcg-pocket-collection-tracker/how-are-filtered-searches-and-data-visualization-efficiently-implemented-in-the-react-frontend-using-react-table-and-react-virtualize-for-large-collections)

Learn to implement filtered searches and data visualization in React with virtualization. Render thousands of cards instantly and sync filter state to the URL for shareable searches.

- Tags: deep-dive
- Published: 2026-03-06

### [How the TCG Pocket Collection Tracker Import Feature Parses and Validates CSV Card Data](/marcelpanse/tcg-pocket-collection-tracker/how-does-the-collection-import-feature-parse-and-validate-csv-formatted-card-data-handling-potential-errors-and-data-inconsistencies)

Learn how the TCG Pocket Collection Tracker parses and validates CSV card data using xlsx, React Query, and robust error handling for seamless collection management.

- Tags: how-to-guide
- Published: 2026-03-06

### [Row Level Security (RLS) Policies in the TCG Pocket Collection Tracker Supabase Backend](/marcelpanse/tcg-pocket-collection-tracker/what-are-the-row-level-security-rls-policies-configured-in-supabase-to-protect-user-specific-card-collection-data)

Discover how to implement Row Level Security RLS policies in Supabase to protect your TCG Pocket Collection Tracker user data. Learn about secure access controls for your card collections.

- Tags: internals
- Published: 2026-03-06

### [How TCG Data Is Organized in CardsDB: Expansions, Rarity, and the Critical internal_id System](/marcelpanse/tcg-pocket-collection-tracker/how-is-the-tcg-data-including-expansions-and-rarity-organized-within-the-cardsdb-and-what-is-the-significance-of-the-internal_id-system)

Discover how tcg data is organized in CardsDB. Learn about expansions, rarity, and the crucial internal_id system for linking application data.

- Tags: internals
- Published: 2026-03-06

### [Single Sign-On (SSO) Integration with Discourse Using Supabase Auth and Deno Edge Functions](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-implementation-of-single-sign-on-sso-integration-with-discourse-using-supabase-auth-and-deno-edge-functions)

Implement Discourse SSO with Supabase Auth and Deno Edge Functions. This guide details stateless integration, signature verification, and user authentication for a seamless login flow.

- Tags: how-to-guide
- Published: 2026-03-06

### [How the Trade Matching System Uses Supabase Edge Functions to Find Trading Partners](/marcelpanse/tcg-pocket-collection-tracker/how-does-the-trade-matching-system-leverage-supabase-edge-functions-to-identify-and-suggest-potential-trading-partners-for-users)

Discover how our trade matching system uses Supabase Edge Functions to find ideal trading partners by analyzing card ownership and preferences for better matches. Get ranked suggestions now.

- Tags: how-to-guide
- Published: 2026-03-06

### [Optimal Pack Calculation Tool: Algorithm and Methodology for Maximizing Collection Completion](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-algorithm-and-methodology-behind-the-optimal-pack-calculation-tool-to-determine-the-best-packs-to-open-for-collection-completion)

Discover the Optimal Pack Calculation Tool algorithm. Learn how it maximizes card collection completion by calculating pull probabilities and selecting the best packs to open.

- Tags: algorithm-and-methodology
- Published: 2026-03-06

### [How Data Synchronization Between localStorage and Supabase Works in TCG Pocket Collection Tracker](/marcelpanse/tcg-pocket-collection-tracker/how-is-data-synchronization-handled-between-localstorage-caching-and-the-remote-supabase-database-to-ensure-collection-consistency)

Learn how localStorage and Supabase sync data in the TCG Pocket Collection Tracker. Explore timestamp validation and effective caching strategies for consistent data.

- Tags: internals
- Published: 2026-03-06

### [Supabase Database Schema for Pokémon Card Collections: Cards, Quantities, and Trade Associations](/marcelpanse/tcg-pocket-collection-tracker/what-is-the-supabase-database-schema-for-storing-pokemon-card-collections-including-details-on-cards-quantities-and-user-associations-for-trades)

Explore the Supabase database schema for Pokémon card collections. Learn how to manage cards, quantities, and trade associations using the relational design in tcg-pocket-collection-tracker.

- Tags: architecture
- Published: 2026-03-06

### [How TCG Pocket Collection Tracker Caches Card Collections Locally Using localStorage: Keys, Validation, and Invalidation Strategies](/marcelpanse/tcg-pocket-collection-tracker/how-does-tcg-pocket-collection-tracker-cache-card-collections-locally-using-localstorage-and-what-are-the-strategies-for-cache-invalidation)

Learn how the TCG Pocket Collection Tracker caches card collections locally with localStorage. Discover key strategies for validation and automatic cache invalidation.

- Tags: deep-dive
- Published: 2026-03-06