Re: [sqlite] 转发：SQLITE3 JOURNAL MODE

On 11 Feb 2015, at 2:59am, Keith Medcalf 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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

On Feb 10, 2015, at 11:21 AM, Peter Aronson 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

Re: [sqlite] 转发：SQLITE3 JOURNAL MODE

>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

[sqlite] FTS5 compression

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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

On 02/11/2015 12:31 AM, Simon Slavin wrote: On 10 Feb 2015, at 5:01pm, Clemens Ladisch 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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

On 2/10/15, Janke, Julian 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:

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

On 10 Feb 2015, at 5:01pm, Clemens Ladisch 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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

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 wrote: > > > > >No, it does not. Using SQLite covers Virtual Tables in great

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

On Tue, Feb 10, 2015 at 5:58 PM, Jay Kreibich 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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

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

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

On Tue, Feb 10, 2015 at 5:27 PM, Janke, Julian 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/

[sqlite] Porting SQLite to another operating system (not supported out of the box)

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

[sqlite] Porting SQLite to another operating system (not supported out of the box)

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

Re: [sqlite] 转发：SQLITE3 JOURNAL MODE

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

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

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

[sqlite] 转发：SQLITE3 JOURNAL MODE

-- 原始邮件 -- 发件人: "2718894394";<2718894...@qq.com>; 发送时间: 2015年2月10日(星期二) 下午5:31 收件人: "drh"; 主题: 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