Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-02 Thread dd
>>The integrity check just takes too long so we don't. pragma quick_check; doesn't take much tme. http://www.sqlite.org/pragma.html#pragma_quick_check On Sun, Mar 3, 2013 at 8:00 AM, Jason Dictos wrote: > >> . > > > > Thanks for the details. What programming

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-02 Thread Jason Dictos
>> . > > Thanks for the details. What programming language do you use? (Dropbox > uses Python.) > C++ >> Early on we figured out quite quickly not leverage the read/write >> locking models of SQLite > > Do you use WAL mode? > I played with it early on but I didn't know how stable the

Re: [sqlite] Informal question

2013-03-02 Thread jic
"Simon Slavin" asked... Although there are many hobbyist programmers here, many of us are clearly using SQLite for our serious day jobs, and not just for playing with. So why is this list busy over the weekends rather than during the working week ? We are putting in place what we got

Re: [sqlite] backup api for sqlite4?

2013-03-02 Thread Richard Hipp
On Sat, Mar 2, 2013 at 3:30 PM, Rob Turpin wrote: > So I'm assuming saving in memory databases isn't an option with sqlite4. > Not in a single step at this time. You could, I suppose, implement the equivalent of the ".dump" command from the shell. The underlying data

Re: [sqlite] backup api for sqlite4?

2013-03-02 Thread Rob Turpin
So I'm assuming saving in memory databases isn't an option with sqlite4. On Sat, Mar 2, 2013 at 5:58 AM, Richard Hipp wrote: > On Sat, Mar 2, 2013 at 5:52 AM, Rob Turpin wrote: > > > The backup API for sqlite3 > > > > sqlite3_backup_init > >

Re: [sqlite] sqlite-users Digest, Vol 63, Issue 2

2013-03-02 Thread Peter Haworth
Hi Igor, Foreign keys are about maintaining the integrity of your database not performance so using a foreign key and creating an index are two different subjects. The foreign key will prevent an application from creating entries in the table that don't have a matching entry in the parent end of

Re: [sqlite] Informal question

2013-03-02 Thread Kevin Benson
On Sat, Mar 2, 2013 at 11:37 AM, Simon Slavin wrote: > Although there are many hobbyist programmers here, many of us are clearly > using SQLite for our serious day jobs, and not just for playing with. So > why is this list busy over the weekends rather than during the

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread kyan
On Sat, Mar 2, 2013 at 6:02 PM, Simon Slavin wrote: > Nevertheless, you do now understand that there are no magic undocumented > calls in SQLite that people are using to do things like his. Which is what > your question was. OK, thanks again.

Re: [sqlite] SQLite 3.7.16 beta

2013-03-02 Thread Eric Sink
FWIW: I am working on a project which uses SQLite extensively. We generally use 3.7.11 on our client side and 3.7.15.2 on our server. I just switched both to this 3.7.16 beta, and all our automated tests still pass. -- E ___ sqlite-users

[sqlite] Suggestion for cache_size pragma documentation

2013-03-02 Thread Richard Allen
Regarding the 'cache_size' pragma documentation@http://www.sqlite.org/pragma.html - Could a note be added stating the version number(3.7.10) where a negative cache_size began to mean a number of kByte instead of a number of pages? In earlier versions, a negative cache_size was interpreted as

Re: [sqlite] Break on cumulative sum

2013-03-02 Thread Michael Black
And I just noticed that should probably be when new.BreakPoint <= -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche Sent: Saturday, March 02, 2013 10:49 AM To: General Discussion of SQLite Database Subject:

Re: [sqlite] Break on cumulative sum

2013-03-02 Thread Gert Van Assche
Michael, this is working perfectly! I learned a lot with your code. Thanks a lot for your help. gert 2013/3/2 Michael Black > I think your "K" row was a typo on the CumulativeValue? > > CREATE TABLE [Test] (TextField, ValueField, CumulativeValue, BreakPoint > DEFAULT 10,

Re: [sqlite] Informal question

2013-03-02 Thread Richard Hipp
On Sat, Mar 2, 2013 at 11:37 AM, Simon Slavin wrote: > Although there are many hobbyist programmers here, many of us are clearly > using SQLite for our serious day jobs, and not just for playing with. So > why is this list busy over the weekends rather than during the

Re: [sqlite] SQLite 3.7.16 beta

2013-03-02 Thread Richard Hipp
On Sat, Mar 2, 2013 at 11:36 AM, Simon Slavin wrote: > > On 2 Mar 2013, at 4:29pm, Richard Hipp wrote: > > > (1) http://www.sqlite.org/draft/releaselog/3_7_16.html > > "Enhance the command-line shell so that a non-zero argument to the ".exit" > command

[sqlite] Informal question

2013-03-02 Thread Simon Slavin
Although there are many hobbyist programmers here, many of us are clearly using SQLite for our serious day jobs, and not just for playing with. So why is this list busy over the weekends rather than during the working week ? Simon. ___ sqlite-users

Re: [sqlite] SQLite 3.7.16 beta

2013-03-02 Thread Simon Slavin
On 2 Mar 2013, at 4:29pm, Richard Hipp wrote: > (1) http://www.sqlite.org/draft/releaselog/3_7_16.html "Enhance the command-line shell so that a non-zero argument to the ".exit" command causes the shell to exist immediately without cleanly shutting down the database

[sqlite] SQLite 3.7.16 beta

2013-03-02 Thread Richard Hipp
The anticipated release date for SQLite 3.7.16 is currently 2013-03-12. Additional information about the forthcoming 3.7.16 release: (1) http://www.sqlite.org/draft/releaselog/3_7_16.html (2) http://www.sqlite.org/draft/download.html (3) http://www.sqlite.org/checklists/3071600 See a

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread Simon Slavin
On 2 Mar 2013, at 3:19pm, kyan wrote: > Thank you for your response Simon. > > On Sat, Mar 2, 2013 at 3:51 PM, Simon Slavin wrote: >> SQLite isn't at its root a DDL. It's a C API, fully documented here: >> >>

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread kyan
Thank you for your response Simon. On Sat, Mar 2, 2013 at 3:51 PM, Simon Slavin wrote: > SQLite isn't at its root a DDL. It's a C API, fully documented here: > > > > That's SQLite and that's its full documentation. As designed, to add

Re: [sqlite] Break on cumulative sum

2013-03-02 Thread Michael Black
I think your "K" row was a typo on the CumulativeValue? CREATE TABLE [Test] (TextField, ValueField, CumulativeValue, BreakPoint DEFAULT 10, GroupName); CREATE TABLE [MyGroup](GroupName); insert into [MyGroup] values(1); create trigger trig1 before insert on [Test] when 10 <= (select

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread Simon Slavin
On 2 Mar 2013, at 1:24pm, kyan wrote: > On Tue, Jan 1, 2013 at 8:01 PM, Peter Haworth wrote: >> There are plenty of third party tools out there that will take care of >> adding/removing constraints to existing tables and a whole lot of other >> functions

[sqlite] Break on cumulative sum

2013-03-02 Thread Gert Van Assche
All, I don't know how to achieve this: I need to put the cumulative sum in a field, and create a group as soon as that cumulative sum is over a breakpoint value (10). This is an example table: CREATE TABLE [Test] (TextField, ValueField, CumulativeValue, BreakPoint DEFAULT 10, GroupName); insert

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread kyan
On Tue, Jan 1, 2013 at 8:01 PM, Peter Haworth wrote: > There are plenty of third party tools out there that will take care of > adding/removing constraints to existing tables and a whole lot of other > functions that aren't available in SQLite's DDL, while accounting for all >

Re: [sqlite] backup api for sqlite4?

2013-03-02 Thread Richard Hipp
On Sat, Mar 2, 2013 at 5:52 AM, Rob Turpin wrote: > The backup API for sqlite3 > > sqlite3_backup_init > sqlite3_backup_step > sqlite3_backup_finish > > I can't find anything similar in sqlite4. Is there any, or plans for it? > There are no pressing plans. It isn't on the

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread Ryan Johnson
On 01/03/2013 8:08 PM, Stephen Chrzanowski wrote: On Fri, Mar 1, 2013 at 11:48 AM, Ryan Johnson wrote: On 01/03/2013 11:10 AM, Stephen Chrzanowski wrote: ***I'm waiting for the repair man to show up to fix my waterheater... so... I'm bored. This is going to be to

Re: [sqlite] Is there a way to create a foreign key in existing table?

2013-03-02 Thread Ryan Johnson
On 01/03/2013 4:09 PM, Igor Korot wrote: Ryan, On Fri, Mar 1, 2013 at 12:48 PM, Ryan Johnson wrote: On 01/03/2013 2:23 PM, Igor Korot wrote: Hi, guys, On Fri, Mar 1, 2013 at 8:48 AM, Ryan Johnson wrote: On 01/03/2013 11:10 AM,

[sqlite] backup api for sqlite4?

2013-03-02 Thread Rob Turpin
The backup API for sqlite3 sqlite3_backup_init sqlite3_backup_step sqlite3_backup_finish I can't find anything similar in sqlite4. Is there any, or plans for it? Thanks, Rob ___ sqlite-users mailing list sqlite-users@sqlite.org