Re: [sqlite] Newbie --question about multiple PCs accessing sqlite
Fred Williams wrote: -Original Message- From: Michael Roth [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 9:10 AM To: Ulrik Petersen Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Newbie --question about multiple PCs accessing sqlite Ulrik Petersen wrote: - Mingw or Cygwin (google for each) www.mingw.org, www.cygwin.com - Microsoft Visual C++ Toolkit 2003. Microsoft recently released their compiler and toolchain for free download: http://msdn.microsoft.com/visualc/vctoolkit2003/ Check the license! It is not really fair! Don't use this toolchain. Yes. Use Borland's, it is truly free :-) Don't want to risk Bill missing a house payment! http://community.borland.com/museum/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://www.openwatcom.org/ is also a possibility. It is an open source C/C++ compiler for several platforms. -- Daniel Lee Kruse Pursuant to U.S. code, title 47, Chapter 5, Subchapter II,Section 227, any and all unsolicited commercial E-mail sent,to this address is subject to a fee of $500.00 U.S. E-Mailing denotes, acceptance of these terms. Consult http://www.law.cornell.edu/uscode/47/227.html for details. "War is an ugly thing, but it is not the ugliest of things. The decayed and degraded state of moral and patriotic feeling which thinks that nothing is worth war is much worse. A man who has nothing for which he is willing to fight, nothing he cares about more than his own personal safety, is a miserable creature who has no chance of being free, unless made so by the exertions of better men than himself." -- John Stuart Mill (1806-1873), British philosopher, economist. "The Contest in America," Dissertations and Discussions (1859) "Kill them all! God will recognize his own." -- Abbot Arnaud-Amalric in 1209, during the Albigensian Crusade on how to differentiate the Cathar heretics from the Catholics "If Microsoft is ever going to produce something that does not suck, it is very likely a vacuum cleaner." Axel Hagedorn - Darmstadt/Germany - [EMAIL PROTECTED] Anonymous quotes: Pay attention to the political views of famous actors. After all, pretending to know things is their profession. (To minimize internet/virus/worm infections, I have a policy of not using Micro$oft products) Ein Volk, Ein Reich, Ein Fuehrer -- NSDAP (Nazi) slogan, 1930s One World, One Web, One Program -- Microsoft slogan, 1990s My two cents - Why would Micro$oft pattern a slogan after a Nazi slogan? Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Software is cheap, fast, and reliable ... (pick two). Windows (3.1, 95, 98, ME, NT, 2K, XP): n. 32 bit extensions and a graphical shell for a 16 bit patch to an 8 bit operating system originally coded for a 4 bit microprocessor, written by a 2 bit company, that can't stand 1 bit of competition. "Friends don't let friends use Windows" - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Newbie --question about multiple PCs accessing sqlite
> -Original Message- > From: Michael Roth [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 9:10 AM > To: Ulrik Petersen > Cc: [EMAIL PROTECTED] > Subject: Re: [sqlite] Newbie --question about multiple PCs accessing > sqlite > > > Ulrik Petersen wrote: > > > - Mingw or Cygwin (google for each) > > www.mingw.org, www.cygwin.com > > > - Microsoft Visual C++ Toolkit 2003. Microsoft recently released their > > compiler and toolchain for free download: > > http://msdn.microsoft.com/visualc/vctoolkit2003/ > > Check the license! It is not really fair! Don't use this toolchain. > Yes. Use Borland's, it is truly free :-) Don't want to risk Bill missing a house payment! http://community.borland.com/museum/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Newbie --question about multiple PCs accessing sqlite
Ulrik Petersen wrote: - Mingw or Cygwin (google for each) www.mingw.org, www.cygwin.com - Microsoft Visual C++ Toolkit 2003. Microsoft recently released their compiler and toolchain for free download: http://msdn.microsoft.com/visualc/vctoolkit2003/ Check the license! It is not really fair! Don't use this toolchain. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Newbie --question about multiple PCs accessing sqlite
> I'm contemplating using the TCL binding of sqlite, but the database is to > be located in a shared folder and about 100 users will be accessing it for > read/write purposes. I would like to take some time to learn as much as > possible to safeguard the database from getting corrupt due to several > users accessing it at the same time. However, the sqlite website > "http://www.sqlite.org/cvstrac/wiki?p=WhenToUseSqlite" says: > > “A good rule of thumb is that you should avoid using SQLite in situations > where the same database will be accessed simultaneously from many computers > over a network filesystem.“ > > > I have 3 questions: > > 1.From the above statement, Am I right to assume that sqlite is not for > me? Probably not unless you intend on implementing some application level write locking on the SQLite database. I've done this with one application but there probably aren't ever anywhere near 200 people accessing it at the same time. If someone is writing the database it waits a few milliseconds and tries again (up to a finite number of times, at which time it reports a failure).. With that many possible concurrent users you might look into a RDBMS server like PostgreSQL or MySQL. My personal preference is PostgreSQL, but many use MySQL too.. > 2.If sqlite is feasible for my purpose, where can I find good > information to avoid ending up with a corrupt database SQLite locks the *whole* database when writing. You simply cannot write more than one thing at a time to the database (INSERT, UPDATE, DELETE etc). I don't think there is any documentation that says anything more than that. I'm not sure if doing so will corrupt the data or just plain fail, but either way you can't do it :-) > 3.The TCL binding I downloaded says version 2.0 and I do not have a C++ > compiler, where can I get the most recent binary of TCL sqlite? > Thanks. No idea on this one, check the SQLite webpage.. -- - Mitchell Vincent - kBilling - http://www.k-billing.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]