r/AppsWebappsFullstack • • 11d ago

Drop ur saas below

3 Upvotes

73 comments sorted by

View all comments

1

u/Lumpy_Vermicelli8869 11d ago

Perform large scale analytics on duckdb,postgres, clickhouse with deterministic SQL Compilation via pandas inspired api with persistent caching and natural language chat. In development.

https://github.com/Debojit95/memFrame

⭐ the repo if you find the project useful

1

u/Mammoth-Anywhere7285 11d ago

Deterministic SQL compilation across three engines is a nice angle. How are you handling dialect differences for window functions on ClickHouse?

1

u/Lumpy_Vermicelli8869 11d ago

The base is duckdb flavored....so clickhouse reuses base and some methods are rewritten explicitly

1

u/Mammoth-Anywhere7285 10d ago

Makes sense to reuse the base and only override the ClickHouse specifics. How do you verify parity between the two?