Re: [sqlite] how to take backup sqlite db @ ipad

2011-06-11 Thread Simon Slavin 

On 11 Jun 2011, at 11:49am, irfan khan wrote:

> Now i am taking backup of my sqlite database(ipad) from sqlite browser by
> syncing my ipad with local machine in the same network.
> I want to know how to take backup of SQLITE databases on ipad both cold and
> hot if anyway is there?

Use iTunes to backup your iPad in the normal way, when you synchronise it to 
your computer.  This will backup the contents of your SQLite databases along 
with all other application files.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] can we configure high availibility with SQLITE?

2011-06-11 Thread Alexey Pechnikov 
No, not like to other.  Sqlite engine does not has internal high
availability functions.
Use application-level sync or async replication/logging if needed.

2011/6/11 irfan khan :
> Hi,
>
>  Can we configure high availibility with SQLITE databases like we can do
> with other rdbms.
>
> --
>
>
>
> Thanks & Regards
>
> Irfan Khan
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] can we configure high availibility with SQLITE?

2011-06-11 Thread Kees Nuyt 
On Sat, 11 Jun 2011 13:51:43 +0300, irfan khan
 wrote:

> Hi,
>
> Can we configure high availibility with SQLITE databases like we can do
> with other rdbms.

No.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] can we do recovery for certain time?

2011-06-11 Thread Kees Nuyt 
On Sat, 11 Jun 2011 13:54:45 +0300, irfan khan
 wrote:

>Hello,
>
> I want to know, if we can do a point time recovery for SQLITE database? not
> only restore database.

No, SQLite automatically recovers up to and including the last
completed transaction, rolling back any unfinished transaction.
If you know beforehand which points in time you are interested in,
you could:
- backup that point in time (file backup)
- backup that point in time (using the SQLite backup facility)
- take a snapshot of the filesystem (using e.g. zfs).

> awaiting ofr your replayplease help me.

Reading the documentation at http://www.sqlite.org/docs.html will
give you more insight.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-11 Thread Christoph P.U. Kukulies 
Am 10.06.2011 16:55, schrieb Paul Linehan:
> 2011/6/9 Christoph P.U. Kukulies:
>
>
>>> If you want something that works on Linux as well as Windows, try
>>> the Firefox SQLite extension - it's the dog's!
>> I've heard big caveats about that one - to avoid like the .., no, I

There was some thread initated by the words "avoid MySQL like the plague 
..." and it incended
a flameful thread. That's what I wanted to avoid. But since you are asking:

Maybe I read it here or in another forum where soneone was saying that 
he had nothing but trouble
with this Firefox SQLite-plugin. It was said that it was either hogging 
FF or it was an SQLite DB unwantedly.

>> don't want to open another can of worms :)
>
> I don't wish to cause controversy here, but could you explain
> exactly what you mean by this? What is there about this tool
> that is problematic?
--
Christoph

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] can we do recovery for certain time?

2011-06-11 Thread irfan khan 
Hello,

 I want to know, if we can do a point time recovery for SQLITE database? not
only restore database.
 awaiting ofr your replayplease help me.


-- 



Thanks & Regards

Irfan Khan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] can we configure high availibility with SQLITE?

2011-06-11 Thread irfan khan 
Hi,

 Can we configure high availibility with SQLITE databases like we can do
with other rdbms.

-- 



Thanks & Regards

Irfan Khan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to take backup sqlite db @ ipad

2011-06-11 Thread irfan khan 
Hello,

 Now i am taking backup of my sqlite database(ipad) from sqlite browser by
syncing my ipad with local machine in the same network.
 I want to know how to take backup of SQLITE databases on ipad both cold and
hot if anyway is there?


-- 



Thanks & Regards

Irfan Khan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users