I am looking into the best method for implementing a database for a small
application that I will most likely be building it in Adobe Air. I looked
at Appropriate Uses For SQLite on the the SQLite.org website and I got
some conflicting info.
for Example I saw the following:
SQLite usually
:
I am looking into the best method for implementing a database for a small
application that I will most likely be building it in Adobe Air. I looked
at Appropriate Uses For SQLite on the the SQLite.org website and I got
some conflicting info.
for Example I saw the following:
SQLite usually
looking into the best method for implementing a database for a small
application that I will most likely be building it in Adobe Air. I
looked
at Appropriate Uses For SQLite on the the SQLite.org website and I got
some conflicting info.
for Example I saw the following:
SQLite usually
Thank you for your thorough replies to my supplementary remarks on this topic.
It seems to me clear now that it is best not to take a careful disclaimer etc (on
site networking support) as typically/generally indicating a limitation on
usefulness of sqlite. Rather it is a matter of taking care
Hey, sorry I'm a little late on this one (as usual).
On 2/3/07, David M X Green [EMAIL PROTECTED] wrote:
I am new to this but are these issues those of trying to get it to do what sqlite
it is not designed for. I quote the book
The Definitive Guide to SQLite - Chapter 1 --- Networking
On Feb 2, 2007, at 8:59 AM, Clark Christensen wrote:
FWIW, I'm not convinced Samba has locking working correctly. Using
a very recent Samba version, I managed to corrupt a SQLite database
last fall by (I think) doing simultaneous writes from the Linux host
box, and my WinXP client box
]
Sent: Sunday, 4 February 2007 1:17 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
I am new to this but are these issues those of trying to get it to do
what sqlite it is not designed for. I quote the book
The Definitive Guide to SQLite - Chapter 1 --- Networking
: Re: [sqlite] Appropriate uses for SQLite
I am new to this but are these issues those of trying to get it to do
what sqlite it is not designed for. I quote the book
The Definitive Guide to SQLite - Chapter 1 --- Networking Again,
most of these limitations are intentional-they are a result
]
Sent: Monday, 5 February 2007 3:08 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
We used Sqlite in a web server successfully. It is embedded in a custom
written web server which provides multithreaded access and application
language support (an application
I am new to this but are these issues those of trying to get it to do what
sqlite it is not designed for. I quote the book
The Definitive Guide to SQLite - Chapter 1 --- Networking
Again, most of these limitations are intentional—they are a result of
SQLite’s
design. Supporting high
[EMAIL PROTECTED] wrote:
The problem is, not many network filesystems work correctly.
Hi All,
If my understanding of this is correct, SQLite only requires that the
network file system has; reliable data transport and working file
locking. This has primarily been an issue on older
Dennis Cote wrote:
[EMAIL PROTECTED] wrote:
The problem is, not many network filesystems work correctly.
Hi All,
If my understanding of this is correct, SQLite only requires that the
network file system has; reliable data transport and working file
locking. This has primarily been an issue
[EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Friday, February 2, 2007 7:49:55 AM
Subject: Re: [sqlite] Appropriate uses for SQLite
[EMAIL PROTECTED] wrote:
The problem is, not many network filesystems work correctly.
Hi All,
If my understanding of this is correct, SQLite only requires
On 2/2/07, Dennis Cote [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
The problem is, not many network filesystems work correctly.
I'm sure someone knows which versions of NFS have working file locking,
at least under Linux.
I doubt it is this easy. You need to line up a bunch of things
Scott Hess wrote:
On 2/2/07, Dennis Cote [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
The problem is, not many network filesystems work correctly.
I'm sure someone knows which versions of NFS have working file locking,
at least under Linux.
I doubt it is this easy. You need to line up
Hi SQLite users
Thank you for your attention - I am just hoping for some clarification
of usability of SQLite.
Referring to: http://www.sqlite.org/whentouse.html
- SQLite works well in websites
- Other RDBMS may work better for Client/Server applications
- SQLite will work over a network file
I am not an expert on SQLite - but if you are running separate
websites from your multiple servers, then why not use 4 instances of
SQLite ?? That is unless the websites need to share the same
database/tables.
If they do need to share the same database/tables, then PostgreSQL or
MySQL
Subject: Re: [sqlite] Appropriate uses for SQLite
I am not an expert on SQLite - but if you are running separate websites
from your multiple servers, then why not use 4 instances of SQLite ??
That is unless the websites need to share the same database/tables.
If they do need to share the same
-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
I am not an expert on SQLite - but if you are running separate
websites
from your multiple servers, then why not use 4 instances of SQLite ??
That is unless the websites need to share the same database/tables.
If they do need
drop data once in a blue moon, but corruption is
not
acceptable.
Thanks again.
Anil.
-Original Message-
From: Philip Butler [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 February 2007 11:39 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
I am
data is in separate files with
no compression, etc.
Thanks for taking the time.
Anil.
-Original Message-
From: Philip Butler [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 February 2007 12:16 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
And this is when I'll
February 2007 12:24 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
I'd be _extremely_ leery of doing this on a network store. In theory,
it should work just fine, but bridging theory and practice may very well
cost you many sleepless nights. sqlite is in many
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Appropriate uses for SQLite
That's what I'm talking about! It's good to get the perspective from
your setup, Phil. I'm beginning to get the picture.
I am starting to think that I should stick to an enhancement of my
current system. It's *very* basic, even
Butler [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 7:39 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
I am not an expert on SQLite - but if you are running separate
websites from your multiple servers, then why not use 4 instances of
SQLite
.
Thanks Eric.
Anil.
-Original Message-
From: Eric Pankoke [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 February 2007 1:08 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Appropriate uses for SQLite
By separate files, do you mean that each user has their own data store?
If so, why not do
question, Wayne.
Anil.
-Original Message-
From: WB Stow [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 February 2007 1:12 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Appropriate uses for SQLite
I think that he said that he is running one website on four different
servers using loadbalancing
Anil Gulati -X \(agulati - Michael Page at Cisco\) [EMAIL PROTECTED] wrote:
I am trying to decide whether I can use SQLite for a website that runs
on 4 load-balanced servers using networked file storage mounted by all
servers for common data access.
This sounds like a job for a
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Appropriate uses for SQLite
Anil Gulati -X \(agulati - Michael Page at Cisco\) [EMAIL PROTECTED]
wrote:
I am trying to decide whether I can use SQLite for a website that runs
on 4 load-balanced servers using networked file storage mounted by all
28 matches
Mail list logo