Re: [sqlite] vertical -> horizontal data conversion

Andy, You should be looking for pivot tables. However, there is no native support for them in sqlite as far as I know. Some databases (e.g. SQL Server 2005+) know PIVOT command but not sqlite. You may want to look at http://mesh.dl.sourceforge.net/sourceforge/souptonuts/Solving_Complex_SQL_Proble

Re: [sqlite] Performance Care

Bruno, I'm quite new to sqlite but I believe that concurrency may be an issue only for data changes which require db locking. As long as you go with SELECTs, there's not much to worry about. Tomas On Fri, Aug 22, 2008 at 7:47 PM, Bruno Moreira Guedes <[EMAIL PROTECTED]>wrote: > Hello, > > I hav

[sqlite] Recursive triggers - any news about their implementation?

Hello everyone! It's been almost two years since the last round of discussions about recursive trigger implementation (on this mailing list). Are there any news about their support in near future? (same with foreign keys) I wish there was a rough schedule for the unsupported features ( http://www