https://www.sqlite.org/src/info/24f258c239229016
Line 809:
should not
vstat_vfs.base.szOsFile = sizeof(VStatFile) + pNew->pVfs->szOsFile;
be
vstat_vfs.base.szOsFile = sizeof(VStatFile) + vstat_vfs->pVfs->szOsFile;
___
sqlite-users mailing li
Hi,
In one application I am using sqlite database as file container
I found very convenient to have a new function that permits comparing
the contents of
a blob and a file directly.
I've coded that function and it is tested successfully
So this is my proposal for adding this new function in sq
Hi Richard,
Thanks for getting back to me.
I agree it seems like the same bug.
Best regards,
j-
On Sat, May 28, 2016 at 4:19 AM, Richard Hipp wrote:
> On 5/27/16, Jonathan Brossard wrote:
> >
> > I'd like to report a heap overflow, please find an advisory attached to
> > this email.
> >
>
>
Simon wrote on Tue, 31 May 2016 16:28:55 +0100
>You can find the version Unix chooses to run using the "which" command:
>simon$ which sqlite3
>/usr/bin/sqlite3
Right, that's the way it works on practically all *n?x based systems.
What I do is changing the $PATH so Darwin's bash looks first in the
> I tried your example and got ~0.45s for json and ~0.37s for my
> implementation;
I have also tried a custom virtual table, and I also get figures about
20-30% faster than with json.
> Interesting: when NOT using "primary key" (I have a flag for this), the
> times are ~ 0.26s vs 0.18s vs 0.47s !
Sorry, forgot a key point.
You can find the version Unix chooses to run using the "which" command:
simon$ which sqlite3
/usr/bin/sqlite3
so you may have multiple copies of sqlite3 installed but that command will tell
you which one Unix will run if you just type the name of the executable.
Simo
On 31 May 2016 at 15:41, Eric Kestler wrote:
> I’m a newbie to Sqlite, if that explains the following:
>
> Last year, I installed Sqlite on my Mac; it was version 3.7.6.3:
>
> Server Type: SQLite
> Connection Name: testDB
> Database File: /Users/ekestler/Dropbox/SyleneDB/test.db
> Setting Save P
On Tue, May 31, 2016 at 5:05 PM, Igor Korot wrote:
> > I'm not an OSX user, but if it's like Linux, you can run the ldd command
> on
> > your executable file,
> > and it will show you which dynamic libraries it depends on. If you don't
> > see SQLite, it probably statically linked... --DD
>
> On
On 31 May 2016, at 3:41pm, Eric Kestler wrote:
> Where does Sqlite actually reside when installed on a Mac?
In multiple places. The sqlite source code is distributed as C source code and
is intended to be compiled into each program that uses it. There is no central
installation of SQLite wh
Hi,
On Tue, May 31, 2016 at 11:01 AM, Dominique Devienne
wrote:
> On Tue, May 31, 2016 at 4:41 PM, Eric Kestler wrote:
>
>> Where does Sqlite actually reside when installed on a Mac?
>>
>
> Probably *inside* navicat.
>
> When you build a native application, you can use static linking of
> librar
On Tue, May 31, 2016 at 4:41 PM, Eric Kestler wrote:
> Where does Sqlite actually reside when installed on a Mac?
>
Probably *inside* navicat.
When you build a native application, you can use static linking of
libraries you depend on, like SQLite, or dynamic linking.
With static linking, there'
I’m a newbie to Sqlite, if that explains the following:
Last year, I installed Sqlite on my Mac; it was version 3.7.6.3:
Server Type: SQLite
Connection Name: testDB
Database File: /Users/ekestler/Dropbox/SyleneDB/test.db
Setting Save Path: /Users/ekestler/Library/Application Support/PremiumSoft
C
Hi Eric,
As I know you from Delphi related projects, I thought it would be nice to
share my ideas.
I am using a home-grown framework for sqlite persistence, optimized for
storing records into tables.
Main ideas:
- using virtual tables (with the same structure) to speed up sqlite inserts
a write tr
Hi,
This is additional information in respect to the following ticket:
https://sqlite.org/src/tktview/6c266900a22574d4d647
I can reproduce an odd behaviour when .mode columns breaks on a UTF-8
character. But I can only reproduce in tmux, not in bash.
To set it up.
create table Team (name TEXT);
14 matches
Mail list logo