Re: [sqlite] sqlite db portability

Thanks everyone for your input. Shilpa On 8/27/07, Asif Lodhi <[EMAIL PROTECTED]> wrote: > Hi Shilpa, > > On 8/28/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote: > > Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL > > installed. Ca

Re: [sqlite] sqlite db portability

I meant the db file. Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL installed. Can it access "mysqlitedb.db" On 8/27/07, Markus Hoenicka <[EMAIL PROTECTED]> wrote: > Shilpa Sheoran writes: > > Can the sqlite db file be access

[sqlite] sqlite db portability

Can the sqlite db file be accessed using another DB api's eg. MySQL or anyother. Thanks. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Declaring variables

Does SQLite support declaring/using local variables in a Trigger? If not what is the alternative? CREATE TRIGGER trig1 AFTER INSERT ON table1 BEGIN DECLARE num INTEGER; SELECT COUNT(id) INTO num FROM table1; INSERT INTO table2 (count) VALUES (num); END; Thanks Shilpa

[sqlite] Sqlite - LISTEN/NOTIFY

All, Does sqlite implement LISTEN or NOTIFY commands? Basically if one application modifies the database will sqlite notify other interested applications about the modification? Shilpa - To unsubscribe, send email to

[sqlite] Sqlite - Multithreading

All, According to the documentation.. "When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds. Other processes just wait on the writer to finish then continue about their business" Does sqlite take

Re: [sqlite] SQL error: disk I/O error

error. Thanks On 5/22/07, Joe Wilson <[EMAIL PROTECTED]> wrote: What is the OS you're using and what kind of media is it? Hard drive or USB key or ??? --- Shilpa Sheoran <[EMAIL PROTECTED]> wrote: > It seems that rc = fsync(fd); is failing in function > static int full_fsync(in

Re: [sqlite] SQL error: disk I/O error

It seems that rc = fsync(fd); is failing in function static int full_fsync(int fd, int fullSync, int dataOnly) in file os_unix.c { #else /* if !defined(F_FULLSYNC) */ if( dataOnly ){ rc = fdatasync(fd); }else{ //*this call is failing rc =

[sqlite] SQL error: disk I/O error

I'm running the command line tool to create sqlite3 db. My directory permissions are drwxrwxrwt. I'm getting the following error. ./sqlite3 newdb SQLite version 3.3.12 Enter ".help" for instructions sqlite> create table tbl1(one varchar(10), two smallint); SQL error: disk I/O error If I try

[sqlite] Schema

All, Are there database schema's (eg. for Phonebook ) available on the net? Thanks Shilpa - To unsubscribe, send email to [EMAIL PROTECTED] -