Thanks for the info. it has helped clarify some things for me. I think I will
stick with MySQL with this application as it is going to be a networked app.
If I do one that does not need to be on a network i will dive into SQLlite.
thanks again.
Pavel Ivanov-2 wrote:
>
> There's no
There's no contradiction in those citations. First talks about website
with some 100K hits/day. Website means application running on some
dedicated server, clients send HTTP requests to your application and
application processes it working with locally stored database. Second
citation is talking
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: 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
: 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 r
]
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
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
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
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
<[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
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] 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
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 netwo
"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
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
.
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
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
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
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
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
ot, when *can* corruption occur?
>
> I don't mind making the users wait in the unlikely event of a record
> collision, or even drop data once in a blue moon, but corruption is
> not
> acceptable.
>
> Thanks again.
> Anil.
>
> -Original Message-
> From: Philip
-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
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
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
26 matches
Mail list logo