Re: [sqlite] download db - security question

I was wondering if someone can just download off my webpage the sqlite database. And if they can is there a way to block this type of download throw apache? Any tips and advices are welcome. The best solution is to store database file out of domain root: /www/domain.com - directory for http://www.

Re: [sqlite] SQLite and "crosstab queries"

Andy Elvey wrote: Hi everyone - I'm a "first-timer" here, and was wondering - does SQLite support crosstab queries? Many thanks in advance - bye for now! - Andy If you mean something like: select a.*, b.* from a,b where a.column=1 or b.another=5; or select a.*, b.* from a left join b on (a.i