On Fri, Dec 21, 2012 at 12:53 AM, Larry Brasfield wrote:
> On 12/20/2012 4:10 PM, Larry Brasfield wrote:
>> > Igor Tandetnik wrote:
>> [regarding where parameters allowed, "where literals are"]
>> >> >
>> >> > How did you discern this?
>> >>
>> >> I know from
I think there is a documentation error on
http://sqlite.org/lang_corefunc.html
for the instr() function.
The site says: The instr(X,Y) function finds the first occurrence of
string X within string Y ...
where it should be ...finds the first occurrence of string Y within
string X...
Thanks,
Hello,
We are facing a problem with the '.backup' command using the SQLite
command line interface. The resulting backup-database seems to be corrupt.
We ran into this problem on a ARM9 platform using SQLite 3.7.5, but it
can also be reproduced on the latest 3.7.15.1 version on Intel.
I
Can you please try running "pragma integrity_check;" on the original
database? That will give an indication of whether the original database
has any data corruption.
On Fri, Dec 21, 2012 at 4:13 AM, Marco ten Thije <
marco.tenth...@usetechnology.nl> wrote:
> Hello,
>
> We are facing a problem
It returns 'ok':
./sqlite3 energy.sqlite
SQLite version 3.7.15.1 2012-12-19 20:39:10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma integrity_check;
ok
sqlite>
So, the original database looks ok.
I have compared the two databases (original and backup)
On 12/21/2012 08:46 PM, Marco ten Thije wrote:
It returns 'ok':
./sqlite3 energy.sqlite
SQLite version 3.7.15.1 2012-12-19 20:39:10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma integrity_check;
ok
sqlite>
So, the original database looks ok.
I have
On 20 Dec 2012, at 11:16pm, Arun Jagatheesan
wrote:
> Are there any community standard benchmarks (scripts) that are more
> sqlite oriented available?
If you're looking for speed tests, then there isn't really anything relevant.
The amount of time SQLite
What is the size of the two database files?
The size of both files is 160768 bytes.
Also, can we have the first 6 lines of each hex dump
(i.e. enough to see the first 100 bytes)?
The first bytes of the original database:
000 5153 694c 6574 6620 726f 616d 2074 0033
010 0004 0101
On 12/21/2012 10:54 PM, Marco ten Thije wrote:
What is the size of the two database files?
The size of both files is 160768 bytes.
Also, can we have the first 6 lines of each hex dump
(i.e. enough to see the first 100 bytes)?
The first bytes of the original database:
000 5153 694c
9 matches
Mail list logo