tobilg.com

What if you could take a SQL query written for PostgreSQL and transpile it to BigQuery, Snowflake, or any of 33 database dialects — entirely in the browser, with no server round-trip?

What if you could run full SQL queries, including JOINs, aggregations, and even remote Parquet file reads, directly inside a Cloudflare Worker?

With recent updates of DuckDB itself, DuckDB-Wasm and the Iceberg extension it is now possible to query Iceberg catalog directly from the browser, with no backends. involved.

What if you could query any REST API, GraphQL endpoint, or web page directly from DuckDB using SQL?

You can use the unofficial AWS News MCP Server, which combines the news articles, blog posts and updates of more than 40 different AWS Newsfeeds to a single source.

Preconditions# To use the Amazon SageMaker Lakehouse with DuckDB, you first have to create a S3 Table bucket, a namespace and an actual S3 Table.

Recap: Data Warehouses, Data Lakes, Lakehouses?

Data Lakes come in a broad variety and lots of different flavors.

The General Transit Feed Specification (GTFS) is a standardized, open data format for public transportation schedules and geographic information.

Amazon S3 Tables was launched on December 3rd 2024, and provides you “storage that is optimized for tabular data such as daily purchase transactions, streaming sensor data, and ad impressions in Apache Iceberg format”.

DuckDB has gained a new feature in preview, that allows querying of Iceberg data in AWS S3 Tables.

I had a use case that eventually required performing IP address lookups in a given list of CIDR ranges, as I maintain an open source project that gathers IP address range data from public cloud providers, and also wrote an article in my blog about analyzi…

A while ago I published sql-workbench.com and the accompanying blog post called “Using DuckDB-WASM for in-browser Data Engineering”.

Introduction# DuckDB, the in-process DBMS specialized in OLAP workloads, had a very rapid growth during the last year, both in functionality, but also popularity amongst its users, but also with developers that contribute many projects to the Open Source…

What is Lambda@Edge# AWS Lambda@Edge is an extension of the traditional AWS Lambda service, but with a crucial twist – it brings serverless computing capabilities closer to the end-users.

As the Skillbuilder website is sometimes a bit hard to navigate, here’s the full list of free badges you can do on AWS Skillbuilder: AWS Knowledge: Cloud Essentials AWS Knowledge: Architecting AWS Knowledge: Serverless AWS Knowledge: Object Storage AWS Kn…

Introduction# In today’s data-driven world, interactive and visually appealing web-based maps have become an integral part of countless applications and services.

As organizations increasingly adopt the public cloud, managing the networking and security aspects of cloud computing becomes more complex.

In the age of big data, organizations of all sizes are collecting vast amounts of information about their operations, customers, and markets.

Since release v0.7.1, DuckDB has the ability to repartition data stored in S3 as parquet files by a simple SQL query, which enables some interesting use cases.

Prelude# DuckDB is an open-source in-process SQL OLAP database management system that has recently gained significant public interest due to its unique architecture and impressive performance benchmarks.

Motivation# Who needs a reverse proxy with on-demand SSL support?