Re: [sqlite] SQLite destroys civilization.

On Sun, Mar 2, 2014 at 12:34 PM, Richard Hipp wrote: > Reports on twitter say that the "nanobots" in the TV drama "Revolution" > have source code in the season two finale that looks like this: > > https://pbs.twimg.com/media/BhvIsgBCYAAQdvP.png:large > > Compare to the SQLite

Re: [sqlite] help needed for major SQLite problem

On Mon, Feb 10, 2014 at 4:40 PM, Stephen Chrzanowski wrote: > Personally, I don't buy that DropBox is the culprit as I've done this kind > of thing a few times in a few applications of my own, however, I'm the > single user that works on that single account, and any app that

Re: [sqlite] help needed for major SQLite problem

On Mon, Feb 10, 2014 at 2:54 PM, RSmith wrote: > How to go from the error codes to the diagnosis? I think the logic is as > follows: > > We can see an error occurs when trying to access the file, or more > specifically, trying to obtain a shared lock on it. This means it is

Re: [sqlite] help needed for major SQLite problem

On Sat, Feb 8, 2014 at 4:28 AM, Kees Nuyt wrote: > > On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy > wrote: > >> SQLITE_LOG: delayed 1375ms for lock/sharing conflict (10) SQLITE_IOERR > >> > >> SQLITE_LOG: os_win.c:35129: (5) winAccess(C:\Documents

Re: [sqlite] help needed for major SQLite problem

This is a follow-up to a question I asked on this list on Sep 1st, 2013, about an error that I was randomly getting with disk-based SQLite database in a Python desktop application. I now have more info to provide about the error...such as what was asked for at that time: On Sun, Sep 1, 2013 at

Re: [sqlite] help needed for major SQLite problem

On Mon, Sep 2, 2013 at 3:28 PM, E.Pasma <pasm...@concepts.nl> wrote: > Op 2 sep 2013, om 17:58 heeft C M het volgende geschreven: > >> ... >> >> Is setting up APSW and making the transition from pysqlite2's wrapper >> fairly straightforward, or would I ha

Re: [sqlite] help needed for major SQLite problem

On Sun, Sep 1, 2013 at 6:12 PM, Richard Hipp wrote: > Does Python have an interface to the error and warning log mechanism of > SQLite? (http://www.sqlite.org/errlog.html) Can you turn that on? It > will probably give more details about what it happening. > Looks like, no,

Re: [sqlite] help needed for major SQLite problem

On Sun, Sep 1, 2013 at 7:51 PM, Roger Binns wrote: > > He needs to give the exception traceback which will show what is happening > at the time. > > A common mistake with newish Python programmers is to catch all > exceptions, and then keep going which also hides the

Re: [sqlite] help needed for major SQLite problem

On Mon, Sep 2, 2013 at 2:33 AM, Markus Schaber <m.scha...@codesys.com>wrote: > Hi, C M, > > > Just to be safe: Can you roule out any antivirus or other security > software locking the files temporarily? > Good idea, but I don't think that is what is happening in my case

Re: [sqlite] help needed for major SQLite problem

On Sun, Sep 1, 2013 at 6:53 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 1 Sep 2013, at 10:34pm, C M <cmpyt...@gmail.com> wrote: > > > Do you know how I can do that with Python? For example, I tried this: > > > > status = cursor.execute("som

Re: [sqlite] help needed for major SQLite problem

On Sun, Sep 1, 2013 at 4:28 PM, jose isaias cabrera <cabr...@wrc.xerox.com>wrote: > > "C M" wrote... > > > Keeping it simple: >> >> I have a Python application that uses SQLite, and I randomly get this >> error: >> >> "SQL logic

Re: [sqlite] help needed for major SQLite problem

On Sun, Sep 1, 2013 at 2:23 PM, Simon Slavin wrote: > > On 1 Sep 2013, at 6:38pm, Richard Hipp wrote: > > > A good starting place might be to tell us what the program is doing when > > the error comes back. > > As well as telling us the call that trieggers

Re: [sqlite] help needed for major SQLite problem

On Sun, Sep 1, 2013 at 1:38 PM, Richard Hipp <d...@sqlite.org> wrote: > On Sun, Sep 1, 2013 at 1:12 PM, C M <cmpyt...@gmail.com> wrote: > > > > > I have a Python application that uses SQLite, and I randomly get this > > error: > > > > "SQL lo

[sqlite] help needed for major SQLite problem

Keeping it simple: I have a Python application that uses SQLite, and I randomly get this error: "SQL logic error or missing database" I have no idea how to figure out what's wrong, and if I can't figure it out, it leaves a huge deal-breaking bug in my application, such that I'd have to abandon

[sqlite] SQL logic error or missing database with Python sqlite

This appears to have been asked many times online, but none of the threads I've seen help me fix my issue. I am using SQLite through Python 2.5 or 2.7, which is the sqlite3 module. In a desktop application, every now and then, and in a fairly irreproducible way, when committing to the database I

Re: [sqlite] MIN() for a timedelta?

Thanks everyone for the various replies and help. Very useful and I will look into the differences and if I have questions about how these work will let you know. Thank you, Che ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] MIN() for a timedelta?

On Thu, Jul 26, 2012 at 6:45 PM, Nico Williams <n...@cryptonector.com> wrote: > On Thu, Jul 26, 2012 at 4:32 PM, C M <cmpyt...@gmail.com> wrote: >> I could zero pad these strings myself, so that '9:00:00.00' >> becomes '09:00:00.00', but that would break other us

[sqlite] MIN() for a timedelta?

I have string representations of a Python timedelta stored in an SQLite database of the form H:MM:SS:ss (the last is microseconds). Here are a possible examples of such timedeltas: '0:00:06.229000' '9:00:00.00' '10:01:23:041000' I want to select the shortest duration (the smallest

Re: [sqlite] catching sqlite errors...what to know

Thanks for the help, just getting back now. > Your message indicates you are using Python. You should be using > transactions and context managers. This ensures that things either > complete or don't, not some half way state. I thought SQlite never did anything in a half way state anyway? I

Re: [sqlite] catching sqlite errors...what to know

On Sun, Jul 1, 2012 at 12:12 PM, Simon Slavin wrote: Thanks for the help. Sorry to not get back sooner. >> 1) locked database (due to using SQLite Database Browser to change a >> database but not Saving it) >> 2) sqlite3.OperationalError: SQL logic error or missing

[sqlite] catching sqlite errors...what to know

I'm working on a database program and have found three different kinds of SQLite errors now and then, only 1 of which is known as to what is causing it: 1) locked database (due to using SQLite Database Browser to change a database but not Saving it) 2) sqlite3.OperationalError: SQL logic error or

Re: [sqlite] SELECT average timestamp to get average time of day? (C M)

On Wed, Feb 29, 2012 at 8:41 AM, Mark Belshaw wrote: > This is the first time I've posted a response to any mailing list, so I > hope > I'm doing it right and it appears where it should! > It sure did. Thanks for participating. > Not SQLite, but a technique we

Re: [sqlite] RE SELECT average timestamp to get average time of day?

On Sat, Feb 25, 2012 at 8:44 AM, Black, Michael (IS) wrote: > I subtract 12 hours...so any time from 24:00:00 to 12:00:00 will work. > > Time from noon to noon becomes midnight to midnight. Then you just add > the 12 hours back in. > > > > CREATE TABLE tijd(t int(11));

Re: [sqlite] SELECT average timestamp to get average time of day?

On Fri, Feb 24, 2012 at 4:53 PM, Marc L. Allen wrote: > You're trying to calculate it for individual people? Can you count on > night-time people to stay night-time, or do you need to worry about someone > shifting by 12 hours? > It's for individuals, and it is

Re: [sqlite] SELECT average timestamp to get average time of day?

On Fri, Feb 24, 2012 at 4:06 PM, Marc L. Allen wrote: > Actually this is quite an interesting question. > > Given two fixed times of midnight and noon, having the third time one > minute before or after midnight drastically changes what I think you want > the

[sqlite] SELECT average timestamp to get average time of day?

I'd like to have a SELECT query to get the average time of a person's day (not necessarily a strict 24 hour day) given timestamps of the form: '-MM-DD HH:MM:SS.mm'. The data will have gaps of days in which there is no timestamp for that day. The problem is, simply averaging times of day

Re: [sqlite] corrupt database with update?

On Thu, May 8, 2008 at 7:08 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On May 8, 2008, at 2:54 AM, C M wrote: > >> How likely (or possible) is it to corrupt or in some way screw up an >> SQlite database if one is doing an UPDATE and it fails? (computer go

[sqlite] corrupt database with update?

How likely (or possible) is it to corrupt or in some way screw up an SQlite database if one is doing an UPDATE and it fails? (computer goes out, etc.) Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Re: select date using variables in Python

On Dec 12, 2007 1:51 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > C M wrote: > > > > Thanks to you both--using the || did the trick, and I can try the other > > approaches mentioned as well. In Python Igor's suggestion was just: > > > > amount = "+1&

Re: [sqlite] Re: select date using variables in Python

On Dec 12, 2007 8:20 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > C M <[EMAIL PROTECTED]> wrote: > > cur.execute('SELECT string FROM test WHERE d >= date("now","+1 day")') > > > > However, I'd like to make it flexible, so that a u

[sqlite] select date using variables in Python

I'm new to SQLite and can't figure out the right way to write this. I want to select a range of dates, let's say anything beyond tomorrow So in my table called test I want to select the column called string based on the date being tomorrow or later... This statement (from the sql wiki about

Re: [sqlite] Request for help with the SQLite Website

I agree; less is more. Way too many words on the front page now. First, why have nav bars at top AND at the right side? (Plus vertical nav bars are best put on the left side. ) I'd recommend just (something like) this text on the main page: SQLite is a free, public domain, compact, embedded

Re: [sqlite] best way to match a date but not a time?

Thanks, Simon, Trey, and Dan, this is really helpful and has got me back on track. -CM On 9/2/07, Trey Mack <[EMAIL PROTECTED]> wrote: > > > I want to have queries that will match dates but not care about times. > > The date might be today, anything within the last week, month, year, > > or a

[sqlite] best way to match a date but not a time?

Hi, I'm very new to SQLite, and I'm using it with Python. I want to have queries that will match dates but not care about times. The date might be today, anything within the last week, month, year, or a range of dates. I'm using Python's datetime function, so the dates enter the database in this