| Title: | 'Arrow' Database Connectivity ('ADBC') 'SQLite' Driver |
| Version: | 0.20.0 |
| Description: | Provides a developer-facing interface to the 'Arrow' Database Connectivity ('ADBC') 'SQLite' driver for the purposes of building high-level database interfaces for users. 'ADBC' https://arrow.apache.org/adbc/ is an API standard for database access libraries that uses 'Arrow' for result sets and query parameters. |
| License: | Apache License (≥ 2) |
| Encoding: | UTF-8 |
| RoxygenNote: | 7.3.2 |
| SystemRequirements: | SQLite3 |
| Suggests: | nanoarrow, testthat (≥ 3.0.0) |
| Config/testthat/edition: | 3 |
| Config/build/bootstrap: | TRUE |
| URL: | https://arrow.apache.org/adbc/current/r/adbcsqlite/, https://github.com/apache/arrow-adbc |
| BugReports: | https://github.com/apache/arrow-adbc/issues |
| Imports: | adbcdrivermanager |
| NeedsCompilation: | yes |
| Packaged: | 2025-09-16 17:05:26 UTC; dewey |
| Author: | Dewey Dunnington 
[aut, cre],
Apache Arrow [aut, cph],
Apache Software Foundation [cph] |
| Maintainer: | Dewey Dunnington <dewey@dunnington.ca> |
| Repository: | CRAN |
| Date/Publication: | 2025-09-16 19:10:02 UTC |
adbcsqlite: 'Arrow' Database Connectivity ('ADBC') 'SQLite' Driver
Description
Provides a developer-facing interface to the 'Arrow' Database Connectivity ('ADBC') 'SQLite' driver for the purposes of building high-level database interfaces for users. 'ADBC' https://arrow.apache.org/adbc/ is an API standard for database access libraries that uses 'Arrow' for result sets and query parameters.
Author(s)
Maintainer: Dewey Dunnington dewey@dunnington.ca (ORCID)
Authors:
Apache Arrow dev@arrow.apache.org [copyright holder]
Other contributors:
Apache Software Foundation dev@arrow.apache.org [copyright holder]
See Also
Useful links:
Report bugs at https://github.com/apache/arrow-adbc/issues
ADBC SQLite3 Driver
Description
ADBC SQLite3 Driver
Usage
adbcsqlite()
## S3 method for class 'adbcsqlite_driver_sqlite'
adbc_database_init(driver, ..., uri = ":memory:")
## S3 method for class 'adbcsqlite_database'
adbc_connection_init(database, ..., adbc.connection.autocommit = NULL)
## S3 method for class 'adbcsqlite_connection'
adbc_statement_init(
connection,
...,
adbc.ingest.target_table = NULL,
adbc.ingest.mode = NULL,
adbc.sqlite.query.batch_rows = NULL
)
Arguments
driver |
An |
... |
Driver-specific options. For the default method, these are named values that are converted to strings. |
uri |
A URI to a database path or ":memory:" for an in-memory database. |
database |
An adbc_database. |
adbc.connection.autocommit |
Use FALSE to disable the default autocommit behaviour. |
connection |
|
adbc.ingest.target_table |
The name of the target table for a bulk insert. |
adbc.ingest.mode |
Whether to create (the default) or append. |
adbc.sqlite.query.batch_rows |
The number of rows per batch to return. |
Value
An adbcdrivermanager::adbc_driver()
Examples
adbcsqlite()