RE: [sqlite] SQLite in Web application

2003-10-26 Thread Allan Edwards
If you want to do something like this, the only thing necessary is to synchronize access to your data layer. In other words, only one thread of execution should be able to access your Sqlite db at one time. To accomplish this, here is a simple solution. If you have not already put all data access

[sqlite] SQLite in Web application

2003-10-26 Thread Greg Obleshchuk
Hi Everyone , I would like some opinions from anyone with experience in this area. I am thinking of replacing the MS SQL Server backend to my web site with a few SQLite databases. I use the database backend to record purchases and store client information. I also record things like software p

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread Mrs. Brisby
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" as foolish sentiment. These > > people ob

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread Darren Duncan
Twas said: >The thing that most scared me about the higher-order unicode encodings >(16, 32-bit etc) was this "Encoding" list under Windows XP notepad: >ANSI >Unicode >Unicode Big Endian >UTF-8 > >All I can say is "Eeek! Higher-order unicode encodings are >endian-specific!!!". In my mind this puts

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread Peter
Mrs. Brisby wrote: Now what am I trying to do? I'm trying to keep other people from getting confused. If you think I'm attacking you personally, then pay closer attention to what I am saying. No idea, but your tone is getting increasingly flippant.

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread Wayne Venables
At 09:39 AM 26/10/2003, you wrote: Most deliberately unicode-aware task domains have chosen UTF-8- simply because it's a path of minimal resistance. Microsoft chose double-byte unicode encoding (often referred to as UCS16). In case anyone is wondering why Microsoft made such an OBVIOUSLY bad choice

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread Mrs. Brisby
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. > > Not correct, unless I misunderstood the original

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread ben . carlyle
(Looks like I'm one of the first to get caught hitting reply without thinking ;) - Forwarded by Ben Carlyle/AU/IRSA/Rail on 27/10/2003 09:37 AM - Ben Carlyle 27/10/2003 09:33 AM To: Wayne Venables <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] M

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-26 Thread [EMAIL PROTECTED]
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" as foolish sentiment. These > people obviously don't know what they're talking about and need a good >

Re: [sqlite] Making sqlite support unicode?

2003-10-26 Thread M. Fioretti
On Sun, Oct 26, 2003 12:39:40 at 12:39:40PM -0500, Mrs. Brisby ([EMAIL PROTECTED]) wrote: > You did; that's okay. UCS16 != UTF-8. Uh, OK. Thanks for the detailed explanation. Marco Fioretti -- Marco Fioretti m.fioretti, at the server inwind.it Red Hat for low memory ht

Re: [sqlite] Alter Table?!

2003-10-26 Thread Danny Reinhold
Hi andr3a and others > I've implemented this sintax with few options on my PHP Class, if you're > interested in syntax like this: > ALTER TABLE tbl_name ADD column_name alter_specification [FIRST | AFTER > column_name] > or this: > ALTER TABLE tbl_name DROP [COLUMN] col_name > tell me. That's q