Re: [sqlite] Seg fault with core dump. How to explore?

2017-10-01 Thread Simon Slavin
On 2 Oct 2017, at 5:33am, Kevin O'Gorman wrote: > What such things always say "segementation fault (core dumped)" and the > name of the program. Try standard investation for any Python program which gives a segmentation fault. Waht does faulthandler say ?

Re: [sqlite] Seg fault with core dump. How to explore?

2017-10-01 Thread Kevin O'Gorman
On Sat, Sep 30, 2017 at 11:41 PM, Clemens Ladisch wrote: > Kevin O'Gorman wrote: > > my latest trial run ended with a segmentation fault > > Really a segmentation fault? What is the error message? > What such things always say "segementation fault (core dumped)" and the name of the program. >

Re: [sqlite] sqlite3_analyzer on Windows 10 crash

2017-10-01 Thread Richard Hipp
On 10/1/17, James Key wrote: > When I attempt to run the sqlite3_analyzer from the command line. It crashes > after loading it in MS debug the error message is: > > Unhandled exception at 0x09E45AE0 in sqlite3_analyzer.exe: 0xC005: > Access violation reading location 0x09E45AE0. > > Any though

[sqlite] sqlite3_analyzer on Windows 10 crash

2017-10-01 Thread James Key
When I attempt to run the sqlite3_analyzer from the command line. It crashes after loading it in MS debug the error message is: Unhandled exception at 0x09E45AE0 in sqlite3_analyzer.exe: 0xC005: Access violation reading location 0x09E45AE0. Any thoughts? Is this a known issue? I searched th

Re: [sqlite] sqlite3_errcode()

2017-10-01 Thread Bart Smissaert
Ok, thanks. All cleared up. RBS On 1 Oct 2017 19:32, "Igor Tandetnik" wrote: On 10/1/2017 1:56 PM, Bart Smissaert wrote: > This is in the documentation of sqlite3_errcode(): > > If the most recent API call was successful, then the return value from > sqlite3_errcode() is undefined. > > I can s

Re: [sqlite] sqlite3_errcode()

2017-10-01 Thread Igor Tandetnik
On 10/1/2017 1:56 PM, Bart Smissaert wrote: This is in the documentation of sqlite3_errcode(): If the most recent API call was successful, then the return value from sqlite3_errcode() is undefined. I can see that if there is no error then then return value of sqlite3_errcode() can be SQLITE_ROW

Re: [sqlite] sqlite3_errcode()

2017-10-01 Thread Simon Slavin
On 1 Oct 2017, at 6:56pm, Bart Smissaert wrote: > I can see that if there is no error then then return value of > sqlite3_errcode() can be SQLITE_ROW (100) or SQLITE_DONE (101). So, to > check if there is an error (other than looking at all the > return values) do I need to check that sqlite3_e

[sqlite] sqlite3_errcode()

2017-10-01 Thread Bart Smissaert
This is in the documentation of sqlite3_errcode(): If the most recent API call was successful, then the return value from sqlite3_errcode() is undefined. I can see that if there is no error then then return value of sqlite3_errcode() can be SQLITE_ROW (100) or SQLITE_DONE (101). So, to check if t

Re: [sqlite] Proposed registration for application/vnd.sqlite3 and +sqlite3 (was: Why is Sqlite mediatype not registered at iana)

2017-10-01 Thread Clemens Ladisch
Keith Medcalf wrote: > I should that the Security Implications are NONE. > > There are no security implications in setting a MIME type for "magic > number" containing SQLite3 databases. RFC 6838 § 4.6 says that | the security considerations MUST NOT state that there are "no security | issues assoc

Re: [sqlite] Proposed registration for application/vnd.sqlite3 and +sqlite3 (was: Why is Sqlite mediatype not registered at iana)

2017-10-01 Thread Keith Medcalf
I should that the Security Implications are NONE. There are no security implications in setting a MIME type for "magic number" containing SQLite3 databases. I should think that the "Interoperability Considerations" are that the contained data cannot be processed as a stream and it must be sa

Re: [sqlite] Proposed registration for application/vnd.sqlite3 and +sqlite3 (was: Why is Sqlite mediatype not registered at iana)

2017-10-01 Thread Clemens Ladisch
Paul van Genuchten wrote: > i’m currently not a member of the sqlite consortium. RFC 6838 § 3.2 says: | A registration may be placed in the vendor tree by anyone who needs | to interchange files associated with some product or set of products. | However, the registration properly belongs to the ve

Re: [sqlite] When is db size an issue?

2017-10-01 Thread Eduardo Morras
On Wed, 27 Sep 2017 08:41:25 -0400 "Jason T. Slack-Moehrle" wrote: > Hello All, > > Off and on for the last few years I have been writing an e-mail > client to scratch a personal itch. I store the mail in SQLite and > attachments on the file system. However, I recently brought in all of > my mai