Re: [sqlite] OT: Donations?

2006-02-27 Thread Firman Wandayandi
On 2/28/06, Chethana, Rao (IE10) <[EMAIL PROTECTED]> wrote: > Hi! > > Did u enquire about donations to sqlite.org ? what reply u got? > No didn't. And I dunno exactly about donations, you need to wait the sqlite team or you can ask to D. Ricard Hipp for that. -- Firman Wandayandi Never Dreamt

RE: [sqlite] OT: Donations?

2006-02-27 Thread Chethana, Rao \(IE10\)
Hi! Did u enquire about donations to sqlite.org ? what reply u got? -Original Message- From: Firman Wandayandi [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 1:08 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] OT: Donations? On 2/27/06, Chethana, Rao (IE10) <[EMAIL

Re: [sqlite] File format changed !!

2006-02-27 Thread Firman Wandayandi
On 2/28/06, Pavan Savoy <[EMAIL PROTECTED]> wrote: > I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 > and I get the following err when I try to see the sqlite_master table .. > > SQL error: unsupported file format > > > I suppose the file format has been changed over the

RE: [sqlite] File format changed !!

2006-02-27 Thread Chethana, Rao \(IE10\)
Hi! Just use select * from sqlite_master; -Original Message- From: Pavan Savoy [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 10:13 PM To: sqlite-users@sqlite.org Subject: [sqlite] File format changed !! I am trying to open a database created in SQLite 3.3.1 in SQlite

[sqlite] File format changed !!

2006-02-27 Thread Pavan Savoy
I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 and I get the following err when I try to see the sqlite_master table .. SQL error: unsupported file format I suppose the file format has been changed over the versions, but the reverse does work, i.e db created on 3.1.2

Re: [sqlite] Re: what is on my computer

2006-02-27 Thread Roger Binns
ProcessExplorer will also list all resources open per process. That is the easiest way of doing it. Start Process Explorer and then do Find > Find Handle and type in a portion of the filename. You'll then get a listing of all processes/handles with that portion of the filename. Roger

Re: [sqlite] Re: what is on my computer

2006-02-27 Thread Nuno Lucas
On 2/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > look i have over 600 temp file i cannot remove or delete why is this. they > > all start with sqlite_ then there is another over 600 files with 3k > > memory, > > but the sqlite_ files have ok memory > >

Re: [sqlite] Re: what is on my computer

2006-02-27 Thread Jose Da Silva
On February 27, 2006 06:29 pm, [EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] wrote: > > look i have over 600 temp file i cannot remove or delete why is > > this. they all start with sqlite_ then there is another over 600 > > files with 3k memory, but the sqlite_ files have ok memory > > I'm

Re[2]: [sqlite] Triggers and TEMP tables: ticket #1689

2006-02-27 Thread Taka
I definitely second this since I actually got bitten by this last week :-) We split over 2 databases for the same reason as Derrell and always attach after opening them. Surely it's harmless to remove these checks - if something goes wrong, the trigger will just fail normally with a "no such

Re: [sqlite] Triggers and TEMP tables: ticket #1689

2006-02-27 Thread Derrell . Lipman
[EMAIL PROTECTED] writes: > Should I remove the tests from SQLite that prevent > triggers in one database from referring to tables in > a different database? Or should I leave things as > they are and close ticket #1689 with a remark of > "works as designed". I have had use for triggers that

[sqlite] Triggers and TEMP tables: ticket #1689

2006-02-27 Thread drh
A user complains in ticket #1689 that SQLite does not allow triggers in one database to refer to tables in a different database or to TEMP tables. SQLite actually goes to a lot of trouble to detect these kinds of things since, as we were writing the code, we could not think of any circumstance

Re: [sqlite] Suggestions for optimizing delete

2006-02-27 Thread drh
"Brett Wilson" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm working on using sqlite for Firefox's bookmarks and history > system. We need to expire history older than N days when the browser > shuts down. It's currently slower than I would like and I'd appreciate > any tricks you might be able to

Re: [sqlite] Suggestions for optimizing delete

2006-02-27 Thread Jay Sprenkle
On 2/27/06, Brett Wilson <[EMAIL PROTECTED]> wrote: > > I tried some other things like creating a trigger that sets a flag in > moz_history when a visit has been deleted so we only have to check > those items, but it still seems slow. Can anybody offer any insight on > this? I'm not really a SQL

[sqlite] Suggestions for optimizing delete

2006-02-27 Thread Brett Wilson
Hi, I'm working on using sqlite for Firefox's bookmarks and history system. We need to expire history older than N days when the browser shuts down. It's currently slower than I would like and I'd appreciate any tricks you might be able to suggest. Database layout: We have a table of URLs and

[sqlite] RE: [RBL] RE: [sqlite] Writing wrappers?

2006-02-27 Thread Steve O'Hara
In most cases (but not all - C++,Delphi) yes. A wrapper is a lump of C code that bridges the SQLite environment with your own specific language. I just did a bit of research for you and found that Frontier uses a scripting language called UserTalk to allow users to interact with it. It also

Re: [sqlite] OT: Donations?

2006-02-27 Thread Firman Wandayandi
On 2/27/06, Chethana, Rao (IE10) <[EMAIL PROTECTED]> wrote: > Hello! > > That's a good idea! > I think u can post ur question to www.sqlite.org & see. They'll b able > to tell u. > Post to sqlite.org? why not here? that's nice to get some donations. -- Firman Wandayandi Never Dreamt Before:

RE: [sqlite] OT: Donations?

2006-02-27 Thread Chethana, Rao \(IE10\)
Hello! That's a good idea! I think u can post ur question to www.sqlite.org & see. They'll b able to tell u. -Original Message- From: Denis Sbragion [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 12:50 AM To: sqlite-users@sqlite.org Subject: [sqlite] OT: Donations? Hello,

[sqlite] OT: Donations?

2006-02-27 Thread Denis Sbragion
Hello, might be a bit off topic, but, is there any way to make donations to SQLite? I haven't been able to find informations on the SQLite web site. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it