Re: [sqlite] InnoDB Transactions

2005-05-16 Thread Mrs. Brisby
On Sun, 2005-05-15 at 19:48 -0700, Dan Kennedy wrote: > Anyone have a quick summary of InnoDB algorithm for comparison? I > suspect whatever trick they use won't work with SQLite because > there is no server process, but it could be interesting anyway. There are several ways the extra fsync()

Re: [sqlite] Is there a new sqlite specifically design for WinCE.

2005-05-16 Thread Mrs. Brisby
Don't reply to existing messages with a new topic. People won't see your message. On Mon, 2005-05-16 at 08:24 -0400, steven frierdich wrote: > Is there a new Sqlite designed specifically for WinCE? I am using a > Sqlite 3.0.7 version that was design for WinCE. Is there a newer one? > Thanks >

Re: [sqlite] Multi-threading.

2005-07-22 Thread Mrs. Brisby
On Wed, 2005-07-20 at 17:26 +0100, Ben Clewett wrote: > Dr Hipp, > > I am just playing devils advocate here because I have completed much > Java programming in a multi-threaded application. :) > > I understand the problems of multi-threading. I am reminded that it > took nearly 20 years of

RE: [sqlite] Multi-threading.

2005-07-22 Thread Mrs. Brisby
On Fri, 2005-07-22 at 14:00 -0700, Tim McDaniel wrote: > > History has demonstrated that programmers building > > multithreaded applications tend to produce buggier code, and > > code that touches more pages than a non-threaded version. As > > a result, the non-threaded version is easier to

RE: [sqlite] Multi-threading.

2005-07-22 Thread Mrs. Brisby
On Fri, 2005-07-22 at 17:23 -0400, D. Richard Hipp wrote: > On Fri, 2005-07-22 at 14:00 -0700, Tim McDaniel wrote: > > It is hard, if not impossible, with modern GUI > > systems to write any relatively complex app that is both performant and > > graphically responsive without using threads. > > >

Re: [sqlite] Multi-threading.

2005-07-26 Thread Mrs. Brisby
On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote: > The theory has been proposed that threads aren't better than separate > processes, or application implemented context switching. Does anyone > have an experiment that will prove the point either way? It will have > to be OS specific though,

Re: [sqlite] Multi-threading.

2005-07-26 Thread Mrs. Brisby
On Mon, 2005-07-25 at 09:00 +0100, Ben Clewett wrote: > I like what you say about computer science being a Science. This is > exactly my point. A science is a collection of theories which hold true > within a domain until otherwise dissproven. For instance Isac Newtons's > law of gravety and

Re: [sqlite] Multi-threading.

2005-07-27 Thread Mrs. Brisby
On Tue, 2005-07-26 at 23:20 -0400, Kervin L. Pierre wrote: > We get all those threads related questions because SQLite > is difficult to use with threads and has sparse sometimes > conflicting documentation on the subject. Maybe people think that SQLite should serialize its own internals. Maybe

Re: [sqlite] Multi-threading.

2005-07-27 Thread Mrs. Brisby
On Wed, 2005-07-27 at 09:08 +0100, Paul Smith wrote: > At 03:21 27/07/2005, Mrs. Brisby wrote: > >On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote: > > > The theory has been proposed that threads aren't better than separate > > > processes, or application implemen

Re: [sqlite] Multi-threading.

2005-07-27 Thread Mrs. Brisby
On Wed, 2005-07-27 at 13:31 -0400, Andrew Piskorski wrote: > On Tue, Jul 26, 2005 at 10:21:22PM -0400, Mrs. Brisby wrote: > > > That's incorrect. Threading increases development time and produces less > > stable applications. In fairness: it's the skill level of the engineer

Re: [sqlite] Multi-threading.

2005-07-29 Thread Mrs. Brisby
On Thu, 2005-07-28 at 08:44 -0400, Eli Burke wrote: > Mrs. Brisby wrote: > > My PII-350 easily handles 2 million local deliveries per hour, and it > > fork()s for each one. > > > > As has been mentioned: If you think threads are going to make your > > program

Re: [sqlite] Multi-threading.

2005-07-29 Thread Mrs. Brisby
On Thu, 2005-07-28 at 07:42 -0500, Dennis Jenkins wrote: > Mrs. Brisby wrote: > > >meanwhile, two threads attempting to multiplex access to a single sqlite > >handle are a) bound to be confused, and b) need those resource locks > >anyway. > > > > > &

Re: [sqlite] Multi-threading.

2005-07-29 Thread Mrs. Brisby
On Fri, 2005-07-29 at 16:22 -0600, K. Haley wrote: > Mrs. Brisby wrote: > > >Now, if you're feeling like you're on a high horse, go ahead: point out > >a single common platform where threads are the necessity. > > > >Here's some hints: > > > >* it'

Re: [sqlite] Multi-threading.

2005-07-29 Thread Mrs. Brisby
On Fri, 2005-07-29 at 14:29 -0700, Robert Simpson wrote: > Threads are a tool ... sortof like a chainsaw. Used properly, they can save > you time and accomplish your goal. In the hands of an expert, you can even > make some impressive art. Well, perhaps the latter only applies to >

Re: [sqlite] Multi-threading.

2005-07-30 Thread Mrs. Brisby
On Sat, 2005-07-30 at 14:30 +0200, Jan-Eric Duden wrote: > Win9X doesn't support the API async file operations. > WinNT/2K/XP does support it. It supports everything it needs to: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/waitformultipleobjects.asp it doesn't

Re: [sqlite] Accessing Database on Network

2005-07-30 Thread Mrs. Brisby
On Thu, 2005-07-28 at 11:28 +0200, djm wrote: > Hello, > > The documentation suggests that its unsafe to use SQLite when the > database file is on a windows network server and various other > machines may want to simultaneously access it. If however none of > these machines change the data in the

Re: [sqlite] Multi-threading.

2005-07-30 Thread Mrs. Brisby
On Sat, 2005-07-30 at 20:29 +0200, Jan-Eric Duden wrote: > Mrs. Brisby wrote: > > >On Sat, 2005-07-30 at 14:30 +0200, Jan-Eric Duden wrote: > > > > > >>Win9X doesn't support the API async file operations. > >>WinNT/2K/XP does support it. > >&

Re: Re[4]: [sqlite] Accessing Database on Network

2005-08-02 Thread Mrs. Brisby
On Tue, 2005-08-02 at 17:36 +0200, djm wrote: > Hello, > > Thanks very much for the detailed and helpful response. Ill certainly > have a look at the book you receommended.. thanks for the tip. > > Sunday, July 31, 2005, 4:47:11 PM, you wrote: > > > As a result, any piece of software that

Re: Re[6]: [sqlite] Accessing Database on Network

2005-08-03 Thread Mrs. Brisby
On Wed, 2005-08-03 at 10:34 +0200, djm wrote: > Hello, > > Wednesday, August 3, 2005, 4:41:24 AM, you wrote: > > > No, none of those things are guaranteed. If there's even a single > > writer it can be unsafe (consider AFS putting a corrupt journal up > > that clients notice download, and thrash

Re: Re[6]: [sqlite] Accessing Database on Network

2005-08-03 Thread Mrs. Brisby
On Wed, 2005-08-03 at 08:46 -0500, Henry Miller wrote: > >In my opinion system time stamps etc are not a reliable means of > >comparing 2 files. Many things can change the timestamp of a file, > >without changing the contents, and one (server) os/filesystem can > >report a different file size to

Re: Re[8]: [sqlite] Accessing Database on Network

2005-08-09 Thread Mrs. Brisby
On Wed, 2005-08-10 at 00:30 +0200, djm wrote: > Hello, > > Henry> No. It might be on your particular systems, but we cannot make > Henry> a general case. It is possible that it will always be safe on > Henry> (for example) Windows 2000, while not safe on NT or XP! It > Henry> depends on how the

Re: Re[10]: [sqlite] Accessing Database on Network

2005-08-10 Thread Mrs. Brisby
On Wed, 2005-08-10 at 11:30 +0200, djm wrote: > Hello, > > > >> My understanding, after all of your helpful comments, currently is: > >> > >> Simultaneous reading of a server file by different clients is safe, as > >> long as the file doesnt get changed at all (at least in a time scale > >>

Re: [sqlite] Encryption and fixed header values (was Re: [sqlite] Why can i open a textfile?)

2005-08-24 Thread Mrs. Brisby
On Mon, 2005-08-22 at 16:39 -0500, Dennis Jenkins wrote: > RC4 is basically an XOR against a huge one-time pad. No it's not. The only thing like a one-time pad is a one-time pad. What makes an OTP secure isn't the protocol, but where the bits come from. If they come from ANYWHERE but a truly

Re: [sqlite] Encryption and fixed header values (was Re: [sqlite] Why can i open a textfile?)

2005-08-25 Thread Mrs. Brisby
On Wed, 2005-08-24 at 22:55 -0400, D. Richard Hipp wrote: > Weaknesses in RC4 have been found where > the first few numbers coming out of the PRNG leak information about the > key. If an attacker can guess the first few bytes of plaintext, and > hence guess the first few numbers from the PRNG,

Re: [sqlite] Encryption and fixed header values (was Re: [sqlite]Why can i open a textfile?)

2005-08-29 Thread Mrs. Brisby
On Fri, 2005-08-26 at 16:21 +0200, F.W.A. van Leeuwen wrote: > > > > The usual defense against this attack is to mix some random information > > into the beginning of the plaintext. > > > > A better defense: use a different key each time. Encrypt the session key > > separately. > > > > And /or

RE: [sqlite] Encryption and fixed header values (was Re: [sqlite] Why can i open a textfile?)

2005-08-29 Thread Mrs. Brisby
On Fri, 2005-08-26 at 12:53 -0400, Griggs, Donald wrote: > Regarding Mrs. Brisby's ending comment: >"A better defense: use a different key each time. Encrypt the session key > separately." > > I may way off in asking this, but: > Since we're talking about the encyption of data at rest, and

Re: [sqlite] How to reduce the flash erasing times when I using sqlite

2005-09-11 Thread Mrs. Brisby
Don't? Use a :memory: table or a ramdisk. periodically (or at commit time?) save a copy of the database elsewhere- perhaps in another form- perhaps in a form that's less pleasant to query quickly. On Wed, 2005-09-07 at 14:48 +0800, SH L wrote: > I found sqlite will update some fixed places >

Re: [sqlite] CROSS keyword disables certain join optimizations

2005-09-11 Thread Mrs. Brisby
On Sat, 2005-09-10 at 19:25 -0400, D. Richard Hipp wrote: > Beginning with SQLite 3.2.3, the query optimizer has had > the ability to reorder tables in the FROM clause if it thinks > that doing so will make the query run faster. This has caused > a few problems for some folks. To ameliorate

RE: [sqlite] CROSS keyword disables certain join optimizations

2005-09-11 Thread Mrs. Brisby
On Sat, 2005-09-10 at 21:38 -0400, Ned Batchelder wrote: > Rather than overload an existing SQL keyword, would it be possible to > provide pragmas to control the optimizer? Assigning meanings to particular > combinations of SQL queries won't scale as the number of optimizer controls > grows. I

RE: [sqlite] CROSS keyword disables certain join optimizations

2005-09-12 Thread Mrs. Brisby
ngs me back to PostgreSQL - which was commented as not having a special pragma for this but instead a sly little hack identical to the one SQLite is using. People who target PostgreSQL will already have had the fix. > -Original Message- > From: Mrs. Brisby [mailto:[EMAIL PROTECTED]

[sqlite] Database corruption

2005-10-07 Thread Mrs. Brisby
I had some MacOSX systems suffer a power failure, when they came back I made some copies of the database and: sqlite PRAGMA integrity_check; *** in database main *** On tree page 39134 cell 65: 2nd reference to page 33247 On tree page 39134 cell 65: Child page depth differs On tree page 39134

Re: [sqlite] Database corruption

2005-10-07 Thread Mrs. Brisby
On 2005-10-07 at 11:11, http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED]">[EMAIL PROTECTED] wrote: "Mrs. Brisby" http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED]">[EMAIL PROTECTED] wrote: I had some MacOSX systems suffer a pow

Re: [sqlite] Moving the SQLite mailing list

2003-10-18 Thread Mrs. Brisby
On Sat, 2003-10-18 at 10:00, D. Richard Hipp wrote: > The SQLite mailing list is moving off of yahoogroups and onto > the same server that hosts the SQLite homepage. To subscribe > to the new mailing list, send an email to > > [EMAIL PROTECTED] Did you perhaps mean <[EMAIL PROTECTED]> ?

Re: [sqlite] [OT] Digest Attachments: why use them?

2003-10-24 Thread Mrs. Brisby
On Fri, 2003-10-24 at 12:48, M. Fioretti wrote: > On Fri, Oct 24, 2003 10:02:36 at 10:02:36AM +0100, Steve O'Hara ([EMAIL PROTECTED]) > wrote: > > I get some 50 emails per day from various sources and I can't > > afford to have SQLite traffic adding to this list. However, I do want to > > get a

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread Mrs. Brisby
On Sun, 2003-10-26 at 14:26, Wayne Venables wrote: > >Further: I always read statements like "Microsoft C/C++ is the largest > >most popular language platform in the world" as foolish sentiment. These > >people obviously don't know what they're talking about and need a good > >healthy dose of some

Re: [sqlite] Making sqlite support unicode?

2003-10-29 Thread Mrs. Brisby
On Mon, 2003-10-27 at 10:27, [EMAIL PROTECTED] wrote: > On Sun, 26 Oct 2003 23:36:55 -0500 > "Mrs. Brisby" <[EMAIL PROTECTED]> wrote: > > It's good to use null-terminated in many cases; especially in collating > > and sorting. It helps to understand that in t

Re: [sqlite] Protection of db file

2003-11-03 Thread Mrs. Brisby
You really need to specify _who_ you want to protect the database from; what kind of access, etc. I think the answer you're looking for is the SQLite "client" provides access control to SQLite- not the other way around- that is, you must control all clients allowed access to the database in order

Re: [sqlite] Performance problem

2003-11-06 Thread Mrs. Brisby
On Thu, 2003-11-06 at 19:00, [EMAIL PROTECTED] wrote: > How would you handle the lack of ordering associate with hash tables? > Sqlite can currently use indicies for three main tests: equals, less than, > and greater than. While hash-tables are good at finding equal-to in > constant time it

Re: [sqlite] database table is locked

2003-11-07 Thread Mrs. Brisby
On Sat, 2003-11-08 at 07:20, Thiago Mello wrote: > Hi Ben Carlyle, > > First of all, thanks for your help! > > I can't brig these two operation togethe causa I need the result of the > SELECT in a if condition. You cannot do the UPDATE inside of a SELECT callback. You do not need the results

RE: [sqlite] Jumping to a record

2003-11-11 Thread Mrs. Brisby
You need to register a new function with-state to do this. Something like this: void f(sqlite_func *ctx, int arg, const char **argv) { int *state = (int *)sqlite_user_data(ctx); if (atoi(argv[0]) == atoi(argv[1])) *state = 1; sqlite_set_result_int(ctx, *state); } static

Re: [sqlite] In-memory DB performance tuning

2003-11-18 Thread Mrs. Brisby
On Tue, 2003-11-18 at 00:55, Arthur C. Hsu wrote: > Hello, > > I have an in-memory DB and try to perform inserts to tables inside. Seems > that there are some performance bottlenecks for continuous inserts. The row > insertion speed will drop dramatically after the first 6000 rows are >

Re: [sqlite] Improving concurrency in SQLite

2003-11-22 Thread Mrs. Brisby
This is more rambling than anything else. I hope I'm reasonably coherent before coffee... Instead of keeping an "undo" journal- consider using a "changes" journal-- each writer could use it's own journal then only at commit would each worker actually start making changes to the database.

Re: [sqlite] Improving concurrency in SQLite

2003-11-23 Thread Mrs. Brisby
On Sat, 2003-11-22 at 12:02, D. Richard Hipp wrote: > It is more complicated than that. In order to maintain isolation > (the "I" in "ACID") the second commit must fail if at any time during > the transaction it read a value that was written by the first commit, > or if the first commit read a

Re: [sqlite] double email

2003-11-23 Thread Mrs. Brisby
On Sat, 2003-11-22 at 16:23, Bert Verhees wrote: > > It seems to me that all the people send theiur ewmail double, and that it > > is a failure in the list software configuration. > > > > This email has only one TO: sqlite-users <[EMAIL PROTECTED]> > > And no CC or BCC, thus, if this is posted

Re: [sqlite] Spiders vandalizing the wiki

2003-11-25 Thread Mrs. Brisby
Google won't submit forms. Robots can't read. Require a challenge before allowing submissions- whether it be an email-based challenge, or an image that contains distorted text. I don't know if there are any blind users of SQLite but they would probably prefer the former. On Tue, 2003-11-25 at

Re: [sqlite] Let us make SQLite more powerful

2003-12-12 Thread Mrs. Brisby
On Fri, 2003-12-12 at 08:09, Yogesh Vachhani wrote: > For example, if the Phones column is a collection, one can find all > rows that contain the phone number 206-481-4442 by specifying the > following SELECT statement: > > SELECT LastName > FROM Contacts >

RE: [sqlite] Let us make SQLite more powerful

2003-12-15 Thread Mrs. Brisby
curance of Phones and Extension > meets the criteria. > > Although BASIS is fully relational, this feature is very commonly used > instead of creating linked lookup tables and doing a join, because of the > poorer performance of joins. The techniques shown here by Mrs Brisby

Re: [sqlite] BLOB support and SQLite 3.0

2003-12-15 Thread Mrs. Brisby
On Mon, 2003-12-15 at 09:37, D. Richard Hipp wrote: >(2) The ".dump" command will only show the binary data through >the first \000 character. If the binary data contains no >\000 characters, the ".dump" command might segfault. Add an SQL function like TOCHAR or something

Re: [sqlite] Subject: Re: [sqlite] Let us make SQLite more powerful

2003-12-29 Thread Mrs. Brisby
On Sat, 2003-12-27 at 07:16, Yogesh Vachhani wrote: > > Why exactly do you think the JOIN operator is the wrong tool for > > this? > > I feel JOIN operations are taxing on the Process as well as on RAM > and HDD (in form of temporary files) All right then. SQLite doesn't produce temporary files

RE: [sqlite] Subject: Re: [sqlite] Let us make SQLite more powerful

2003-12-30 Thread Mrs. Brisby
On Tue, 2003-12-30 at 06:46, Steve O'Hara wrote: > My understanding is that logically, by their very nature, joins are always > likely to be slower than single table queries - I thought that this was a > given downside to normalisation or am I incorrect? Maybe the downside is > not pronounced in

Re: [sqlite] escaping " and % in sql statements

2004-01-27 Thread Mrs. Brisby
On Mon, 2004-01-26 at 09:08, [EMAIL PROTECTED] wrote: > "D. Richard Hipp" <[EMAIL PROTECTED]> writes: > > > As an interim workaround, you could defined your own > > "like()" function using the sqlite_create_function() API > > that implemented built-in escapes. Any user-defined > > function named

RE: [sqlite] escaping " and % in sql statements

2004-01-27 Thread Mrs. Brisby
gt; > { "like", 2, SQLITE_NUMERIC, my_like_function }, > > then? > > -Original Message- > From: Mrs. Brisby [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 12:27 PM > To: [EMAIL PROTECTED] > Cc: D. Richard Hipp; [EMAIL PROT

Re: [sqlite] row size limit

2004-04-19 Thread Mrs. Brisby
On Mon, 2004-04-19 at 07:04, D. Richard Hipp wrote: > Darren Duncan wrote: > > > > I think the simple answer is that SQLite uses a linked list which can't > > know where a page is until reading the next one, but other databases use > > something other than a linked list; they would trade a bit

Re: [sqlite] row size limit

2004-04-19 Thread Mrs. Brisby
On Mon, 2004-04-19 at 20:36, D. Richard Hipp wrote: > Mrs. Brisby wrote: > >> > >>The linked-list structure of overflow storage is part of the problem. > >>But the fact that SQLite uses synchronous I/O is also a factor. In > >>order to make BLOBs

Re: [sqlite] Implementing LISTEN

2004-05-11 Thread Mrs. Brisby
The hard part is to do it portably. I use a multicast socket that writes the change-event. Then I use a select() call on the multicast socket in other clients- if they see the change event, they incorporate the new data into their cache. If you want it reasonably seamless, create triggers that

Re: [sqlite] Password-function in SQLite?

2004-04-26 Thread Mrs. Brisby
You can create a new function to do this quite painlessly. Poke around the wiki for information on creating a new function, or read the source. But beware: consider creating one that uses SHA1 or MD5 as a hashing function instead of your local systems' crypt() as not all crypt() are created

Re: [sqlite] syncronizing

2004-05-22 Thread Mrs. Brisby
On Sat, 2004-05-22 at 13:47, Puneet Kishor wrote: > On May 22, 2004, at 12:31 PM, nathanvi wrote: > > > In my office we have to share a databse (a list of addresses). > > A lot of people has a notebook. > > So my idea was: > > - a file.sqlite on the server in which all people can add, delete, > >

Re: [sqlite] OT: Reply-To Munging Considered Useful

2004-07-23 Thread Mrs. Brisby
On Fri, 2004-07-23 at 10:25, D. Richard Hipp wrote: > Dan Keeley wrote: > > Or, why dont we have a vote, and once it's decided, tuff luck thats how > > it stays? :) > > > > Better: Somebody please write me a simple, secure, mail handler to > replace qmail/ezmlm that lets each user decide for

Re: [sqlite] PHP mods was: Changing table and security

2004-12-23 Thread Mrs. Brisby
On Thu, 2004-12-23 at 04:27 -0500, Randall Randall wrote: > >> > >> Arg! Just invites people to crash your web site. > >> > > *their* web site... think about phpbb or similar phorums > > The unsaid part here, though quite off-topic, is that PHP bulletin > boards are often changed with "mods"

Re: [sqlite] Precompiled statements in the TCL interface

2004-12-31 Thread Mrs. Brisby
On Fri, 2004-12-31 at 08:30 -0500, D. Richard Hipp wrote: > The issue with the third approach is deciding when to clear the > precompiled statement cache. Precompiled statements use memory > and we do not want them to hang around forever. Why not? Programs that "generate" SQL are often-foolish.

Re: [sqlite] sql tables. . .?

2005-01-08 Thread Mrs. Brisby
On Sat, 2005-01-08 at 00:04 -0500, John Richard Moser wrote: > What can be in an SQL table? Tuples. > Can tables contain tables? Thankfully not. > I want to be able to search for a given > package and find what files are in it, search for a file and find what > packages supply it. . .

Re: [sqlite] sql tables. . .?

2005-01-08 Thread Mrs. Brisby
On Sat, 2005-01-08 at 00:11 -0500, John Richard Moser wrote: > BTW, I was thinking that my package hierarchy would pretty much be lain > out like > > Category->SubCategory->Group->Data Why would you think this? Did you read a book on relations or databases (as already suggested) yet? > Where

Re: [sqlite] $ in table and column names

2005-01-18 Thread Mrs. Brisby
On Mon, 2005-01-10 at 18:00 -0500, D. Richard Hipp wrote: > A user has reported a bug saying that SQLite does > not allow the '$' in the middle of indentifiers > (without quoting). The bug reports says that > statements like this: > > CREATE TABLE ex$1( col$abc INTEGER ); > > are legal and

Re: [sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND IF STRING IS NOT IN THE COLUMN ADD IT

2005-01-25 Thread Mrs. Brisby
On Tue, 2005-01-25 at 09:34 -0500, Steve Frierdich wrote: > Does anyone have any code they can send me that shows how to check for a > string in a column in a table, and if the string is not there on how to > insert the string in the column in the table in a new row. Then finally > on how to

Re: [sqlite] How to create and uses a stored procedure for Sqlite

2005-01-26 Thread Mrs. Brisby
Steve: You really should point out if you're familiar with other environments, and ask questions that represent your eventual goals. You're fishing right now, and your questions are so loaded it's not even funny. I'm going on a hunch here, but I suspect you might be familiar with [a particular

Re: [sqlite] Handling database updates in my program updates

2005-01-29 Thread Mrs. Brisby
None of this is necessary if you select a durable schema. Whenever you think you need to "add a field" - add a whole new table and use joins anywhere you need access to the new field. You can't "delete" a field, but deleting a field usually means losing data anyway. You can't change the nature

Re: [sqlite] Prepared Statement Interface

2005-03-26 Thread Mrs. Brisby
On Sat, 2005-03-26 at 15:15 -0600, Eric Bohlman wrote: > #define SEX "'M'" > > sqlite3_bind_text(stmt, index, SEX, sizeof(SEX), > > SQLITE_TRANSIENT); [note the extra ' in SEX] > Change sizeof to strlen here (and in the corresponding statement below);

Re: [sqlite] using cross-link table

2005-03-26 Thread Mrs. Brisby
On Sat, 2005-03-26 at 10:29 -0500, Jason Jobe wrote: > // to find people whose great-grandfather's name is Fred > Well, this is probably correct sql but hopefully you get the idea. So > part of the question is: > > 1. How efficient is this? Not at all. It doesn't work. If you meant:

Re: [sqlite] backup open database

2005-04-30 Thread Mrs. Brisby
Why is it inappropriate to use: sqlite originaldb ".dump" | sqlite backupdb On Sun, 2005-05-01 at 00:28 +0800, Damian Slee wrote: > hi all, > i want to make a copy of a sqlite3 database file while it is open. is there > anyway that i can tell programatically that any caches/journals are

RE: [sqlite] backup open database

2005-05-01 Thread Mrs. Brisby
nserts. which really requires sqlite running > on a flash file system as well. a copy is really all i want, but knowing > when everything is commited, or locking out other threads without them having > to close the db. > > thanks, > > damian > > > > &g