chdb

What it does

- In-process SQL OLAP Engine, powered by ClickHouse - Serverless. No need to install ClickHouse - Support Parquet, CSV, JSON, Arrow, ORC and 60+more formats - Support Python DB API 2.0 - Library bindings for Python, Go, Rust, NodeJS, Bun - Apache2 License

Experience the power of ClickHouse, in-process. With unparalleled performance, reliability, and scalability for any data-intensive application.

• 
  ScratchDB – Open-Source Snowflake on ClickHouse2023 · github.com · ▲261

  Hello! For the past year I’ve been working on a fully-managed data warehouse built on Clickhouse. I built this because I was frustrated with how much work was required to run an OLAP database in prod: re-writing my app to do batch inserts, managing clusters and needing to look up special CREATE TABLE syntax every time I made a change. I found pricing for other warehouses confusing (what is a “credit” exactly?) and worried about getting capacity-planning wrong. I was previously building accounting software for firms with millions of transactions. I desperately needed to move from Postgres to…

• 
  chDB 3.0 released, 12% faster than DuckDB2025 · github.com · ▲5

  chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse - Release v3.0.0 · chdb-io/chdb

• DU
  Duck-UI – Browser-Based SQL IDE for DuckDB2025 · demo.duckui.com · ▲213

  I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…

• 
  ClickHouse-local – a small tool for serverless data analytics2023 · clickhouse.com · ▲289

  Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…

• 
  SQL workbench in the browser2024 · sql-workbench.com · ▲117

  Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.

• 
  AGX – Open-Source Data Exploration for ClickHouse (The New Standard?)2025 · github.com · ▲48

  Hey HN, We are excited to announce that we’ve open-sourced AGX, a fast and lightweight data explorer for ClickHouse. It is designed for developers and analysts who want to leverage SQL-native querying in an IDE-like environment. Here’s what makes AGX stand out: - Built on ClickHouse (accessible via embedded chdb or remote instance). - IDE-like user interface: features tabs, a Monaco editor, and a fast keyboard workflow. - Zero setup required: no infrastructure or complex dashboards to manage. - Ideal for exploring live blockchain data, while also flexible enough for general ClickHouse usage…

• 
  WallHop – 12ft.io is gone, so I built a replacement▲287

  wallhop is a free paywall bypass. Paste any article link to read it without paywall popups, ads or clutter. No signup, no extension. A simple 12ft.io alternative.

  Growth · 17d ago · wallhop.io

• 
  Prefer▲201

  The execution layer for AEO

  Growth · 28d ago · tryprefer.com

• 
  Clustr▲1,526

  The reality check for your crypto portfolio

  Commerce · 2023 · clustr.io

• 
  Workout.lol – a web app to easily create a workout routine▲993

  Hey everyone, I here is a small open-source project I've been working on lately. I'd love to hear your thoughts and improvement ideas :) GitHub: [github.com/Vincenius/workout-lol](https://github.com/Vincenius/workout-lol)

  Dev tools · 2023 · workout.lol

• HN
  Hacker News user blogroll▲937

  I saw this [0] pretty cool thread by user revskill, and wanted a quicker way to search through it, but also to keep them all in one place so I can read them at my leisure whenever I get time. Right now is like 60 lines of Ruby using Nokogiri, but I will certainly look into it further down the line and improve the list. There's a cronjob checking the thread every 12 hours but I will eventually shut that down and it will become static after that. There are some really awesome blogs in there. I really recommend going through the list, it made my day. [0] "Could you share your personal blog…

  Life & fun · 2023 · dm.hn

• 
  Lazy▲928

  One ⌘ shortcut to capture anything straight to Notion

  AI · 2023 · lazy.so

• 
  Anytype - Public Beta▲907

  Anytype is built on the open-source AnySync protocol: a local-first protocol based on CRDTs. Users of Anytype can create spaces - graph-based databases with modular UI. Each space has unique access rights. Today, Anytype's beta is in single-player mode. Multiplayer mode, which will support local-first collaboration between multiple users, will be launched in the first half of 2024. Anytype fulfils the seven ideals of local first software from here - https://www.inkandswitch.com/local-first/ , our team felt these things are important to all of us: • No spinners: your work…

  Commerce · 2023 · anytype.io

• 
  n8n 1.0▲786

  Workflow automation for technical people

  Dev tools · 2023 · n8n.io