Загрузка видео...

Не удалось загрузить видео

Возникла проблема при загрузке этого видео. Это может быть связано с временными проблемами сети или видео может быть недоступно.

На главную

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 просмотров • 6 месяцев назад •via X (Twitter)

Новости и политика Наука и технологии

Anya Rossi• Live Now

Private livecam show

Комментарии: 10

Фото профиля Ashish “Logmaster”

Ashish “Logmaster”6 месяцев назад

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

Фото профиля Harlaksh Singh

Harlaksh Singh6 месяцев назад

What's the use here Mehdi?

Фото профиля Alex Mabe

Alex Mabe6 месяцев назад

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

Фото профиля Sri Madireddy

Sri Madireddy6 месяцев назад

Thanks . Will check it out

Фото профиля shashank

shashank6 месяцев назад

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

Фото профиля Bastien Gares

Bastien Gares6 месяцев назад

Thanks !

Фото профиля Baraka

Baraka6 месяцев назад

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

Фото профиля dalu

dalu6 месяцев назад

auth? safeguards?

Фото профиля David Liang

David Liang6 месяцев назад

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

Фото профиля Adel Bucetta

Adel Bucetta6 месяцев назад

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

Похожие видео

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 просмотров • 7 месяцев назад

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 просмотров • 6 месяцев назад

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,595 просмотров • 1 год назад

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 просмотров • 2 лет назад

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 просмотров • 9 месяцев назад

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 просмотров • 5 месяцев назад

🚀 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 просмотров • 1 год назад

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 просмотров • 5 месяцев назад

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 просмотров • 2 месяцев назад

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 просмотров • 8 месяцев назад

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 просмотров • 1 месяц назад

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 просмотров • 2 лет назад

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 просмотров • 6 месяцев назад

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 просмотров • 10 месяцев назад

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 просмотров • 1 год назад

🚀 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 просмотров • 3 месяцев назад

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 просмотров • 7 месяцев назад

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,027 просмотров • 5 месяцев назад

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

578,612 просмотров • 1 месяц назад