[sqlite] Problem in Sqlite installation in Irix

2005-12-19 Thread Prettina Louis
hello sir, I am trying to install Sqlite-3.2.7 in Irix 6.5 version OS. As mentioned in the README file, I gave the following command: mkdir bld cd bld ../sqlite-3.2.7/./configure --with-sqlite3 after this command got executed I could see four files in the bld dir. Makefile, config.status,

[sqlite] Version 3.2.8 and 2.8.17

2005-12-19 Thread Prettina Louis
hello sir, Greetings in the name of the lord! Sir, please let me know , if I can download and configure the Sqlite 3 in irix 6.5.. I would be highly grateful to you. Thanks in advance "praise the lord!" With regards and prayers, prettina ==

re: [sqlite] VB.Net

2005-12-19 Thread sales
We did try one wrapper designed for .NET but it's setup program didn't set itself up right on our system and I didn't have the time to mess with it. We do use this and it works great: http://www.sqliteplus.com/ It's a COM interface to a sqlite DLL. It's a little pricey at $180 but that includ

re: Re[2]: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread sales
Thank you for your tips on page file settings. This is going to end up as a commerical product and it can be difficult to predict what potential users may have and what other programs they might try to run the same time as mine in the background. Our application runs up to 20 threads and is pr

Re: [sqlite] VB.Net

2005-12-19 Thread Robert Simpson
- Original Message - From: "Vishal Kashyap" <[EMAIL PROTECTED]> Any possibility of using VB.NET with Sqlite as Backend. Please do mention some links. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Lots to choose from ... Robert

Re: [sqlite] VB.Net

2005-12-19 Thread Cory Nelson
check out the sqlitewrappers wiki page. On 12/19/05, Vishal Kashyap <[EMAIL PROTECTED]> wrote: > Dear All , > > Any possibility of using VB.NET with Sqlite as Backend. > > Please do mention some links. > > > -- > With Best Regards, > Vishal Kashyap. > http://vishalkashyap.tk > -- Cory Nelson htt

[sqlite] VB.Net

2005-12-19 Thread Vishal Kashyap
Dear All , Any possibility of using VB.NET with Sqlite as Backend. Please do mention some links. -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk

Re[2]: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread Teg
Hello drh, I'll try to characterize what I see. I'm running bare-backed here, no firewall or virus scanner (though I'm protected from the internet by a hardware firewall). Some of my databases are pushing 10gig but, I see it on smaller ones too, or at least I think I see it. C Monday, December

Re[2]: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread Teg
Hello sales, What are you using for a data structure? I regularly have literally millions of hashed data structures in memory without encountering this. If it's windows, I know exactly what it is though, windows pages things out on a whim so, if you're not constantly touching your data structures,

[sqlite] implementing editable result sets

2005-12-19 Thread Will Leshner
Hi. I apologize in advance for the length of this question, but it is a little involved. I am the author of a wrapper for SQLite and in that wrapper there is an object called a RecordSet that represents the results of a query. One of the things you can do with a RecordSet is edit records. T

Re: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread sales
Yes the timestamp method is one we have done from within our own code and it may very well be the operating system catching up to where it should be and not the database's fault at all. It hangs on a read after the inserts--- ourDB.Exec("Select x From Y where x.HashCode = z LIMIT 1;"). (where

Re: [sqlite] Version 3.2.8 and 2.8.17

2005-12-19 Thread drh
[EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] writes: > > > New versions of SQLite 2 and 3 are now available on the website. > > > > http://www.sqlite.org/ > > > > These new versions contain a one-line fix to a problem that can > > lead to database corruption. The problem has been in the code >

Re: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread Dennis Jenkins
[EMAIL PROTECTED] wrote: The delay seems to coincide with the journal file creation-- it happens after our first (committed but not yet written to disk) write attempt to the database, the journal file does not at-the-time exist, and there are 500+ inserts pending with reads rapidly being adde

Re: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread sales
The delay seems to coincide with the journal file creation-- it happens after our first (committed but not yet written to disk) write attempt to the database, the journal file does not at-the-time exist, and there are 500+ inserts pending with reads rapidly being added after that. Although I to

Re: [sqlite] Version 3.2.8 and 2.8.17

2005-12-19 Thread Derrell . Lipman
[EMAIL PROTECTED] writes: > New versions of SQLite 2 and 3 are now available on the website. > > http://www.sqlite.org/ > > These new versions contain a one-line fix to a problem that can > lead to database corruption. The problem has been in the code > for almost 4 years and has so far gone un

Re: [sqlite] Version 3.2.8 and 2.8.17

2005-12-19 Thread Gerry Snyder
[EMAIL PROTECTED] wrote: New versions of SQLite 2 and 3 are now available on the website. http://www.sqlite.org/ Is the omission of tcl bindings for 2.8.17 deliberate? They are not listed for either linux or Windows.

[sqlite] Version 3.2.8 and 2.8.17

2005-12-19 Thread drh
New versions of SQLite 2 and 3 are now available on the website. http://www.sqlite.org/ These new versions contain a one-line fix to a problem that can lead to database corruption. The problem has been in the code for almost 4 years and has so far gone unnoticed, suggesting that it is not a se

Re: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread drh
[EMAIL PROTECTED] wrote: > > We just noticed a 30-40 second hit at early on in our program running. > Others have reported things like this caused by anti-virus software running on the same machine and insisting on doing some kind of virus scan the first time the journal file is created. -- D. R

Re: Re[2]: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread Will Leshner
On Dec 19, 2005, at 8:32 AM, Teg wrote: I notice a similar thing with my databases when they get to any decent size. it seems like the first time you access them, doing anything, there's a decent startup delay and then it's fast from that time forward. Someone mentioned OS disk cache and I wond

Re[2]: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread Teg
Hello sales, I notice a similar thing with my databases when they get to any decent size. it seems like the first time you access them, doing anything, there's a decent startup delay and then it's fast from that time forward. Someone mentioned OS disk cache and I wonder about the internal SQLite c

re: [sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread sales
I think I've confused the issue a bit and the aforementioned time hit might be normal given: http://www.sqlite.org/lockingv3.html We are using a separately developed COM DLL interface to Sqlite v3: http://www.sqliteplus.com/ And we can live with the journal creation time if that is what it is

[sqlite] multiple Db's and journal file time hit?

2005-12-19 Thread sales
Hello Recently it was written: whenever a modifying transaction starts (or rather, when it has to actually write data to disk for the first time), SQLite has to create a journal file for each DB involved as well as a master journal file. We are testing (almost ready to purchase the $180 COM

RE: [sqlite] Reg: Sqlite Installation

2005-12-19 Thread Essien Ita Essien
Hi Prettina, It would *really* help, if you included a snip of the *actual* error you're having. Then folks would be able to help out. As it is, I don't think there's an *SQLite3 For IRIX Installation Howto(tm)* anywhere on the Googlesphere ;) A picture is worth a thousand words... but when in do

[sqlite] Reg: Sqlite Installation

2005-12-19 Thread Prettina Louis
  Respected Sir, Greetings! Sir, I am planning to install Sqlite for Kobas in Irix 6.5 OS, Please let me know in detail how to install the same. I am facing problem after configuration step, ie in 'make' step some error. I would be grateful to you if u could give me a step wise