[sqlite] Feature request

Dear list, I often have to use SQLite strftime() to compute a week number but the only proposed format '%W' causes problems. Not only that north-american week number has a varying range [00..52] or [01..53] but some years (e.g. 2012, 2040) yield a result in [00..53], making those years 54

Re: [sqlite] View column data type affinity?

Yes, by giving the column a type, that determines its affinity. On Sun, Jan 15, 2017 at 8:08 PM, Joe Seeley wrote: > Is there a way when creating a view to specify the data type affinity for > each column? > ___ > sqlite-users

Re: [sqlite] View column data type affinity?

On 1/15/17, Joe Seeley wrote: > Is there a way when creating a view to specify the data type affinity for > each column? Make each in the SELECT that implements the view be of the form: CAST(column AS TYPE) Type affinity for views and subqueries is messed up. It has

[sqlite] View column data type affinity?

Is there a way when creating a view to specify the data type affinity for each column? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multiple sessions, page sizes and cache

On 1/15/17, Kim Gräsman wrote: > > 1) If I configure a global SQLite heap with SQLITE_CONFIG_HEAP, won't > I just trade malloc heap fragmentation for SQLite private heap > fragmentation? Or does SQLite's fragmentation-prevention strategy work > well even in the face of

Re: [sqlite] possible integrity problem

On Sat, Jan 14, 2017 at 5:04 PM, Simon Slavin wrote: > > On 15 Jan 2017, at 1:01am, Kevin O'Gorman wrote: > > > Update: the integrity check said "ok" after about 1/2 hour. > > the record count now takes about 4 seconds -- maybe I remembered wrong >

Re: [sqlite] Insert into with Id...

Dear Mr. Simon: Today, early in the morning, I have reviewed the former ExcelToSQLite.exe and try to run it with data from my last application. I have corrected some mistakes and pretty work. I thought my problems was solved. Thanks very much, Ing. Héctor F. Fiandor Rosario

Re: [sqlite] Multiple sessions, page sizes and cache

Hi Richard, On Sat, Jan 14, 2017 at 2:17 PM, Richard Hipp wrote: > On 1/13/17, Kim Gräsman wrote: >> >> In an effort to reduce memory usage/fragmentation, we're trying to >> configure SQLite to allocate as much memory as necessary up-front >> (based on

Re: [sqlite] Multiple sessions, page sizes and cache

On Sat, Jan 14, 2017 at 1:09 PM, Simon Slavin wrote: > > On 14 Jan 2017, at 8:54am, Clemens Ladisch wrote: > >> If your use case is more complex than the simple mechanism offered by >> SQLITE_CONFIG_PAGECACHE, consider using SQLITE_CONFIG_PCACHE2 (or >>