Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-20 Thread Dan Kennedy
On 10/18/2018 04:58 PM, Maziar Parsijani wrote: Hi, how could I ignore syntax errors like this? *SELECT *,* * highlight(searchsimpleenhanced, 2, '', '') text* * FROM searchsimpleenhanced* * WHERE searchsimpleenhanced MATCH 'sth][';* You can use double quotes to search for a token that

Re: [sqlite] Hot-Journal with VFS

2018-10-20 Thread Dan Kennedy
On 10/18/2018 09:27 PM, Bob schwanzer wrote: Hi, I'm seeing hot journal frequently in our SQLite installation. We use VFS which does some checksum and other operations. There are no abnormal scenarios such as power off, process crash, abandoned transactions... DB is opened by 10-20 processes

Re: [sqlite] geopoly data input options

2018-10-20 Thread Jonathan Moules
More specifically, in the "Simple Features for SQL" specification: http://www.opengeospatial.org/standards/sfs and if you have access (or gobs of money), there's the ISO spec (I'm guessing it's the same) - https://webstore.ansi.org/RecordDetail.aspx?sku=ISO+19125-1%3A2004 I'd also suggest

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

2018-10-20 Thread dmp
> I have a bunch of hyperlinks in an SQLite database, and need to read each > page for validation before deleting the record. > To make it easier, the DB manager should launch the default web browser when > I double click on a column that contains a hyperlink. > Before I build a GUI, is there a

Re: [sqlite] SQLITE_OPEN_READONLY in PHP

2018-10-20 Thread Tim Streater
On 20 Oct 2018, at 17:05, "p...@geniais.com" wrote: > I'm using a C compiled program to write exclusively to a database, and a php > script for reading only (that communicates via socket). > I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there > is a way to open a

Re: [sqlite] SQLITE_OPEN_READONLY in PHP

2018-10-20 Thread Simon Slavin
On 20 Oct 2018, at 5:05pm, p...@geniais.com wrote: > I'm using a C compiled program to write exclusively to a database, and a php > script for reading only (that communicates via socket). > I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there > is a way to open a

[sqlite] SQLITE_OPEN_READONLY in PHP

2018-10-20 Thread p...@geniais.com
Hello, I'm using a C compiled program to write exclusively to a database, and a php script for reading only (that communicates via socket). I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there is a way to open a database for readonly in php (since just one C program is

Re: [sqlite] database is locked

2018-10-20 Thread Simon Slavin
On 20 Oct 2018, at 1:19pm, p...@geniais.com wrote: > I'm using exec() to simply get true/false result (just reading) and I'm > receiving this error, even in WAL mode: > SQLite3::exec(): database is locked in ... on line 47 > > Any help will be apreciated I'm assuming that you are aware that

[sqlite] database is locked

2018-10-20 Thread p...@geniais.com
Hello, I'm using exec() to simply get true/false result (just reading) and I'm receiving this error, even in WAL mode: SQLite3::exec(): database is locked in ... on line 47 Any help will be apreciated Thank you Ismael ___ sqlite-users mailing