Re: [sqlite] SQLite GUI comparison

2011-02-22 Thread skywind mailing lists
Hi Tom, if you do not have a command line tool in one of the software package you can do two things: 1) try to create an FTS or RTree table. It will fail if the extensions are not supported. 2) create a database having all to be tested extension and then issue a SELECT * statement on the

Re: [sqlite] SQLite GUI comparison

2011-02-22 Thread Kees Nuyt
On Tue, 22 Feb 2011 10:16:20 +1100, BareFeetWare wrote: >On 22/02/2011, at 4:31 AM, skywind mailing lists wrote: > >> "Supports SQLite extension" would be an accurate feature description. And in >> the cell (value) I suggest to put - if supported - FTS2, FTS3, RTree

Re: [sqlite] SQLite GUI comparison

2011-02-21 Thread BareFeetWare
On 22/02/2011, at 4:31 AM, skywind mailing lists wrote: > "Supports SQLite extension" would be an accurate feature description. And in > the cell (value) I suggest to put - if supported - FTS2, FTS3, RTree etc., > otherwise a "-". A yes or no is insufficient because some support RTree but >

Re: [sqlite] SQLite GUI comparison (was: ANN: Base 2.0, Mac SQLite GUI)

2011-02-21 Thread skywind mailing lists
Hi Tom, "Supports SQLite extension" would be an accurate feature description. And in the cell (value) I suggest to put - if supported - FTS2, FTS3, RTree etc., otherwise a "-". A yes or no is insufficient because some support RTree but not FTS and vice versa. Alternatively you may have a row

[sqlite] SQLite GUI comparison (was: ANN: Base 2.0, Mac SQLite GUI)

2011-02-20 Thread BareFeetWare
On 21/02/2011, at 3:20 AM, skywind mailing lists wrote: > in your comparison chart it would also be nice to see which software is able > to support SQLite extension. A couple of them do not support the FTS nor > RTree capabilities of SQLite. Sure, I'd be happy to add that. How do you suggest