[sqlite] I don't understand dates

There are several aspects of SQLite that I don't understand, and at the top of this list is dates. I have an application that writes data into a simple SQLite table with three fields. Two are integers and the third is a date. At one customer's site, that application was happily writing

[sqlite] Allowing external writes while a database is open

Hello! We are using SQLite to collect process data so that it can be displayed on a graph.  While a user is looking at the graph, the database is locked and no new data can be added to the table.  If a user opens a graph and walks away for two hours, the database containing data for that graph

[sqlite] Out of memory error on query returning no records

I found the table that I wasn't closing properly, which was locking up my database.  Thanks again, Dr. Hipp, for pointing me in the right direction. But I just stumbled on another problem.  It shouldn't show up in production, but it wouldn't be good to ignore it, either.  The table I'm

[sqlite] sqlite3_step() returning SQLITE_OK

According to the documentation, assuming I'm reading it correctly, and assuming there are no locks on the database, and assuming the query sent to sqlite3_prepare_v2() was valid, sqlite3_step() should return either SQLITE_ROW or SQLITE_DONE.  I am seeing a different result after executing a

[sqlite] Best way to do a date comparison?

Greetings! I am trying to write a simple applicaton in C# that will remove all data older than 30 days from an SQLite table.  However, my application is removing all data, not just the old data. Before I run my query, the value_timestamp field of my table contains: 2009-05-07 17:00:43 My

Re: [sqlite] Best way to do a date comparison?

Igor, Thank you very much for your reply. So, since SQLite doesn't have a dedicated date or time type, what does the datetime() function return?  Merely a string in a guaranteed format?  I'm sure I need to use the datetime() function on both sides of the comparison to ensure that I'm

Re: [sqlite] Best way to do a date comparison?

Thanks again for your help, Igor. RobR ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Cannot insert records into a table after dropping and recreating it

Greetings! I have an application that uses an SQLite database file that may or may not exist when the application starts. At startup, the application creates three tables. If the file previously existed, the create table queries fail. My code checks the error message, and if it indicates

[sqlite] Help building SQLite project, please

This isn't directly related to SQLite, but rather to how I am converting the source code into a DLL. I hope someone here can help me understand what's happening. It appears that my previous problem was caused by some problem within the ancient, unbelievably slow and ugly library we have been

[sqlite] ExecuteNonQuery() consuming memory

Greetings! I have a Windows service application written in C# using Visual Studio 2008 that uses the ADO.Net 2.0 provider for SQLite downloaded from SourceForge. The application writes one row consisting of three values to each of 124 SQLite databases once a minute. The service uses the

[sqlite] Hypothetical memory consumption question

Greetings! I have a hypothetical question. Assume I have the simplest possible SQLite database on a disk file: a single table with a single column. Now assume that I have a Windows service that opens the database when it starts, and leaves it open forever. The service has a loop that is

Re: [sqlite] Hypothetical memory consumption question

Pavel, Thank you for your reply. Does data get cached even though I am never executing a select statement? Here's the real world problem: I am trying to write a service that updates 124 simple SQLite databases every minute. The service is written in C#, using Visual Studio 2008 and the

Re: [sqlite] Hypothetical memory consumption question

Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqlite.org on behalf of Radcon Entec Sent: Tue 4/27/2010 2:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Hypothetical memory consumption question Pavel, Than

Re: [sqlite] Hypothetical memory consumption question

megabytes. If I can get my service down to that rate of growth, I'll be happy. RobR From: Radcon Entec <radconen...@yahoo.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tue, April 27, 2010 2:25:56 PM Subject: [sqlite]