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 week
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 mailing list
> sqlite-use
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 been for
a long time. This
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
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 multiple page sizes and conn
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
> and
> > it always took this long, but I wasn't
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
___
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 the excellent information in
>> https://www
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
>> SQLITE_CONFIG_MALLOC).
>
> However, the imp
9 matches
Mail list logo