[sqlite] Load extension in a trigger?

Hi, I'm using spatialite via the command line in a script/batch file: sqlite3 -cmd ".load mod_spatialite.com" %DB% everything works perfectly... However, I need to use it via JDBC for a java application and loading the spatialite extension in the jdbc connection is extremely buggy...

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

On 20 Aug 2019, at 8:40pm, Mark Tomlin wrote: > I found the regular sqlite3::open method has an $encryption_key parameter. > > https://www.php.net/manual/en/sqlite3.open.php Yep. > As I am using PDO for the interface into SQLite, I wonder if there is a > similar parameter for that interface.

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

On 8/20/19, Mark Tomlin wrote: > I've looked at the PRAGMA statements and there doesn't appear to > be any public documentation on this interface. The PRAGMAs in question are part of the SEE documentation, as they are unique to SEE. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

Thank you Richard for the extremely quick response. I found the regular sqlite3::open method has an $encryption_key parameter. https://www.php.net/manual/en/sqlite3.open.php As I am using PDO for the interface into SQLite, I wonder if there is a similar parameter for that interface. Perhaps

Re: [sqlite] [FTS5] Potential table name escape issue with ORDER BY rank

On 21/8/62 01:06, Matt Haynie wrote: Hello sqlite-users, Apologies if this isn’t formatted correctly, I’m not used to submitting bug reports via mailing lists. Although I’m sure some people will be shaking their head, I chose to use periods between words in table names. I’ve been careful to

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

On 8/20/19, Mark Tomlin wrote: > I would like to use SQLite's Encryption Extension with my PHP 7.2 code > base, as well as 7.3 and 7.4 code bases moving forward. My hope is is that > the see-sqlite.c code file can be simply renaming it to sqlite.c and > dropping it into PHP's build directory.Then

[sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

I would like to use SQLite's Encryption Extension with my PHP 7.2 code base, as well as 7.3 and 7.4 code bases moving forward. My hope is is that the see-sqlite.c code file can be simply renaming it to sqlite.c and dropping it into PHP's build directory.Then compiling it as I normally would. I'm

[sqlite] [FTS5] Potential table name escape issue with ORDER BY rank

Hello sqlite-users, Apologies if this isn’t formatted correctly, I’m not used to submitting bug reports via mailing lists. Although I’m sure some people will be shaking their head, I chose to use periods between words in table names. I’ve been careful to escape table names everywhere, so this

Re: [sqlite] Error response for automatic transaction rollback

On Aug 20, 2019, at 9:09 AM, Matt Zand wrote: > > I wonder if version 3.29 does support error handling for sql transaction > rollbacks. Also, does it support bypassing errors by forcing unconditional > rollback yet. It sounds like you’re looking for CREATE TRIGGER…BEFORE UPDATE…RAISE(ROLLBACK)

Re: [sqlite] Error response for automatic transaction rollback

On 8/20/19, Matt Zand wrote: > I wonder if version 3.29 does support error handling for sql transaction > rollbacks. Also, does it support bypassing errors by forcing unconditional > rollback yet. I don't understand what you are asking. -- D. Richard Hipp d...@sqlite.org

[sqlite] Error response for automatic transaction rollback

Hey guys, I wonder if version 3.29 does support error handling for sql transaction rollbacks. Also, does it support bypassing errors by forcing unconditional rollback yet. -- Cheers, Matt Zand Cell: 202-420-9192 Work: 240-200-6131 High School Technology Services DC Web

Re: [sqlite] crash at sqlite3DbMallocRawNN

Faults in the memory allocation routines of SQLite are almost always due to heap corruption caused by other unrelated parts of the application. In other words, some other part of the application is misusing the memory heap, and SQLite merely has the misfortune of being the first innocent party to

[sqlite] crash at sqlite3DbMallocRawNN

Hi, I have a crash at sqlite when reading a row in database (detailed stacktrace in the attachment). It happens rarely in our customer machine. We cannot reproduce it. Can you please give some suggestions when this can happen and maybe how to fix it. FAULTING_SOURCE_LINE: