2009/11/25 Tom Lahti t...@bitstatement.net:
SQLite's complete lack of threading model means responding to a single
request at a time.
Simply put, if you have enough users that the possibility of multiple
people requesting information at the same time, or a user request happening
when an
In defence of SQLite (not that I'm especially cheering for it), it
actually is ACID compliant (http://www.sqlite.org/transactional.html,
http://www.sqlite.org/atomiccommit.html) and concurreny issues only
affect writers (readers are fully concurrent;
http://www.sqlite.org/lockingv3.html,
2009/11/24 Todd Chapman t...@chaka.net:
On Mon, Nov 23, 2009 at 10:35 PM, Jesse Vincent je...@bestpractical.com
wrote:
On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote:
I just checked RT out of git and ran:
./configure --enable-layout=inplace --with-my-user-group
Slightly offtopic - is there some best practice limit saying when
SQLite stops being efficient and it's time to use something bigger? Or
in other words, how large are average SQLite installations in terms of
users, tickets, etc.?
In my opinion, I would say that SQLite is appropriate for
-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
boun...@lists.bestpractical.com] On Behalf Of Tom Lahti
Sent: Wednesday, 25 November 2009 10:55
To: Ivan Voras
Cc: rt-users
Subject: Re: [rt-users] Is SQLite no longer supported?
Slightly
Slightly offtopic - is there some best practice limit saying when
SQLite stops being efficient and it's time to use something bigger? Or
in other words, how large are average SQLite installations in terms of
users, tickets, etc.?
We don't recommend that you use RT on SQLite in production,
Slightly offtopic - is there some best practice limit saying when
SQLite stops being efficient and it's time to use something bigger? Or
in other words, how large are average SQLite installations in terms of
users, tickets, etc.?
In my opinion, I would say that SQLite is appropriate for
SQLite's complete lack of threading model means responding to a single
request at a time.
Simply put, if you have enough users that the possibility of multiple people
requesting information at the same time, or a user request happening when an
external ticket comes in (email via
I just checked RT out of git and ran:
./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite
But the database type is set to 'mysql' in RT_Config.pm.
What gives? The schema.SQLite file still exists.
___
On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote:
I just checked RT out of git and ran:
./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite
It helps if you don't misspell '--with-db-type'
But the database type is set to 'mysql' in RT_Config.pm.
On Mon, Nov 23, 2009 at 10:35 PM, Jesse Vincent je...@bestpractical.com wrote:
On Mon, Nov 23, 2009 at 10:33:16PM -0500, Todd Chapman wrote:
I just checked RT out of git and ran:
./configure --enable-layout=inplace --with-my-user-group --with-db-typ=SQLite
It helps if you don't misspell
11 matches
Mail list logo