Michael SimonsAnd that just came in… A Japanese copy of #DuckDBInAction and I totally love it. Writing of mine translated for people at the other end of the world. Soooo cool.
Finally, #DuckDBInAction landed on #Amazon, too:
https://www.amazon.de/Duckdb-Action-Mark-Needham/dp/1633437256
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
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;
So happy that for 2 of my books the creators of the things I wrote about did contribute a forward. That means a lot to me.
Thanks Jürgen Höller (#SpringBootBuch) and now @hannes and Mark Raasveldt for #DuckDBInAction 💚
The latter is already in the MEAP, make sure to check it out.
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.