New Postgres Tools for Analytics
About the event
On 7 October we will be gathering again for some Postgres and a pint. This time we'll have the following talks:
• [Elizabeth Christensen](https://www.linkedin.com/in/elizabeth-garrett-christensen/) from [Snowflake](Snowflake) New Postgres Tools for Analytics; • [Alex Kasko](https://github.com/staticlibs) from [DuckLabs](https://ducklabs.com/) (AWS) Analytics over Postgres data with DuckDB; • and have time for another short 15min talk (message us to book)!
Block your calendars and come!
We are a very informal bunch, so hoping to see you and your colleagues there! We do need to know the numbers, so please register if you are planning on coming.
This event is generously sponsored by [Snowflake](https://www.snowflake.com/en/), a global data and AI company offering a range of data products, including data analytics, machine learning, and fully managed PostgreSQL databases.
WHERE Doggett's Coat and Badge 1 Blackfriars Bridge, SE1 9UD on Wednesday, 7th October from 18:30.
PROGRAMME 18:30 Welcome 19:00-19:45 New Postgres Tools for Analytics (Elizabeth Christensen, Snowflake) - Abstract below. 19:45 Food and bar snacks Lightning talks 20:00-20:15 Analytics over Postgres data with DuckDB (Alex Kasko, [DuckLabs](https://ducklabs.com/) (AWS)) - Abstract below. 20:15-20:30 TBD (want to see your name here - reach out to us) 20:30 It's a pub, so we'll stay and hang out a bit longer — but feel free to leave whenever you prefer!
ABSTRACTS *Main talk* New Postgres Tools for Analytics (Elizabeth Christensen, Snowflake) Let’s talk about some Postgres tools for doing large scale analytics on really big data sets right from your psql driver’s seat. We’ll hit this from two sides, first, doing analytics on huge tables in Postgres with approximation tools like table sample and Apache DataSketches and then, bringing in the pg_lake / DuckDB extension to do analytics on object storage.
*Lightning talk* Analytics over Postgres data with DuckDB (Alex Kasko, DuckLabs (AWS)) DuckDB is an in-process analytical database, sometimes called "SQLite for analytics". DuckDB uses plug-in extensions to read data from various sources. In this short talk Alex will describe the implementation details of the ["postgres" DuckDB extension](https://duckdb.org/docs/current/core_extensions/postgres), that allows to run highly-parallel analytical queries on data stored in PostgreSQL.
About Alex Kasko Alex Kasko is a software engineer at [DuckLabs (AWS)](https://ducklabs.com/) working on integrating PostgreSQL with DuckDB. He lives in Cork, Ireland.
*** THE OFFICIAL BITS The meet-up abides by [PostgreSQL Code of Conduct](https://www.postgresql.org/about/policies/coc/). Postgres, PostgreSQL and the Slonik Logo are trademarks or [registered trademarks of the PostgreSQL Community Association of Canada](https://www.postgresql.org/about/policies/trademarks/), and used with their permission.
