Cpp Duckdb Service

Use Case

C++ DuckDB Client/Service. Use this client to perform Select operations on DuckDB

Libraries Used

Dataflow Diagram (Reuse MongoDB Service Diagram)

Session 1:

  • Connects to DuckDB
  • Read Parquet file
  • Perform Select Operation
  • DuckDB - Service - Controller

Code explanation video

C++ DuckDB Service

Source Code

Session 2:

  • Display output in JSON format
  • Load Parquet file from Pre Signed URL
  • DuckDB httpfs, json extensions - how to build and use them
  • Clean up code

Code explanation video

C++ DuckDB Service 2

Source Code

Session 3:

  • Integrate DuckDB Controller and Service with Router
  • Centralized Model Validation in Model Class
  • Run some test REST calls

Code explanation video

C++ DuckDB Service 2

Source Code

Session 4:

  • End-to-end demonstration:
    • The Angular UI initiates a REST API GET request.
    • The Boost Beast C++ REST API server receives and processes the request.
    • The server queries DuckDB (Parquet file) and returns the requested data.
    • The Angular UI displays the returned data.
  • Review of the final code changes.

UI Screenshot

Code explanation video

C++ DuckDB Service 2

Source Code

comments powered by Disqus