Results of 1 - 10 of about 18 for program (0.002 sec.)
- Statically Linking Extensions 11873
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...o_minutes(5) reports that the function exists in the core_functions extension, even though that extension was linked in. A program can also skip the generated loader and call duckdb_register_static_extension directly on the describe functions it declare...tributes nothing, and a registered extension whose archive is missing fails the link. Calling the Loader Before main A C++ program that wants registration to happen automatically before main compiles extension/loader/static_extension_autoregister.cpp al...ongside the loader. Compile it into the program itself, not into an archive, or the linker drops it. If you do package the loader and the auto-register object into an arc... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Debugging 11873
- The purpose of the tests is to figure out when things break. Inevitably changes made to the system will cause one of the tests to fail, and when that happens the test needs to be debugged. First, it is always recommended to run in debug mod
...running a subset of the tests see the Triggering which tests to run section. After that, a debugger can be attached to the program and the test can be debugged. In the sqllogictests it is normally difficult to break on a specific query, however, we have...kip . Any queries between the two statements will not be executed. Triggering Which Tests to Run When running the unittest program, by default all the fast tests are run. A specific test can be run by adding the name of the test as an argument. For the... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/debugging.html
- Tableau – A Data Visualization Tool 10672
- 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
...e multiple filenames in use. Download the JAR file . macOS: Copy it to ~/Library/Tableau/Drivers/ . Windows: Copy it to C:\Program Files\Tableau\Drivers . Linux: Copy it to /opt/tableau/tableau_driver/jdbc . Using the PostgreSQL Dialect If you just want...Taco file.) Server (Online) On Linux, copy the Taco file to /opt/tableau/connectors . On Windows, copy the Taco file to C:\Program Files\Tableau\Connectors . Then issue these commands to disable signature validation: tsm configuration set -k native_api.... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Internal Errors 10260
- Internal errors signal an assertion failure within DuckDB. They usually occur due to unexpected conditions or errors in the program's logic. For example, running issue 17002 on DuckDB 1.2.1 results in an internal error. INTERNAL Error: Atte
... - https://man.mtool.work/duckdb/2.0/dev/internal_errors.html
- Dot Commands 9454
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...mode section .excel Display the output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this program with return-code CODE .headers ⟨on/off⟩ Turn display of headers on or off . Does not apply to duckbox mode .help ⟨-all⟩ ⟨P...COMPONENT⟩ Set the progress bar component styles .prompt ⟨OPTIONS⟩ ⟨CONTINUE⟩ Replace the standard prompts .quit Exit this program .read ⟨FILE⟩ Read input from FILE .read_line_version ⟨linenoise/fallback⟩ Set the library used for processing interactive...s) to the .once command, query results can also be sent to a temporary file and automatically opened in the user's default program. Use either the -e flag for a text file (opened in the default text editor), or the -x flag for a CSV file (opened in the... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- INSERT Statements 9454
- INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual I
...will be called for every statement. This is typically unnecessary when bulk loading and will significantly slow down your program. Tip If you absolutely must use INSERT statements in a loop to load data, wrap them in calls to BEGIN TRANSACTION and COMM... - https://man.mtool.work/duckdb/2.0/data/insert.html
- Startup & Shutdown 9059
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
...alified ); duckdb_create_instance_cache Creates a new database instance cache. The instance cache is necessary if a client/program (re)opens multiple databases to the same file within the same process. Must be destroyed with 'duckdb_destroy_instance_cac...any database allocated through duckdb_open or duckdb_open_ext . Note that failing to call duckdb_close (in case of e.g., a program crash) will not cause data corruption. Still, it is recommended to always correctly close a database object after you are... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Executing SQL in Python 8664
- SQL queries can be executed using the duckdb.sql function. import duckdb duckdb.sql("SELECT 42").show() By default this will create a relation object. The result can be converted to various formats using the result conversion functions. For
...42 0 42 By default, a global in-memory connection will be used. Any data stored in it will be lost after shutting down the program. A connection to a persistent database can be created using the connect function. After connecting, SQL queries can be exe... - https://man.mtool.work/duckdb/2.0/guides/python/execute_sql.html
- Handle Results 8253
- 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
...rguments, the same as database/sql queries . Registering an Arrow Stream as a View An Arrow stream produced elsewhere in a program, an array.RecordReader , can be registered as a DuckDB view and queried in SQL. RegisterView() takes the reader and a view... - https://man.mtool.work/duckdb/2.0/clients/go/result_handling.html
- Deploy as Native Image 7858
- 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
...b on macOS, duckdb_java.dll on Windows. The lookup is anchored to the executable rather than the working directory, so the program runs correctly from anywhere. This option produces a small executable, under 20 MB for a simple application, with no extra... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
DuckDB 2.0 Documentation / man.mtool.work