The progress on the MotherDuck UI is amazing! It went from minimal utility to my preferred place to write SQL in a matter of months 

The amount of data I am storing in 
@motherduck rn for a new project is criminal 🤣
Decided to try it out since I am a big 
@duckdb user. Is pretty good so far. Have few hundred million records.

I'm just checking a little about the hosted DuckDB by @motherduck. What a nice user experience. It automatically detects errors, and `accept & run` fixes common errors. Love it.

using sql for data cleaning vs excel (reason 879 to learn sql)

levenstein distance between 590strings in excel (350k combinations): 
excel: 25 mins of spinning. 
duckdb: 1.2s

If you're not familiar with DuckDB, you definitely want to give it a look. I've recently converted all my existing code from using CSV files and SQLite databases for exploratory analysis to parquet files, DuckDB and MotherDuck. The transformation in my workflow has been nothing short of astounding. 10GB of CSV files turned into 1GB of parquet files that are now stored in S3 buckets. Using DuckDB and MotherDuck, I can run exploratory queries seamlessly thanks to the DuckStack with dual execution with local processing and cloud scale. My query development time has decreased by 90%. And I'm loving the team feature of the MotherDuck platform. OCEANCODA is rocking the small data life! #duckdb #python #motherduck #eda #ai #ml (Graphic courtesy of Manning Publications Co. book 'DuckDB in Action.' ) Check it out.

DuckDB is increasingly being built into every data tool, but DuckDB isn't designed to be used as a cloud data warehouse

@motherduck is solving that problem, and they’re doing it in a delightful, uniquely DuckDB way

DuckDB is my new best friend for analytics. It's so fast, makes it easy to manipulate dataframes, ingests anything, and exports it to whatever form I want. 

Parquet, Arrow dataframes, and DuckDB are the future for analytics.

#duckdb is really impressive: good terminal client, solid, easy and fast import of csv data and impressive speed on a 20mio data set. With automatic schema creation. Easy export to parquet and more. I think I am gonna spend more time on it...

I have been kicking the tyres of @motherduck - and it is 🤯

Being able to do hybrid queries over local and humongous remote datasets are incredible.

The potential applications are making my head spin with awe and excitement. Well done.

Another awesome & insightful post from the @motherduck team. The last few decades have been about scale-out. The next decade will be about scale-up! What you can accomplish with a single machine these days is incredibly impressive

I just deployed to Rill cloud backed by Motherduck and it worked great— wonderful experience...
    In-browser CLI auth with Rill Cloud, added my Motherduck token, invited some viewers, I'm live. Took 3 minutes.

The statistics from the 2023 StackOverflow survey have been released, and @duckdb has been recognized in several categories, including a noteworthy position among the top 30 most popular databases 🎉

Because, I don't have enough time on my hands, I created a DuckDB extension that allows you to import data by scanning an Athena table. 

https://github.com/dacort/duckdb-athena-extension

How fast is DuckDB compared to the best commercial data warehouses? I decided to benchmark it myself. Short version: very fast! But it's not (yet) great at scaling up to many cores. https://fivetran.com/blog/how-fast-is-duckdb-really

@duckdb is empowering machine learning use cases! 🤖
Any good model training starts with some good data exploration.
  
@huggingface now enables SQL queries using DuckDB on any dataset stored on the Hub!

DuckDB Co-Creator @hfmuehleisen and MotherDuck Founder @jrdntgn in this new podcast - among other things about the origin story of DuckDB and later MotherDuck:

just built a pipeline using @dltHub and @motherduck and it's very nice. 10/10 experience once you get the hang of it and very scalable.

I don’t want to say that #DuckDB is a silver bullet because there is no such thing, but it’s surprisingly projectile-shaped, very shiny, and killed all the various werewolves (ok, data problems) I’ve thrown at it

DuckDB is increasingly being built into every data tool, but DuckDB isn't designed to be used as a cloud data warehouse

@motherduck
 is solving that problem, and they’re doing it in a delightful, uniquely DuckDB way...

We Classified 100k Rows in 40 Seconds: Introducing prompt_jev()

The easiest way to explore local data files using DuckDB

duckdb-ui

DuckDB-powered Postgres for high performance apps and analytics.

pg_duckdb

A DuckDB-specific API built on C for using DuckDB in Node.js

duckdb-node-neo

dbt-duckdb

MotherDuck page for open source community

Building for the community

Community Contributions

duckdb/duckdb-ui

duckdb/pg_duckdb

duckdb/duckdb-node-neo

duckdb/dbt-duckdb

Word on the Street