Re: [sqlite] LSM bug

On Tuesday, April 29, 2014 03:38:57 AM Dan Kennedy wrote: > On 04/29/2014 03:53 AM, sql...@charles.derkarl.org wrote: > > I didn't know this list strips attachments, so the source file is here: > > > > http://derkarl.org/~charles/runlsm.cpp > > Thanks for this. It is a problem. > > LSM

[sqlite] SQLite and GPFS

Dear SQLiters, I understand that SQLite relies on the underlying filesystem to perform flushes to disk. This is a problem in network file system (NFS) when a disk is mounted on several nodes of a compute cluster and SQLite is ran on them. Essentially, NFS disallows running SQLite concurrently

Re: [sqlite] When to open/close connections

On 29 Apr 2014, at 2:24pm, Drago, William @ MWG - NARDAEAST wrote: > Does closing the connection force, or at least encourage, the OS to write to > disk whatever it might have been caching? Closing a connection calls fclose() on the database file (as long as fopen()

Re: [sqlite] When to open/close connections

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Yuriy Kaminskiy > Sent: Monday, April 28, 2014 8:36 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] When to open/close connections > > Simon Slavin wrote: > > On

Re: [sqlite] Question : how to retrieve a byte array

I'm not sure this sounds like a SQLite issue but I think File.ReadAllBytes and File.WriteAllBytes in the System.IO namespace may do what you want. Cheers, On 28 April 2014 22:58, Denis Bezeau wrote: > Hi, I am currently working on a video game using sqlite3, and I am

Re: [sqlite] bug or inconsistency in column headers

On Tue, Apr 29, 2014 at 6:35 AM, wrote: > > I'm not sure whether this is a bug or not. > I stumbled across a situation where a table alias sometimes is reflected > in the column name and sometimes not. > > Uncomment the last /*LEFT*/ JOIN and the column headers are id_flaeche, >

Re: [sqlite] LSM bug

On 04/29/2014 03:53 AM, sql...@charles.derkarl.org wrote: I didn't know this list strips attachments, so the source file is here: http://derkarl.org/~charles/runlsm.cpp Thanks for this. It is a problem. LSM accumulates data in a tree structure in shared-memory until there is "enough" (~1-2

[sqlite] Question : how to retrieve a byte array

Hi, I am currently working on a video game using sqlite3, and I am having an issue when saving the database to the platform im on. The save function for these platform use either a string or a byte array to save. So I need to be able to get a byte array of the database, and be able to rebuild the

[sqlite] bug or inconsistency in column headers

I'm not sure whether this is a bug or not. I stumbled across a situation where a table alias sometimes is reflected in the column name and sometimes not. It *is* reflected when the last join is a *left* one. Script (sorry that I couldn't come up with a simpler test case): CREATE TABLE

Re: [sqlite] Problems with INT columns

On 29 Apr 2014, at 10:15am, Kleiner Werner wrote: > If I understand the SQLite Docu correct there is no difference between INT or > INTEGER, except if you use a column as Primary Autoincrement. > I thought an Int column in SQLite is always 64bit integer, but why does the >

[sqlite] Problems with INT columns

Hello In our SQLite DB there are some tables with column type as "int" which contains values with 13 digits, like 189336960 It seems that the values are stored correct in SQLite table. But if our Windows Tool with the SQLite Datareader tries to select this value it returns wrong values.