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:
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 flushe
ld be a lot
> quicker than a series of .dump Inserts. 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.
>
> tha
On Sat, 2005-05-07 at 14:57 +0100, [EMAIL PROTECTED] wrote:
> Hello,
>
> Imagine you have a simple database with two tables, and a third to join them
> as a many-to-many relationship. Someone sends me an SQLite database as a file
> which has the same structure, but the data is different. I want
On Mon, 2005-05-09 at 09:01 -0500, Jay Sprenkle wrote:
> > Has good hints on where to get your globally unique identifiers.
> >
> > Or translate the original keys to globally unique identifiers within a
> > transaction before loading into your master database.
>
> Works fine if you don't have any
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() migh
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
> Ste
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 devel
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 writ
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 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, s
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 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
th
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 imp
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 th
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 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 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:
> >
>
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 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.
> >
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 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 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 an
On Sat, 2005-07-30 at 18:18 -0700, Cory Nelson wrote:
> something like sql server is likely better for the task. sqlite can
> lag quite a bit when it needs to get file locks over the network to
> stay atomic.
The point of this thread is that SQLite cannot be _atomic_ over [any]
networked filesyst
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
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
> >> whe
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 ran
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, a
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 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 a
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
> freq
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 do
e DBMS's, but at least it would be possible.
Which brings 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 Mes
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 ce
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 MacO
On Fri, 2003-10-17 at 04:24, Paul Smith wrote:
> At 19:43 16/10/2003, Bernie Cosell wrote:
> >On 16 Oct 2003 at 17:08, Paul Smith wrote:
> >
> > > At 16:44 16/10/2003, you wrote:
> > > >I prefer the 'reply to sender' default rather than
> > > >'reply to all'. ...
> >
> > > It really depends what yo
On Fri, 2003-10-17 at 09:07, Bert Verhees wrote:
> >Fix your email client, or use one that isn't broken. Tell others to do
> >the same.
> >
> Fixing an email-client is not always an option.
> Many emailclients respond to the Reply To header, like described in RFC822
>
> "the presence of the "Repl
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]> ?
I
On Sun, 2003-10-19 at 17:08, D. Richard Hipp wrote:
> William Trenker wrote:
> >
> > Any chance of adding the standard List-Id header to the new mailing list?
>
> If I made the change correctly, this reply should have the List-Id header
> line.
It's incorrect. The entry has junk in it (backspa
On Sun, 2003-10-19 at 18:33, D. Richard Hipp wrote:
> JeeBak Kim wrote:
> > * D. Richard Hipp ([EMAIL PROTECTED]) [031019 14:08]:
> >
> >>William Trenker wrote:
> >>
> >>>Any chance of adding the standard List-Id header to the new mailing list?
> >>
> >>If I made the change correctly, this reply
I've seriously considered taking this off the list because this whole
thread has turned retarded. People involved: read on if you actually
feel like finding out why, and what you can do about it.
> Why not be a bit flexible, one of the tasks of an admin is to comfort
> the users as much as he or
On Thu, 2003-10-23 at 13:31, Wayne Venables wrote:
> Unfortunately that still means there is a performance hit converting all
> data in and out of the library from UTF-8 to UCS16. A large number of
> operating systems and programming languages store strings natively as UCS16.
If you're actually
On Thu, 2003-10-23 at 19:46, v t wrote:
> Hi,
>
> How do I turn journalling OFF?
Why do you want to? What exactly are you trying to accomplish?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Consider using an automated filtering system. Your MTA may be able to
filter sqlite-users messages for you.
On Fri, 2003-10-24 at 05:02, Steve O'Hara wrote:
> Hi All,
>
> I suppose this has to be the most boring topic that I've seen on SQLite
> listservers for the past 2 years. However, since t
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 d
On Fri, 2003-10-24 at 21:06, Wayne Venables wrote:
> At 05:39 PM 24/10/2003, you wrote:
> >On Thu, 2003-10-23 at 13:31, Wayne Venables wrote:
> > > Unfortunately that still means there is a performance hit converting all
> > > data in and out of the library from UTF-8 to UCS16. A large number of
>
CREATE TABLE Correlations (origin, destination, weight);
INSERT INTO Correlations VALUES ('p', 'q', 1);
INSERT INTO Correlations VALUES ('q', 'a', 0.5);
INSERT INTO Correlations VALUES ('q', 'b', 0.5);
INSERT INTO Correlations VALUES ('q', 'c', 0.5);
INSERT INTO Correlations
SELECT a1.orig
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 Sat, 2003-10-25 at 04:32, M. Fioretti wrote:
> On Fri, Oct 24, 2003 21:24:44 at 09:24:44PM -0400, Mrs. Brisby ([EMAIL PROTECTED])
> wrote:
> >
> > FYI, nobody said internal use of "unicode" - just "UCS16". Plan9
> > doesn't. Linux doesn't.
On Sun, 2003-10-26 at 19:11, [EMAIL PROTECTED] wrote:
> On Sun, 26 Oct 2003 12:39:40 -0500
> "Mrs. Brisby" <[EMAIL PROTECTED]> wrote:
> > Further: I always read statements like "Microsoft C/C++ is the largest
> > most popular language platform in the world&
am not worried about rolling back the database to a
> known state in case of some failure.
>
> vt
>
> "Mrs. Brisby" <[EMAIL PROTECTED]> wrote:
> On Thu, 2003-10-23 at 19:46, v t wrote:
> > Hi,
> >
> > How do I
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
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 Tue, 2003-11-04 at 05:39, D. Richard Hipp wrote:
> Avner Levy wrote:
> >
> > We have just finished testing the same scenario with MySql at amazingly
> > they continued to insert 1500-3000 rows per second even when the
> > database had 60,000,000 records. I don't know how this magic is done...
On Tue, 2003-11-04 at 17:12, D. Richard Hipp wrote:
> I'm not sure what you or Mrs.Brisby mean by "packing".
My apologies then; my statement was made before espresso so I don't
doubt I was making much sense.
Here goes:
Because MySQL stores the literal values of integers as a four octet
value the
On Wed, 2003-11-05 at 13:44, Clark, Chris wrote:
> > -Original Message-
> > From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
> >
> > MySQL has stated in-documentation that it uses a B-tree for
> > it's index.
> > I think this is a mistake- especially
On Wed, 2003-11-05 at 23:59, Jonas Forsman / Axier.SE wrote:
> According to the postgresql documentation, the hash algorithm is
> discouraged compared to b-tree for performance reasons.
>
> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=indexes-types.html
>
> Note: Testing has sh
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 usua
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
On Thu, 2003-11-06 at 23:31, [EMAIL PROTECTED] wrote:
> I guess in this case the hashes aren't really hashes anymore, they're more
> like arrays. There wouldn't be any bucket under hash unless the key was
> identical for two values. The B-tree entry becomes x div 4 (or an
> appropriate number).
Usually they don't.
If your program actually depends on SQLite the dynamic linker will bring
the greatest non-api-incompatible version in automatically. You simply
add -lsqlite to the link list and libsqlite.so will automatically be
brought in- thus saving disk space at the expense of startup time
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 in
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
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.
DEFER_W
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 val
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 twic
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 07:
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
>
On Fri, 2003-12-12 at 09:58, Paul Smith wrote:
> > > If one always store fax numbers in the third element of the Phones
> > > collection, one could find all rows that contain a particular fax
> > > number
> > > like this:
> > >
> > > SELECT LastName FROM Contacts WHERE Phones(3) = "2064814442"
> >
t; WITH Extension="234"
> This means find records where the same occurance 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
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
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 f
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 S
Actually, I knew... I don't think this is a bug, but instead a feature.
Note it has nothing at all to do with closing the file descriptor. In my
below example (taken from a Linux 2.6 system), I don't bother closing
fd#3 before trying to lock again-- and yet my lock succeeds anyway.
open("/tmp/foo
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
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
Guaranteed? No. Clients can disassemble, reverse engineer, trace,
snapshot pages, and attach whatever debugging interface they like.
Some are of the mindset that because you cannot do it, you shouldn't
pretend you can.
Others think pretending that something works is just as good as it
actually wo
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 o
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
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 ev
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 equal.
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,
> >
On Wed, 2004-06-02 at 01:53, Daniel K wrote:
> Hi,
>
> The getpid() call on my Redhat9 linux box is causing
> some trouble for SQLite. It's reasonably complicated,
> but SQLite currently assumes that on linux the
> getpid() function returns a different value in
> different threads.
Have you trie
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 th
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" w
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. P
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
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 Dat
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 w
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 upd
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 v
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 o
96 matches
Mail list logo