[sqlite] Checkin 24f258c239229016 vfsstat.c ...

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

[sqlite] comparing a blob with a file (samefilecontent function proposal)

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

Re: [sqlite] bug report (security)

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

Re: [sqlite] Version issues on Mac after updating

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

Re: [sqlite] Fastest way to add many simple rows to a table?

> 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

Re: [sqlite] Version issues on Mac after updating

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.

Re: [sqlite] Version issues on Mac after updating

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:

Re: [sqlite] Version issues on Mac after updating

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

Re: [sqlite] Version issues on Mac after updating

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

Re: [sqlite] Version issues on Mac after updating

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

Re: [sqlite] Version issues on Mac after updating

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

[sqlite] Version issues on Mac after updating

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

[sqlite] Fastest way to add many simple rows to a table?

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

[sqlite] sqlite3 .mode columns with UTF-8 breaks on tmux

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