[sqlite] Enable sqlite3 FTS5 for PHP

Hi, I'm trying to use SQLite3 FTS5 (full-text search) with PHP on CentOS.. but I couldn't get it successfully after so much time trying. I'm building a loadable FTS5 Extension for SQlite and tried the following steps (from docs) in the server terminal (SSH) : $ yum install libsqlite3x-devel $

Re: [sqlite] sqlite3 unable to open network db file in readwrite mode

On Wed, 3 Jul 2019 20:48:42 -0500, Lewis Balentine wrote: > *First, version numbers:* > My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface, > Kernel 4.15.0-52 Generic x86_64 > The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user > interface, Kernel

Re: [sqlite] sqlite3 unable to open network db file in readwrite mode

On 7/3/19, Lewis Balentine wrote: > When I open the file in DB Browser for SQLite I can browse the tables but I > can not change anything. > The error is: "attempt to write a readonly database" Is the directory that contains the database file writable? It needs to be in order to write to the

Re: [sqlite] Preserve file descriptors for journal files

On 7/4/19, krimskr...@vollbio.de wrote: > Hi, > > we currently switched from a simple file back-end to SQLite in our > application (no threads, single process) and use the following > settings: > > sqlite3_config(SQLITE_CONFIG_SINGLETHREAD) > sqlite3_enable_shared_cache(0) > PRAGMA synchronous =

[sqlite] DENSE_RANK ignores COLLATE NOCASE

Hi! It looks like DENSE_RANK doesn't work correctly with COLLATE NOCASE columns. CREATE TABLE fruits ( name TEXT COLLATE NOCASE, color TEXT COLLATE NOCASE ); -- Note mixed case spelling. INSERT INTO fruits (name, color) VALUES ('apple', 'RED'); INSERT INTO fruits (name, color) VALUES

[sqlite] sqlite3 unable to open network db file in readwrite mode

*First, version numbers:* My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface, Kernel 4.15.0-52 Generic x86_64 The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user interface, Kernel 4.4.0-141 Generic x86_64 SQLite Version 3.22.0 DB Browser for SQLite

[sqlite] Preserve file descriptors for journal files

Hi, we currently switched from a simple file back-end to SQLite in our application (no threads, single process) and use the following settings: sqlite3_config(SQLITE_CONFIG_SINGLETHREAD) sqlite3_enable_shared_cache(0) PRAGMA synchronous = OFF PRAGMA journal_mode = TRUNCATE It is quite common