I had some MacOSX systems suffer a power failure, when they came back I made
some copies of the database and:br
br
sqlitegt; PRAGMA integrity_check;br
*** in database main ***br
On tree page 39134 cell 65: 2nd reference to page 33247br
On tree page 39134 cell 65: Child page depth differsbr
On
On 2005-10-07 at 11:11, a
href=http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED][EMAIL
PROTECTED]/a wrote:
nbsp;br
gt; Mrs. Brisby lt;a
href=http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED][EMAIL
PROTECTED]/agt; wrote:
nbsp;br
gt;
nbsp;br
gt; gt; I had some
target PostgreSQL will already have had
the fix.
-Original Message-
From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
Sent: Sunday, 11 September, 2005 10:07 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] CROSS keyword disables certain join optimizations
On Sat, 2005-09-10 at 21
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 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 those
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 don't
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 start
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 aren't
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, and
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
where the Client Os
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 OS handles
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 their
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 another
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 relies on
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 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 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.
It supports everything it needs to:
http
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 fast, you don't know what you're doing.
Like
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.
(background: I've been using threads on win32 since 1998
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's not windows
* it's not unix
* it's not java (closures
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
chainsaws,
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 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 implemented context switching. Does anyone
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
...
When people - even
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 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 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 development
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 write,
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.
Not
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() might
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
Steve
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
From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
Sent: Sun 1/05
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 flushed
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);
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:
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 of a
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 update
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 work
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. . . what's the
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 Data would
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 which alter the
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 themselves
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,
select
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 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 of
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 fast in SQLite, I would have to change to a different
indexing
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 like() is used
, 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 PROTECTED]
Subject: Re: [sqlite] escaping and % in sql statements
On Mon, 2004-01-26
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 for
lookup tables and doing a join, because of the
poorer performance of joins. The techniques shown here by Mrs Brisby are
fine but because they use LIKE, they don't use an index and so will be very
slow for large databases.
However, there are some disadvantages to this stuff;
Multi-occurance
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 like that.
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 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 value that
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
inserted.
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 of a
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 usually
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 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 reality.
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] ?
If not,
67 matches
Mail list logo