Results of 1 - 10 of about 23 for Handle (0.004 sec.)
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 15986
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ge to the official Microsoft ODBC documentation , which is a great resource for learning more about ODBC. General Concepts Handles Connecting Error Handling and Diagnostics Buffers and Binding Handles A handle is a pointer to a specific ODBC object whi...ch is used to interact with the database. There are several different types of handles, each with a different purpose, these are the environment handle, the connection handle, the statement handle, and the de...scriptor handle. Handles are allocated using the SQLAllocHandle which takes as input the type of handle to allocate, and a pointer to the... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
- Startup & Shutdown – DuckDB 9149
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ocumentation / Client APIs / C Copy Markdown Startup & Shutdown 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 (...-memory database no data is persisted to disk (i.e., all data is lost when you exit the process). With the duckdb_database handle, you can create one or many duckdb_connection using duckdb_connect() . While individual connections are thread-safe, they...with duckdb_disconnect() and the duckdb_database has to be explicitly closed with duckdb_close() to avoid memory and file handle leaking. Example duckdb_database db ; duckdb_connection con ; if ( duckdb_open ( NULL , & db ) == DuckDBError ) { // handl... - https://man.mtool.work/duckdb/1.3/clients/c/connect.html
- Python – DuckDB 8964
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...g Extensions Before thinking about statically linking extensions you should know that the Python package currently doesn't handle linked in extensions very well. If you don't really need to have an extension baked in than the advice is to just stick to...he DuckDB Python API, you'll need to manually add corresponding type hints to the stub files. What are py::objects and py::handles? These are classes provided by pybind11, the library we use to manage our interaction with the Python environment. py::ha...ndle is a direct wrapper around a raw PyObject* and does not manage any references. py::object is similar to py::handle but it can handle refcounts. I say can because it doesn't have to, using py::reinterpret_borrow<py::object>(...) we can cr... - https://man.mtool.work/duckdb/1.3/dev/building/python.html
- Query – DuckDB 8680
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...le state = duckdb_query ( con , "CREATE TABLE integers (i INTEGER, j INTEGER);" , NULL ); if ( state == DuckDBError ) { // handle error } // insert three rows into the table state = duckdb_query ( con , "INSERT INTO integers VALUES (3, 4), (5, 6), (7,...NULL);" , NULL ); if ( state == DuckDBError ) { // handle error } // query rows again state = duckdb_query ( con , "SELECT * FROM integers" , & result ); if ( state == DuckDBError...) { // handle error } // handle the result // ... // destroy the result after we are done with it duckdb_destroy_result ( & result ); Va... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Rust Client – DuckDB 8613
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...B C API , please refer to the README for details. Startup & Shutdown To use duckdb, you must first initialize a Connection handle using Connection::open() . Connection::open() takes as parameter the database file to read and write from. If the database.... This is not much difference between these in the typical case, but in case there is an error, you'll have the chance to handle it with the explicit close. Querying SQL queries can be sent to DuckDB using the execute() method of connections, or we ca..., 10 ]]) ? ; Ok (()) } 関連キーワード Connection person conn DuckDB Rust duckdb database memory client also Client details handle using params case execute prepare query Person stmt iter Appender rows Documentation 関連するページ Prepared Statements Ja... - https://man.mtool.work/duckdb/1.3/clients/rust.html
- Configuration – DuckDB 8143
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...b ; duckdb_config config ; // create the configuration object if ( duckdb_create_config ( & config ) == DuckDBError ) { // handle error } // set some configuration options duckdb_set_config ( config , "access_mode" , "READ_WRITE" ); // or READ_ONLY duc...); // open the database using the configuration if ( duckdb_open_ext ( NULL , & db , config , NULL ) == DuckDBError ) { // handle error } // cleanup the configuration object duckdb_destroy_config ( & config ); // run queries... // cleanup duckdb_close... - https://man.mtool.work/duckdb/1.3/clients/c/config.html
- Prepared Statements – DuckDB 8093
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...duckdb_result result ; if ( duckdb_prepare ( con , "INSERT INTO integers VALUES ($1, $2)" , & stmt ) == DuckDBError ) { // handle error } duckdb_bind_int32 ( stmt , 1 , 42 ); // the parameter index starts counting at 1! duckdb_bind_int32 ( stmt , 2 , 4...sing prepared statements if ( duckdb_prepare ( con , "SELECT * FROM integers WHERE i = ?" , & stmt ) == DuckDBError ) { // handle error } duckdb_bind_int32 ( stmt , 1 , 42 ); duckdb_execute_prepared ( stmt , & result ); // do something with result // c... - https://man.mtool.work/duckdb/1.3/clients/c/prepared.html
- Star Expression – DuckDB 8093
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...separate columns. This is particularly useful when a prior operation creates a struct of unknown shape, or if a query must handle any potential struct keys. See the STRUCT data type and STRUCT functions pages for more details on working with structs. F...separate columns. This is particularly useful when a prior operation creates a struct of unknown shape, or if a query must handle any potential struct keys. See the STRUCT data type and STRUCT functions pages for more details on working with structs. F... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- S3 Parquet Import – DuckDB 7909
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...mmand: SELECT * FROM read_parquet ( 's3:// bucket / file ' ); Google Cloud Storage (GCS) and Cloudflare R2 DuckDB can also handle Google Cloud Storage (GCS) and Cloudflare R2 via the S3 API. See the relevant guides for details. 関連キーワード httpfs ex... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_import.html
- ODBC API on Linux – DuckDB 7858
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t performs the configuration of the DuckDB ODBC Driver. It is based on the unixODBC package that provides some commands to handle the ODBC setup and test like odbcinst and isql . Run the following commands with either option -u or -s to configure DuckD... - https://man.mtool.work/duckdb/1.3/clients/odbc/linux.html
DuckDB 1.3 Documentation / man.mtool.work