Video wird geladen...

Video konnte nicht geladen werden

Beim Laden dieses Videos ist ein Problem aufgetreten. Dies könnte an einem vorübergehenden Netzwerkproblem liegen oder das Video ist möglicherweise nicht verfügbar.

DuckDB just released Quack: a client/server protocol over HTTP. Any DuckDB can serve (quack_serve()), any DuckDB can attach to it. DuckDB-Wasm included since it's plain HTTP on port 9494. Some fun stuff : - A browser tab talking directly to a DuckDB server somewhere on the internet - Local-first... show more

Mehdi Ouazza

2,638 subscribers

66,033 Aufrufe • vor 6 Monaten •via X (Twitter)

Nachrichten & Politik Wissenschaft & Technologie

Anya Rossi• Live Now

Private livecam show

10 Kommentare

Profilbild von Ashish “Logmaster”

Ashish “Logmaster”vor 6 Monaten

All duckdb go quack quack now. Very cool extension. Thanks you!

Profilbild von Harlaksh Singh

Harlaksh Singhvor 6 Monaten

What's the use here Mehdi?

Profilbild von Alex Mabe

Alex Mabevor 6 Monaten

Great feature, HTTP server extension were kinda doing it before, but this is much nicer! Added it to my DuckDB-WASM SQL IDE ^_^

Profilbild von Sri Madireddy

Sri Madireddyvor 6 Monaten

Thanks . Will check it out

Profilbild von shashank

shashankvor 6 Monaten

Thanks for the idea. Sending it to gptmaxx 5.9 pro.

Profilbild von Bastien Gares

Bastien Garesvor 6 Monaten

Thanks !

Profilbild von Baraka

Barakavor 6 Monaten

Why is everyone trying so hard to give db access to clients? How many times have we heard this to be a bad idea?

Profilbild von dalu

daluvor 6 Monaten

auth? safeguards?

Profilbild von David Liang

David Liangvor 6 Monaten

quack_serve() is such a good name. curious how the perf holds up vs arrow flight for larger workloads

Profilbild von Adel Bucetta

Adel Bucettavor 6 Monaten

this is massive. the real unlock isn't just querying db, it's treating data as an API that can be queried by anything, anywhere

Ähnliche Videos

We're excited to announce duckdb-skills, a DuckDB plugin for Claude Code! We think the embedded nature of DuckDB makes it a perfect companion for Claude in your local workflows. The skills supported include: + read-file and query – uses DuckDB's CLI to query data locally, unlocking easy access to any file that DuckDB can read. + read-memories – a clever idea to store your Claude memories in DuckDB and query them at blazing speed. These are powered by two additional skills: + attach-db – gives Claude a mechanism to manage DuckDB state through a .sql file linked to your project. + duckdb-docs – uses a remote DuckDB full-text search database to query the DuckDB docs and answer all of your (and Claude's own) questions.

We're excited to announce duckdb-skills, a DuckDB plugin for Claude Code! We think the embedded nature of DuckDB makes it a perfect companion for Claude in your local workflows. The skills supported include: + read-file and query – uses DuckDB's CLI to query data locally, unlocking easy access to any file that DuckDB can read. + read-memories – a clever idea to store your Claude memories in DuckDB and query them at blazing speed. These are powered by two additional skills: + attach-db – gives Claude a mechanism to manage DuckDB state through a .sql file linked to your project. + duckdb-docs – uses a remote DuckDB full-text search database to query the DuckDB docs and answer all of your (and Claude's own) questions.

DuckDB

60,855 Aufrufe • vor 7 Monaten

This Tuesday, we announced Quack, our new protocol that turns DuckDB into a client-server database. Watch Hannes' talk, recorded at the AI Council, where he explained how Quack works in practice, what stack it's built on, how it performs, and what our long-term ambitions are.

This Tuesday, we announced Quack, our new protocol that turns DuckDB into a client-server database. Watch Hannes' talk, recorded at the AI Council, where he explained how Quack works in practice, what stack it's built on, how it performs, and what our long-term ambitions are.

DuckDB

11,152 Aufrufe • vor 6 Monaten

The 1.4 release of DuckDB supports using a DuckDB database to serve vector tiles! Of course, I had to try this out in R. Check it out: all 242,000 US Census block groups dynamically served as vector tiles from a DuckDB database, displayed on a MapLibre map from R in Positron.

The 1.4 release of DuckDB supports using a DuckDB database to serve vector tiles! Of course, I had to try this out in R. Check it out: all 242,000 US Census block groups dynamically served as vector tiles from a DuckDB database, displayed on a MapLibre map from R in Positron.

Kyle Walker

45,630 Aufrufe • vor 1 Jahr

Web Analytics in the browser with DuckDB WASM: Filtering in milliseconds, instead of waiting for API responses

Web Analytics in the browser with DuckDB WASM: Filtering in milliseconds, instead of waiting for API responses

Tobias Müller

56,910 Aufrufe • vor 2 Jahren

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Denis Magda

28,597 Aufrufe • vor 9 Monaten

Friends, I just witnessed a miracle :) Parquet with 600 M rows in #onelake , #duckdb server in my laptop, #PowerBI in Direct Query mode using this experminetal driver

Friends, I just witnessed a miracle :) Parquet with 600 M rows in #onelake , #duckdb server in my laptop, #PowerBI in Direct Query mode using this experminetal driver

Mim

13,661 Aufrufe • vor 6 Monaten

🚀 Visualize Big Vector Data in Python—FAST! Tired of slow and clunky tools for visualizing big vector dataset in Python? Discover this one-line Python trick using Leafmap + DuckDB to instantly render huge vector datasets—even gigabytes in size—right in your Jupyter notebook. In this video, you'll learn how to: ✅ Visualize millions of vector features with ease ✅ Use Leafmap + DuckDB to serve vector tiles dynamically ✅ Handle GeoParquet, GeoPackage, cloud-hosted data & more ✅ Create fully interactive maps—without crashing your browser! 📌 Watch the full video tutorial on YouTube: 👉 Notebook example: #Visualization #Leafmap #BigData #DuckDB #GeoPython #GIS #OpenSource

🚀 Visualize Big Vector Data in Python—FAST! Tired of slow and clunky tools for visualizing big vector dataset in Python? Discover this one-line Python trick using Leafmap + DuckDB to instantly render huge vector datasets—even gigabytes in size—right in your Jupyter notebook. In this video, you'll learn how to: ✅ Visualize millions of vector features with ease ✅ Use Leafmap + DuckDB to serve vector tiles dynamically ✅ Handle GeoParquet, GeoPackage, cloud-hosted data & more ✅ Create fully interactive maps—without crashing your browser! 📌 Watch the full video tutorial on YouTube: 👉 Notebook example: #Visualization #Leafmap #BigData #DuckDB #GeoPython #GIS #OpenSource

Qiusheng Wu

13,147 Aufrufe • vor 1 Jahr

I was talking to a friend about serving customer-facing dashboards with just Cloudflare R2 & Hyparquet for range queries ~ no db required. Turns out it's fast! first time I haven't reached for DuckDB for this use in while, though naturally I did use it to build the datacube

I was talking to a friend about serving customer-facing dashboards with just Cloudflare R2 & Hyparquet for range queries ~ no db required. Turns out it's fast! first time I haven't reached for DuckDB for this use in while, though naturally I did use it to build the datacube

Hamilton Ulmer

47,004 Aufrufe • vor 2 Monaten

GeoLibre v0.9.0 is out. GeoLibre is a lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data across desktop and web environments, with a responsive layout for mobile screens. This release turns GeoLibre into a far more complete analysis environment. Highlights: - New cloud data panels for Microsoft Planetary Computer and Google Earth Engine, plus an Overture Maps plugin and federal Web Services plugins, including NASA Earthdata, USGS National Map, EPA EnviroAtlas, FEMA NFHL - Accessing 1000+ NASA Earthdata layers with a few simple clicks - Time Slider plugin for animating time series raster and vector data - SQL Workspace: run DuckDB Spatial SQL directly against loaded layers, local files, and remote URLs, with query history and one-click "add results to map" - Conversion tools: Vector to GeoParquet, CSV to GeoParquet, and Raster to COG, running in the browser with DuckDB-WASM - Controls menu with Measure, Bookmark, Minimap, View State, and Print Everything is open source. Try it in your browser, install the desktop app, or self-host it. Live demo: GitHub: Feedback and contributions are welcome. #GIS #Geospatial #OpenSource #MapLibre #DuckDB #WebGIS #GeoLibre

GeoLibre v0.9.0 is out. GeoLibre is a lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data across desktop and web environments, with a responsive layout for mobile screens. This release turns GeoLibre into a far more complete analysis environment. Highlights: - New cloud data panels for Microsoft Planetary Computer and Google Earth Engine, plus an Overture Maps plugin and federal Web Services plugins, including NASA Earthdata, USGS National Map, EPA EnviroAtlas, FEMA NFHL - Accessing 1000+ NASA Earthdata layers with a few simple clicks - Time Slider plugin for animating time series raster and vector data - SQL Workspace: run DuckDB Spatial SQL directly against loaded layers, local files, and remote URLs, with query history and one-click "add results to map" - Conversion tools: Vector to GeoParquet, CSV to GeoParquet, and Raster to COG, running in the browser with DuckDB-WASM - Controls menu with Measure, Bookmark, Minimap, View State, and Print Everything is open source. Try it in your browser, install the desktop app, or self-host it. Live demo: GitHub: Feedback and contributions are welcome. #GIS #Geospatial #OpenSource #MapLibre #DuckDB #WebGIS #GeoLibre

Qiusheng Wu

42,457 Aufrufe • vor 5 Monaten

Built a spatial SQL explorer for my GIS students this week. Drop a GeoJSON, practice writing queries, see instant results on a map + linked table. All in-browser, nothing to install. Powered by DuckDB WASM + MapLibre. Try it out:

Built a spatial SQL explorer for my GIS students this week. Drop a GeoJSON, practice writing queries, see instant results on a map + linked table. All in-browser, nothing to install. Powered by DuckDB WASM + MapLibre. Try it out:

Kyle Walker

21,088 Aufrufe • vor 9 Monaten

DuckDB 2.0 alpha reads Parquet and CSV from S3 2x to 3x faster, with zero query changes. 1.5: each worker downloads, waits, decodes, repeats. 2.0: a download pool fetches ahead, workers only decode. Same laptop, same query: 18.8 s to 7.7 s. On by default. Full numbers, plus recursive CTEs and VARIANT:

DuckDB 2.0 alpha reads Parquet and CSV from S3 2x to 3x faster, with zero query changes. 1.5: each worker downloads, waits, decodes, repeats. 2.0: a download pool fetches ahead, workers only decode. Same laptop, same query: 18.8 s to 7.7 s. On by default. Full numbers, plus recursive CTEs and VARIANT:

MotherDuck

18,222 Aufrufe • vor 2 Monaten

DuckDB-gsheets is live! read & write google sheets in pure SQL no one can stop you FWAHAHAHAHA

DuckDB-gsheets is live! read & write google sheets in pure SQL no one can stop you FWAHAHAHAHA

archie 🦋

12,559 Aufrufe • vor 2 Jahren

14.3 million parcels visualized across Texas. Draw a shape, query DuckDB, tabulate surface ownership instantly. Modern geospatial tooling brings powerful land analytics to your laptop.

14.3 million parcels visualized across Texas. Draw a shape, query DuckDB, tabulate surface ownership instantly. Modern geospatial tooling brings powerful land analytics to your laptop.

Kyle Walker

35,714 Aufrufe • vor 6 Monaten

sqlit is a lazygit style SQL TUI for the terminal. It supports 10+ databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more. Peter Adams (Maxteabag on GitHub) made sqlit using textualize.io and is Terminal Tool of the Week! ⭐️

sqlit is a lazygit style SQL TUI for the terminal. It supports 10+ databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more. Peter Adams (Maxteabag on GitHub) made sqlit using textualize.io and is Terminal Tool of the Week! ⭐️

Terminal Trove

138,230 Aufrufe • vor 10 Monaten

What is HTTP Downgrading, why use it, and how does it work? HTTP/2 is default for most web apps these days, however, it's not uncommon for backend servers to still use HTTP/1.1 causing parsing mismatches between frontend and backend. And that's where HTTP downgrading comes in! But what is it? HTTP downgrading is the process of forcing a request to be processed under HTTP/1.1 instead of HTTP/2. This allows you to manipulate how the frontend and backend servers interpret requests and exploit vulnerabilities unique to HTTP/1.1 parsing such as Content-Length Transfer-Encoding (CL.TE) attacks. How to downgrade HTTP/2 to HTTP/1.1 using Burp Suite 1️⃣ Open Burp Suite and Navigate to Proxy → HTTP History 2️⃣ Locate the request that is currently using HTTP/2. 3️⃣ Send the Request to Repeater 4️⃣ In the Repeater tab, open the "Inspector" panel → Request Attributes → Protocol 5️⃣ Change HTTP Version to HTTP/1.1 6️⃣ Click "Send" in Repeater. If successful, you should receive a valid response, confirming the server accepts HTTP/1.1. And that's it! You've just downgraded the HTTP protocol and confirmed that the frontend server accepts HTTP/1.1! 🥳 You are now ready to smuggle requests! If you want to learn how to exploit this, we've got a Web Academy Lab you need to check out: Thanks for reading! #requestsmuggling #cybersecurity #BurpSuite #hacking #infosec

What is HTTP Downgrading, why use it, and how does it work? HTTP/2 is default for most web apps these days, however, it's not uncommon for backend servers to still use HTTP/1.1 causing parsing mismatches between frontend and backend. And that's where HTTP downgrading comes in! But what is it? HTTP downgrading is the process of forcing a request to be processed under HTTP/1.1 instead of HTTP/2. This allows you to manipulate how the frontend and backend servers interpret requests and exploit vulnerabilities unique to HTTP/1.1 parsing such as Content-Length Transfer-Encoding (CL.TE) attacks. How to downgrade HTTP/2 to HTTP/1.1 using Burp Suite 1️⃣ Open Burp Suite and Navigate to Proxy → HTTP History 2️⃣ Locate the request that is currently using HTTP/2. 3️⃣ Send the Request to Repeater 4️⃣ In the Repeater tab, open the "Inspector" panel → Request Attributes → Protocol 5️⃣ Change HTTP Version to HTTP/1.1 6️⃣ Click "Send" in Repeater. If successful, you should receive a valid response, confirming the server accepts HTTP/1.1. And that's it! You've just downgraded the HTTP protocol and confirmed that the frontend server accepts HTTP/1.1! 🥳 You are now ready to smuggle requests! If you want to learn how to exploit this, we've got a Web Academy Lab you need to check out: Thanks for reading! #requestsmuggling #cybersecurity #BurpSuite #hacking #infosec

Web Security Academy

62,874 Aufrufe • vor 1 Jahr

🚀 GeoLibre just passed 5,000 stars on GitHub, in only two months! GeoLibre went public on May 27, and the community has already pushed it past 5,100 stars and 500+ forks. Thank you to everyone who starred, forked, filed issues, opened pull requests, and shared the project. For those just discovering it: GeoLibre is a free and open-source, lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data. It runs everywhere you do, in the web browser, on the desktop, on mobile, and inside Jupyter notebooks, all while keeping your data local and private. Key features of GeoLibre: - Runs anywhere: the same app ships as a native desktop app, a browser web app, a native Android app, and a Jupyter widget. - Local and private by default: load and analyze GeoJSON, GeoParquet, GeoPackage, Shapefile, COG, LiDAR, 3D Tiles, and more, right in the browser. - Powered by open source: built on MapLibre GL JS, DuckDB-WASM Spatial, Tauri, React, and TypeScript. - Spatial SQL in the browser: query your data with DuckDB Spatial, PostGIS via PGlite, and Apache Sedona. - Extensible: a growing plugin system for cloud data, federal web services, and custom tools. - Supports 12 planetary basemaps: Earth, Mars, the Moon, Mercury, Venus, and more. Two months in, we have already shipped 25 releases, the latest being v2.4.0. There is a lot more to come, and the best way to shape it is to jump in. Try it out - Launch GeoLibre Web: - GitHub: - Documentation: - Release notes: If GeoLibre is useful to you, a star on GitHub and a share here go a long way. Thank you for an incredible first two months. #geospatial #opensource #MapLibre #GeoLibre

🚀 GeoLibre just passed 5,000 stars on GitHub, in only two months! GeoLibre went public on May 27, and the community has already pushed it past 5,100 stars and 500+ forks. Thank you to everyone who starred, forked, filed issues, opened pull requests, and shared the project. For those just discovering it: GeoLibre is a free and open-source, lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data. It runs everywhere you do, in the web browser, on the desktop, on mobile, and inside Jupyter notebooks, all while keeping your data local and private. Key features of GeoLibre: - Runs anywhere: the same app ships as a native desktop app, a browser web app, a native Android app, and a Jupyter widget. - Local and private by default: load and analyze GeoJSON, GeoParquet, GeoPackage, Shapefile, COG, LiDAR, 3D Tiles, and more, right in the browser. - Powered by open source: built on MapLibre GL JS, DuckDB-WASM Spatial, Tauri, React, and TypeScript. - Spatial SQL in the browser: query your data with DuckDB Spatial, PostGIS via PGlite, and Apache Sedona. - Extensible: a growing plugin system for cloud data, federal web services, and custom tools. - Supports 12 planetary basemaps: Earth, Mars, the Moon, Mercury, Venus, and more. Two months in, we have already shipped 25 releases, the latest being v2.4.0. There is a lot more to come, and the best way to shape it is to jump in. Try it out - Launch GeoLibre Web: - GitHub: - Documentation: - Release notes: If GeoLibre is useful to you, a star on GitHub and a share here go a long way. Thank you for an incredible first two months. #geospatial #opensource #MapLibre #GeoLibre

Qiusheng Wu

94,979 Aufrufe • vor 3 Monaten

What if you could search 50M satellite image embeddings with no server, no database, and no API? Part 2 of Caleb Robinson and my series on Compressing Earth Embeddings is live at We binarized the global Clay v1.5 Sentinel-2 embeddings from 183GB → 7GB and built TerraBit — a retrieval demo that runs with zero backend. DuckDB-WASM, cleverly partitioned GeoParquet on S3, and brute-force Hamming in an in-memory index makes the experience feel too good to be true. If you also wondered how Google's TurboQuant fares on compressing earth embeddings -- don't worry, we got you covered in the blog -- hint: TurboQuant int4 is a solid choice

What if you could search 50M satellite image embeddings with no server, no database, and no API? Part 2 of Caleb Robinson and my series on Compressing Earth Embeddings is live at We binarized the global Clay v1.5 Sentinel-2 embeddings from 183GB → 7GB and built TerraBit — a retrieval demo that runs with zero backend. DuckDB-WASM, cleverly partitioned GeoParquet on S3, and brute-force Hamming in an in-memory index makes the experience feel too good to be true. If you also wondered how Google's TurboQuant fares on compressing earth embeddings -- don't worry, we got you covered in the blog -- hint: TurboQuant int4 is a solid choice

Isaac Corley

43,389 Aufrufe • vor 7 Monaten

I am very excited to release GeoLibre v1.0 🌍 GeoLibre is a free and open-source, lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data. One application that runs everywhere: in your web browser, as a native desktop app, on your phone, and inside a Jupyter notebook. No account, no server, no cost. Everything runs locally and your data stays private. In this video, I walk through GeoLibre 1.0 step by step: how to install and run it, load vector and raster data, stream gigabyte-scale cloud-native datasets without downloading them, edit attributes and geometry, work with PMTiles, 3D tiles, LiDAR point clouds, and DuckDB, and share your projects as static links. GeoLibre is built on MapLibre GL JS, React + TypeScript, Tauri (Rust), DuckDB, and Try it: GitHub: Full video tutorial: If you have feature requests or run into bugs, leave a comment or open an issue on GitHub. And if you find GeoLibre useful, please give it a star. #GIS #OpenSource #Geospatial #MapLibre #Python #DataVisualization #GeoLibre

I am very excited to release GeoLibre v1.0 🌍 GeoLibre is a free and open-source, lightweight, cloud-native GIS platform for visualizing, exploring, and analyzing geospatial data. One application that runs everywhere: in your web browser, as a native desktop app, on your phone, and inside a Jupyter notebook. No account, no server, no cost. Everything runs locally and your data stays private. In this video, I walk through GeoLibre 1.0 step by step: how to install and run it, load vector and raster data, stream gigabyte-scale cloud-native datasets without downloading them, edit attributes and geometry, work with PMTiles, 3D tiles, LiDAR point clouds, and DuckDB, and share your projects as static links. GeoLibre is built on MapLibre GL JS, React + TypeScript, Tauri (Rust), DuckDB, and Try it: GitHub: Full video tutorial: If you have feature requests or run into bugs, leave a comment or open an issue on GitHub. And if you find GeoLibre useful, please give it a star. #GIS #OpenSource #Geospatial #MapLibre #Python #DataVisualization #GeoLibre

Qiusheng Wu

40,062 Aufrufe • vor 5 Monaten

Introducing Tapkit Tapkit is a Mac app that lets your agents use your iPhone. Tell it to do anything and it can use your phone to do it. We've been iterating on Tapkit over the last few months with our earliest users and finally feel like it's ready for general use. Today it is easy to use, supports any agent, and can even use multiple iPhones at the same time. There are so many great things that we can do with this new primitive, but I didn't want to wait any longer to share it with you. Try it now:

Introducing Tapkit Tapkit is a Mac app that lets your agents use your iPhone. Tell it to do anything and it can use your phone to do it. We've been iterating on Tapkit over the last few months with our earliest users and finally feel like it's ready for general use. Today it is easy to use, supports any agent, and can even use multiple iPhones at the same time. There are so many great things that we can do with this new primitive, but I didn't want to wait any longer to share it with you. Try it now:

teej

579,653 Aufrufe • vor 1 Monat