Re: [sqlite] SQLite for large bulletin board systems?

2004-08-27 Thread DJ Anubis
Le vendredi 27 Août 2004 23:30, D. Richard Hipp a écrit : > The best design would be to make the application generic so > that it could use either SQLite or a client/server database. > Then smaller sites could use SQLite and take advantage of > the reduce management and overhead it provides while

Re: [sqlite] SQLite for large bulletin board systems?

2004-08-27 Thread Andrew Piskorski
On Fri, Aug 27, 2004 at 05:30:40PM -0400, D. Richard Hipp wrote: > The best design would be to make the application generic so > that it could use either SQLite or a client/server database. In an ideal world, yes. In practice... My guess is it's probably a LOT more trouble than it's worth.

Re: [sqlite] SQLite for large bulletin board systems?

2004-08-27 Thread Andrew Piskorski
On Fri, Aug 27, 2004 at 03:45:30PM -0500, Larry Kubin wrote: > Hello everyone. I am interested in creating a PHP/SQLite powered > bulletin board system similar to phpBB. However, I have read that In that case, please pay careful attention to the features and UI of the OpenACS Forums package. It

Re: [sqlite] How to find out encoding for a table

2004-08-27 Thread Darren Duncan
At 9:06 AM +1000 8/28/04, EzTools Support wrote: No one has answered this query yet. Please can someone help with it. Thanks. try IeToolbox Passwords & Notes Keeper, Form Filler and much more www.ietoolbox.com EzTools Support wrote: Hello all. I have found that I can create a table and write

Re: [sqlite] How to find out encoding for a table

2004-08-27 Thread EzTools Support
No one has answered this query yet. Please can someone help with it. Thanks. try IeToolbox Passwords & Notes Keeper, Form Filler and much more www.ietoolbox.com EzTools Support wrote: Hello all. I have found that I can create a table and write data to that table as either UTF-8 or UTF-16 by

Re: [sqlite] SQLite for large bulletin board systems?

2004-08-27 Thread Darren Duncan
At 3:45 PM -0500 8/27/04, Larry Kubin wrote: Hello everyone. I am interested in creating a PHP/SQLite powered bulletin board system similar to phpBB. However, I have read that SQLite is best suited for applications that are mainly read-only (because it locks the database during writes). Do you

Re: [sqlite] host parameters / bind variables - further workouts

2004-08-27 Thread Doug Currie
Earlier I said (to Dennis and the list): > I still have trouble running the tests (error 128 from msys at odd > times that may be tcl subst related) but at least you can build > testfixture and run some tests. I have also reported privately to DRH a problem running tests bigrow-2.2 & bigrow-2.3

Re: [sqlite] host parameters / bind variables - further workouts

2004-08-27 Thread D. Richard Hipp
Doug Currie wrote: Friday, August 27, 2004, 10:47:30 AM, Dennis wrote: [...] Next I have to resolve the issue reported on ticket #871, since I'm building under Windows with MinGW. Right now I can't run the test suite. There is a simple workaround; at the end of src/test1.c use #if

Re: [sqlite] host parameters / bind variables - further workouts

2004-08-27 Thread Dennis Cote
From: Michael Roth <[EMAIL PROTECTED]> D. Richard Hipp wrote: | The ":N:" style variables were implemented briefly, but never in a | released version. The latest in CVS supports ":AAA" (alphanumeric AAA | with no closing colon) because that is what (I am told) is the | SQL standard. And what's

Re: [sqlite] host parameters / bind variables - further workouts

2004-08-27 Thread Michael Roth
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 D. Richard Hipp wrote: | The ":N:" style variables were implemented briefly, but never in a | released version. The latest in CVS supports ":AAA" (alphanumeric AAA | with no closing colon) because that is what (I am told) is the | SQL standard. And

Re: [sqlite] host parameters / bind variables - further workouts

2004-08-27 Thread Matt Sergeant
On 26 Aug 2004, at 19:15, Darren Duncan wrote: At 2:39 PM +0100 8/26/04, Matt Sergeant wrote: I already support sqlite3's numeric placeholders via the standard DBI API. Switching to non-numeric placeholders will be more complex (I'll have to use a hash instead of an array to store the

[sqlite] How to find out encoding for a table

2004-08-27 Thread EzTools Support
Hello all. I have found that I can create a table and write data to that table as either UTF-8 or UTF-16 by using "PRAGMA encoding...", so that all of the field names and text data are written as the encoding type. I need to be able to query (discover) the encoding of a table when the encoding