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

2015-02-12 Thread J Decker
this contains a very basic vfs implementation; kinda uses internal file abstraction stuff so a lot can be stripped out and replaced with fopen/fread/etc... https://code.google.com/p/c-system-abstraction-component-gui/source/browse/src/sqlite/sqlite_interface.c maybe it's more cryptic than I think

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

2015-02-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/10/2015 07:03 PM, Jay Kreibich wrote: > ... VFS is unlikely to make the cut. ... similar things about the > xBestIndex() and xFilter() functions I haven't read the book, but one thing that may help is not using C for these. I think it is easier

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

2015-02-10 Thread Jay Kreibich
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 3.6.x, there are a

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

2015-02-10 Thread Dan Kennedy
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 implementation. My guess

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

2015-02-10 Thread Richard Hipp
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: https://www.sqlite.org/src/artifact/0396f220561f --

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

2015-02-10 Thread Simon Slavin
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 best place to start w

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

2015-02-10 Thread Peter Aronson
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 detail, but not >V

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

2015-02-10 Thread Clemens Ladisch
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 http://sqlite.org:8080/cgi-bin/mailm

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

2015-02-10 Thread Stephan Beal
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 http://wanderinghorse.net/home/stephan/

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

2015-02-10 Thread Jay Kreibich
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 >(http://www.sqlit

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

2015-02-10 Thread Stephan Beal
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/ resp. http://shop.oreilly.

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

2015-02-10 Thread Janke, Julian
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 standa

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

2015-02-10 Thread Janke, Julian
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 informati