[sqlite] Re:SQLite ODBC Driver

Hello, Here's what my ISP is saying: "it doesn't look like we would be installing SQLite on our shared servers. It looks to be in an "experimental state" so we couldn't install it due to the security and stability risks." Now if there was only a stable ODBC driver with SQLite then I could

Re: [sqlite] getpid() and linux threads in sqlite

Daniel K wrote: Hi, The getpid() call on my Redhat9 linux box is causing some trouble for SQLite. It's reasonably complicated, but SQLite currently assumes that on linux the getpid() function returns a different value in different threads. Not so for my setup! The attachment is a program to test

Re: [sqlite] Re:SQLite ODBC Driver

Le mer 02/06/2004 à 08:16, Raymond Irving a écrit : > Hello, > > Here's what my ISP is saying: > > "it doesn't look like we would be installing SQLite on > > our shared servers. It looks to be in an > "experimental state" wrong > so we > couldn't install it due to the security and

[sqlite] palm pilot

Hello, i hope not to ask a faq :-) I use a palm Vx. The biggest problem, in my opinion, i can't find a good databse for this device. I want to ask you if sqlite may run on palm. Is it possible? Is there a version for this device or is it planned? Thanks --

Re: [sqlite] getpid() and linux threads in sqlite

Hi Dainel, From: "Daniel K" <[EMAIL PROTECTED]> > The getpid() call on my Redhat9 linux box is causing > some trouble for SQLite. It's reasonably complicated, > but SQLite currently assumes that on linux the > getpid() function returns a different value in > different threads. Not so for my

Re: [sqlite] getpid() and linux threads in sqlite

Hello Dan, list Here are the results for Mandrake 10: Linux linux.local 2.4.25-2mdk #1 Tue Mar 2 07:39:08 CET 2004 i686 unknown unknown GNU/Linux pid is 2363 pid is 2363 pid is 2363 pid is 2363 pid is 2363 Linux linux.local 2.6.3-4mdk #1 Tue Mar 2 07:26:13 CET 2004 i686 unknown unknown

[sqlite] Does Richard have a wish-list @ Amazon?

Hi, BTW, does Richard have a wish-list over at Amazon or Barnes and Noble so that people have an easy way to show their appreciation of the work he does with SQLite? Great make-over of the site. I like it :-) Cheers Fred. - To

Re: [sqlite] Re:SQLite ODBC Driver

On Wednesday 02 June 2004 02:55 am, David Morel wrote: > What do you mean? SQLite installation is the simplest thing ever! > > Change your ISP. Go for a real hosting service. > They sound like they *dont* know how to install it, and *dont* even want to try.

Re: [sqlite] palm pilot

There is a PalmOS port of SQLite available. Mr. Wayne on this list kindly sent me the code of his work on the Palm port. I have not tested it on Palm Vx but I do believe it works(Mr. Wayne can correct me if I am wrong). I am working on Palm OS 6 port of SQLite but haven't been able to get far as

Re: [sqlite] Does Richard have a wish-list @ Amazon?

Frederic Faure wrote: Does Richard have a wish-list over at Amazon or Barnes and Noble I have a wish-list on Amazon. :-) My name and email address at Amazon are as shown in the signature line below. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] Does Richard have a wish-list @ Amazon?

Well then, expect some books because SQLite has made me a lot of cash! Thanks Dr. Hipp - amazing work with SQLite! D. Richard Hipp wrote: Frederic Faure wrote: Does Richard have a wish-list over at Amazon or Barnes and Noble I have a wish-list on Amazon. :-) My name and email address at Amazon

Re: [sqlite] palm pilot

On Jun 2, 2004, at 7:31 AM, Jalil Vaidya wrote: There is a PalmOS port of SQLite available. Mr. Wayne on this list kindly sent me the code of his work on the Palm port. I have not tested it on Palm Vx but I do believe it works(Mr. Wayne can correct me if I am wrong). I am working on Palm OS 6 port

[sqlite] Triggers & last_inserted_id

Suppose I've some tables like these: CREATE TABLE contacts (ID, name, surname); CREATE TABLE oldContacts (ID, name, surname); CREATE TABLE messages (message, contactID, contactWasDeleted default NULL); I wrote a trigger similar to this: CREATE TRIGGER OnDeleteContact BEFORE DELETE ON Contacts FOR

Re: [sqlite] Does Richard have a wish-list @ Amazon?

>> I have a wish-list on Amazon. :-) My name and email address at Amazon are as shown in the signature line below. Since e-mails are automatically removed to avoid spam bots, for those interested, here's the list: http://tinyurl.com/3db5j Fred.

Re: [sqlite] palm pilot

Hello, I think it is certainly possible, although you might need to spend some time searching for an option that works. I was working on a project that needed my to install a database on a mobile device called an Intel Personal Server. It's just like an ipaq, but without the screen. I

[sqlite] Sqlite Secure backup

Hello Everyone, I am a contributor on the php project ( my profile is available at http://pear.php.net/user/gurugeek ) where I maintain several extensions. I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some

Re: [sqlite] Sqlite Secure backup

At 1:26 AM +0200 6/3/04, David Costa wrote: I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some suggestions. Is the right way to proceed the db dump ? I assume that copying the db will result in a corrupted

RE: [sqlite] Sqlite Secure backup

Hi David, I have been thinking about developing a backup/restore as part of my wrapper. It would be great to have all of these features compatible. I really wanted to backup the database and then have the ability to restore just one table or the entire DB. What do you think? Maybe we should

Re: [sqlite] Sqlite Secure backup

On Jun 3, 2004, at 1:38 AM, Darren Duncan wrote: At 1:26 AM +0200 6/3/04, David Costa wrote: I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some suggestions. Is the right way to proceed the db dump ? I assume

Re: [sqlite] Triggers & last_inserted_id

At 5:38 PM +0200 6/2/04, Pix wrote: There is a way to have the right last_inserted_rowid() ? Don't use it. Instead, try substituting the string "old.id" for "last_insert_rowid()". You already know what the contact id is because its in "old.id". Moreover, "last_insert_rowid()" is completely

RE: [sqlite] Sqlite Secure backup

At 9:42 AM +1000 6/3/04, Greg Obleshchuk wrote: Hi David, I have been thinking about developing a backup/restore as part of my wrapper. It would be great to have all of these features compatible. I really wanted to backup the database and then have the ability to restore just one table or the

Re: [sqlite] Sqlite Secure backup

David, please send all replies, like the original questions, to the list ([EMAIL PROTECTED]), not directly to me. You would get a quicker response that way, and I don't feel soley responsible for answering. At 2:49 AM +0200 6/3/04, David Costa wrote: On Jun 3, 2004, at 2:17 AM, Darren Duncan

[sqlite] palm pilot

Hello, i hope not to ask a faq :-) I use a palm Vx. The biggest problem, in my opinion, i can't find a good databse for this device. I want to ask you if sqlite may run on palm. Is it possible? Is there a version for this device or is it planned? Thanks --