Re: [sqlite] NFS--how to test?

2008-11-08 Thread Peter A. Friend
On Nov 8, 2008, at 11:06 AM, Joshua Paine wrote: > Joshua Paine wrote: >> Some web hosts, like DreamHost and Mosso, provide only NFS-based >> storage. I would very much like to know if it's possible to run >> SQLite >> safely on these (Mosso, actually), so I need some way of testing >> if

Re: [sqlite] The APress SQLite Book

2008-06-18 Thread Peter A. Friend
On Jun 18, 2008, at 8:01 AM, Stefan Arentz wrote: > Sorry if this is a little offtopic but I am curious what other > people thing. > > Is it just me, or is the APress book 'The definitive guide to SQLIte' > not very high quality? > > First, the index is completely unusable. The index is

Re: [sqlite] Writing double into a socket file

2008-06-10 Thread Peter A. Friend
Alex Katebi wrote: > Peter, >I am using my own implementation. I found RPC and others too complicated > to use and it did not give me enough control on the transport layer. I need > my socket to be non-blocking and I am using epoll( ) which is very > efficient. > XDR is a separate

Re: [sqlite] Writing double into a socket file

2008-06-09 Thread Peter A. Friend
Alex Katebi wrote: > I am trying to implement remote procedure calls (RPC) for SQLite API to be > used in my application. > In particular sqlite3_column_double( ) returns a floating point double. > How can I write this double value into a TCP socket? > I have tried writing 8 bytes as integer

Re: [sqlite] Question on Blobs

2008-02-28 Thread Peter A. Friend
On Feb 27, 2008, at 7:35 PM, Mike McGonagle wrote: > Wow, Peter, didn't expect that anyone would go to the trouble of > writing a > program on the spot I didn't. :-) That was just a snippet of something I wrote for myself when I first started playing with SQLite. > Just curious, but

Re: [sqlite] Question on Blobs

2008-02-27 Thread Peter A. Friend
On Feb 27, 2008, at 4:48 PM, Mike McGonagle wrote: > Hello all, > I was hoping that someone might share some tips on working with > Blobs? I > would like to be able to store some images and sound files in a > database, > but never having dealt with them, I am kind of at a loss for some >

Re: [sqlite] LIKE clauses with prepared statements

2008-02-12 Thread Peter A. Friend
On Feb 12, 2008, at 3:51 PM, Igor Tandetnik wrote: > Diego Souza <[EMAIL PROTECTED]> > wrote: >> I wasn't able to figure this out. I'm trying to execute a query like >> this: >> >> SELECT columns FROM table WHERE column LIKE ? >> >> However, I'd like to use % or _ placeholders. For instance in

Re: [sqlite] odd behavior difference between LIKE and GLOB

2007-10-10 Thread Peter A. Friend
On Oct 10, 2007, at 2:12 PM, [EMAIL PROTECTED] wrote: "Peter A. Friend" <[EMAIL PROTECTED]> wrote: As near as I can tell from the documentation, the only difference between LIKE and GLOB is the wildcard character and that LIKE is case- insensitive (unless configu