Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

Brilliant! Thanks > cl sqlite3.c -link -dll -out:sqlite3.dll cl sqlite3.c -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll > nmake /f makefile.msc nmake /f makefile.msc DYNAMIC_SHELL=1 ___ sqlite-users mailing list

Re: [sqlite] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

Detlef Golze wrote: > > This code still assumes that SQLITE_WIN32_CACHE_SIZE is measured in pages: > The value of SQLITE_WIN32_HEAP_INIT_SIZE is an initial estimate of the eventual heap size. It does not have to be an exact figure. Using either KiB or pages normally ends up giving a fairly

Re: [sqlite] Linux top command and sqlite

Definitely 'D' as in "Disk I/O", if you type "1" while runing top, the results for each CPU are displayed separately und you will find at least 1 line (not necessarily always the same line) with a significant percentage of "wa" (I/O wait state). Apparently your transactions involve very much

Re: [sqlite] error 6410 after upgrade to 3.17.0 on android

Using this: SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.CREATE_IF_NECESSARY | SQLiteDatabase.NO_LOCALIZED_COLLATORS); Instead of this: SQLiteDatabase.openOrCreateDatabase(path, null); I don't get the error on database creation but if I then manually execute the offending statement

[sqlite] Magic self-healing database!

Hello List. Well, here's something I haven't seen before. I've got a DB in WAL mode on an embedded Linux system. My app (which has several threads, each with a connection, with Sqlite running fully serialized) was reporting database corruption in its logs. Sun Feb 19 07:52:45 2017 user.warn

Re: [sqlite] SQLite Options

I don't recall how I obtained the SQLite files ... was two years ago. When I have SQLite installed on my genealogy program and on my SQLite .dll library, it works fine. When I don't have SQLite installed on my genealogy program, I get an exception "Unable to load DLL 'SQLite.Interop.dll': ... "

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

Hello, On 2017-02-21 07:32, Green Fields wrote: cl sqlite3.c -link -dll -out:sqlite3.dll cl sqlite3.c -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll nmake /f makefile.msc nmake /f makefile.msc DYNAMIC_SHELL=1 -- best regards Cezary H. Noweta

Re: [sqlite] Unresolved External sqlite3_user_add

On 21 Feb 2017, at 10:11pm, Andrew Stewart wrote: > What I am trying to do is hide my data. Then user-authentication is useless to you. You need encryption. The development team of SQLite also developed an encryption extension which is not free to use:

Re: [sqlite] Unresolved External sqlite3_user_add

Hi, Thanks for the response. That worked. Don't do enough work between C++ and C to remember to use the #ifdef statements. Only 1 problem, the database can still be opened and the data viewed by other programs that are not compiled with SQLITE_USER_AUTHENTICATION. I am testing with SQLite

Re: [sqlite] Linux top command and sqlite

Original message From: Roger Binns Date: 21/02/2017 20:48 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Linux top command and sqlite On 21/02/17 10:22, Kevin O'Gorman wrote: > Some of my stuff takes

[sqlite] Unresolved External sqlite3_user_add

Hi, I am trying to add the authentication extension in and I am getting this message. I have included the 'userauth.c' at the bottom of the amalgamation. I have included 'sqlite3userauth.h' at the bottom of sqlite3.h. It finds it during the compile, but does not find it

Re: [sqlite] Unresolved External sqlite3_user_add

On 02/22/2017 12:47 AM, Andrew Stewart wrote: Hi, I am trying to add the authentication extension in and I am getting this message. I have included the 'userauth.c' at the bottom of the amalgamation. I have included 'sqlite3userauth.h' at the bottom of sqlite3.h. It finds

[sqlite] Linux top command and sqlite

I'm not at all sure this is the right place to ask, but as it only comes up when I'm running one of my sqlite jobs, I thought I'd start here. I'm running Python 3.5 scripts in Linux 16.04.1 using the sqlite3 package. Machine is Core i5, 32GB RAM. Some of my stuff takes a while to run, and I

Re: [sqlite] SQLite Options

Are you using NuGet or downloading the binaries from System.Data.Sqlite.org? Ah. You'll have to excuse me, it's been a while since I actually started a new project and set SQLite as a dependency. I'm not sure if things have changed, or if my memory is terrible, but what I said may not have been

Re: [sqlite] error 6410 after upgrade to 3.17.0 on android

On 2/21/17, Alexandre Mainville wrote: > Hi, > > I just upgraded from sqlite 3.8.8.3 to 3.17.0. (I use zipvfs 3.17.0) > > On android, I get error SQLITE_IOERR_GETTEMPPATH (6410) when I try to > create a new DB. > > I checked that SQLITE_TEMP_STORE is properly set

Re: [sqlite] error 6410 after upgrade to 3.17.0 on android

On 02/22/2017 12:11 AM, Alexandre Mainville wrote: Hi, I just upgraded from sqlite 3.8.8.3 to 3.17.0. (I use zipvfs 3.17.0) On android, I get error SQLITE_IOERR_GETTEMPPATH (6410) when I try to create a new DB. I checked that SQLITE_TEMP_STORE is properly set to 3 in Android.mk Is there

Re: [sqlite] Linux top command and sqlite

On 2/21/17, Kevin O'Gorman wrote: > I'm not at all sure this is the right place to ask, but as it only comes up > when I'm running one of > my sqlite jobs, I thought I'd start here. I'm running Python 3.5 scripts > in Linux 16.04.1 using the sqlite3 package. Machine is

[sqlite] shell .schema command doesn't display attached table schemas

Example: [jim@mb ~]$ sqlite3 dummy -- Loading resources from /Users/jim/.sqliterc SQLite version 3.15.1 2016-11-04 12:08:49 with the Encryption Extension Copyright 2016 Hipp, Wyrick & Company, Inc. Enter ".help" for usage hints. sqlite> create table t1(text); sqlite> ^D [jim@mb ~]$ ls -l dummy

Re: [sqlite] Linux top command and sqlite

I'll try the synchronous=off the next time I run it. As it happens, this one finished in 57 minutes, which is not bad, considering. But, I wonder, could i not tell if it's doing lots of commits by looking at the size of the ?.db-journal file? It gets pretty large. On Tue, Feb 21, 2017 at

Re: [sqlite] Linux top command and sqlite

On 21/02/17 10:22, Kevin O'Gorman wrote: > Some of my stuff takes a while to run, and I like to keep tabs on it. > Right now, I'm running one of those, and the Linux top command shows > extremely small CPU usage, and a status ("S" column) of "D" which the man > page defines as "uninterruptable

Re: [sqlite] SQLite Options

in my SQLite.dll library program. On Tue, Feb 21, 2017 at 2:42 PM, Clyde Eisenbeis wrote: > I don't recall how I obtained the SQLite files ... was two years ago. > > When I have SQLite installed on my genealogy program and on my SQLite > .dll library, it works fine. > > When I

[sqlite] error 6410 after upgrade to 3.17.0 on android

Hi, I just upgraded from sqlite 3.8.8.3 to 3.17.0. (I use zipvfs 3.17.0) On android, I get error SQLITE_IOERR_GETTEMPPATH (6410) when I try to create a new DB. I checked that SQLITE_TEMP_STORE is properly set to 3 in Android.mk Is there something else I need to force all temp files to memory?

Re: [sqlite] SQLite Options

Thanks for the good info! I can't find SQLite.Interop.dll ... is referenced at https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki, but don't see a download. On Mon, Feb 20, 2017 at 12:30 PM, Barry Smith wrote: > I would use system.data.sqlite in that