Re: [sqlite] Hardcopy docs?

Do you know exactly which version of SQLite the book discusses? Thanks Alex [EMAIL PROTECTED] wrote: "Bernie Cosell" <[EMAIL PROTECTED]> wrote: I'll confess that I am an old-fashioned "hardcopy" kind of guy... are the sqlite3 docs available in any sort of reasonably-printable format?

Re: [sqlite] Hardcopy docs?

Excellent. I'll start saving my pennies!! Alex [EMAIL PROTECTED] wrote: Alex Roston <[EMAIL PROTECTED]> wrote: Do you know exactly which version of SQLite the book discusses? Version 3.3.x. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] SQLite vs MS Access

I wrote a little server based on SQLite, and it works just fine. I handled the "multiple processes" issue by simply having the software make a list of requests, then handling those requests serially. Essentially there are two parts to the software. One listens for requests and lists them. It

Re: [sqlite] command-line shell handling of errors.

I don't use the command-line shell, but I'd definitely prefer not to see a fundamental change in the behavior of any tool I use. The debugging could get nasty and it's possible that someone using the tool in an unsupervised script might not notice the problem until after it had done some

Re: [sqlite] Music Files

At one point there was a project that did something like this, and it was called Route66. I think it used mysql, perl and a player called splay. You might google it. Alex sebcity wrote: Is it possible to store mp3 files in a SSQLite database? would they be able to be played from the

Re: [sqlite] Appropriate uses for SQLite

Dennis Cote wrote: [EMAIL PROTECTED] wrote: The problem is, not many network filesystems work correctly. Hi All, If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue

Re: [sqlite] Appropriate uses for SQLite

Scott Hess wrote: On 2/2/07, Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. I'm sure someone knows which versions of NFS have working file locking, at least under Linux. I doubt it is this easy. You need to line

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

This is an excellent idea. Alex René Tegel wrote: Hi, Seen the popularity of sqlite, i think 1200 subscribers is very reasonable. Lots of people track mailing lists, only contributing rarely but nevertheless are interested. You could consider a system that requires moderation by the

[sqlite] Wildcards

Does SQLite have anything resembling a wildcard function? I need to either get rid or modify a whole group of rows which have some common elements in the primary key. Ideally I'd like to do something like: "UPDATE card SET foo='100' where bar='ABC*';" The construct above doesn't work, but is

Re: [sqlite] Wildcards

Thanks Jay, but I've been there, and didn't see any examples, so I wasn't sure how it fit into the other commands. (I'm a little dull today - too many crisises - crisi? whatever... this week.) Alex Jay Sprenkle wrote: On 6/13/06, Alex Roston <[EMAIL PROTECTED]> wrote: Does SQLit

Re: [sqlite] Wildcards

DJ Anubis wrote: Alex Roston a écrit : Ideally I'd like to do something like: "UPDATE card SET foo='100' where bar='ABC*';" Use SQL standard construct: UPDATE card SET foo='100' WHERE bar LIKE 'ABC%' ; Excellent. Thank You. My problems are solved!! Alex