On 08/28/2015 09:36 PM, Scott Robison wrote:
> On Fri, Aug 28, 2015 at 3:47 AM, Yahoo! Mail yahoo.com
>> wrote:
>>
>> On 08/26/2015 09:03 PM, Richard Hipp wrote:
>>
>> Time stands still for multiple rows, as long as they are within the
>>> same sql
ith 10 rows only; it *should* have
finished within milliseconds, but it repeated the same task as
above, even the database size remained the same (28GB that is).
On 08/28/2015 05:45 PM, R.Smith wrote:
>
>
> On 2015-08-28 03:09 PM, Yahoo! Mail wrote:
>> Where did you
mith wrote:
>
> On 2015-08-28 01:17 PM, Yahoo! Mail wrote:
>> Obviously you did not get my issue; something is wrong and your timer
>> suggestion indicates this. During the execution of each command, I
>> would monitor it with *watch "du test.db*"*. The j
; create table t1(a datetime); vacuum t1;
begin; with recursive c(x) as (values(1) union all select x + 1 from c
where x < 100) insert into t1(a) select datetime('now') from c; commit;
Run Time: real 209.612 user 4.724000 sys 21.588000*
On 08/28/2015 01:48 PM, Clemens Ladisch wrote:
>
On 08/26/2015 09:03 PM, Richard Hipp wrote:
> Time stands still for multiple rows, as long as they are within the
> same sqlite3_step() call. For example, if you run:
>
> CREATE TABLE t1(a DATETIME);
> WITH RECURSIVE
> c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE
I run a simple search on a Windows XP (virtual) machine of mine and
found the following programs using SQLite:
* Adobe Reader
* Adobe Acrobat Professional
* Avira Antivir (almost 400 million use it based on their official
website)
* Apple Application Support
On 05/03/2015 11:32
How about curl? This is taken directly from the official website:
" curl is used in command lines or scripts to transfer data. It is also
used in cars, television sets, routers, printers, audio equipment,
mobile phones, tablets, settop boxes, media players and is the internet
transfer backbone
Please dnt spam my email
Hi everyone!
Im Brazilian, also, Android Dev.
Im in a struggle with Sqlite and accented chars such as á or é.
What Im trying to do is a select with where accent insensitive.
For months I have having research over and over the internet to accomplish
that, but, unfortunately unsuccessful.
On 11 Aug, Gerry Snyder wrote:
> fred238 wrote:
>> Gerry Snyder a écrit :
>>> fred238 wrote:
Is necessary to set column datatype in sqlite3 ?
Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER,
REAL, NONE) ?
>>> Check out http://www.sqlite.org/datatype3.html
Hi,
I'm developing a small reception application for staff to use.
The app records visitors signing in and out of the building.
CREATE TABLE av2 (
Activity_ID INTEGER PRIMARY KEY,
Timestamp TIMESTAMP,
Visitor_ID VARCHAR(8),
Action VARCHAR(1),
Message VARCHAR(255));
insert into av2
11 matches
Mail list logo
