Alternatives
Products that do what Snowflake Emulator – Local Snowflake Development with Go and DuckDB does
Hi HN! I built a Snowflake emulator for local development and testing. Testing Snowflake code locally is frustrating – you need a real account (expensive) or mock everything (tedious). I wanted something that just works with the standard [gosnowflake](https://github.com/snowflakedb/gosnowflake) driver or REST API. snowflake-emulator fixes this by: - Using DuckDB as the storage engine - Auto-translating Snowflake SQL (IFF→IF, NVL→COALESCE, DATEADD, etc.) - Supporting gosnowflake driver protocol – no code changes needed - Providing REST API v2 – use from any language…
- 1
- 2MO
Hey hacker news! I built Melchi, an open-source tool that handles Snowflake to DuckDB replication with proper CDC support. I'd love your feedback on the approach and potential use cases. *Why I built it:* When I worked at Redshift I saw two common scenarios that were painfully difficult to solve: Teams needed to query and join data from other organizations' Snowflake instances with their own data stored in different warehouse types, or they wanted to experiment with different warehouse technologies but the overhead of building and maintaining data pipelines was too high. With DuckDB's…
2024 · github.com
- 3SS
Hi all! Just released Super Snowflake Maker! Draw on the pie with freeform or polygon tools, change the number of sections, click on the large snowflake to see fold, and.... download! Enjoy + Happy Holidays! (tech: threejs/r3f, react, ts, useSpring, tailwind, canvas, svg, offscreen canvas, paperjs)
2024 · supersnowflakemaker.com
- 4DU
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…
Oct 2025 · demo.duckui.com
- 5
- 6AN
No gc, No goroutines, Produces small binaries while using the unmodified official go toolchain, and comes with complete Web SDK (generated from w3c/webref). We are building `pcz` to provide a reimagination of Go the language, in an effort to make it suitable for all kinds of programming tasks, and currently you can use it to build efficient web applications in Go using the generated Web SDK (as shown with the live web demo[1]). The journey is just starting, any suggestions? or any critics? [1]: https://primecitizens.github.io/livedemos/10-plat-web/
2023 · github.com
- 7DA
Hi HN! I’m an engineer at Artie where we do real-time data replication. We were adding MotherDuck as a destination and the first version just used DuckDB’s Go driver directly. It worked great on my machine… until we wired it into our Transfer service (https://github.com/artie-labs/transfer). Because the driver requires CGO, our cross-compiles to amd64 and arm64 started failing, we lost our easy static binaries, and our Docker images had to pull in C toolchains and system libraries just to support one dependency. We tried isolating the CGO bits in a separate module, but it…
Dec 2025 · github.com
- 8OA
I’ve been a long-time Snowplow user and unofficial evangelizer. I have deep respect for its founders, Alex and Yali, who I met a few times. What made me fall in love with Snowplow was that it was unopinionated, gave access to raw event data, and was truly open source. Back in 2013, that changed everything for me. I couldn’t look at GA the same way again. Over the years, analytics moved into SQL warehouses driven by cheaper CPU/storage, dbt, reproducibility, and transparency. I saw the need for a democratized Snowplow pipeline and launched a hosted version in 2019. In January 2024,…
Oct 2025 · opensnowcat.io
- 9
- 10
Local sandboxes for AI agents on your Mac, Linux, bare metal
Aug 2026 · github.com
- 11CD
Hi everyone, I'm a PhD student in databases at CMU. Over the past few months, I've been interning at Columnar and building a community extension for DuckDB that lets you query Snowflake, Databricks, BigQuery, PostgreSQL, MySQL, and any other system with an ADBC (Arrow Database Connectivity) driver. The extension supports querying ADBC databases directly through a read_adbc table function. It also supports using ATTACH to connect to an ADBC database and then running SELECT, INSERT, COPY, and CTAS statements as if the database were local to DuckDB. You can install it from DuckDB by running:…
Jul 2026 · github.com
- 12RA
2024 · github.com
- 13SA
Sharing my project inspired by twitter snowflake UUID generator but that supports: 1) Longer range of id's to be generated. 2) No coordination with other machines in the distributed system.
2022 · github.com
- 14PR
Hi HN! We built PondPilot – a fully client-side data exploration tool powered by DuckDB. It’s open-source and built for speed, privacy, and simplicity. Try it: https://app.pondpilot.io GitHub: https://github.com/pondpilot/pondpilot You can: - Run fast SQL queries directly in your browser - Explore CSV, Parquet, JSON, or .duckdb files without uploading - Keep your data 100% local (it never leaves your device) - Install as a PWA and work offline - Use it read-only, with real-time updates when files change It’s designed as a lightweight alternative to notebooks or…
2025 · app.pondpilot.io
- 15S5
I'm a former YC founder, and I've been working with some friends from Google to build Espresso AI, an ML-powered Snowflake optimizer. We use LLMs to analyze and predict your SQL workload and run your warehouses more efficiently. Our first few customers are seeing Snowflake savings from 30% to 70%. We're launching out of beta, and if your team uses Snowflake we'd like to help you cut down your bill. You can set up Espresso in under 15 minutes with the instructions here: https://espresso.ai/onboarding Before turning anything on we'll send you a savings estimate based on your…
2024
- 16MS
Hi all, Aram and Eduard here - authors of Modelence (https://github.com/modelence/modelence), an all-in-one backend platform for teams that love TypeScript + MongoDB. Think Supabase, but for MongoDB: auth, cron jobs, email, monitoring, without glue code before you can ship. As Karpathy (and many of us) noted, getting from prototype to production is mostly painful integration work. The pieces exist, but stitching them together reliably is the hard part: https://x.com/karpathy/status/1905051558783418370. YC AI Startup School talk about this -…
2025 · github.com
- 17MG
Hello HN, I've been working on this project for a while, and it has been in an "open" beta for some time. I finally believe it's ready for its first release. I hope you like it. Here are some potential questions that may arise: 1. How does it compare to LM Studio? It's likely that if you're already using LM Studio, you'll continue to do so. This project is designed to be more user-friendly. 2. Is it open-source? No, it is not. 3. Does it use any open-source libraries? Yes, it uses llama.cpp and a few others, as indicated in the license information included with the application. 4. Why is not…
2023 · avapls.com
- 18DR
We’ve built SQLRooms, an open-source framework for creating single-node data analytics apps powered by DuckDB. It lets you build fully client-side, data-centric apps using React and DuckDB running in the browser (via WebAssembly) or in Electron. No server or backend is required — apps can work offline, preserve data privacy, and run queries on large datasets with sub-second performance. Features: - Query large datasets in browser with DuckDB (WASM) - Modular design for building composable data UIs (query editors, dashboards, notebooks, etc.) - Data privacy-preserving AI assistant that can…
2025 · sqlrooms.org
- 19RI
Hey all! We've been working on RestApp V1 and this is our first time posting it on HN. It's an No/Low Code data modeling tool that enables you to build & maintain data pipelines with a visual programming interface. We don't store your data but we compute them through Apache Spark for query speed & efficiency. Here's some features: `Connectors: Connect to any source and destinations (DB, DWH and SaaS Applications). We currently support MongoDB, Snowflake, BigQuery, MySQL, MSSQL, SFTP (JSON, txt, csv, excel files supported), Hubspot, Stripe, GDrive (JSON, txt, csv, excel files supported).…
2022 · os.restapp.co
- 20DA
Duck (https://duck-lang.dev) is a statically typed, compiled programming language that combines the best of Rust, TypeScript and Go, aiming to provide an alternative for full-stack-development while being as familiar as possible Improvements over Rust: - garbage collection simplifies developing network applications - no lifetimes - built-in concurrency runtime and apis for web development Improvements over bun/node/typescript: - massive performance gains due to Go's support for parallel execution and native code generation - easier deployment since Duck compiles to a…
Jan 2026 · duck-lang.dev
- 21MS
Hello HN! We're excited to announce MyDuck Server, an open-source project that seamlessly integrates the analytical power of DuckDB with your existing MySQL & Postgres databases. *Backstory* Currently, there are no fully satisfactory open-source OLAP solutions for MySQL & Postgres. In the MySQL ecosystem, HeatWave offers close integration, but it's a proprietary, commercial product from Oracle. The Postgres community has seen promising DuckDB-based extensions emerge, including the official pg_duckdb. However, extensions can introduce isolation concerns in mission-critical environments.…
2024 · github.com
- 22DS
Hey HN, I am Alex. I am open sourcing Data Studio, a lightweight data exploration IDE in your browser that runs locally. Try it: https://local.dataspren.com (no account needed, runs locally) More information: https://github.com/dataspren-analytics/data-studio I love working with data (Postgres, SQL, DuckDB, DBT, Iceberg, ...). I always wanted a data exploration tool that runs in my browser and just works. Without any infra or privacy concerns (DuckDB UI came quite close). Features: - Data Notebooks - SQL cells work like DBT models (they materialize to views) -…
Feb 2026 · github.com
- 23PM
Hello HN, one of the founders of Mooncake Labs here. Today, we are launching pg_mooncake, an extension that brings columnstore tables with DuckDB execution to Postgres. Expect analytical performance akin to DuckDB on Parquet (clickbench results to come soon). You can run transactional updates, deletes, inserts on these tables, and they're written as Delta Lake tables (and soon Iceberg) to your object store (S3, etc.). pg_mooncake is live on Neon today. Let us know what you think. It'll be coming to Supabase shortly, and other Postgres providers in the future. Why another postgres analytics…
2024 · github.com
- 24GM
I built GoSMig for my own projects and open-sourced it in case it helps others. It’s a tiny generic library (no external deps except golang.org/x/term) for writing SQL migrations in Go with compile-time checks. It supports transactional and non-transactional migrations, rollback, status, version, and a small CLI handler so you can ship your own migration binary. Why another migrator? - Minimal API, no DSL or file layout to learn - Type-safe via Go generics - Works with database/sql and sqlx out of the box - Should work with any db library (or wrapper) that implements some…
Oct 2025 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →