[sqlite] C++ ORM

On Mon, Mar 9, 2015 at 3:25 PM, Simon Slavin wrote: > > On 9 Mar 2015, at 9:38pm, Scott Robison wrote: > >> A co-worker who is working on a project is interested in finding out if >> there is an effective ORM for C++ / SQLite. I've not used one so I'm >> turning to the list to see if anyone has

[sqlite] sqlite3_config via the PHP interface to sqlite3

On 11 Mar 2015 at 17:46, Richard Hipp wrote: > Am I correct in understanding that you have enabled the error and > warning log (https://www.sqlite.org/errlog.html) and it is not showing > anything unusual? The page at the link above references this call via the C interface:

[sqlite] PRAGMA Synchronous safety

I don?t run pragma quick_check in my application ? and I don?t have any corrupted database here. I only ever see the log files when my application reports a damaged application, and there I see the ?disk image malformed? error message. The diagnosis routine included in my application and

[sqlite] PRAGMA Synchronous safety

On 11 Mar 2015, at 5:33pm, Mario M. Westphal wrote: > All recent occurrences of the problem where on local hard disks / SSD disks. > It even affects the small configuration databases my application maintains in > SQLite, with the FULL synch mode for maximum safety. These also use WAL / >

[sqlite] PRAGMA Synchronous safety

Sorry, typing on a handheld with too thick thumbs :) The database files can be on remote storage (e.g. Windows server or NAS) (I know that this may be a factor and we discussed this already and I know the texts on your web site about false/incomplete locking etc). I just mentioned that here

[sqlite] Libstringmetrics

> On 11 Mar 2015, at 4:56pm, Milan Roubal wrote: > > I am also facing problem with sqlite closed by windows because of crash. On > same data this query crash: > > select load_extension("libstringmetrics.dll"); > select a.vorname, b.vorname, a.nachname, b.nachname, >

[sqlite] PRAGMA Synchronous safety

One process only.

[sqlite] UPDATE Problem

When you store something that "looks like a number" in a column with numeric affinity in the table declaration, the value is converted to a numeric type. That is, if the "something that looks like a number" can be stored as an integer, then it is stored as an integer (with no decimal point

[sqlite] Libstringmetrics

Dear Andrea, I am also facing problem with sqlite closed by windows because of crash. On same data this query crash: select load_extension("libstringmetrics.dll"); select a.vorname, b.vorname, a.nachname, b.nachname, stringmetrics("qgrams_distance","similarity",a.nachname, b.nachname, "")

[sqlite] PRAGMA Synchronous safety

>All recent occurrences of the problem where on local hard disks / SSD >disks. It even affects the small configuration databases my application >maintains in SQLite, with the FULL synch mode for maximum safety. These >also use WAL / shared_cache but are only updated a couple of times per >minute

[sqlite] want to specify DB.TABLE with ".import" and ".mode insert"

Hello, I observe the following two issues with the command-line sqlite3, both with version 3.6.20 (on RHEL6) and the latest 3.8.8.3 compiled from source. It appears that the '.import FILE TABLE' command doesn't support specifying the database name (db.table) -- I get a "no such table" error.

[sqlite] Weird (slow) TEMP B-TREE ORDER BY

Hi guys, Sorry to be a pain, but does anyone have an idea about this issue? I have to recommend switching DBs this week based on this, and I am reluctant to do so, but we haven't been able to figure a fix either. Thanks, Dinu

[sqlite] Libstringmetrics

Dear Andrea, thank you for the answer. The only idea I have so far is the line 452 in file wrapper_functions.c sqlite3_result_text(context, metrics, strlen(metrics)+1, SQLITE_STATIC); I would change that to sqlite3_result_text(context, metrics, strlen(metrics)+1, SQLITE_TRANSIENT); but I don't

[sqlite] Unexpected behaviour when use "IN" clause and double parentheses

My opinion is that the double parentheses should be ignored. I've tested this in other engines like H2, Apache Derby or MySQL and all of them simply ignores the double parentheses and returns the three rows. On Wed, Mar 11, 2015 at 2:57 PM, Hick Gunter wrote: > The syntax diagram mandates 1

[sqlite] PRAGMA Synchronous safety

The problem is that the databases usually are several gigabytes in size, which make them too large for the users to send them to me. A pragma quick_check takes one to two minutes, if the database is on remove storage even more? I currently only have a small 30 MB database which reports ?ok?

[sqlite] (no subject)

Hello, I would like know the difference between SQLite and SQLite Manager, and how many bytes i can register in SQLite and SQLite Manager. Thanks.

[sqlite] (no subject)

On 11 Mar 2015, at 2:18pm, djamel slim wrote: > I would like know the difference between SQLite and SQLite Manager, SQLite is a tool for programmers to use. It allows for easy and flexible storage and retrieval of data. If you're just someone who uses programs, and not a programmer, you'll

[sqlite] PRAGMA Synchronous safety

PRAGMA quick_check Talks ~ 120s on an average size (4 GB) database. Database is on a SSD. Cold database, right after open, nothing in the Windows file cache yet. Running it again takes about 100 seconds, not much faster. Nothing you can run very often or in the background because it keeps

[sqlite] PRAGMA Synchronous safety

On 11 Mar 2015, at 2:21pm, Mario M. Westphal wrote: > I currently only have a small 30 MB database which reports ?ok? for the > pragma quick_check but > > ?row 2481 missing from index idx_settings_sndidmnun? for pragma > integrity_check. If some of the corruption you're seeing can't be

[sqlite] PRAGMA Synchronous safety

I use 3.8.8.1, source id is 2015-01-20 16:51:25 f73337e3e289915a76ca96e7a05a1a8d4e890d55 I compile the amalgamation using Visual Studio 2012. The options I use are: encoding='UTF-16le'; journal_mode=WAL; wal_autocheckpoint=2; // better bulk speed inserts locking_mode=EXCLUSIVE;

[sqlite] Unexpected behaviour when use "IN" clause and double parentheses

Hi, First of all thanks for your effort creating this database engine. I've encountered a problem adapting an ORM library to use with SQLite. The good news is that is easily reproducible with the command line client. The problem is when I use double parentheses in a expression with "IN" clause

[sqlite] PRAGMA Synchronous safety

On 11 Mar 2015, at 1:56pm, Mario M. Westphal wrote: > PRAGMA quick_check > > Talks ~ 120s on an average size (4 GB) database. Can you just verify for us that that PRAGMA does spot the corruption you've mentioned ? It may not be practical to build it into your app but knowing whether the

[sqlite] Unexpected behaviour when use "IN" clause and double parentheses

The syntax diagram mandates 1 set of parentheses around the select for the IN operator. Putting a SELECT statement inside parentheses makes it a SCALAR SUBQUERY that returns (at most) 1 row with 1 column. Any extra data is ignored. Works as specified. -Urspr?ngliche Nachricht- Von:

[sqlite] PRAGMA Synchronous safety

On 3/11/15, Mario M. Westphal wrote: > I don?t run pragma quick_check in my application ? and I don?t have any > corrupted database here. I only ever see the log files when my application > reports a damaged application, and there I see the ?disk image malformed? > error message. > > > > The

[sqlite] data which when inserted into a table cannot be queried - a bug ?

Hi, SELECT oid, ip, name FROM hosts ; 1|a.proper.host.name|2886748296 shows that ip = 'a.proper.host.name ' and name = 2886748296, so of course your queries give no data. The problem is that your insert statement does not name the columns, which is never a good idea. Martin Am 11.03.2015 um

[sqlite] data which when inserted into a table cannot be queried - a bug ?

Aargh! Thank You! Someone else's eyes do help sometimes... On 11/03/2015, Hick Gunter wrote: > You have swapped data and field names in the insert. > > -Urspr?ngliche Nachricht- > Von: Jason Vas Dias [mailto:jason.vas.dias at gmail.com] > Gesendet: Mittwoch, 11. M?rz 2015 13:08 > An:

[sqlite] data which when inserted into a table cannot be queried - a bug ?

> On 11 Mar 2015, at 12:10pm, Jason Vas Dias > wrote: > > I have a table: > > CREATE TABLE hosts > ( >ip INTEGER NOT NULL , >nameTEXT NOT NULL > ); > > My application does: > > BEGIN TRANSACTION; > INSERT INTO hosts > VALUES ( "a.proper.host.name",

[sqlite] data which when inserted into a table cannot be queried - a bug ?

You have swapped data and field names in the insert. -Urspr?ngliche Nachricht- Von: Jason Vas Dias [mailto:jason.vas.dias at gmail.com] Gesendet: Mittwoch, 11. M?rz 2015 13:08 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] data which when inserted into a table cannot be

[sqlite] data which when inserted into a table cannot be queried - a bug ?

Good day - This is the first problem I've encountered with SQLite having used it trouble free for a number of years, so I was surprised when I discovered I can insert data into a table that then cannot be queried : I have a table: CREATE TABLE hosts ( ip INTEGER NOT NULL ,

[sqlite] data which when inserted into a table cannot be queried - a bug ?

Good day - This is the first problem I've encountered with SQLite having used it trouble free for a number of years, so I was surprised when I discovered I can insert data into a table that then cannot be queried : I have a table: CREATE TABLE hosts ( ip INTEGER NOT NULL , name

[sqlite] Attach via prepared statement / Multiple attach

Thanks for your reply, James! > Parameterized queries in general let you replace any data value > (and not metadata). For instance, you can replace a column value, but > not a column name. Using that as a guide, I'm a little suprised that > > ATTACH DATABASE ? AS ? > > works, because

[sqlite] PRAGMA Synchronous safety

On 11 Mar 2015, at 10:35am, Mario M. Westphal wrote: > My application logs all error codes from SQLite but I have not seen anything > unusual in the logs provided to me by customers. I have even added an error > callback for SQLite (as per our recent discussion), to get more info about > the

[sqlite] PRAGMA Synchronous safety

I?m also concerned about this. I have used SQLite since around 2008 with great success. For the latest version of my application I decided to switch to using WAL mode and shared cache, to gain better performance. I use pragma synchronous=NORMAL and for a highly-critical (yet small, 2 MB)

[sqlite] (no subject)

from http://sourceforge.net/projects/sqlitemanager/ "SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4, but work fine with PHP5. Work just as well on a platform Linux as on Windows or MAC." from http://www.sqlite.org/ "SQLite is a

[sqlite] Weird (slow) TEMP B-TREE ORDER BY

On 3/11/15, Dinu Marina wrote: > > Sorry to be a pain, but does anyone have an idea about this issue? > Maybe try: CREATE TEMP TABLE xyz AS SELECT -- query without the ORDER BY clause; Followed by: SELECT * FROM xyz ORDER BY ; DROP TABLE xyz; does doing it that way run

[sqlite] UNION with ORDER BY collate gives 'Error: no such column:'

Hello, With the latest version of sqlite 3.8.5 and above we have notice some of our existing queries are failing. We noticed this with the iOS 8.2 release. The schema example we are using for our test case CREATE TABLE Table2 ( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE Table3 ( id

[sqlite] PRAGMA Synchronous safety

On 3/11/15, Mario M. Westphal wrote: > > I use pragma synchronous=NORMAL and for a highly-critical (yet small, 2 MB) > database even synchronous=FULL. synchronous should not matter, except following a power-outage. > > My application is multi-threaded, but each thread uses a separate instance >

[sqlite] PRAGMA Synchronous safety

On 3/11/15, Mario M. Westphal wrote: > > A pragma quick_check takes one to two minutes, if the database is on remove > storage even more? > In your original email, you said that all database files were on a local disk. This message implies that sometimes they are on a remote filesystem. (I'm

[sqlite] PRAGMA Synchronous safety

On 3/11/15, Mario M. Westphal wrote: > > The typical scenario is: Windows 7 or 8. One user. Database on a local hard > disk or SSD. No power failure. No blue-screen or other issue from the ?How > to damage your SQLite database? help topic. The error just happens. It may > cause SQLite to refuse

[sqlite] PRAGMA Synchronous safety

On 3/11/15, Mario M. Westphal wrote: > > Is there a higher risk in using WAL and/or shared_cache? In a mulit-threaded > environment? > No. WAL should be "safer" than rollback as it is less prone to problems due to malfunctioning FlushFileBuffers() system calls. Multithreading should not be a

[sqlite] data which when inserted into a table cannot be queried - a bug ?

On Wed, Mar 11, 2015 at 7:08 AM, Jason Vas Dias wrote: > Good day - > This is the first problem I've encountered with SQLite having > used it trouble free for a number of years, so I was surprised > when I discovered I can insert data into a table that then cannot > be queried : > > I have a

[sqlite] sqlite3_exec ROLLBACK command

On 2015-03-10 10:44 PM, Mayank Kumar (mayankum) wrote: > Thanks Richard, but we call rollback only when my earlier sqlite3_step has > failed for some reason. Can it still undo some inserts/updates/deletes from a > previously executed but not yet commited tx ? > > Does completion of

[sqlite] Libstringmetrics

Hi Milan, thx for your report. I try to see a check, and effectively I notice the problem is in the qgrams_distance when used the metrics option. As reported in the readme, the stringmetrics extension is based on the https://github.com/jokillsya/libsimmetrics library. The code on the metrics

[sqlite] Attach via prepared statement / Multiple attach

On Mon, 9 Mar 2015 17:59:33 +0100 Fabian Stumpf wrote: > I am currently using > > ATTACH DATABASE ? AS ?; > to dynamically attach databases to a connection. > In some cases, the same physical database file is attached under > different names. > > This all seems to work perfectly, although the