Simon SkoczylasFinally! 😅 🙈
The book arrived.
I ordered that #Kubernetes book four years ago as part of #Manning Early Access Program (#MEAP).
https://www.manning.com/books/kubernetes-in-action-second-edition
Michael SimonsAlso 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.
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.
Jimmy Angelakos 
📘 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 💕
#PostgreSQL #Manning #MEAP #Development #Databases #OpenSource #TechBooks #BookLaunch
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.
Tiny Spheres ofAggregate 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
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;
Dave Mackey
Matthew Sparby
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.
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.