NEWS.md

In tjpalanca/dbtools: Database Tools for R

dbtools 0.2.0

• Writable Tibbles using (tbl_db)
• Use tbl_db() just like [dplyr::tbl] to generate a lazy loaded sql table, with the difference that you can write to the table.
• New methods to supplement lack of them in {DBI} interface, initially just for the initial support set of PostgreSQL and SQLite.
  • dbPrimaryKey() - fetch the names of the primary key columns
  • dbInTransaction() to determine if the transaction is active
  • dbSetConnId() to add identifiers to the connection
• Operations to perform on tbl_db that mimic {DBI} but operate on a table
  • execute()
  • connect()
• Transaction Control (TCL)
  • begin()
  • commit()
  • rollback()
  • transact()
  • in_transaction()
• Data Manipulation (DML) powered by {dbx}
  • insert()
  • update()
  • upsert()
  • delete()
• df_db() is generated whenever a tbl_db() is collected, so that one can perform atbitrary transformations in memory while still being able to retain a connection to the DB for data manipulation statements.
• Package
• Add License check to ensure valid licenses

dbtools 0.1.0

• Features
• Construct and Deconstruct functions translate between objects and data frames, inspired by the Strapping.jl library in Julia.
• Package
• Test Coverage
• Hex Sticker
• README badge

dbtools 0.0.0.9000

• Added a NEWS.md file to track changes to the package.

tjpalanca/dbtools documentation built on Oct. 7, 2021, 6:43 a.m.