Addendum: This test was conducted using a full size test dataset. I had
been using one that was an order of magnitude smaller for profiling before,
but could use the full size for this test.
On Mon, Jan 16, 2012 at 4:37 PM, John Elrick wrote:
> Lacking the status interfaces for 3.6.17 I
Lacking the status interfaces for 3.6.17 I was forced to mark them as
"interface not supported". Simon suggested I track the calls to _malloc,
so I've added extensive tracing code. Here is the final output from the
two versions:
Application: Surveyor.exe
Sqlite version:
_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
John Elrick
Fenestra Technologies
540-868-1377
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote:
> On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote:
>
> >
> > 3.6.17
> >
> > Procedure % TimeTimeCalls
> > _sqlite3_step 58.4% 1.795,052
>
On Mon, Jan 16, 2012 at 10:33 AM, Richard Hipp wrote:
> On Mon, Jan 16, 2012 at 10:29 AM, John Elrick >wrote:
>
> >
> >
> > > SQLite has lots of interfaces that can be used to determine performance
> > and
> > > status information. Some
On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote:
> On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote:
>
SNIP
> SQLite has lots of interfaces that can be used to determine performance and
> status information. Some example code from the command-line shell that
> ac
On Mon, Jan 16, 2012 at 4:37 AM, Max Vlasov wrote:
> On Sun, Jan 15, 2012 at 3:35 AM, John Elrick >wrote:
>
> > On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov
> wrote:
> >
> > 5,008 calls to
> >
> > UPDATE RESPONSES SET
> > RESPONSE_NAME = :RESPO
On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov wrote:
> John,
> I read your previous post and unfortunately, your conversation with Richard
> didn't reveal much details. I worked with scenario similar tou yours
> (Delphi + statically linked sqlite) for several years and during
On Sat, Jan 14, 2012 at 10:42 AM, Dan Kennedy wrote:
> On 01/14/2012 04:49 AM, John Elrick wrote:
>
>>
>> So, obviously the problem is that _malloc is being called a much larger
>> number of times by 3.7.9 in this particular circumstance -- roughly 70
>> times a
On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote:
> On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote:
>
> >
> > 3.6.17
> >
> > Procedure % TimeTimeCalls
> > _sqlite3_step 58.4% 1.795,052
>
On Fri, Jan 13, 2012 at 5:20 PM, Pavel Ivanov wrote:
> > At this point I've exhausted my avenues of research. Does anyone have
> any
> > further ideas as to what may be going on which could cause this increase
> in
> > memory management activity? Or any suggestions of where to look next?
>
> II
e any
further ideas as to what may be going on which could cause this increase in
memory management activity? Or any suggestions of where to look next?
--
John Elrick
Fenestra Technologies
540-868-1377
___
sqlite-users mailing list
sqlite-users@sqlit
Alternatively in tcl :
dbcmd eval { create table mytable ( aaa integer, text) }
dbcmd eval { insert into mytable (aaa,bbb) values (1, '') }
dbcmd eval "select * from mytable" loopvar {
# loopvar(*) contains the column names, loopvar(aaa) contains 1,
loopvar(bbb) contains "zzz
ite, there doesn't appear to be a built in
mechanism for creating this type of log. Is this correct or am I
missing something?
--
John Elrick
Fenestra Technologies
540-868-1377
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.
otentially relevant information.
I did add an assertion which runs during initialization to ensure that
the version is as expected. I have confirmed that both the shell
application and the full application concur on version numbers.
On Tue, Jan 10, 2012 at 10:35 AM, John Elrick wrote:
> O
On Tue, Jan 10, 2012 at 10:14 AM, Richard Hipp wrote:
> On Tue, Jan 10, 2012 at 10:08 AM, John Elrick wrote:
>
>> On Tue, Jan 10, 2012 at 8:31 AM, Richard Hipp wrote:
>> > On Tue, Jan 10, 2012 at 8:14 AM, John Elrick > >wrote:
>> >
>> >> I will
On Tue, Jan 10, 2012 at 8:31 AM, Richard Hipp wrote:
> On Tue, Jan 10, 2012 at 8:14 AM, John Elrick wrote:
>
>> I will have to get back to you on this. While running tests against
>> isolated queries, I noticed an unusual circumstance. When I isolate
>> the queries into
Mon, Jan 9, 2012 at 11:13 AM, Richard Hipp wrote:
>
>> Please send private email to d...@sqlite.org. CC to d...@sqlite.org and
>> j...@sqlite.org.
>>
>>
>> On Mon, Jan 9, 2012 at 11:09 AM, John Elrick wrote:
>>
>>> Sorry "The combined files
Sorry "The combined files are 2.4 MB zipped"
On Mon, Jan 9, 2012 at 11:09 AM, John Elrick wrote:
> Richard,
>
> I have the information available for you. Unfortunately, it appears
> that I cannot actually reduce the case, however, the issues appear to
> be fairly confin
.
The combined files are 2.4 MB. How would you prefer I send this file
to you?
On Fri, Jan 6, 2012 at 4:51 PM, John Elrick wrote:
> Yes. Look for it on Monday. I'm about to leave for the day. The
> queries are automatically generated and will require some mining to
> get specifi
.
On Fri, Jan 6, 2012 at 4:42 PM, Richard Hipp wrote:
> Can you publish for us:
>
> (1) A sample database
> (2) The specific queries that are causing your problems
>
> So that we can investigate further?
>
> On Fri, Jan 6, 2012 at 4:31 PM, John Elrick wrote:
>
>> B
pleased to hear
them. For the moment we are reverting to 3.6.7 as a temporary
solution.
--
John Elrick
Fenestra Technologies
540-868-1377
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
This would make a good entry for an Obfuscated SQL contest.
Well done
John
On 19 December 2011 21:43, Nico Williams wrote:
> You can do conditionals via WHERE clauses, as others have pointed out.
> You can also use WHEN clauses on triggers.
>
> Think of it as IF . And remem
Try
set roads {"Miller lane" "Pine street" "Wilson blvd"}
set SQL "insert into myTable VALUES( '[join $road "','"]' )"
db eval $SQL
# note the single quotes on each side of the join command
# and the argument to the join command.
JG
___
sqlite-users mai
extensions for known types enabled in windows"
When this is enabled windows does not display the extension for known
types so that if you have more than 1 file with the same base name
they will appear as the same but with a different icon in the explorer
view.
John M. Drescher
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Kit, I've tried many of the tools listed @
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools. My hands-down vote
is for SQLiteExpert Professional @
http://sqliteexpert.com/<http://sqliteexpert.com/>. In my opinion
spending $59 for the Pro version is a **no-brainer** for many reas
eption* pEx)
{
TRACE(_T("File %20s cannot be removed\n"), sFileName);
pEx->Delete();
}
strLibDB.Format ("%s%s", LOCAL_DB, "MediaLibrary.sqlitedb-wal");
sscanf (strLibDB,"%s", sFileName);
> If the mailing list was replaced by a forum, everybody would go to the forum.
>
The failure in this logic is that is not true. I already said I would
not bother with the forum and I was not the only one.
John
___
sqlite-users mailing list
sqlite
their status. With that said I rarely participate on
the sqlite mailing list. This is mainly because I have not had many
problems with it.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I have a FTS3 table that was created with the simple tokenizer. I want to
change the tokenizer and reindex the table.
Is there a way to change the tokenizer in place and have it reindex with
minimal code?
Else the other option I was thinking about was dropping the table,
re-creating it with the n
mbarrassing to admit my dumb mistakes, I kinda feel like you
deserve to know since you provided so much assistance. Thanks again, and if
you are ever in Brookfield, MO, lunch is on me.
R,
John
___
sqlite-users mailing list
sqlite-users@sqli
e a piece of code as I could.
Thanks for what help you gave. It pointed me in the right direction, I think.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ose sqlite db ptr"): // As far as I can
tell, this msg showed up with the processing of every record.
}
I'm not sure where I've gone wrong.
R,
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
hat the role of the finalize call?
Here's the sequence of events I use when I use sqlite3_close:
Result = sqlite3_step(ResultStmt);
if(Result != SQLITE_DONE)
{
Do some error/loop stuff as appropriate
}
sqlite3_finalize(ResultStmt);
sqlite3_close(db_ptr);
sqlite3_shutdown();
is
always associated with the advent of a system File Open dialog that is empty of
all files in the folder I am working, when it should have between 60 and 100
files.
Has anyone working a Mac ever experienced something like this?
John A.M. Darnell
Senior Programmer
john.darn...@walsworth.com
Hello Baruch,
You may want to look at sqlite3_exec() (http://www.sqlite.org/c3ref/exec.html).
John
--- On Wed, 7/27/11, Baruch Burstein wrote:
> From: Baruch Burstein
> Subject: [sqlite] c-api
> To: "General Discussion of SQLite Database"
> Date: Wednesday, July 27, 20
\VC\bin\amd64\cl.exe"' : return code '0x2'
> Stop.
> Anyone knows how can I include this path that is missing?
>
Did you run that from a "Visual Studio 2010 command prompt" ?
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Does anybody have or know of another example of using the geometry callback
in R-Trees? I am following the example on the site, but still can't wrap my
mind around the concept.
Thanks in advance.
John
___
sqlite-users mailing list
sqlite-
Hello,
I am new and have received much information from this list so I hope I am not
wasting bandwidth. I don't know if it is my misunderstanding or typos but
should your sqlite3_column_int() use indexes 0,1 and 2 instead of 1, 12 and 13?
If this is the case, according to the docs on sqlite3_c
Has anybody seen this before? I use System.Data.SQLite for a project and
the program will not run on a client's computer. This is the exception
listed in the event viewer.
Thanks,
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
d (in this case 11 years old) sets of API. It's going to happen again in
> OS X 10.7
> because OS X 10.7 does not support the PowerPC compatibility layer.
Gulp. Another sleepless three months for us InDesign Plugin programmers as we
figure out how to cope...
Take care.
R,
John
__
Um, what's top-posting?
And of course I always strive to be wise. Simon (or for that matter, the rest
of the list), if you thought I was being a wiseass, then again, my apologies.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite
x27;s an excuse (grin), but it's all I've got.
Take care, and honest, thanks!
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Simon Slavin
> Sent: Friday, June 17, 2011 5:18 PM
> T
Thanks Doug. I appreciate you pointing this out to me.
I checked two references and neither one of them mentioned this teensy little
requirement. I guess they must've thought it wasn't important.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.or
Thanks Pavel. That worked.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Pavel Ivanov
> Sent: Friday, June 17, 2011 2:23 PM
> To: General Discussion of SQLite Database
> Subject: Re:
"Here's the SQLite error message: %s\n", msg);
// Sent to stderr: "Unable to open database file."
I have verified that the file exists on the path described above. What am I
doing wrong?
TIA!
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing C
Sorry to send this twice, but I realized that my first transmission did not
include a subject line.
_
From: john darnell
Sent: Friday, June 17, 2011 1:56 PM
To: 'General Discussion of SQLite Database'
Subject:
I am attempting to open
Hi,
from my experience the query "PRAGMA case_sensitive_like;" doesn't return the
pragma's current value.
I suppose this is the intended behavior but I'd like a confirmation since I
can't find an answer in the docs.
- John Q.
__
bject: Re: [sqlite] Unlocking the database
>
> John, I've had nothing but trouble with the Firefox plugin. Download and
> install
> the SQLite Expert Personal 3 GUI (free) and see if that does anything for
> you, or
> at least gives you better diagnostics.
>
> --- On Sat, 5
lem I will contact the list
immediately instead of waiting a day.
Thanks everyone. I appreciate your help.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Richard Hipp
> Sent: Saturday, May 28, 2
I understand the need for integrity when locking a database, but in this case I
knew that the problem was caused by a (in all honesty, my) bug. I tried
rebooting the machine and it did not unlock the table.
So I guess that means that the answer is "no."
R,
John
> -Ori
g has caused it to lock.
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be reached at
johnamdarn...@gmail.com<mailto:johnamdarn...@gmail.com>
Trivia question Trivia question: In The Lord of the Rings,Leglolas was a
prince among the Silvan Elves
oss a way to get SQLite3 to compile and link without error or
warning. How we did it is provided in a previous email sent last evening, but
I would be happy to share it again for anyone who finds him(her)self in the
same boat.
Take care,
John
> -Original Message-
> From: sqlite
_t id, const struct timespec twait);
**(note the change in wait)**
I would appreciate it if those of you who know the code would double-check my
hubris and let me know if I have done something monstrously (or maybe even just
a little) stupid. It wouldn't be the first time...
R,
John
___
same name, and now inside a block inside that scope the programmer is
creating a new variable with the same name. On Windows, Visual Studio doesn't
care. In Xcode 3.1.3, it lets the programmer know that he is doing it. It's
up to her to decide to fix it.
Thanks to all of you w
Thank you Mr. Ivanov. I can buy what you are saying 100%. What I need to know
is how to tell Xcode to compile that file as a C file if the standard procedure
is not working.
I recoup: the files are being classified as sourcecode.c.c and sourcecode.c.h.
What else do I need to do?
R,
John
>
> I'm not sure what .dylib you're using. The standard installation of OS X
> with the
> Developer tools has sqlite header files in
>
> /usr/include/sqlite3.h
>
> and
>
> /Developer/SDKs/MacOSX10.6.sdk/usr/include/sqlite3.h
>
> which may or may not be identical to each-other.
>
> Whereve
information
2.) I'm being so wordy that no one will want to look at my questions/responses
(there is a reason my moniker is 'Pedantic' :).
R,
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
re are two errors out of the 1200+ errors generated (I tried to include as
much information as possible to help identify the problem. Please forgive if I
am overdoing it...):
Compiling /.../sqlite3.c
Error:invalid conversion from "void *" t
> On 26 mai 2011, at 16:49, john darnell wrote:
>
> >
> > Since then I have tried using the sqlite.dylib file that comes with OSX but
> > in
> doing so, some important SQLite functions (such as the prepare function) were
> not found during the link process.
>
on my Windows box, upon
compilation, it generated a whopping 200 errors, and continued to do so until I
turned off "using precompiled headers." I cannot see a way to do this in
Xcode. Perhaps that is my problem?
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfie
Hello Pavel,
Thanks. This is the conclusion I was arriving at. I do use the Sqlite3
utility but only for looking at test results when the server is in an inactive
state.
Thanks,
John
--- On Tue, 5/24/11, Pavel Ivanov wrote:
> From: Pavel Ivanov
> Subject: Re: [sqlite] Multi-thr
that. Pthread_rwlock() works fine.
Thanks,
John
--- On Tue, 5/24/11, Pavel Ivanov wrote:
> From: Pavel Ivanov
> Subject: Re: [sqlite] Multi-threading Common Problem
> To: "General Discussion of SQLite Database"
> Date: Tuesday, May 24, 2011, 9:51 AM
> > I have al
. With my pthread_rwlock(), I have multiple
threads reading the DB and my writes get the exclusive access they need. Now I
could loop on the write until it gets in but that seems very wasteful.
So how do I implement the equivalent of a pthread_rwlock() using SQLite
mechinisms?
Thanks,
Joh
bvious.
Thanks,
John
--- On Fri, 5/13/11, Roger Binns wrote:
> From: Roger Binns
> Subject: Re: [sqlite] Multi-threading Common Problem
> To: sqlite-users@sqlite.org
> Date: Friday, May 13, 2011, 2:00 AM
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 05/12/2
Any thoughts?
R,
John
.
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Simon Slavin
> Sent: Monday, May 16, 2011 4:32 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Compil
Okay, I started looking at the code in SQLite3 and noticed that this is
already done for me.
Please have mercy on me, I am on the road and do not have access to my usual
resources. What do I need to do to get Xcode to compile this code in 3.1.3?
R,
John
> -Original Mess
; On Behalf Of Richard Hipp
> Sent: Monday, May 16, 2011 3:45 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Compiling in Xcode 3.1.3
>
> On Mon, May 16, 2011 at 4:31 PM, john darnell
> wrote:
>
> > Thanks for responding, Mr HIpp.
&
where SQLite 3 is stored) but I did that and it didn't really resolve
anything.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Richard Hipp
> Sent: Monday, May 16, 2011 3:19 PM
> To: G
I have code that compiles just fine using Visual Studio 8 on Windows XP, but
when I port SQLite over to a Mac OSX (Snow Leopard) platform using Xcode
3.1.3 I get roughly 1000 errors based upon SQLite. Is there something I need
to turn off/on when using SQLite on the Mac?
R,
John A.M
connection. I am
afraid that the second step() call will fail with a "database locked" error
since the first step() call is complete but the reset() has not taken place yet
(because I am doing column() calls to extract the retrieved data before
resetting the prepared statement).
Tha
implementation of the former was
more established than the later.
Again thanks for the information and I apologize for taking up so much list
bandwidth. I hope others can benefit.
John
--- On Thu, 5/12/11, Pavel Ivanov wrote:
> From: Pavel Ivanov
> Subject: Re: [sqlite] Common Multi-treaded P
should be doing.
Thanks,
John
--- On Thu, 5/12/11, Simon Slavin wrote:
> From: Simon Slavin
> Subject: Re: [sqlite] Common Multi-treaded Problem
> To: "General Discussion of SQLite Database"
> Date: Thursday, May 12, 2011, 9:28 PM
>
> On 13 May 2011, at 1:33am,
:45 AM, Igor Tandetnik wrote:
> John wrote:
> > I don't see how that helps. Let's say I have table with rules which
> > determine from which view to select:
> >
> > create rules_table
> > (condition integer, myview integer);
> >
> > insert
Hello Roger,
OK I see your point now. I could most likely remove the OS mutexes.
Thanks,
John
--- On Thu, 5/12/11, Roger Binns wrote:
> From: Roger Binns
> Subject: Re: [sqlite] Multi-threading Common Problem
> To: sqlite-users@sqlite.org
> Date: Thursday, May 12, 2
Hello Pavel,
Humm. Resetting each prepared statement right after use seemed to work. So in
review, a select prepared statement will lock the DB from other threads (or is
it DB connections?) but not the current thread (or is it DB connection).
Thanks for the help!
John
--- On Thu, 5/12/11
after you have performed these activities. That
would imply if what I interpret your statements correctly, that the database is
locked until the reset is issued.
I appreacate your help. I am just trying to understand what you are trying to
tell me.
Thanks,
John
--- On Thu, 5/12/11, Pavel Ivanov
between different connections in the same process when
> shared cache is
> turned off.
>
>
> Pavel
>
>
> On Thu, May 12, 2011 at 4:26 PM, John Deal
> wrote:
> > Good question. Very possible my understanding is not
> complete.
> >
> > I have basi
er Binns
> Subject: Re: [sqlite] Multi-threading Common Problem
> To: sqlite-users@sqlite.org
> Date: Thursday, May 12, 2011, 4:01 PM
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 05/12/2011 09:38 AM, John Deal wrote:
> > I have been working for weeks on thi
plete transactions.
Anyway, thanks for the insight.
John
--- On Thu, 5/12/11, Igor Tandetnik wrote:
> From: Igor Tandetnik
> Subject: Re: [sqlite] Common Multi-treaded Problem
> To: sqlite-users@sqlite.org
> Date: Thursday, May 12, 2011, 12:35 PM
> On 5/12/2011 12:31 PM, John Deal
>
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have used SQLite extensively single-threaded with no problems (other than my
own!). I am currently working on another pr
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have used SQLite extensively single-threaded with no problems (other than my
own!). I am currently working on another pr
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have basically the same situation as this thread:
---
On Wed, Jan 26, 2011 at 10:
_in)
Something like this will generate an error, same if I try to use case.
On Wed, May 11, 2011 at 11:13 PM, Igor Tandetnik wrote:
> John wrote:
> > So now I know that case can return column names. But is there a way to
> tell
> > it from which table to select.
> > Earlier
I meant to attach some language that would give me more flexibility than
straight sql.
On Wed, May 11, 2011 at 10:35 PM, John wrote:
> I've developed a mobile app that I want on all smartpnones (that means at
> least 4 different platformorms/languages). I've managed to put 8
gt; work any faster than the same logic in your application. In fact it
> would work even slower because SQLite would have to implement
> something general with lots of different features and you can
> implement something simple and optimized to your particular use case.
>
>
> Pavel
&g
:
> On Wed, May 11, 2011 at 9:03 PM, John wrote:
> > Yes, I could. But considering that I'm applying tons of logic and not
> just
> > selected this would be a real mess. Not even sure I could pull it.
> > Normalization was something I lacked with regard to previous post.
lack of
dynamic sql. I can't trully construct sql statement piece by piece with SQL
db as I did with Oracle. Just wanted to confirm.
On Wed, May 11, 2011 at 9:58 PM, Nico Williams wrote:
> On Wed, May 11, 2011 at 8:47 PM, John wrote:
> > That would work if I needed to select a si
e)
> Connected by MOTOBLUR™ on T-Mobile
>
> -Original message-
> From: John
> To: General Discussion of SQLite Database
> Sent: Wed, May 11, 2011 18:17:14 PDT
> Subject: [sqlite] Can I dynamically select a table?
>
> So now I know that case can return column names. But is there
(select case
when 1=1
then t1
else t2
end);
Thanks.
--
~John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I tried using case myself as the first thing but it didn't work, I though I
need dynamic sql for that. Didn't realize it's that simple - just the column
name.
On Wed, May 11, 2011 at 9:04 PM, John wrote:
> yes, using Case worked for me too and that's exactly what I n
yes, using Case worked for me too and that's exactly what I need since I
need only today's value. Thank you so much guys! My kudos to you, Igor :)
On Wed, May 11, 2011 at 9:02 PM, John wrote:
> too much logic
>
>
> On Wed, May 11, 2011 at 9:01 PM, John wrote:
>
>
too much logic
On Wed, May 11, 2011 at 9:01 PM, John wrote:
> I should have done it like that (normal referential table). But now I'm at
> the end of this project and too logic uses that table already. So perhaps
> I'll refactor some day.
>
>
> On Wed, May 11, 201
I should have done it like that (normal referential table). But now I'm at
the end of this project and too logic uses that table already. So perhaps
I'll refactor some day.
On Wed, May 11, 2011 at 8:56 PM, Igor Tandetnik wrote:
> On 5/11/2011 8:52 PM, John wrote:
> &g
sday' dow, thursday_goal value from user_goals
union all
select 'friday' dow, friday_goal value from user_goals
union all
select 'saturday' dow, saturday_goal value from user_goals
union all
select 'sunday' dow, sunday_goal value from user_goals;
select dow, value fr
ok, I will try. Meanwhile I created the actual view that does what I need.
(considering I have many mondays, tuesdays... I replaced UNION with UNION
ALL)
On Wed, May 11, 2011 at 8:44 PM, Mr. Puneet Kishor wrote:
>
> On May 11, 2011, at 7:37 PM, John wrote:
>
> > Igor,
> > Wh
011 at 8:30 PM, Igor Tandetnik wrote:
> On 5/11/2011 8:14 PM, John wrote:
> > I am in situation where I need to keep as much logic as possible within
> > SQLite. However the query that I need to perform does not seem to be
> > possible to perform.
> >
> > let&
from user_goals
union
select sunday_goal from user_goals;
> Nico Williams writes:
> > On May 11, 2011 7:14 PM, "John" wrote:
> > > let's say I have a table with columns for each day of the week
> > >
> > > create table seven_days
>
teger,
wednesday_value integer,
... );
I want to select value from whatever day it is today. So if today is
Tuesday, select from tuesday_value.
Can I do it with pure SQlite?
--
~John
___
sqlite-users mailing list
sqlite-users@sqlite.org
ARE link flag) is 2GB and fragmented so that the largest
single process allocation (without resorting to AWE) is somewhere
around 1.2GB to 1.5GB even if you have a system with 4GB of RAM and
8GB of swap space.
John
___
sqlite-users mailing list
sqlite-user
501 - 600 of 2794 matches
Mail list logo
