Results of 1 - 10 of about 11 for connector (0.001 sec.)
- Connect 12945
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...alization steps with a Connector , the client's thread-safety and connection-lifetime rules, and closing a database cleanly. Opening a Database sql.Open()...nfiguration page . Options can also be changed after connecting with a SET statement . Running Initialization Steps with a Connector To run setup statements before any query, or to configure DuckDB in code rather than in the DSN, create a Connector with d...uckdb.NewConnector() and open the database with sql.OpenDB() . The connector's second argument is a callback that runs against each new conne... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Profile and Monitor 10064
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...le metric names. Log Storage DuckDB can forward its log messages to a custom storage registered from Go. Register one on a Connector with duckdb.RegisterLogStorage() , giving it a name and a duckdb.LoggerCallbacks whose DefaultLoggerCallback receives each...entry's level, type, and message: connector, err := duckdb.NewConnector("", nil) check(err) defer connector.Close() err = duckdb.RegisterLogStorage(connector, "my_log...%s", level, logType, logMsg) }, }) check(err) // Enable logging, then point it at the registered storage. db := sql.OpenDB(connector) _, err = db.Exec(`CALL enable_logging(level = 'info')`) check(err) _, err = db.Exec(`SET logging_storage = 'my_log_storag... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Import Data 9851
- Overview The Go client offers two ways to load data into DuckDB in bulk: the high-performance Appender for inserting rows generated in Go, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. For in
...nerated in Go, much faster than issuing INSERT statements. It operates on a raw DuckDB connection, so it is created from a Connector rather than a *sql.DB . Obtain a connection from the connector, then create the appender for a target table with duckdb.Ne...wAppenderFromConn() , passing the schema (empty for the default) and table name: connector, err := duckdb.NewConnector("test.db", nil) if err != nil { log.Fatal(err) } defer connector.Close() conn, err := connecto...flush. The following follows the client's appender example , which creates the table through a *sql.DB opened on the same connector, appends a row, then reads it back: package main import ( "context" "database/sql" "log" "github.com/duckdb/duckdb-go/v2"... - https://man.mtool.work/duckdb/2.0/clients/go/data_import.html
- Tableau – A Data Visualization Tool 9637
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...gate functions. To make the data source connection more compatible with the PostgreSQL dialect, please use the DuckDB taco connector as described below. Installing the Tableau DuckDB Connector While it is possible to use the Tableau-provided PostgreSQL di...alect to communicate with the DuckDB JDBC driver, we strongly recommend using the DuckDB Taco connector . This connector has been fully tested against the Tableau dialect generator and is more compatible than the provided Post...greSQL dialect. The documentation on how to install and use the connector is in its repository, but essentially you will need the duckdb_jdbc.taco file. (Despite what the Tableau documentation say... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Write User Defined Functions 9495
- Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a
...nd table functions are registered on a connection checked out with db.Conn() , while a replacement scan is registered on a Connector ; in each case the function is then callable from SQL like any built-in. The sections below build and register each. Scala...s a query that references a table name DuckDB cannot resolve and rewrites it into a table function call. Register one on a Connector with duckdb.RegisterReplacementScan() , passing a callback of type duckdb.ReplacementScanCallback . The callback receives...the unresolved table name and returns the replacement function name and its arguments: connector, err := duckdb.NewConnector("", nil) check(err) defer connector.Close() duckdb.RegisterReplacementScan(connector, func(tab... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
- DuckDB Repositories 9353
- Several components of DuckDB are maintained in separate repositories. Main Repositories duckdb : core DuckDB project duckdb-web : documentation and blog duckdb-quack : Quack remote protocol Clients duckdb-go : Go client duckdb-java : Java (
...t : Swift client duckdb-wasm : WebAssembly client duckplyr : a drop-in replacement for dplyr in R DuckDB.jl : Julia client Connectors dbt-duckdb : dbt duckdb-mysql : MySQL connector duckdb-postgres : PostgreSQL connector (connect to PostgreSQL from DuckDB...) duckdb-sqlite : SQLite connector pg_duckdb : official PostgreSQL extension for DuckDB (run DuckDB in PostgreSQL) Extensions duckdb-ui : web UI for DuckDB C... - https://man.mtool.work/duckdb/2.0/dev/repositories.html
- Handle Results 8339
- Overview DuckDB is columnar, and beyond reading a result set row by row through database/sql , the Go client can exchange whole results with Apache Arrow as a stream of record batches, and register an Arrow stream as a queryable view. Both
...t back an array.RecordReader . Iterate it with Next() , reading one arrow.RecordBatch at a time, and release it when done: connector, err := duckdb.NewConnector("", nil) if err != nil { log.Fatal(err) } defer connector.Close() conn, err := connector.Conne... - https://man.mtool.work/duckdb/2.0/clients/go/result_handling.html
- Julia Client 7343
- The DuckDB Julia package provides a high-performance front-end for DuckDB. Much like SQLite, DuckDB runs in-process within the Julia client, and provides a DBInterface front-end. The package also supports multi-threaded execution. It uses J
...ckDB.close(appender); end # spawn many appender tasks for i in 1:100 Threads.@spawn run_appender(db, 2) end Original Julia Connector Credits to kimmolinna for the original DuckDB Julia connector .... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/julia.html
- DBeaver SQL IDE 6970
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...uilding complex queries. DuckDB's JDBC connector allows DBeaver to query DuckDB files, and by extension, any other files that DuckDB can access (like Parquet files ). Inst... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- Writing Tests 6899
- Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests ar
...SQL tests should be written using the sqllogictest framework . C++ tests can be written using the Catch framework . Client Connector Tests DuckDB also has tests for various client connectors. These are generally written in the relevant client language, an... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/writing_tests.html
DuckDB 2.0 Documentation / man.mtool.work