Results of 1 - 10 of about 18 for Finally (0.002 sec.)
- CLI Charting with YouPlot 12594
- 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 visually pleasing plots on the terminal. It can accept input from other programs by pipi
...uckdb -s "SELECT date, sum(purchases) AS total_purchases FROM read_json('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10" Finally, wrap the SELECT in the COPY ... TO function with an output location of /dev/stdout . The syntax looks like this: sql COPY...input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10) TO '/dev/stdout' WITH (FORMAT csv, HEADER)" Connecting DuckDB to YouPlot Finally, the data can now be piped to YouPlot! Let's assume we have an input.json file with dates and number of purchases made by... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Raspberry Pi 11187
- DuckDB is not officially distributed for the Raspberry Pi OS (previously called Raspbian). You can build it following the instructions on this page. Raspberry Pi (64-bit) First, install the required build packages: sudo apt-get update sudo
...e and build it as follows: git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja BUILD_EXTENSIONS="icu;json" make Finally, run it: build/release/duckdb Raspberry Pi (32-bit) On 32-bit Raspberry Pi boards, you need to add the -latomic link flag... - https://man.mtool.work/duckdb/2.0/dev/building/raspberry_pi.html
- ODBC 101: A Duck Themed Guide to ODBC 10706
- What is ODBC? ODBC which stands for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different d
...vironment handle is allocated, then the environment is set to ODBC version 3, then the connection handle is allocated, and finally the connection is made to the database. The following code snippet shows how to do this: SQLHANDLE env; SQLHANDLE dbc; SQL...and perform other database operations such as inserting, updating, or deleting data. 6. Free the Handles and Disconnecting Finally, we need to free the handles and disconnect from the database. First, we need to free the statement handle: SQLFreeHandle(...SQL_HANDLE_STMT, stmt); Then we need to disconnect from the database: SQLDisconnect(dbc); And finally, we need to free the connection handle and the environment handle: SQLFreeHandle(SQL_HANDLE_DBC, dbc); SQLFreeHandle(SQL_H... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
- Client Overview 10243
- DuckDB is primarily an in-process database system, and as such, it offers client APIs (“drivers”) for several languages. Client API Maintainer Support tier Latest version C Core team 2.0.0 CLI (command line interface) Core team 2.0.0 Java (
...es and are covered by community support . Secondary clients receive new features but are not covered by community support. Finally, there are no feature or support guarantees for tertiary clients. The DuckDB clients listed above are open-source and we w... - https://man.mtool.work/duckdb/2.0/clients/overview.html
- Analyzing a Git Repository 10243
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...e use the NATURAL ANTI JOIN clause here, which allows us to elegantly filter out values that occur in the stopwords table. Finally, we select the top-20 most common words. SELECT word, count(*) AS count FROM words GROUP BY ALL ORDER BY count DESC LIMIT...there due to commit messages for merging pull requests (e.g., ”Merge pull request #13776 from Mytherin/expressiondepth” ). Finally, we also see some DuckDB-related terms such as duckdb (shocking!) and function . Visualizing the Number of Commits Let's v... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- S3 API Support 9299
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...le as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) for the credential chain to work properly. Finally, R2 secrets are only available when using URLs starting with r2:// , for example: SELECT * FROM read_parquet('r2://⟨some-f...le as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) for the credential chain to work properly. Finally, GCS secrets are only available when using URLs starting with gcs:// or gs:// , for example: SELECT * FROM read_parquet('g... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Swift Client 8356
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...ing. We'll then cast the result columns to Swift native types using DuckDB's ResultSet cast(to:) family of methods, before finally wrapping them up in a DataFrame from the TabularData framework. ... import TabularData extension ExoplanetStore { // Retri... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Hugging Face Support 8356
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL patter
...n hello To read a JSONL file, you can run: SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-jsonl-1/data.jsonl'; Finally, for reading a Parquet file, use the following query: SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-parquet-1... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- Pivot Internals 8356
- PIVOT Pivoting is implemented as a combination of SQL query re-writing and a dedicated PhysicalPivot operator for higher performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator
...CT DISTINCT year::VARCHAR FROM cities ORDER BY year ); PIVOT cities ON year IN __pivot_enum_0_0 USING sum(population); and finally translated into: SELECT country, name, list(year), list(population_sum) FROM ( SELECT country, name, year, sum(population)... - https://man.mtool.work/duckdb/2.0/internals/pivot.html
- SQL Introduction 8356
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...l store cities and their associated geographical location: CREATE TABLE cities ( name VARCHAR, lat DECIMAL, lon DECIMAL ); Finally, it should be mentioned that if you don't need a table any longer or want to recreate it differently you can remove it usi...0; city max(temp_lo) Hayward 37 which gives us the same results for only the cities that have all temp_lo values below 40. Finally, if we only care about cities whose names begin with S , we can use the LIKE operator: SELECT city, max(temp_lo) FROM weat... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
DuckDB 2.0 Documentation / man.mtool.work