--- [EMAIL PROTECTED] wrote: > Let me clarify then. 100% of our customer want web based. With .NET > and SQL server we can throw in our data adapter and be off to the > races. We don't have to worry about future scalability. With > Sqlite, you dont' receive a trusty data provider. Good ones exist, > but all of this extra work boils down to time cost. As well, what if > you want to move the database to another machien to distribute > workload. > > Well, our bug tracking system Swatter we did use Sqlite but we had to > write the thead syncronization layer. In fact, it is a .nET > application that runs across a web service or a sockets layer, to a > sqlite database eventually. Our sql server version does not require > any special coding like sqlite. So after 250k lines of code in our > bug tracking system, we have a picture painted. The sqlite version > is what we use, not the sql server but we deal with the corporate > requirments as well like this fellow is up against. > > Does SQLite have a distributed API now. This means a client that > talks efficient binary across a network to a server that eventually > syncronizes into database work? Did I miss something. I thought > this thing was only a binary that you have to do everything else on > top of.
I believe you understand correctly. With sqlite there is no central server, the applications that use the database all open a single file containing the data. It's suitable for web applications (I use it for that) if all the applications can access the same file. Usually that means they're all on a single server, or on group of servers that can connect to a single network shared file. In my case the web server houses the database as well as all the code that uses it. It's light, fast, self contained, and fairly difficult for hackers to break into. It won't work if you want to let users connect to it using Excel and run reports against the database, though I understand that can be done with an odbc driver. I don't know how well that works. Connectivity can be an issue if you need it, but in my case the lack of exposed (I.E. Hackable) connections is a bonus. Scaling can be done by buying bigger iron. ===== --------------------------------- "Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on the walls of the ancient tomb of the petrified pharaoh, he vowed there would be no curse on him like on that other Lord, unless you count his marriage to Lady Tarlington who, when the lost treasure was found, will be dumped faster than that basket in the bulrushes." Melissa Rhodes --------------------------------- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264 __________________________________ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250
