re: [sqlite] Network Performance

2003-11-25 Thread Greg Obleshchuk
Hi Brian, I few things. The problem is your network speed compared to local disk speed (also distance is an issue as well) Disk transfer is in Mega bytes where as network IO is in mega bits. SO while IDE standard 33.3MB looks slower than 100mb for your network (even switched) it is in fact sl

re: [sqlite] .NET sqlite wrapper

2003-11-25 Thread Greg Obleshchuk
Hi Richard, Have you placed it on the wiki yet. I added a .NET section with three other native .NET wrappers for SQlite? You should place an entry there if you haven't yet. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers regards Greg O - Original Message - From: Richard Heyes

Re: [sqlite] .NET sqlite wrapper

2003-11-25 Thread Paul Selormey
Someone posted a link to sourceforge.net project of similar effort. You might wish to join efforts to create a single wrapper. Best regards, Paul. - Original Message - From: "Richard Heyes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 26, 2003 8:20 AM Subject: [s

[sqlite] .NET sqlite wrapper

2003-11-25 Thread Richard Heyes
Would anyone be interested in a mostly C# .net wrapper for sqlite? Mostly because of the null reference bug I had which I got around by using a C++ proxy object for open, close and execute functions. It's not your normal ADO.NET model however, just a query class and result class. Cheers. -- Richa

[sqlite] Network Performance

2003-11-25 Thread Brian Pugh
Hi, Now that I've completed my SQLite application (written in Pyxia's IBasic), using the SQLite DLL, I have some questions My database is about 37mb, and has 114,380 records (rows) If I open and query the database locally (ie, the .db file is in the same folder as the application), things move p

[sqlite] SQLite Administration web application

2003-11-25 Thread Greg Obleshchuk
Hello, for anyone who is interested I have placed an application on sourceforge to manage SQLite database from you web site. This is an ASP.NET application . At the moment you can manage databases and table objects. There is a query form and a table wizard form which allows you to data enter i

RE: [sqlite] Win32 coders: change os.c?

2003-11-25 Thread Rob Fowler
KL, thanks. I'm glad to hear someone in agreement with me that using WideCharToMultiByte within os.c is not preferable for performance reasons. >From what I gather, you're doing the exact same thing I'm doing: changing all the string handling Win32 functions in os.c to their 'A' versions. I *love

Re: [sqlite] Spiders vandalizing the wiki

2003-11-25 Thread Matt Sergeant
On 25 Nov 2003, at 12:48, D. Richard Hipp wrote: In the past couple of days, I've been having problems with spiders vandalizing the Wiki at http://www.sqlite.org/cvstrac/wiki. The damage (so far) has been relatively minor and easy to fix. But I've been monitoring these spiders for a while and noti

Re: [sqlite] Spiders vandalizing the wiki

2003-11-25 Thread Gerhard Häring
Good suggestions, IMO, Peter. I normally really hate this, but you could try to mangle the email adresses they look for with some JavaScript gimmicks using document.write. OTOH this sucks big time, because it will make the site harder to use for those who surf with JavaScript disabled or withou

Re: [sqlite] Spiders vandalizing the wiki

2003-11-25 Thread Peter
D. Richard Hipp wrote: If you have any suggestions on what to do about them, I'd like to hear from you. Block the entire IP range, for say 2 weeks at a time. I'm guessing that these spiders are coming from spammers looking to harvest email addresses. Last nights attack came from 61.51.123.205.

Re: [sqlite] Spiders vandalizing the wiki

2003-11-25 Thread Mrs. Brisby
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:

Re: [sqlite] Spiders vandalizing the wiki

2003-11-25 Thread Gerhard Häring
D. Richard Hipp wrote: In the past couple of days, I've been having problems with spiders [...] You could use a robots.txt to guard against those spiders that behave well. If the misbehaving spiders use a certain distinguishable User-Agent header, you could block that. -- Gerhard --

[sqlite] Spiders vandalizing the wiki

2003-11-25 Thread D. Richard Hipp
In the past couple of days, I've been having problems with spiders vandalizing the Wiki at http://www.sqlite.org/cvstrac/wiki. The damage (so far) has been relatively minor and easy to fix. But I've been monitoring these spiders for a while and notice that they are becoming increasingly aggressive.