Re: [sqlite] General R*Tree query

Perhaps this is a weird way for me to get deeper knowledge of R trees, and because I vaguely remember that Tyco refers to a specific epoch in which coordinates are defined, but would it be possible to search R tree using a cone, i.e. stars within a cone of certain degree around given star? This

Re: [sqlite] General R*Tree query

On Tue, Dec 17, 2013 at 3:57 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > > Since coordinate system is spherical, how do you tell that RA=23:59 and > RA=00:01 are next to each other using usual comparisons? I don't; usual comparisons won't work so I do two comparisons: I am

Re: [sqlite] General R*Tree query

On Tue, Dec 17, 2013 at 3:51 PM, Dan Kennedy wrote: > On 12/18/2013 12:49 AM, Brian T. Carcich wrote: > >> [...] > > Points are fine. [...] > Is it working now? How many more stars do you have data for? Excellent, thanks for the info! I forgot to mention that we do

Re: [sqlite] Is there

Maybe just use a connection list of some sort in a table? When you connect, insert (and clear out any others from your client in case it crashed before), when you disconnect, remove it. Pretty sure there's not a way to find open connections because the sqlite api closes and opens the DB with

[sqlite] Is there

Hi, I want to detect if a sqlite database is already connected to an application?  Is there anyway sqlite API available for this? I have a use case where 2 different applications would try to connect to same database and I want to detect that and give info to the user. Thank you -Veeresh

Re: [sqlite] General R*Tree query

Since coordinate system is spherical, how do you tell that RA=23:59 and RA=00:01 are next to each other using usual comparisons? Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Dan Kennedy

Re: [sqlite] General R*Tree query

On 12/18/2013 12:49 AM, Brian T. Carcich wrote: I'm working on an SQLite solution to get at star catalogs; they are usually searched via Right Ascension (RA), Declination (DEC), and magnitude (mag). RA,DEC is a spherical coordinate system to specify a star position on-sky; magnitude is related

Re: [sqlite] System.Data.SQLite and UNC Paths

Denis Burke wrote: > > All versions of System.Data.SQLite beyond 1.0.85 (including 1.0.89) fail > when I try to open a DB using a UNC path. The error I see is that the > database cannot be read. > Due to the newly revised connection string parsing algorithm (which was revised to fix other

[sqlite] General R*Tree query

I'm working on an SQLite solution to get at star catalogs; they are usually searched via Right Ascension (RA), Declination (DEC), and magnitude (mag). RA,DEC is a spherical coordinate system to specify a star position on-sky; magnitude is related to star brightness. What I have so far is here:

[sqlite] System.Data.SQLite and UNC Paths

System.Data.SQLite v1.0.85 (and prior) work well when accessing databases via UNC paths. All versions of System.Data.SQLite beyond 1.0.85 (including 1.0.89) fail when I try to open a DB using a UNC path. The error I see is that the database cannot be read. e.g. - All versions of

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013/12/17 margave : > Well, I gave up on sqlite inside of Cygwin. > > I found a standalone sqlite3.exe that does not depend upon (or install with) > Cygwin. > It's from http://www.sqlite.org > One executable, no .dlls ... and it just runs, no problems. For most situation,

Re: [sqlite] Weird behavior of SQLite violating primary key constraints, started suddenly.

On 17 Dec 2013, at 7:53am, Priyam Chokhani wrote: > Integrity check gives the following result - > > http://www.sqlite.org/download.html> instructions here: Simon. ___

[sqlite] Weird behavior of SQLite violating primary key constraints, started suddenly.

Hello, We have been using SQLite for our desktop application for around an year now. Suddenly we started getting weird errors and could see multiple entries in the same table violating primary key constraints. The version of of SQLite is 3 and System.Data.SQLite is 1.0.82.0. The table schema is

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

Well, I gave up on sqlite inside of Cygwin. I found a standalone sqlite3.exe that does not depend upon (or install with) Cygwin. It's from http://www.sqlite.org One executable, no .dlls ... and it just runs, no problems. -- View this message in context: