Andrew Lindsay writes:
[...]
> I am trying to search an SQL database that is meant to have entries logged
> every minute for a period of approximately 15 months.
>
> I want to create a query that will search through the database and tell me
> for which periods I do not have any entries.
>
[...
On 21 Apr 2011, at 3:53am, Donald Griggs wrote:
> Re: *SQLite is not really related to this*
> I wasn't really posing an issue for the list, just an fyi, such as is
> often done when an sqlite application is in the news.
Hadn't seen many articles like that but now you've raised the idea I s
Re: *SQLite is not really related to this*
I wasn't really posing an issue for the list, just an fyi, such as is
often done when an sqlite application is in the news.
Re: *...as is almost all database-suitable data in an iPhone.*
Didn't realize it was so extensive in the iPhone. So
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/20/2011 06:54 AM, thilo wrote:
> They are a great tool ensuring programs have fewer memory leaks, thread
> issues and the like and if one has access to their results, please USE
> it and judge the false positives with human eyes - strcpy & fprint
Andrew Lindsay wrote:
> I am trying to search an SQL database that is meant to have entries logged
> every minute for a period of approximately 15 months.
>
> I want to create a query that will search through the database and tell me
> for which periods I do not have any entries.
Something like
Could you not do this:
Select A.time + 1 minute, B.time - 1 minute from log as A, log as B where
A.RowID=B.RowID+1 and B.time-A.time > 1 minute
Tom
-Original Message-
From: Andrew Lindsay
Sent: Wednesday, April 20, 2011 7:34 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Request for
Actually, with this criteria, you can -- in a roundabout way.
select the timestamps by a large period, perhaps daily or monthly.
aggregate on that rough timestamp, and also select the count.
Anywhere the count is lower than expected, you are missing data.
You can then repeat over relevant ranges
On 21 Apr 2011, at 12:34am, Andrew Lindsay wrote:
> I am trying to search an SQL database that is meant to have entries logged
> every minute for a period of approximately 15 months.
>
>
>
> I want to create a query that will search through the database and tell me
> for which periods I do not
Dear Group,
I am trying to search an SQL database that is meant to have entries logged
every minute for a period of approximately 15 months.
I want to create a query that will search through the database and tell me
for which periods I do not have any entries.
Any assistance would be gr
On 21 Apr 2011, at 12:03am, Donald Griggs wrote:
> The video mentions that the file "consolidated.db" is an ordinary sqlite
> file, containing latitude, longitude, and timestamps. The data they
> examined went back several months.
>
> http://radar.oreilly.com/2011/04/apple-location-tracking.ht
The video mentions that the file "consolidated.db" is an ordinary sqlite
file, containing latitude, longitude, and timestamps. The data they
examined went back several months.
http://radar.oreilly.com/2011/04/apple-location-tracking.html
There's no allegation the data is *transmitted* to Apple
Remember that System.Data.SQLite.dll needs to be able to find the
SQLite.Interop.dll.
There's a post-build step that attempts to copy the Interop DLL to the
appropriate debug directory.
You may still need to copy into your debug directory for your test purposes.
On Wed, Apr 20, 2011 at 3:04 PM,
On Apr 20, 2011, at 10:25 PM, ArbolOne wrote:
> Hell! any body?
http://tinyurl.com/4yxf2gc
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hell! any body?
-
Hey folks.
I would like to use sqlite in a C++ program.
Is there a place in the internet where I can see C/C++ examples of sqlite?
TIA
--
All things in life are temporary. If going well enjoy it, they will not last
forever. If going wrong don't worry, they can't
Shane:
I downloaded http://system.data.sqlite.org/sqlite-dotnetsrc-1006900.zip
and changed SQLite.NET.Settings.targets as per your recommendation.
It did not appear to solve my problem since my application threw an
exception stating that Sqlite.Interop was missing. To be complete I
tried 3 permut
On Wed, Apr 20, 2011 at 2:58 PM, Jonathan Allin
wrote:
> The "Chinook" SQL script for creating the database contains many commands
> with brackets, eg
>
>
>
> DROP TABLE IF EXISTS [Album];
>
>
>
> What do the brackets do?
The [...] quote the identifier they contain, thus allowing the identifier
The "Chinook" SQL script for creating the database contains many commands
with brackets, eg
DROP TABLE IF EXISTS [Album];
What do the brackets do? I've not seen any examples with brackets, but on
the other hand SQLite seems to ignore them. In other words the above
statement seems to be equi
Hello Khanh,
Until you confirm the memory leak, I doubt anyone will respond. For
example, when my program exits, I abandon a bunch of allocated memory
to speed exit. VC says that's a memory leak but, it's not, because
it's not leaking memory while I'm using it. I purposely abandon
allocated memory
On Wed, Apr 20, 2011 at 8:34 AM, sajnank wrote:
> sqlite3_prepare_v2() is giving SQLITE_MISUSE error(error code 21) after
> running the application for several times. Once SQLITE_MISUSE is
> returned all sqlite queries are failing and they return the same error
> code. In our application, native
Hi SQLite3 community,
Please forgive me this panic, incorrect bug report. The cause of memory
leaks was from another my software component. The SQLite3.dll is working
greatly with my solution. However, it was memory leaks detection from VS2008
when I built the SQLite3 with Sqlite3.c in my solution
On Sat, Apr 16, 2011 at 5:35 PM, Kenneth Ballard <
kball...@kennethballard.com> wrote:
> Good afternoon,
>
> Here is an issue I started to experience after upgrading from SQLite
> 3.7.5 to 3.7.6 involving a trigger I have on a database table.
>
Using the database you sent me by private email, I f
I have read those links but there is a reason I want to keep everyone out of
the file completely.
I did came across "PRAGMA locking_mode=EXCLUSIVE;" and this is what I am doing
to achieve what I want.
Is there a reason why I should not use this?
On 4/20/2011 10:40 AM, asheu at comcast.net w
Whenever you have doubt like that just go to
http://www.sqlite.org/lang.html and see if the statement you are
trying to execute exists there and what its correct syntax is.
Pavel
On Wed, Apr 20, 2011 at 10:40 AM, wrote:
> Is LOCK TABLE statement supported by by SQLite? I am getting syntax err
On 4/20/2011 10:40 AM, as...@comcast.net wrote:
> Is LOCK TABLE statement supported by by SQLite?
No. Read more about how SQLite peforms locking here:
http://sqlite.org/lockingv3.html
http://sqlite.org/atomiccommit.html
--
Igor Tandetnik
___
sqlite-u
Is LOCK TABLE statement supported by by SQLite? I am getting syntax error when
I execute this "LOCK TABLE tablename IN EXCLUSIVE MODE NOWAIT". Just want to
make sure it's not supported rather than my syntax is incorrect.
___
sqlite-users mailing list
On 4/13/2011 4:04 PM, Roger Binns wrote:
> On 04/12/2011 08:25 AM, Stephen Blessing wrote:
> > It appears that your SQLite3.6.23.1 software may have some security
> issues
> > that need to be addressed:
>
> The tool you used is pathetic. It is about as helpful as saying your
> house
> has "High" s
sqlite3_prepare_v2() is giving SQLITE_MISUSE error(error code 21) after
running the application for several times. Once SQLITE_MISUSE is
returned all sqlite queries are failing and they return the same error
code. In our application, native layer opens the DB for writing(which
include: sqlite3_
On Tue, Apr 19, 2011 at 6:46 PM, Dennis Cote wrote:
> Hi,
>
> On the page http://www.sqlite.org/lang_createtable.html
>
> The following text appears:
>
>* If the default value of a column is CURRENT_TIME, CURRENT_DATE or
> CURRENT_DATETIME, then the value used in the new row is a text
> repre
On Wed, Apr 20, 2011 at 1:40 AM, Prasanna Parthasarathy <
pvenk...@hotmail.com> wrote:
> Can you please update the website with the dll compiled using the
> preprocessor symbol in the subject?
The build procedures have been updated to include
SQLITE_ENABLE_COLUMN_METADATA for the windows DLL and
On Wed, Apr 20, 2011 at 12:37 AM, Kenneth Ballard <
kball...@kennethballard.com> wrote:
> Okay I'm going to just give up on creating a specific test case for this
> one and I'm just attaching the original database file. Every time I tried to
> isolate out just the tables applicable to the trigger
Hello, after 3 hours of struggle, I have come to determine that the current
windows dll available for download from the website has been compiled *without*
the preprocessor symbol SQLITE_ENABLE_COLUMN_METADATA and therefore I am unable
to run my rails project. I have Ruby 1.9.2, Rails 3.0.7, an
Okay I'm going to just give up on creating a specific test case for this
one and I'm just attaching the original database file. Every time I
tried to isolate out just the tables applicable to the trigger code, the
issue is not reproducible. So attached to this message is the database
in questio
Hi,
On the page http://www.sqlite.org/lang_createtable.html
The following text appears:
* If the default value of a column is CURRENT_TIME, CURRENT_DATE or
CURRENT_DATETIME, then the value used in the new row is a text
representation of the current UTC date and/or time. For CURRENT_TIME,
the
33 matches
Mail list logo