On 27 Apr 2011, at 12:02pm, Paul Linehan wrote: > Gigs - what I'm interested in is sharding and using SQLite instances as > shards in a larger ensemble.
Well now you've told us what you want out of it, we can comment usefully. You can handle your shards yourself, and you can implement sharding by using VIEWs and TRIGGERs, but SQLite does not have sharding implemented /per se/. If your design, from the ground up, is based around multi-hosted data and/or client-server architecture, then SQLite is not the system for you. You will be happier with MySQL or one of the other client/server systems. However, there's no problem with the amount of data you specified, and SQLite works on all your platforms (more than any other SQL DBMS I'm aware of) without problems, since all the SQLite team supplies is the source code for the function library. If you need more details, ask more specific questions. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
