-- 原始邮件 --
发件人: 2718894394;2718894...@qq.com;
发送时间: 2015年2月10日(星期二) 下午5:31
收件人: drhd...@hwaci.com;
主题: SQLITE3 JOURNAL MODE
HELLO, I HAVE SOME QUESTIONS ABOUT USING SQLITE3 '8.8.2'
WHERE A POWER LOSS OR SIGNAL 'KILL -9' HAPPEND IN LINUX SYSTEM,HOW CAN I
We have not done this in the past. We are trying to create a SQLite
database to use as a project file for software we're developing. The test
project I linked to in the initial email is one we were able to first make
work with MS SQL Compact, but it has limitations that we want to avoid.
The
On 11 Feb 2015, at 2:59am, Keith Medcalf kmedc...@dessus.com wrote:
1) Keep it on the boot volume, not a network or external drive.
The following things will make your journal less safe:
1) PRAGMA data_store_directory to anywhere other than the boot volume
I presume you mean local
1) Keep it on the boot volume, not a network or external drive.
The following things will make your journal less safe:
1) PRAGMA data_store_directory to anywhere other than the boot volume
I presume you mean local filesystem not boot volume. The problem is that
remote filesystems (aka network
On Feb 10, 2015, at 11:21 AM, Peter Aronson pbaron...@att.net wrote:
You could add VFS creation if you ever do a revised edition (along with a
virtual table example that actually used xBestIndex and xFilter…)
Given that the book is over four years old and covers to the end of SQLIte3
Firma: Capgemini Deutschland GmbH
Aufsichtsratsvorsitzender: Antonio Schnieder • Geschäftsführer: Dr. Michael
Schulte (Sprecher) • Jost Förster • Dr. Peter Lempp • Dr. Volkmar Varnhagen
Amtsgericht Berlin-Charlottenburg, HRB 98814
This message contains
On Tue, Feb 10, 2015 at 5:27 PM, Janke, Julian julian.ja...@capgemini.com
wrote:
So my question is, if there is any additional information, how to write a
VFS?
Or does anyone have a clue how to start best?
This book:
http://www.amazon.de/Using-SQLite-Jay-Kreibich-ebook/dp/B008IGK5QM/
Hello,
we plan to port the SQLite library on an embedded system, which runs on a
platform other than the ones that are supported out of the box (it’s an SMX
based system). For the first step, we don’t need a working mutex subsystem,
because we have no multithreaded environment. The required
On 2/10/15, Janke, Julian julian.ja...@capgemini.com wrote:
I know there are two implementations for unix and windows systems in
os_unix.c and os_win.c,
but these are very large files, which are not very helpful for a first
rough
understanding.
See also:
Janke, Julian wrote:
In my opinion, this means, we must only write a VFS implementation for
our target platform.
What file API is there?
Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
No, it does not. Using SQLite covers Virtual Tables in great detail, but not
VFS systems. They’re somewhat unusual, after all.
I assume you’ve read the VFS docs: http://www.sqlite.org/vfs.html
From there, my suggestion is to look closely at the code for the VFS structure
On Tue, Feb 10, 2015 at 5:58 PM, Jay Kreibich j...@kreibi.ch wrote:
No, it does not. Using SQLite covers Virtual Tables in great detail, but
not VFS systems. They’re somewhat unusual, after all.
My apologies - i mixed my terminology there!
--
- stephan beal
You could add VFS creation if you ever do a revised edition (along with a
virtual table example that actually used xBestIndex and xFilter...).
On Tuesday, February 10, 2015 9:58 AM, Jay Kreibich j...@kreibi.ch wrote:
No, it does not. Using SQLite covers Virtual Tables in great detail,
On 10 Feb 2015, at 5:01pm, Clemens Ladisch clem...@ladisch.de wrote:
Janke, Julian wrote:
In my opinion, this means, we must only write a VFS implementation for
our target platform.
What file API is there?
It looks like a standard POXIS implementation. My guess is that the best place
to
On 02/11/2015 12:31 AM, Simon Slavin wrote:
On 10 Feb 2015, at 5:01pm, Clemens Ladisch clem...@ladisch.de wrote:
Janke, Julian wrote:
In my opinion, this means, we must only write a VFS implementation for
our target platform.
What file API is there?
It looks like a standard POXIS
On 10 Feb 2015, at 9:32am, 博协软件-张涛 2718894...@qq.com wrote:
WHERE A POWER LOSS OR SIGNAL 'KILL -9' HAPPEND IN LINUX SYSTEM,HOW CAN I
MAKE SURE THE DB FILE HAVE THE fewest LOSS! At the same time, THE kernel
CPU period IN 30MS~50MS OR LESS.
I HAVE TRIED TO USE WAL JOURNAL MODE, IN
Hi,
What kind of compression is used with the experimental FTS5? I¹d be
interested to hear about real world comparisons in regards to compaction
and performance.
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
17 matches
Mail list logo