News for hackers. Stuff that matters.
Re:My Laptop Is Faster Than Your Cloud: Announcing MotherDuck by ttunguz on Tuesday November 15, 2022 @08:27PM (#33617690)
Author here: I agree with you on benchmarks. It's hard to compare different databases well.

MotherDuck is an analytics database optimized for reading with columnar compression. Postgres is more of a transactional/general purpose database. Tuning it well for analytics would surely improve performance.

Most people won't tune a db with custom indices though because it can be hard, so purpose built solutions like this offer value in those cases.

The article isn't purely about performance but also ease of use. MD is an in process database so starting with it is very easy.

Glad we agree on the power within a laptop! It's underappreciated.

Re:My Laptop Is Faster Than Your Cloud: Announcing MotherDuck by m_ke on Tuesday November 15, 2022 @08:29PM (#33617697)
*motherduck is not a database, it's a company commercializing a great open source project called duckdb.
Re:My Laptop Is Faster Than Your Cloud: Announcing MotherDuck by carterschonwald on Tuesday November 15, 2022 @08:34PM (#33617731)
this is an important detail I couldn't figure out from the linked materials!
Re:My Laptop Is Faster Than Your Cloud: Announcing MotherDuck by ttunguz on Tuesday November 15, 2022 @08:52PM (#33617848)
Good addition. I should have been more clear.
Re:My Laptop Is Faster Than Your Cloud: Announcing MotherDuck by danielmarkbruce on Tuesday November 15, 2022 @09:25PM (#33618059)
I don't understand how this is easier than using snowflake.

About the only situation where it seems useful is if I'm using a jupyter notebook and I want to use it to pull data in but it's too much to fit into memory, and sqlite is too slow... which seems like a pretty specific situation to be in? And it's not data that is part of some business process that needs updating frequently?

Or I'm just missing the point entirely? I see another post about huge parquet datasets - but how do I get them? Is everyone at my company comfortable with me moving them onto my machine even if I can?