Man pages for blueraleigh/db
An R interface to SQLite
| cursor-class | An S4 class to wrap a prepared SQL statement |
| database-class | An S4 class to wrap a SQLite database connection |
| db.close | Close a database connection |
| DB.connections | An environment to store database connections |
| db.create_module | Register a virtual table module |
| db.delete_module | Unregister a virtual table module |
| db.dumpJSON | Dump the contents of a table or database into a JSON array |
| db.eval | Evaluate SQL statements |
| db.exec | Execute a SQL script |
| db.exists | Check for the existence of a database table, view, or index |
| db.fetch | Retrieve the rows from the result set of a query |
| db.fields | List the fields of a database table |
| db.fromJSON | Unserialize a JSON string to an R object |
| db.function | Register functions with a database connection |
| db.get | Get a registered database connection |
| db.help | Open the help documentation for a database |
| db.httpd | Respond to HTTP requests against a database |
| db.lapply | Apply a function to rows in a result set |
| db.open | Open a new database connection |
| db.param | Convert input parameters to expected format (list of lists) |
| db.prepare | Prepare a SQL statement for evaluation |
| db.register | Register a database connection |
| db.register_shadowname | Register a the name of shadow table for a virtual table |
| db.reply | Add text to the HTTP response |
| db.reply_file | Make the contents of a file the HTTP response |
| db.reply_header | Add a header to the HTTP response |
| db.reply_raw | Return a raw vector as the HTTP response |
| db.reply_redirect | Redirect to the given location |
| db.reply_status | Set the status code of the HTTP response |
| db.reply_type | Set the MIME type of the HTTP response |
| db.schema | List the schema of database tables |
| db.sqlar | Create a SQLite archive |
| db.sqlar_root | Return the root directory of a SQLite archive |
| db.sqlar_skeleton | Initialize the SQLite archive schema |
| db.sqlar_update | Update the content of a SQLite archive |
| db.subst | Simple expression substitution within strings |
| db.tables | List the tables in a database |
| db.toJSON | Serialize an R object to a JSON string |
| db.unregister | Unregister a database connection |
| db.unregister_shadowname | Unregister a shadow name |
| db.unsqlar | Unpack a SQLite archive. |
| db.urlpath | Retrieve elements of a URL path |
| db.virtualtable | Create a virtual table module |
| sqlar_compress | Compress data using gzip |
| sqlar_uncompress | Uncompress gzip'd data |
| virtualtable-class | An S4 class to implement new virtual table modules |
