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
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
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]
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
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
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
>
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
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
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,
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
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
> >>
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
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
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
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
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.
> >&
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
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
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
>
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'
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.
> >
> >
> &
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
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
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
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
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
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,
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.
> >
>
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
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
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
>
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()
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
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
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:
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);
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
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
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
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
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
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. . .
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.
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"
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
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,
> >
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
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
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
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
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
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
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
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
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
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
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
>
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
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
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
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.
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
>
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
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
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
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
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
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
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
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]> ?
70 matches
Mail list logo