sqlite?

[Peter]

Any chance of supporting sqlite?

[Ken]

You should be able to connect to SQLite via the ODBC connection. Two options -- to create a connection go to File > Create Connection and then click on the ODBC tab. This should "mount" your DB within the Project Tree and you should be able to view your tables. Otherwise, to import data directly into Strata, go to File > Import and then click on the ODBC tab.

It would be very nice to have more direct support for SQLite though, I'll put this request in our Features list.

#353

[Peter]

It might increase the attractiveness of the package quite a bit. If you have a flat database in csv form, there are very easy to use tools which will make an sqlite database out of it. If you can then access it from a full fledged browser with in effect support for intuitive scripting, you're bringing something to the desktop which the less technical user just does not have now, unless he goes to Filemaker or Access. And you have provided it in the form of an open database. It might be really worth doing.

I'll have a go with ODBC but, as you note, native mode would be much more appealing.