Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

On Fri, 23 Oct 2009 09:55:17 -0700, Alex Mandel wrote: >There's a reason why a lot of them don't display more than 100-1000 >records per view. Yup. The Firefox-based SQLiteManager couldn't handle the 100.000 rows I SELECTed :-/ >You could also try

Re: [sqlite] SQLite server for Windows/Linux?

On Sat, 24 Oct 2009 00:38:20 +0200, "Olaf Schmidt" wrote: >Hmm in this case, what about: >http://www.realsoftware.com/realsqlserver/ Thanks much for the tip :) I'll give it a shot. >So, on what platform(s) do your client-apps need to work? >In what (main)language do you develop

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

On Fri, 23 Oct 2009 18:13:27 +0200, "Roger Andersson" wrote: >Never had any access violation but regarding number of records >Options -> Fetch Size -> 0 >And then like said by Donald, right click and Copy Result Set To Clipboard Thanks for the tip, but after SELECTing 100.000

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

On Sat, 24 Oct 2009 16:28:21 +0200, Gilles Ganault wrote: >>You could also try http://www.gaia-gis.it/spatialite/ > >Ah, good one :-) It succesfully SELECTed all the rows, and let me copy >them into the clipboard in a fraction of a second. Thanks a lot. I'll take that

[sqlite] Fwd: error message

Begin forwarded message: > From: John Mason > Date: October 24, 2009 11:12:26 AM EDT > To: d...@hwaci.com > Subject: error message > > I have a windows xp operating system and when I go to access > information on the apple store I keep getting the following

Re: [sqlite] Fwd: error message

On Oct 24, 2009, at 11:40 AM, D. Richard Hipp wrote: > > > Begin forwarded message: > >> From: John Mason >> Date: October 24, 2009 11:12:26 AM EDT >> To: d...@hwaci.com >> Subject: error message >> >> I have a windows xp operating system and when I go to access >>

Re: [sqlite] Fwd: error message

On Oct 24, 2009, at 11:40 AM, D. Richard Hipp wrote: > > > Begin forwarded message: > >> From: John Mason >> Date: October 24, 2009 11:12:26 AM EDT >> To: d...@hwaci.com >> Subject: error message >> >> I have a windows xp operating system and when I go to access >>

[sqlite] Prevent cartesian products altogether?

I want to my SQLite database to NEVER accept cartesian products. That is, if the user makes a query that results in a cartesian product (explicit or implicit), the execution of it must fail! Is this possible?

Re: [sqlite] commit time

the plot thickens.. we're running WinCE. i'm using a service to do the writing (worker thread running in servicesd process). i'm interested in using a synchronous ioctl call on the service to perform the reading. this read ioctl call will be made from another process (not servicesd) and

[sqlite] Can FK be created behind the scene?

Dear SQLiters, I'm almost sure the answer is "No" but I'd rather ask the question anyway. Is there _any_ situation where the v3.6.19 stock SQLite3 would create _by itself_ temporary foreign keys not explicitely created by the user, either or both on the referencing or on the referenced table?

Re: [sqlite] Can FK be created behind the scene?

Jean-Christophe Deschamps wrote: > I'm almost sure the answer is "No" but I'd rather ask the question anyway. > > Is there _any_ situation where the v3.6.19 stock SQLite3 would create > _by itself_ temporary foreign keys not explicitely created by the user, > either or both on the referencing or

Re: [sqlite] Can FK be created behind the scene?

Hi Igor, >"Temporary foreign keys"? I can't fathom what this term could possibly >mean. > >Your question makes no sense to me, sorry. What problem are you really >trying to solve? Sorry, problem solved (outside SQLite). I noticed that after trying a DBM application I got errors saying that

Re: [sqlite] SQLite server for Windows/Linux?

Have a peek at : http://www.sqlitening.com/support/index.php Different language and could run under Wine on *nix Olaf Schmidt wrote: > > > "Gilles Ganault" schrieb im > Newsbeitrag news:10h3e55s5ml6kto9rkvasvv1ejc0ao2...@4ax.com... > >> Maybe someone will come up

[sqlite] Occasional SQLITE_BUSY error on database with read-only operations

I am using the C/C++ interface to SQLite version 3.6.17 in a Linux environment. I am using SQLite as part of a CGI program on a clustered group of webservers which do searches on the database. Some of these searches can happen at the same time as multiple instances of the CGI program can execute

Re: [sqlite] Occasional SQLITE_BUSY error on database with read-only operations

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jamie wrote: > Given all this, why am I on rare occasions getting a SQLITE_BUSY > return code when calling sqlite3_prepare_v2() or sqlite3_step() ? Hint: How does the SQLite connection you are currently using know that no other SQLite connection

Re: [sqlite] Occasional SQLITE_BUSY error on database with read-only operations

> Hint: How does the SQLite connection you are currently using know that no > other SQLite connection won't be updating the database? Isn't it a SHARED lock that will ensure that no other connection is updating the database? And isn't SHARED lock should allow another SHARED lock? I believe the

Re: [sqlite] Occasional SQLITE_BUSY error on database with read-only operations

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pavel Ivanov wrote: > I believe the problem here can be either in buggy file locking via NFS The issue is two fold. One is that SQLite still does locking operations even if you open read only (which may not be expected by some users but is

Re: [sqlite] Occasional SQLITE_BUSY error on database with read-only operations

On Sat, Oct 24, 2009 at 05:55:53PM -0700, Roger Binns wrote: > Hint: How does the SQLite connection you are currently using know that no > other SQLite connection won't be updating the database? The database is only rarely updated. When it is updated, a copy is taken of it, it is then updated