Results of 1 - 10 of about 40 for application (0.008 sec.)
- ODBC 101: A Duck Themed Guide to ODBC 16382
- 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
...r methods of connecting to a database, such as using a native driver, as it adds an extra layer of abstraction between the application and the database. Furthermore, because DuckDB is column-based and ODBC is row-based, there can be some inefficiencies when...allocate, and a pointer to the handle, the driver then creates a new handle of the specified type, which it returns to the application. The DuckDB ODBC driver has the following handle types. Environment | Handle name | Environment | | Type name | SQL_HANDLE...Initializing ODBC, managing driver behavior, resource allocation. | | Additional information | Must be allocated once per application upon starting, and freed at the end. | Connection | Handle name | Connection | | Type name | SQL_HANDLE_DBC | | Descriptio... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
- Deploy as Native Image 10079
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...y metadata that native-image needs, and the build picks it up automatically from the class path. Two things remain for the application to configure: native access and the location of DuckDB's shared library. Driver versions up to and including 1.5.5 do not...ship this metadata. For those versions, generate it by running the application once on the JVM with the tracing agent : bash java -agentlib:native-image-agent=config-output-dir=⟨config_dir⟩ -cp ⟨classp...directory, so the program runs correctly from anywhere. This option produces a small executable, under 20 MB for a simple application, with no extraction cost when connections open. The library can be extracted from the driver JAR, or taken from the -nolib... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- ADBC Client 9267
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...C-style API that enables code portability between different database systems. This allows developers to effortlessly build applications that communicate with database systems without using code specific to that system. The main difference between ADBC and O...DBC/JDBC is that ADBC uses Arrow to transfer data between the database system and the application. DuckDB has an ADBC driver, which takes advantage of the zero-copy integration between DuckDB and Arrow to efficiently tra...using DuckDB as an ADBC driver, you must install the libduckdb shared library on your system and make it available to your application. This library contains the core DuckDB engine that the ADBC driver interfaces with. Downloading libduckdb Download the app... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
- Swift Client 9158
- 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
...through a database connection. let connection = try database.connect() DuckDB supports multiple connections per database. Application Example The rest of the page is based on the example of our announcement post , which uses raw data from NASA's Exoplanet...Archive loaded directly into DuckDB. Creating an Application-Specific Type We first create an application-specific type that we'll use to house our database and connection and through... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Connect 9033
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...a file that was modified after deployment. DuckDBConnection.getSessionInitSQL() returns the text that was executed, so an application can log or audit it. Warning The SQL in the file runs with the full privileges of the connection. Treat the connection str...M's threads: a single Statement.executeQuery() call can occupy every thread in the pool, and blocking JDBC calls from many application threads do not increase DuckDB's parallelism. The pool belongs to the database instance , not to the Connection . Every co...async_threads explicitly as well: SET threads = 4; SET async_threads = 4; Two consequences are worth calling out for Java applications: Attached databases do not add threads. ATTACH adds a catalog to the database instance the connection already belongs to.... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Profile and Monitor 8347
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...VM signal. The feature is strictly opt-in and is a silent no-op on JVMs without JFR support: nothing is emitted unless the application both sets the JDBC property on a connection and has an active JFR recording that enables the event. Enabling Emission Moni...try (Recording r = new Recording()) { r.enable("duckdb.MemoryUsage").withPeriod(Duration.ofSeconds(1)); r.start(); // ... application work ... r.stop(); r.dump(Path.of("app.jfr")); } The equivalent .jfc snippet: <event name="duckdb.MemoryUsage"> <setting n...b.MemoryUsage event per DuckDB memory tag per JFR tick, with the following fields: Field Type Description component String Application-supplied identifier, the jdbc_jfr_memory_monitor value. tag String DuckDB memory tag, such as BASE_TABLE , HASH_TABLE , or... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Troubleshoot 8128
- Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys
...DuckDB from the source shipped with the crate, so nothing else is needed to build, and it is the simplest choice for most applications. Without bundled , the underlying libduckdb-sys crate links against a DuckDB library already on the system, which it loca...open_in_memory Panics in an Extension Build The loadable-extension feature builds a DuckDB extension rather than a client application. When it is enabled, entry points such as Connection::open_in_memory() panic if they are called outside an extension conte...xt, because there is no host DuckDB instance to attach to. Do not enable loadable-extension for a client application. Use it only when building an extension. See Write User Defined Functions for how loadable extensions are built and packag... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
- Troubleshoot 8003
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...d This error occurs when the DuckDB JDBC driver is not on the application's classpath, typically because the build tool has not resolved the dependency. If the Java application is unable to find t... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Tableau – A Data Visualization Tool 8003
- 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
...ors folder. Then launch Tableau Desktop from the Terminal with the command line argument to disable signature validation: /Applications/Tableau\ Desktop\ ⟨year⟩.⟨quarter⟩.app/Contents/MacOS/Tableau -DDisableVerifyConnectorPluginSignature=true You can also p...ackage this up with AppleScript by using the following script: do shell script "\"/Applications/Tableau Desktop 2023.2.app/Contents/MacOS/Tableau\" -DDisableVerifyConnectorPluginSignature=true" quit Create this file w...ith the Script Editor (located in /Applications/Utilities ) and save it as a packaged application : You can then double-click it to launch Tableau. You will need to chan... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Securing DuckDB 8003
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...ings. The right configuration depends on your use case, environment, and threat model. If you plan to embed DuckDB in your application, also consult the "Embedding DuckDB" page. Untrusted Input Untrusted SQL Input Warning Treat SQL in DuckDB like code in Ba...ldn't run an untrusted shell script or Python program without sandboxing, apply the same caution to SQL in DuckDB. If your application must execute SQL from untrusted sources, use additional safeguards when running untrusted code such as: Use duckdb-wasm fo...perating system-level sandboxing Use network isolation to prevent data exfiltration Implement strict query timeouts at the application level The settings described on this page provide defense-in-depth and can limit certain capabilities, but they are not a... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
DuckDB 2.0 Documentation / man.mtool.work