[sqlite] Date as integer

2015-12-29 Thread Richard Hipp
On 12/29/15, Cecil Westerhof wrote: > I first had the following table: > CREATE TABLE simpleLog ( >datetimeTEXT NOT NULL PRIMARY KEY DEFAULT CURRENT_TIMESTAMP, >description TEXT NOT NULL > ) > > ?But datetime then takes 19 bytes. I understood you can also use an Integer > or Real and

[sqlite] whish list for 2016

2015-12-29 Thread Warren Young
On Dec 24, 2015, at 7:49 PM, Simon Slavin wrote: > > What makes "ALTER TABLE table-name DROP ?COLUMN" hard is checking the schema > to make sure that nothing in the schema refers to the dropped column. Given that the current alternative to this feature is hand-rolled code like I gave earlier

[sqlite] Using colation in Java

2015-12-29 Thread Rowan Worth
On 29 December 2015 at 08:23, Cecil Westerhof wrote: > When working in Python I can use: > con.create_collation("mycollation", collate) > > To change the sort order. How should I do this in Java? > Note there are multiple ways to use sqlite from java, so it would help to specify which

[sqlite] Using colation in Java

2015-12-29 Thread Cecil Westerhof
2015-12-29 1:35 GMT+01:00 Rowan Worth : > On 29 December 2015 at 08:23, Cecil Westerhof > wrote: > > > When working in Python I can use: > > con.create_collation("mycollation", collate) > > > > To change the sort order. How should I do this in Java? > > > > Note there are multiple ways to

[sqlite] Using colation in Java

2015-12-29 Thread Cecil Westerhof
When working in Python I can use: con.create_collation("mycollation", collate) To change the sort order. How should I do this in Java? -- Cecil Westerhof

[sqlite] SQLITE_DEFAULT_WORKER_THREADS & SQLITE_MAX_WORKER_THREADS

2015-12-29 Thread Olivier Mascia
Can you help me understand the intent in these lines? Referring to sqlite3.c amalgamation version 3.9.2 for Windows, lines 9531 to 9540: #ifndef SQLITE_MAX_WORKER_THREADS # define SQLITE_MAX_WORKER_THREADS 8 #endif #ifndef SQLITE_DEFAULT_WORKER_THREADS # define SQLITE_DEFAULT_WORKER_THREADS 0

[sqlite] SQLITE_DEFAULT_WORKER_THREADS & SQLITE_MAX_WORKER_THREADS

2015-12-29 Thread Simon Slavin
On 28 Dec 2015, at 11:24pm, Olivier Mascia wrote: > If SQLITE_MAX_WORKER_THREADS is not predefined, it defaults to 8. > If SQLITE_DEFAULT_WORKER_THREADS is predefined let's say to 12, then > SQLITE_MAX_WORKER_THREADS is raised to match the default. > > I must be missing something important