# bbl-tracker-public-db | Nelson Chen | Knowledge Base | Instagit

🦆 https://bbltracker.com database for DuckDB and AI Queries

GitHub Stars: 1

Repository: https://github.com/nelsonjchen/bbl-tracker-public-db

---

## Articles

### [How to Debug Network Errors and Handle Missing Parquet Files in BBL Tracker](/nelsonjchen/bbl-tracker-public-db/debugging-network-errors-and-handling-missing-parquet-files)

Debug BBL Tracker network errors and missing parquet files. Implement retry logic, validate URLs, and filter missing files to handle transient failures with diagnostic logging.

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

### [Understanding Creative Commons License and Data Attribution Requirements for the Bambu Lab Store Filament Tracker](/nelsonjchen/bbl-tracker-public-db/understanding-creative-commons-license-and-attribution)

Learn about the Creative Commons license and data attribution rules for the BBL Tracker public database. Understand your obligations for using and sharing this open data.

- Tags: best-practices
- Published: 2026-03-08

### [Comparing Stock Levels Across Different Time Periods with the Bambu Lab Public Database](/nelsonjchen/bbl-tracker-public-db/comparing-stock-levels-across-different-time-periods)

Compare stock levels across time periods using the Bambu Lab Public Database. Query Parquet shards with DuckDB or reconstruct your own database to analyze historical inventory trends.

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

### [Handling ETA Field Availability and NULL Values in Bambu Lab Tracker Queries](/nelsonjchen/bbl-tracker-public-db/handling-eta-field-availability-and-null-values)

Master ETA field availability and NULL values in Bambu Lab Tracker queries. Learn to filter, replace, or count non-NULL values using standard SQL and DuckDB for accurate data.

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

### [Exporting Merged Data for ChatGPT Code Interpreter Analysis: The Bambu Lab Filament Database Guide](/nelsonjchen/bbl-tracker-public-db/exporting-merged-data-for-chatgpt-code-interpreter)

Export merged data for ChatGPT Code Interpreter analysis by downloading Parquet shards and compiling with the reconstruct_db.py script. Analyze Bambu Lab filament data now.

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

### [Using Python with uv for Zero-Setup DuckDB Queries on Remote Parquet Data](/nelsonjchen/bbl-tracker-public-db/using-python-with-uv-for-zero-setup-duckdb-queries)

Query remote Parquet data with DuckDB and Python using uv for zero local setup. Learn how to leverage uv run for seamless dependency management and effortless data querying.

- Tags: tutorial
- Published: 2026-03-08

### [How to Filter Data by Timestamp Ranges for Trend Analysis in Bambu Lab Filament Stock Data](/nelsonjchen/bbl-tracker-public-db/filtering-data-by-timestamp-ranges-for-trend-analysis)

Filter Bambu Lab filament stock data by timestamp ranges for trend analysis using DuckDB's BETWEEN clause or the manifest.json index. Analyze historical data effectively.

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

### [Understanding Sampling Rate Changes in Bambu Lab Filament Tracker Data](/nelsonjchen/bbl-tracker-public-db/understanding-sampling-rate-changes-60min-vs-30min)

Explore sampling rate changes in Bambu Lab Filament Tracker data from 60min to 30min intervals. Understand the impact on temporal resolution and data structure.

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

### [Calculating Purchase Window Overlaps for Multiple Products](/nelsonjchen/bbl-tracker-public-db/calculating-purchase-window-overlaps-for-multiple-products)

Learn to calculate purchase window overlaps for multiple products using DuckDB on Parquet shards. Find simultaneous stock availability efficiently.

- Tags: tutorial
- Published: 2026-03-08

### [Detecting Flash Sales Using the is_flash_sale Boolean Field in Bambu Lab Tracker](/nelsonjchen/bbl-tracker-public-db/detecting-flash-sales-using-is-flash-sale-field)

Easily detect flash sales using the is_flash_sale boolean field in the BBL Tracker database. Filter and analyze limited-quantity purchase events separately from regular stock data.

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

### [How to Join product_name and variant_name for Unique Product Identification in BBL Tracker](/nelsonjchen/bbl-tracker-public-db/joining-product-name-and-variant-name-for-identification)

Learn how to join product_name and variant_name for unique product identification in BBL Tracker. Concatenate with SQL || operator for complete product details. See script.py for example.

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

### [Optimizing Query Performance by Selecting Specific Time Ranges in BBL Tracker](/nelsonjchen/bbl-tracker-public-db/optimizing-query-performance-by-selecting-time-ranges)

Speed up BBL Tracker DuckDB queries by selecting specific time ranges. Generate deterministic URLs for 6-hour Parquet shards to avoid downloading the full manifest and boost performance.

- Tags: performance
- Published: 2026-03-08

### [Understanding Data Ingestion Start Times and Regional Availability in BBL Tracker](/nelsonjchen/bbl-tracker-public-db/understanding-data-ingestion-start-times-and-regional-availability)

Learn about BBL Tracker data ingestion start times and regional availability. Discover when BBL Tracker data became available across the US, EU, UK, Australia, Canada, and global markets.

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

### [How to Use the skr=yes Parameter to Bypass Region Selection Redirects](/nelsonjchen/bbl-tracker-public-db/how-to-use-skr-yes-parameter-to-bypass-region-redirects)

Bypass region selection redirects on store pages using the ?skr=yes parameter. Access stock pages directly and avoid redirect loops with this simple trick.

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

### [How to Integrate the Bambu Lab Dataset with AI Assistants for Analysis](/nelsonjchen/bbl-tracker-public-db/integrating-bambu-lab-dataset-with-ai-assistants)

Integrate the Bambu Lab dataset with AI assistants for analysis. Download the public manifest, merge Parquet shards into DuckDB, and upload to LLMs for natural language insights.

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

### [Calculating Product Availability Percentage Over Time Using DuckDB](/nelsonjchen/bbl-tracker-public-db/calculating-product-availability-percentage-over-time-duckdb)

Calculate product availability percentage over time using DuckDB. Query R2, find in-stock ratios, and pinpoint bottlenecks to improve your supply chain.

- Tags: tutorial
- Published: 2026-03-08

### [How to Reconstruct a Local DuckDB Database from the Streaming Parquet Dataset](/nelsonjchen/bbl-tracker-public-db/reconstructing-local-duckdb-from-streaming-parquet-dataset)

Learn to reconstruct a local DuckDB database from streaming Parquet data. Efficiently query remote files directly into your .duckdb file for powerful local analytics.

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

### [How to Interpret Stock Visibility Caps and max_quantity Values in Bambu Lab Filament Data](/nelsonjchen/bbl-tracker-public-db/interpreting-stock-visibility-caps-and-max-quantity-values)

Understand Bambu Lab filament stock visibility caps and max_quantity values. Learn how to interpret inventory data accurately for the bbl-tracker-public-db repository. Get the real stock number.

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

### [Identifying Product Availability Bottlenecks Using SQL Aggregation: A DuckDB Approach](/nelsonjchen/bbl-tracker-public-db/identifying-product-availability-bottlenecks-with-sql-aggregation)

Identify product availability bottlenecks using SQL aggregation in DuckDB. Analyze hourly stock data to find SKUs with low stock ratios and improve order fulfillment.

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

### [How to Filter Bambu Lab Stock Data by Region (US, EU, UK, AU, CA) in SQL Queries](/nelsonjchen/bbl-tracker-public-db/filtering-stock-data-by-region-in-sql-queries)

Learn to filter Bambu Lab stock data by region US EU UK AU CA in SQL queries using WHERE clauses on the region column in DuckDB. Access public Parquet data easily.

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

### [How to Use `manifest.json` for Programmatic File Discovery and Filtering in BBL Tracker](/nelsonjchen/bbl-tracker-public-db/how-to-use-manifest-json-for-file-discovery-and-filtering)

Learn to use manifest.json for programmatic file discovery and filtering in BBL Tracker. Access Parquet files efficiently without listing entire storage buckets.

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

### [Understanding the Parquet File Naming Convention and 6-Hour Partition Structure in BBL Tracker](/nelsonjchen/bbl-tracker-public-db/understanding-parquet-file-naming-and-6-hour-partition-structure)

Learn the BBL Tracker Parquet file naming convention and 6-hour partition structure. Understand how data is organized by date and time for efficient querying.

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

### [How to Query the Bambu Lab Stock History Dataset Using DuckDB and Parquet Files](/nelsonjchen/bbl-tracker-public-db/how-to-efficiently-query-bambu-lab-stock-history-duckdb-parquet)

Query Bambu Lab stock history fast with DuckDB and Parquet. Access data directly from Cloudflare R2 via HTTP URLs no local downloads needed.

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