duckdb - Robuta Search

https://duckdb.org/ DuckDB – An in-process SQL OLAP database management system in process database management duckdb sql olap https://duckdbsnippets.com/ SQL, Python & More for DuckDB | DuckDB Snippets Share and vote for your favorites with the DuckDB community. more for sql python duckdb snippets https://motherduck.com/duckdb-book-summary-chapter1/ What Is DuckDB? Introduction, Use Cases & Architecture | DuckDB in Action What is DuckDB and when should you use it? Chapter 1 of DuckDB in Action covers the embedded analytics database, key use cases, and how it compares to SQLite,... what is use cases duckdb introduction architecture https://github.com/duckdb/duckdb GitHub - duckdb/duckdb: DuckDB is an analytical in-process SQL database management system · GitHub DuckDB is an analytical in-process SQL database management system - duckdb/duckdb database management system in process https://drimble.nl/bedrijf/amsterdam/49812653/duckdb-engineering-bv.html Alles over DuckDB Labs Amsterdam B.V. Science Park 404 op Drimble.nl Drimble verzamelt en ordent informatie uit duizenden nieuws- en overige bronnen in Nederland, helder en overzichtelijk. https://shop.duckdb.org/ DuckDB Webshop – DuckDB webshop duckdb webshop https://www.casd.eu/duckdb-23-juin-2026/ DuckDB – 23 juin 2026 – Le CASD – Centre d'accès Sécurisé aux Données https://duckdb.org/visualizer/ DuckDB Table Visualizer – DuckDB This is a demo built with duckdb-wasm and regular-tables. duckdb table visualizer https://duckdb.org/docs/current/sql/data_types/time Time Types – DuckDB The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day TIMETZ TIME... time types duckdb https://duckdb.org/community_extensions/extensions/lindel lindel – DuckDB Community Extensions DuckDB Community Extensions Linearization/Delinearization, Z-Order, Hilbert and Morton Curves lindel duckdb community extensions https://docs.akave.xyz/akave-o3/solutions-and-integrations/duckdb/ https://docs.akave.xyz/solutions-and-integrations/duckdb/ solutions and integrations https docs akave xyz https://www.digitalturbine.com/blog/small-scale-data-pipeline-spark-vs-chdb-vs-duckdb Small-Scale Data Pipeline: DuckDB vs. chDB vs. Spark We faced a 40GB data aggregation challenge for DT Exchange. This post details our benchmark of DuckDB, chDB, and Spark for local processing. small scale data pipeline duckdb vs chdb https://www.ssp.sh/brain/duckdb/ DuckDB DuckDB is an in-process SQL OLAP database management system. It has strong support for SQL. DuckDB is borrowing the SQLite shell implementation. duckdb https://duckdb.org/docs/current/clients/c/types Types – DuckDB DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a... types duckdb https://duckdb.org/docs/current/core_extensions/httpfs/s3api_legacy_authentication Legacy Authentication Scheme for S3 API – DuckDB Prior to version 0.10.0, DuckDB did not have a Secrets manager. Hence, the configuration of and authentication to S3 endpoints was handled via variables. This... legacy authentication scheme api duckdb https://duckdb.org/docs/current/guides/offline-copy Browsing Offline – DuckDB The offline documentation is currently not available. Please check back later. You can browse the DuckDB documentation offline in the following formats: Single... browsing offline duckdb https://datastackshow.com/podcast/quacking-through-data-duckdbs-emerging-ecosystem/ Quacking Through Data: Duckdb's Emerging Ecosystem | The Data Stack Show the stack quacking data duckdb emerging https://motherduck.com/blog/15-companies-duckdb-in-prod/ 15+ Companies Using DuckDB in Production: A Comprehensive Guide May 12, 2026 - Discover how companies are running DuckDB in production companies using duckdb production comprehensive guide https://learningduckdb.com/newsletters/welcome-to-learning-duckdb/?ref=christopheblefari.ghost.io Welcome to Learning DuckDB! Learning DuckDB with a weekly newsletter welcome to learning duckdb https://duckdb.org/docs/current/guides/network_cloud_storage/s3_export S3 Parquet Export – DuckDB To write a Parquet file to S3, the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL... parquet export duckdb https://motherduck.com/duckdb-book-brief/ Free "DuckDB in Action" Book Download a free PDF of the DuckDB in Action book published by Manning. The book is rich with technical guidance on data analytics and data engineering with... in action free duckdb book https://buylibs.com/pascal/duckdb/api/ddb-0.10.1.16-51aa66ab/ddb.OperatorExtensionInfo.html ddb: Record OperatorExtensionInfo | DuckDB Integration for Delphi and Free Pascal | BuyLibs for delphi free pascal ddb record duckdb https://duckdb.org/docs/current/guides/meta/summarize Summarize – DuckDB The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query. The SUMMARIZE command launches a query that computes a... summarize duckdb https://duckdb.org/docs/current/sql/dialect/friendly_sql Friendly SQL – DuckDB DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of... friendly sql duckdb https://bioscryptome.t-ohashi.info/blog/duckdb-statement/ [blog] DuckDB - Statements blog duckdb statements https://www.dbreunig.com/2024/06/25/using-duckdb-spatial-joins-to-map-overture-gers-ids-to-us-census-fips-codes.html Using DuckDB to Map Overture GERS IDs to US Census FIPs Codes Jun 25, 2024 - Persistent identifiers for geospatial data can unlock the potential of geospatial intelligence for a wider group of organizations. Here we use DuckDB to create... to map us census using duckdb overture https://duckdb.org/docs/current/sql/data_types/numeric Numeric Types – DuckDB Fixed-Width Integer Types The types TINYINT, SMALLINT, INTEGER, BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of... numeric types duckdb https://www.runtime.news/salesforce-drops-the-ui-duckdb-hits-the-lake/ Salesforce drops the UI; DuckDB hits the lake Apr 18, 2026 - Today on Product Saturday: Salesforce might have the answer to SaaS sustainability in an AI world, DuckDB addresses the salesforce drops ui duckdb hits https://duckdb.org/docs/current/sql/statements/update UPDATE Statement – DuckDB The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL, set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i... update statement duckdb https://duckdb.org/docs/current/data/multiple_files/overview Reading Multiple Files – DuckDB DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to... multiple files reading duckdb https://duckdbsnippets.com/page/2 SQL, Python & More for DuckDB - Page 2 | DuckDB Snippets Share and vote for your favorites with the DuckDB community. more for sql python duckdb snippets https://pigsty.cc/ext/e/duckdb_fdw/ duckdb_fdw | PIGSTY duckdb fdw pigsty https://duckdb.org/docs/current/guides/data_viewers/youplot CLI Charting with YouPlot – DuckDB DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing... cli charting duckdb https://www.stacksync.com/integrations/quickbooks-and-duckdb Quickbooks and DuckDB Integration | Stacksync Sync Quickbooks and DuckDB without code. Sync data bi-directionally and in real time, automate workflows, and manage every data pipeline. quickbooks duckdb integration stacksync https://duckdb.org/docs/current/guides/file_formats/csv_import CSV Import – DuckDB To read data from a CSV file, use the read_csv function in the FROM clause of a query: SELECT * FROM read_csv('input.csv'); Alternatively, you can omit the... csv import duckdb https://duckdb.org/docs/current/guides/glossary Glossary of Terms – DuckDB This page contains a glossary of a few common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's... glossary of terms duckdb https://advisories.gitlab.com/pkg/pypi/llama-index-retrievers-duckdb-retriever/ Pypi/Llama-Index-Retrievers-Duckdb-Retriever | GitLab Advisory Database (GLAD) pypi llama index retrievers duckdb https://duckdb.org/docs/current/operations_manual/securing_duckdb/embedding_duckdb Embedding DuckDB – DuckDB CLI Client The Command Line Interface (CLI) client is intended for interactive use cases and not for embedding. As a result, it has more features that could be... embedding duckdb https://www.nuget.org/stats/packages/DuckDb?groupby=Version NuGet Gallery | Package Downloads for DuckDb nuget gallery package downloads duckdb https://motherduck.com/blog/ MotherDuck Blog | DuckDB Tutorials, Tips & Data Engineering Guides Practical DuckDB tutorials, performance tips, and data engineering guides. Learn SQL analytics, work with Parquet files, and build faster data pipelines - from... motherduck blog data engineering duckdb tutorials tips https://duckdb.org/docs/current/sql/data_types/map Map Type – DuckDB MAPs are similar to STRUCTs in that they are an ordered list of key-value pairs. However, MAPs do not need to have the same keys present for each row, and thus... map type duckdb https://buylibs.com/pascal/duckdb/api/ddb-0.10.1.16-51aa66ab/ddb.UnionValue.html ddb: Record UnionValue | DuckDB Integration for Delphi and Free Pascal | BuyLibs for delphi free pascal ddb record duckdb https://duckdb.org/docs/current/guides/file_formats/query_parquet Querying Parquet Files – DuckDB To run a query directly on a Parquet file, use the read_parquet function in the FROM clause of a query. SELECT * FROM read_parquet('input.parquet'); The... querying parquet files duckdb https://duckdb.org/docs/current/sql/query_syntax/filter FILTER Clause – DuckDB The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function... filter clause duckdb https://duckdb.org/news/ Engineering Blog – DuckDB engineering blog duckdb https://duckdb.org/docs/current/data/json/caveats Caveats – DuckDB Equality Comparison Warning Currently, equality comparison of JSON files can differ based on the context. In some cases, it is based on raw text comparison,... caveats duckdb https://duckdb.org/docs/current/data/appender Appender – DuckDB The Appender can be used to load bulk data into a DuckDB database. It is currently available in the C, C++, Go, Java and Rust APIs. The Appender is tied to a... appender duckdb https://duckdb.org/everywhere/ DuckDB Everywhere – DuckDB duckdb everywhere https://duckdb.org/docs/current/clients/c/data_chunk Data Chunks – DuckDB Data chunks represent a horizontal slice of a table. They hold a number of vectors, that can each hold up to the VECTOR_SIZE rows. The vector size can be... data chunks duckdb https://duckdb.org/docs/current/core_extensions/tpch TPC-H Extension – DuckDB The tpch extension implements the data generator and queries for the TPC-H benchmark. Installing and Loading The tpch extension is shipped by default in some... tpc h extension duckdb https://dbquacks.com/tutorial/9 DB Quacks - Interactive SQL & DuckDB Tutorial Master SQL and DuckDB with Duckbert's interactive tutorial! Write real SQL queries, solve progressive challenges, and learn database concepts step-by-step.... db quacks interactive sql tutorial https://buylibs.com/pascal/duckdb/api/ddb-0.10.1.16-51aa66ab/ddb.Relation.html ddb: Record Relation | DuckDB Integration for Delphi and Free Pascal | BuyLibs for delphi free pascal ddb record relation https://duckdb.org/docs/current/guides/python/execute_sql Executing SQL in Python – DuckDB SQL queries can be executed using the duckdb.sql function. import duckdb duckdb.sql( executing sql python duckdb https://tobilg.com/posts/using-duckdb-to-repartition-parquet-data-in-s3/ Using DuckDB to repartition parquet data in S3 - tobilg.com Feb 26, 2023 - A common task in S3-based Data Lakes is to repartition data, to optimize query patterns and speed. This article describes a serverless solution using DuckDB using duckdb parquet data https://duckdb.org/docs/current/guides/python/import_arrow Import from Apache Arrow – DuckDB CREATE TABLE AS and INSERT INTO can be used to create a table from any query. We can then create tables or insert into existing tables by referring to the... import from apache arrow duckdb https://www.datacamp.com/pl/blog/an-introduction-to-duckdb-what-is-it-and-why-should-you-use-it Introduction to DuckDB: A Guide for Data Analysis | DataCamp Explore DuckDB, the fast, easy-to-use analytics database for Python and R. Learn its key features, use cases, and how it optimizes data analysis tasks. for data analysis introduction duckdb guide datacamp https://docs.dagster.io/integrations/libraries/motherduck/dagster-duckdb-pandas dagster-duckdb-pandas library | Dagster Docs dagster-duckdb-pandas library Dagster API | Comprehensive Python API documentation for Dagster, the data orchestration platform. Learn how to build, test, and... dagster duckdb pandas library docs https://duckdb.org/docs/current/clients/c/value Values – DuckDB The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value(duckdb_value *value); duckdb_value... values duckdb https://central.sonatype.com/artifact/org.duckdb/duckdb_jdbc/1.4.4.0/overview Maven Central: org.duckdb:duckdb_jdbc:1.4.4.0 Discover duckdb_jdbc in the org.duckdb namespace. Explore metadata, contributors, the Maven POM file, and more. maven central duckdb jdbc https://mcprepository.com/ktanaka101/mcp-server-duckdb mcp-server-duckdb - MCP Server mcp-server-duckdb MCP Server: A DuckDB MCP server mcp server duckdb https://getbruin.com/ingestion/platforms/copy-data-from-pinterest-to-duckdb/ Pinterest to DuckDB Ingestion | Bruin Learn how to ingest data from Pinterest to DuckDB with a single command using ingestr. Complete tutorial with examples and troubleshooting. pinterest duckdb ingestion bruin https://duckdb.org/docs/current/core_extensions/aws AWS Extension – DuckDB The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities, using the AWS SDK. Installing and Loading The aws... aws extension duckdb https://duckdb.org/docs/current/sql/data_types/bitstring Bitstring Type – DuckDB Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is of variable length. A... bitstring type duckdb https://duckdb.org/docs/current/sql/statements/export EXPORT and IMPORT DATABASE Statements – DuckDB The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the... export and import database statements duckdb https://spatialworld.fi/fi/fme-blog-duckdb-llm-reporting/ kysymys-sql-raportti-fme-duckdb - Spatialworld Oy kysymys sql raportti fme duckdb https://duckdb.org/docs/current/core_extensions/lance Lance Extension – DuckDB The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud... lance extension duckdb https://buylibs.com/pascal/duckdb/api/ddb-0.10.1.16-51aa66ab/ddb.ListType.html ddb: Record ListType | DuckDB Integration for Delphi and Free Pascal | BuyLibs for delphi free pascal ddb record duckdb https://duckdb.org/docs/current/core_extensions/httpfs/overview httpfs Extension for HTTP and S3 Support – DuckDB The httpfs extension is an autoloadable extension implementing a file system that allows reading remote/writing remote files. For plain HTTP(S), only file... extension http support duckdb https://duckdb.org/docs/current/guides/snippets/create_synthetic_data Create Synthetic Data – DuckDB DuckDB allows you to quickly generate synthetic datasets. To do so, you may use: range functions hash functions, e.g., hash, md5, sha256 the Faker Python... synthetic data create duckdb https://www.ssp.sh/blog/obsidian-rag-duckdb-sql/ Building an Obsidian RAG with DuckDB and MotherDuck | ssp.sh Feb 13, 2026 - How I built a knowledge assistant on 9000 Obsidian notes using DuckDB as a vector database, MotherDuck WASM for a serverless web app, and what I learned about... building obsidian rag duckdb motherduck https://blog.qsliu.dev/tagged/DuckDB/ #DuckDB at qsliu's blog A blog about software engineering, systems programming, databases, and distributed systems. duckdb blog https://notes.billmill.org/NBA_Stats/duckdb-wasm_attempt.html duckdb-wasm attempt - llimllib notes duckdb wasm attempt notes https://duckdb.org/docs/current/sql/functions/array Array Functions – DuckDB All LIST functions work with the ARRAY data type. Additionally, several ARRAY-native functions are also supported. Array-Native Functions Function Description... array functions duckdb https://www.blog.brightcoding.dev/2025/09/14/harlequin-the-terminal-native-sql-ide-built-for-duckdb-sqlite-and-beyond/ Harlequin: The Terminal-Native SQL IDE Built for DuckDB, SQLite, and Beyond - BrightCoding TL;DR: Harlequin gives you the convenience of a full-featured SQL IDE schema browser, editable query panes, scrollable results, themes, autocompletion without... https://duckdb.org/docs/current/clients/python/expression Expression API – DuckDB The Expression class represents an instance of an expression. Why Would I Use the Expression API? Using this API makes it possible to dynamically build up... expression api duckdb https://deepnote.com/blog/ultimate-guide-to-duckdb-library-in-python Ultimate guide to DuckDB library in Python DuckDB is an open-source, embeddable analytical database engine designed for high-performance SQL queries on local data. ultimate guide duckdb library python https://dux.now/ Dux: Distributed DuckDB-native DataFrames for Elixir DuckDB-native dataframes for Elixir. Lazy pipelines compile to SQL CTEs. DuckDB handles the compute. The BEAM handles distribution. dux distributed duckdb native dataframes https://duckdb.org/docs/current/sql/dialect/overview Overview – DuckDB DuckDB's SQL dialect is based on PostgreSQL. DuckDB tries to closely match PostgreSQL's semantics, however, some use cases require slightly different behavior.... overview duckdb https://duckdb.org/docs/current/data/json/overview JSON Overview – DuckDB DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which... json overview duckdb https://www.dbreunig.com/2025/05/03/duckdb-is-the-most-impactful-geospatial-software-in-a-decade.html DuckDB is Probably the Most Important Geospatial Software of the Last Decade May 3, 2025 - What happens when you embed geospatial capabilities in generalist data tools? More people engaging with geo data. the most geospatial software duckdb probably https://duckdb.org/docs/current/data/multiple_files/combining_schemas Combining Schemas – DuckDB Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name:... combining schemas duckdb https://duckdb.org/release_calendar Release Calendar – DuckDB release calendar duckdb https://buylibs.com/pascal/duckdb/api/ddb-0.10.1.16-51aa66ab/ddb.EPermissionException.html ddb: Class EPermissionException | DuckDB Integration for Delphi and Free Pascal | BuyLibs for delphi free pascal ddb class duckdb https://duckdb.org/docs/current/dev/building/windows Windows – DuckDB On Windows, DuckDB requires the Microsoft Visual C++ Redistributable package both as a build-time and runtime dependency. Note that unlike the build process on... windows duckdb https://duckdb.org/docs/current/sql/functions/time Time Functions – DuckDB This section describes functions and operators for examining and manipulating TIME values. Time Operators The table below shows the available mathematical... time functions duckdb https://duckdb.org/docs/current/core_extensions/postgres PostgreSQL Extension – DuckDB The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the... postgresql extension duckdb https://www.duckdbstats.com/ DuckDB Stats - Python Package Downloads Real-time analytics dashboard for DuckDB Python package downloads from PyPI, powered by MotherDuck. python package duckdb stats downloads https://duckdb.org/community_extensions/ Community Extensions – DuckDB Community Extensions List of Community contributed open-source DuckDB extension community extensions duckdb https://endjin.com/blog/duckdb-rise-of-in-process-analytics-understanding-data-singularity DuckDB: the Rise of In-Process Analytics and Data Singularity Mar 29, 2026 - Modern laptops can now handle datasets up to a billion rows, yet 94% of query spending goes on big-data compute that isn't needed. DuckDB brings analytical SQL... analytics and data the rise in process duckdb singularity https://cdnjs.com/libraries/duckdb-wasm/1.29.1-dev279.0 duckdb-wasm - Libraries - cdnjs - The #1 free and open source CDN built to make life easier for... DuckDB powered by WebAssembly - Simple. Fast. Reliable. Content delivery at its finest. cdnjs is a free and open-source CDN service trusted by over 12.5% of... https://docs.dbpilot.io/connect-duckdb Connect to DuckDB - Docs - DB Pilot connect to duckdb docs pilot https://duckdbsnippets.com/snippets/2/using-the-exclude-function-in-duckdb Using the EXCLUDE() function in DuckDB | DuckDB Snippets Nov 2, 2024 - Tired of copying/pasting many column names to select all columns except a handful? The EXCLUDE() function in SQL allows you to exclude specific columns from... using exclude function duckdb snippets https://niklas-heringer.com/research/data-engineering-with-dagster-part-two/ Data Engineering With Dagster - Part Two: Dependencies, DuckDB, and Geo Heatmaps Jan 3, 2026 - Learning to wire assets together, load data into DuckDB, and build heatmaps with real NYC taxi data. data engineering part two dagster https://duckdb.org/docs/current/core_extensions/spatial/gdal GDAL Integration – DuckDB The spatial extension integrates the GDAL translator library to read and write spatial data from a variety of geospatial vector file formats. See the... gdal integration duckdb https://central.sonatype.com/artifact/org.duckdb/duckdb_jdbc Maven Central: org.duckdb:duckdb_jdbc Discover duckdb_jdbc in the org.duckdb namespace. Explore metadata, contributors, the Maven POM file, and more. maven central duckdb jdbc https://duckdb.org/docs/current/sql/functions/enum Enum Functions – DuckDB This section describes functions and operators for examining and manipulating ENUM values. The examples assume an enum type created as: CREATE TYPE mood AS... enum functions duckdb https://duckdb.org/docs/current/guides/file_formats/read_duckdb Directly Read DuckDB Databases – DuckDB DuckDB allows directly reading DuckDB files through the read_duckdb function: read_duckdb('path_to_database', table_name = 'table_to_read'); Using this... directly read duckdb databases https://modal.com/docs/examples/s3_bucket_mount Analyze NYC yellow taxi data with DuckDB on Parquet files from S3 | Modal Docs This example shows how to use Modal for a classic data science task: loading table-structured data into cloud stores, analyzing it, and plotting the results. https://motherduck.com/events/ Data Conferences, DuckDB Meetups & MotherDuck Events Find upcoming data conferences, DuckDB meetups, and MotherDuck events worldwide. Join us for in-person and online data analytics and data science events. data conferences duckdb meetups motherduck https://tabularis.dev/solutions/duckdb-redis-database-workflows DuckDB and Redis Workflows via Plugins | Tabularis Explore how Tabularis can support DuckDB, Redis, and other extended database workflows through its plugin system and open extensibility model. duckdb redis workflows via plugins