[sqlite] Compiler warnings in contributed extension-functions.c

Hi, I've integrated the extension-functions.c code into an R package so that these functions can be used in R via RSQLite. In the process, I came across a couple of compiler warnings that seemed to have easy fixes. I could not find contact information for Liam Healy so am posting this here.

Re: [sqlite] SQLite turns 10 years old (D. Richard Hipp)

> Thanks, everybody, for helping to make SQLite the most widely deployed > SQL database engine in the world. And Happy 10th Birthday to SQLite! > > D. Richard Hipp > d...@sqlite.org That SQLite made it ten years is testament to its focused initial design objectives, and unwavering adherence

[sqlite] FOR NEWBIES: SQLite Database Design

For those of you just getting started with designing applications that use SQLite, I have put together a YouTube channel that shows how to use SQL with SQLite. The channel is at: http://www.youtube.com/view_play_list?p=463DF6FFEF8D05FA Enjoy. Cheers, Jay Godse

[sqlite] FOR NEWBIES: SQLite Programming

For those of you just getting started with programming with SQLite, I have put together a YouTube playlist of videos showing how to program with the SQLite database in various programming languages. http://www.youtube.com/view_play_list?p=AA9B7C174493EC68 Enjoy. Cheers, Jay Godse

Re: [sqlite] Getting a "rowid" from a view

2010/5/29 Jim Terman : > Say I have a table of phone numbers > > CREATE TABLE phonebook (first_name TEXT, last_name TEXT, phone_number TEXT); > > I want to sort this by name, so I create a view > > CREATE VIEW phonebook_order AS SELECT first_name, last_name, > phone_number FROM

Re: [sqlite] WAL in SQLite

* Richard Hipp: > Good to know. Would moving to shm_open() help? I think it's difficult to clean up the shared memory segments when a database which had opened the database crashes. And access control would be very hard to get right, too. ___

[sqlite] Minor compiler warnings in contributed extension-functions.c

Hi, I've integrated the extension-functions.c code into an R package so that these functions can be used in R via RSQLite. In the process, I came across a couple of compiler warnings that seemed to have easy fixes. I could not find contact information for Liam Healy so am posting this here.

Re: [sqlite] WAL in SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/29/2010 07:01 PM, Richard Hipp wrote: >> Good to know. Would moving to shm_open() help? The problem is that unless the networked filesystem provides exclusive locks that can be retained by one client only then there will always be race