Learn R Programming

ODB

R package to create, query and update OpenDocument Database (.odb) files.

Availability

A short presentation of the project can be found on my personnal website.

Release sources and builds can be found in the CRAN repository :

Development sources are freely available on GitHub :

All this material is freely distributed under the GNU Public License 3, shipped with sources and builds.

Support

Bugs, suggestions and help requests should be submitted using GitHub's Issues (see 'Availability').

Changelog

Release updates are tracked by the NEWS.Rd file, browsable on the CRAN repository (see 'Availability').

Individual commits can be followed on GitHub (see 'Availability').

Credits

Sylvain Mareschal <maressyl@gmail.com>

Copy Link

Version

Install

install.packages('ODB')

Monthly Downloads

188

Version

1.2.1

License

GPL (>= 3)

Maintainer

Sylvain Mareschal

Last Published

March 11th, 2020

Functions in ODB (1.2.1)

isClosed

Checks if a DBI connection is closed
odb.comments

Gets or sets column comments in an ODB database
difftimeFmt

Formats a time difference in multiple units
ODB-class

Class "ODB"
odb.open

Creates a connection to a .odb file
ODB-package

ODB
odb.create

Creates a .odb empty file.
odb.close

Closes an "ODB" connection and updates the .odb file
odb.insert

Wrapper for inserting data in an ODB table.
odb.export

Exports an ODB database to a SQL file.
progress-class

Classes "progress", "progress.file" and "progress.console"
odb.queries

Gets or sets stored queries in an ODB database
odb.read

Executes a reading SQL query in an ODB database (SELECT ...)
odb.write

Executes writing SQL queries in an ODB database (INSERT ...)
odb.tables

Gets description of every table in an ODB database.