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
$ w
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 4.4
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 dat
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 = O
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 ('APPLE
*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 Vers
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 th
7 matches
Mail list logo