[R-sig-DB] RSQLite 1.0.0

[Hadley Wickham]

I've just pushed a potential fix. Can you please check?
Hadley

On Tue, Sep 23, 2014 at 6:54 PM, Gabor Grothendieck
<ggrothendieck using gmail.com> wrote:
> I get this error when building RSQLite from source under Windows 8.1
> using github_install:
>
> extension-functions.c:124:24: fatal error: sqlite3ext.h: No such file
> or directory
>
>
>
>
> On Tue, Sep 23, 2014 at 6:10 PM, Hadley Wickham <h.wickham using gmail.com> wrote:
>> Hi everyone,
>>
>> I'm preparing to release a new version of RSQLite, 1.0.0.  (I've taken
>> over maintenance from Seth Falcon). This release is basically a big
>> tidy up - I've refactored a lot of the C code to be easier to follow,
>> deprecated a lot of unused functions, and converted everything to
>> "Hadley"-style package development.  A complete list of changes are
>> included at the bottom of this email.
>>
>> If you use RSQLite, I'd really appreciate it if you'd try out the
>> development version and let me know if you have any problems. You can
>> install it from github with:
>>
>> # install.packages("devtools")
>> devtools::install_github("rstats-db/DBI")
>> devtools::install_github("rstats-db/RSQLite")
>>
>> If you have written a package that depends on RSQLite, please check
>> the list of R CMD check results at
>> https://github.com/wch/checkresults/blob/master/RSQLite/r-release/00check-summary.txt.
>> I've been quite aggressive at deprecating old functions, and
>> un-exporting functions that are really part of RSQLite's internal
>> interface. This means that many packages will need changes. If you
>> have any trouble figuring out the problem, please let me know and I'll
>> be happy to help. I apologise for the hassle, but this will make
>> RSQLite a much better platform to build on in the future.
>>
>> I plan to submit this version of RSQLite to CRAN on Oct 20, so that
>> there's plenty of time for feedback and changes.
>>
>> Hadley
>>
>> # Version 1.0.0
>>
>> ## New features
>>
>> - Updated to SQLite 3.8.6
>>
>> - Added `datasetsDb()`, a bundled SQLite database containing all data frames
>>   in the datasets package (#15).
>>
>> - Inlined `RSQLite.extfuns` - use `initExtension()` to load the many
>>   useful extension functions (#44).
>>
>> - Methods no longer automatically clone the connection is there is an open
>>   result set. This was implement inconsistently in a handful of places (#22).
>>   RSQLite is now more forgiving if you forget to close a result set - it will
>>   close it for you, with a warning. It's still good practice to clean up
>>   after yourself, but you don't have to.
>>
>> - `dbBegin()`, `dbCommit()`, `dbRollback()` throw errors on failure, rather than
>>   return `FALSE`.  They all gain a `name` argument to specify named savepoints.
>>
>> - `dbFetch()` method added (`fetch()` will be deprecated in the future)
>>
>> - `dbRemoveTable()` throws errors on failure, rather than returning `FALSE`.
>>
>> - `dbWriteTable()` has been rewritten:
>>
>>     * It quotes field names using `dbQuoteIdentifier()`, rather
>>       than use a flawed black-list based approach with name munging.
>>
>>     * It now throws errors on failure, rather than returning FALSE.
>>
>>     * It will automatically add row names only if they are character,
>> not integer.
>>
>>     * When loading a file from disk, `dbWriteTable()` will no longer
>>       attempt to guess the correct values for `row.names` and `header` - instead
>>       supply them explicitly if the defaults are incorrect.
>>
>>     * It uses named save points so it can be nested inside other
>>       transactions (#41).
>>
>>     * When given a zero-row data frame it will just creates the table
>>       definition (#35).
>>
>> ## Changes to objects
>>
>> - The `dbname`, `loadable.extensions`, `flags` and `vfs` properties of
>>   a SqliteConnection are now slots. Access them directly instead of using
>>   `dbGetInfo()`.
>>
>> ## Deprecated and removed functions
>>
>> - RSQLite is no longer nominally compatible with S (#39).
>>
>> - `idIsValid()` is deprecated. Please use `dbIsValid()` instead.
>>
>> - `dbBeginTransaction()` has been deprecated. Please use `dbBegin()` instead.
>>
>> - `dbCallProc()` method removed, since generic is now deprecated.
>>
>> - Renamed `dbBuildTableDefinition()` to `sqliteBuildTableDefinition()`
>>   to avoid implying it's a DBI generic. Old function is aliased to new with
>>   a warning.
>>
>> - `dbFetch()` no longer numbers row names sequentially between fetches.
>>
>> - `safe.write()` is no longer exported as it shouldn't be part of the
>>   public RSQLite interface (#26).
>>
>> - Internal `sqlite*()` functions are no longer exported (#20).
>>
>> - Removed `SqliteObject` and `dbObject` classes, modifying `SqliteDriver`,
>>   `SqliteConnection`, and `SqliteResult` to use composition instead of multiple
>>   inheritance.
>>
>> --
>> http://had.co.nz/
>
>
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com



-- 
http://had.co.nz/