Michael SimonsMar 26, 2024

Also new today: The last chapters added to the #MEAP for #DuckDB in Action, including the appendix in which I wrote a bit about using DuckDB from #Java. I used the #1BRC by @gunnarmorling as an example.

https://www.manning.com/books/duckdb-in-action

Now the whole things just need to make its way through the print production.

#Happy

DuckDB in Action

Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.</b> DuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In DuckDB in Action</i> you’ll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you’ll learn everything you need to get the most out of DuckDB—all through hands-on examples. Open up DuckDB in Action</i> and learn how to: Read and process data from CSV, JSON and Parquet sources both locally and remote</li> Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables</li> Use DuckDB from Python, both with SQL and its "Relational"-API, interacting with databases but also data frames</li> Prepare, ingest and query large datasets</li> Build cloud data pipelines</li> Extend DuckDB with custom functionality</li> </ul> Pragmatic and comprehensive, DuckDB in Action</i> introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won’t need to read through pages of documentation—you’ll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines.

Manning Publications
Jimmy Angelakos Feb 13, 2024

📘 Big news! My book-in-progress "PostgreSQL Mistakes and How to Avoid Them" is now available in @ManningPublications Early Access Program (MEAP) — I hope it will help application developers, software architects & database administrators not only avoid mistakes but also learn the right way to do things in #Postgres.

Use code "au35ang" to get 35% off 💕

🌐 http://mng.bz/D9mR

#PostgreSQL #Manning #MEAP #Development #Databases #OpenSource #TechBooks #BookLaunch

PostgreSQL Mistakes and How to Avoid Them - Jimmy Angelakos

Recognize and avoid these common PostgreSQL mistakes!

Manning Publications
Michael SimonsFeb 4, 2024

Oh wow, that just made my day… A comment on #DuckDB in Action, which you find on Manning #MEAP https://www.manning.com/books/duckdb-in-action

"This book opened my eyes to a lot of capabilities I never expected a DB to have."

Whoever took the time to write this: Thank you!

The same goes out to all our reviewers and test readers: Your feedback is appreciated a lot.

DuckDB in Action

Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.</b> DuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In DuckDB in Action</i> you’ll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you’ll learn everything you need to get the most out of DuckDB—all through hands-on examples. Open up DuckDB in Action</i> and learn how to: Read and process data from CSV, JSON and Parquet sources both locally and remote</li> Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables</li> Use DuckDB from Python, both with SQL and its "Relational"-API, interacting with databases but also data frames</li> Prepare, ingest and query large datasets</li> Build cloud data pipelines</li> Extend DuckDB with custom functionality</li> </ul> Pragmatic and comprehensive, DuckDB in Action</i> introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won’t need to read through pages of documentation—you’ll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines.

Manning Publications
Tiny Spheres ofJan 3, 2024
#meap #graffiti along Burgemeester Daleslaan in #Nijmegen.

#StreetArt
Michael SimonsDec 22, 2023

Aggregate values into an ordered list with #DuckDB: You don't have to look for odd methods, but just can continue using the ORDER clause…

https://duckdbsnippets.com/snippets/126/aggregate-rows-into-a-sorted-list

More stuff like this in #DuckDBInAction available as #MEAP from #Manning

http://mng.bz/9Q1l

And as I have been asked: The book is nearly finished, will be in print next year.

Manning has a Christmas deal on 24th with everything 50% off.

Aggregate rows into a sorted list. | DuckDB Snippets

-- list and array_agg take in their own ORDER BY clause, so that you -- can sort the aggregate. The statements order by cannot be used -- as the columns that are used for sorting then need to be a grouping -- key and cannot be used in the aggregate SELECT name, -- Order the aggregated list by another column from line_items list(item_name ORDER BY pos ASC) items FROM orders JOIN line_items ON order_id = id GROUP BY ALL -- Order by grouping keys is ofc possible ORDER BY name;

DuckDB Snippets
Dave MackeyDec 14, 2023

@ManningPublications - Is there a way to see the differences between a #MEAP and the final release? Or for that matter between MEAP and MEAP?

#Manning #Books #Question

Matthew SparbyDec 1, 2023
#Meap vs #Meep
Michael SimonsNov 6, 2023

The #MEAP for #DuckDBInAction has just been updated… https://shortener.manning.com/9Q1l

Now with even more cool queries and proper analytics.

DuckDB in Action

Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.</b> DuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In DuckDB in Action</i> you’ll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you’ll learn everything you need to get the most out of DuckDB—all through hands-on examples. Open up DuckDB in Action</i> and learn how to: Read and process data from CSV, JSON and Parquet sources both locally and remote</li> Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables</li> Use DuckDB from Python, both with SQL and its "Relational"-API, interacting with databases but also data frames</li> Prepare, ingest and query large datasets</li> Build cloud data pipelines</li> Extend DuckDB with custom functionality</li> </ul> Pragmatic and comprehensive, DuckDB in Action</i> introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won’t need to read through pages of documentation—you’ll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines.

Manning Publications
Michael SimonsOct 13, 2023

Pretty stoked seeing the @ManningPublications #MEAP for #DuckDB in Action.

Have a look here if you like: http://mng.bz/9Q1l

@markhneedham, @mesirii and me created a fast paced book about DuckDB, how you can use it in your data pipelines, a hands-on-primer to modern #sql and more.

DuckDB in Action

Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.</b> DuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In DuckDB in Action</i> you’ll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you’ll learn everything you need to get the most out of DuckDB—all through hands-on examples. Open up DuckDB in Action</i> and learn how to: Read and process data from CSV, JSON and Parquet sources both locally and remote</li> Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables</li> Use DuckDB from Python, both with SQL and its "Relational"-API, interacting with databases but also data frames</li> Prepare, ingest and query large datasets</li> Build cloud data pipelines</li> Extend DuckDB with custom functionality</li> </ul> Pragmatic and comprehensive, DuckDB in Action</i> introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won’t need to read through pages of documentation—you’ll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines.

Manning Publications
Lost ReflectorJul 23, 2023
words slip away
night turns to day
lost what to say
til I'm sleeping
#MEAP