I think I may have misunderstood something in a major way with regards to
the subject.
I have an application that maintains a single application-wide connection
which is opened with SQLITE_OPEN_FULLMUTEX flag. So if I have a method that
inserts multiple rows into a db, does that method need an app
a way to find out or how to reproduce this issue?
>
> Dilip
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, Jan 13, 2012 at 9:10 AM, Igor Tandetnik wrote:
> Dilip Ranganathan wrote:
> > Suppose among emp1 and emp2, I only want to see the entry with the latest
> > timestamp.
>
> select timestamp, value, person from mytable t1
> where rowid = (
>select rowid from
On Fri, Jan 13, 2012 at 6:22 AM, Simon Slavin wrote:
>
> On 13 Jan 2012, at 11:07am, Dilip Ranganathan wrote:
>
> > I have a table that looks like something like this:
> >
> >timestampvalue person
> >=
I have a table that looks like something like this:
timestampvalue person
===
2010-01-12 00:00:00 33 emp1
2010-01-12 11:00:00 22 emp1
2010-01-12 09:00:00 16
On Wed, Dec 14, 2011 at 8:35 PM, Igor Tandetnik wrote:
> On 12/14/2011 8:21 PM, Dilip Ranganathan wrote:
>
>> I am not an expert in SQL, so do bear with me if I am asking the obvious.
>>
>> Given:
>>
>> timestamp | col1 | col2
>>
I am not an expert in SQL, so do bear with me if I am asking the obvious.
Given:
timestamp | col1 | col2
xxabc 5
yyabc 4
zzdef 7
rrdef 6
SELECT timestamp, col1, min(col2)
FROM table
GROUP BY col
in sqlite3_open with empty quotes. Unlike what I said in my original
post I'd rather use the temporary DB approach than a pure in-memory
solution.
On Thu, Nov 24, 2011 at 8:45 AM, Dilip Ranganathan wrote:
> Currently I use sqlite to create a bunch of on-disk tables to store my
>
Currently I use sqlite to create a bunch of on-disk tables to store my
data. I use Sqlite's master table to determine if a table already exists
based on which I take certain decisions.
Suppose I switch these to in-memory tables (:memory:), how do I go about
checking if a table exists? Do in-memory
On Mon, Oct 24, 2011 at 11:47 AM, Doug Currie wrote:
>
> On Oct 24, 2011, at 11:07 AM, Dilip Ranganathan wrote:
>
> > But as you all know, this doesn't work:
> >
> > select datetime(time) from table where time >=
> > julianday(datetime(max(time)),'-2
Lets say I have a column named 'time' that stores timestamps as juliandays.
Suppose I only want to extract rows for the past 2 hours from now, I could
do:
select datetime(time) from table where time >= julianday('now','-2
hour','localtime') order by time desc
That works as expected. However what
11 matches
Mail list logo
