Re: [rt-users] Is SQLite no longer supported?

2009-11-25 Thread Ivan Voras
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

Re: [rt-users] Is SQLite no longer supported?

2009-11-25 Thread Tom Lahti
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,

Re: [rt-users] Is SQLite no longer supported?

2009-11-24 Thread Ivan Voras
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

Re: [rt-users] Is SQLite no longer supported?

2009-11-24 Thread Tom Lahti
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

Re: [rt-users] Is SQLite no longer supported?

2009-11-24 Thread Stuart Browne
-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

Re: [rt-users] Is SQLite no longer supported?

2009-11-24 Thread Jesse Vincent
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,

Re: [rt-users] Is SQLite no longer supported?

2009-11-24 Thread Jerrad Pierce
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

Re: [rt-users] Is SQLite no longer supported?

2009-11-24 Thread Tom Lahti
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

[rt-users] Is SQLite no longer supported?

2009-11-23 Thread Todd Chapman
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. ___

Re: [rt-users] Is SQLite no longer supported?

2009-11-23 Thread Jesse Vincent
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.

Re: [rt-users] Is SQLite no longer supported?

2009-11-23 Thread Todd Chapman
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