[sqlite] mmap on FreeBSD/DragonFly

2015-07-16 Thread Baptiste Daroussin
Hi, I have been testing sqlite mmap on FreeBSD/DragonFly and it works perfectly well. (the package manager uses sqlite this is where I have been testing it) would it be possible to activate it? https://people.freebsd.org/~bapt/freebsd-dragonfly-mmap.diff Best regards, Bapt

Re: [sqlite] pragma and prepare statement

2014-07-15 Thread Baptiste Daroussin
The second point seems to explain my problems thanks you 2014-07-10 18:05 GMT+02:00 Dan Kennedy <danielk1...@gmail.com>: > On 07/10/2014 08:44 PM, Baptiste Daroussin wrote: >> >> Hi, >> >> We are using sqlite intensively in out developement and we discovered &g

[sqlite] pragma and prepare statement

2014-07-10 Thread Baptiste Daroussin
Hi, We are using sqlite intensively in out developement and we discovered that apparently we cannot create a statement with a pragma Is there a reason why it is not possible? is it a bug or a per design regards, Bapt ___ sqlite-users mailing list

Re: [sqlite] FreeBSD and SQLITE_ENABLE_LOCKING_STYLE

2013-04-12 Thread Baptiste Daroussin
t 4:03 AM, Baptiste Daroussin < > baptiste.darous...@gmail.com> wrote: > > > Ok so I was not going in the right direction :) > > > > So how it is possible to corrupt a database on nfsv4? Does that ring a > bell > > to someone? > > > > > Pro

Re: [sqlite] FreeBSD and SQLITE_ENABLE_LOCKING_STYLE

2013-04-11 Thread Baptiste Daroussin
Ok so I was not going in the right direction :) So how it is possible to corrupt a database on nfsv4? Does that ring a bell to someone? 2013/4/11 Richard Hipp <d...@sqlite.org> > On Wed, Apr 10, 2013 at 6:40 PM, Baptiste Daroussin < > baptiste.darous...@gmail.com> wrote

[sqlite] FreeBSD and SQLITE_ENABLE_LOCKING_STYLE

2013-04-10 Thread Baptiste Daroussin
I'm trying to activate SQLITE_ENABLE_LOCKING_STYLE=1 on FreeBSD. We use SQLite for our new package manager and we get a report from a user about a totally corrupted database when on nfsv4. I want to try activating this option, but received a compilation failure sqlite3.c:28290:14: error:

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011-09-27 Thread Baptiste Daroussin
2011/9/27 Patrick Proniewski : > Hello, > > I'm facing a challenging problem. I want to log some data into an SQLite3 DB. > Data come from a system command (iostat) in an endless steam, one row every X > seconds: > >         disk0 >   KB/t tps  MB/s >   4.02 2318 9.09 >   4.00