On Tue, Dec 21, 2010 at 2:24 PM, Simon Slavin <[email protected]> wrote:
> > Thanks for that, and the analysis that preceded it. That was my guess, > especially point 1, the most significant thing. It's tough to find a decent > extension for SQLite that enough people want. The two extensions I see most > referred to are FTS3 (to provide the full-text search) and rtrees (to define > distance in terms of two coordinates). > > Simon, I read both your suggestion and the Richard's good explanation about network problems. I think that the idea still deserves to live in some form :). I sometimes access sqlite db on a remote computer accessed with sqlite shell executed in telnet/ssh. It works and it looks like good design for interaction in terms of network bandwidth. If it can be implemented in more friendly way toward the developer, I think it would still be a lighter version of a sql-aware dbms than SQLite/PostgreSQL. Another thought, imagine that a remote computer contains many sqlite databases and moreover, many versions of the same database. It's easy to imagine this like hierarchy of sqlite files accessed remotely, but I just can't imagine straightforward way to implement this with conventional client/server dbms. Max Vlasov _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

