Hi,
I think you should have a look here:
http://www.sqlite.org/uri.html
Hope that helps!
Fredrik
On Tue, Oct 23, 2012 at 10:48 AM, John Gillespie wrote:
> Just spent a while trying to work out how to access sqlite in read-only
> mode from Tcl.
> There seems to be nothing in the API doc :
> ht
Hi,
Just thought I'd tell you that I went into solving this issue myself.
The resulting script is here:
https://github.com/dargosch/sqlite2dot
* Requires Tcl and the sqlite3 package for Tcl.
It generates a .dot file for use with Graphviz. Very simple script,
but it solves the issue I wanted to
Hi,
I'm looking for a tool that would generate a visualisation (UML?) of
the SQLite database schema I'm using, with table constraints and
references between tables if possible. Is there such a tool (for Mac)?
I've looked into SQL::Translator (produces reasonable output, but does
not cover the ent
Hi,
A very nice extension - I'll look into that one for my integer-only
lists, for sure.
Thank you!
/Fredrik
2011/2/10 Alexey Pechnikov :
> See
> http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl
>
> 09.02.2011 17:49 пользователь "Fredrik Karlsson"
> напис
On Wed, Feb 9, 2011 at 6:15 PM, Eric Smith wrote:
> Fredrik Karlsson wrote:
>
>> package require sqlite3
>> sqlite3 db :memory:
>> db eval {create table a (id INTEGER);}
>> db eval {insert into a values (1);}
>> db eval {insert into a values (2);}
>>
Dear list,
I find the IN operator quite useful for selecting a set number of things.
However, I often have a Tcl list with the things I want to match
already when I get to the stage there I should issue a SELECT on the
database.
I then paste all the elements of the list together with ',' or just ,
Hi,
I notice that the int sqlite3_open_v2 C function has a
SQLITE_OPEN_READONLY which allows opening a database in read only
mode.
Would it be possible to have this possibility in the Tcl interface
too? Perhaps similar to the way the "open" command of Tcl specifies
flags.
This feature would be ve
Hi,
Sorry, never mind this post. I haven't found the problem actually yet,
but a "bare minimum" example fed directly to the interpreter through
the command line works correctly:
% package require sqlite3
3.7.2
% set inf [open 1_schema.sql r]
file6
% set sql [read $inf]
[... the contents of the re
On Sat, Nov 20, 2010 at 2:43 PM, Richard Hipp wrote:
> On Sat, Nov 20, 2010 at 8:25 AM, Fredrik Karlsson wrote:
>
>> Dear list,
>>
>> I am having a silly problem, and need your expertise. I just want to
>> initiate a SQLite database using a schema file in Tcl, but I
Dear list,
I am having a silly problem, and need your expertise. I just want to
initiate a SQLite database using a schema file in Tcl, but I just get
an empty database whatever I do. I asked this question on the Tcl
list, and got a reply which I interpret to mean that this is not a
problem in my T
Hi Igor,
Thank you for the qick response. Of course, this PRAGMA solved the
entire issue, once I got a never version of SQLite installed.
Thank you!
/Fredrik
On Tue, Nov 16, 2010 at 10:58 PM, Igor Tandetnik wrote:
> Fredrik Karlsson wrote:
>> I'm probably doing something real
Dear list,
I'm probably doing something really stupid here, but I feel I need to
ask you anyway to see id there is something that I've missed.
Is it not possible for a trigger to trigger itself? I get triggers
that trigger triggers, but so far not triggers that trigger
themselves... (yes, many tri
Hi,
Have you had a look at the EXCEPT statement?
http://www.sqlite.org/lang_select.html (bottom of page)
"EXCEPT takes the result of left SELECT after removing the results of
the right SELECT. "
Does this make sense to you?
/Fredrik
On Thu, May 6, 2010 at 1:03 PM, Matt Young wrote:
> # I am d
On Fri, Apr 2, 2010 at 1:59 PM, Igor Tandetnik wrote:
> Fredrik Karlsson wrote:
>> Sorry for asking this SQL question, but I just have to make sure:
>>
>> - Aliases in subqueries - are the always, local to the scope of the
>> subquery?
>>
>>
>> That
Dear list,
Sorry for asking this SQL question, but I just have to make sure:
- Aliases in subqueries - are the always, local to the scope of the subquery?
That is, if I have this query (this example makes _no_ sense, I know.
Just an illustration.):
select target.* from
(
select target.* f
On Fri, Mar 26, 2010 at 1:25 PM, Igor Tandetnik wrote:
> Fredrik Karlsson wrote:
>> This is of course another solution. I guess, coming from R, I was
>> looking for a substitute for th %in% operator (or the MySQL IN
>> operator as it turns out, now that I've Googled thi
On Fri, Mar 26, 2010 at 12:22 PM, Simon Slavin wrote:
>
> On 26 Mar 2010, at 9:00am, Fredrik Karlsson wrote:
>
>> I have a list of id:s stored in a field. I would now like to get some
>> information from a table by these id:s, but exactly in this order. So,
>> if I ha
Hi,
I have a list of id:s stored in a field. I would now like to get some
information from a table by these id:s, but exactly in this order. So,
if I have a table
1 One
2 Two
3 Three
and the sequence "3,1,2" stored somewhere, how do I get a neat list like
Three
One
Two
?
I I can see a solution
Dear list,
I have a (small) directed graph which I would be able to fins all
ancestors or descendents of a certain vertex (transitive closure?).
So, using this graph:
CREATE TABLE levels_levels (parent_id INTEGER ,child_id INTEGER,
UNIQUE(parent_id, child_id));
INSERT INTO "levels_levels" VALUES(
Dear list,
I am writing small program for large-ish databases involving multiple
(nested) comparisons of time references (REAL) against time intervals
(also REAL) stored as max and min points
(i.e. "is this time point within the intervals I have stored in table X?")
At what point, in terms of dat
Hi,
Yes! That's it! Sorry about the stupid question then..
select datetime('now','localtime'); seems to do what I want.
/Fredrik
On Thu, Oct 8, 2009 at 9:39 AM, Simon Davies
wrote:
> 2009/10/8 Fredrik Karlsson :
>> Hi,
>>
>>
>>
>> On
Hi,
On Thu, Oct 8, 2009 at 12:04 AM, P Kishor wrote:
> On Wed, Oct 7, 2009 at 5:02 PM, Fredrik Karlsson wrote:
>> Dear list,
>>
>> I am sorry if I am asking a FAQ, but what is differnent with
>> datetime() and time()?
>>
>>> date # This is the correc
Dear list,
I am sorry if I am asking a FAQ, but what is differnent with
datetime() and time()?
> date # This is the correct time on the system
Ons 7 Okt 2009 23:56:36 CEST
> sqlite3 temp.sqlite "SELECT datetime();"
2009-10-07 21:56:58
> sqlite3 temp.sqlite "SELECT datetime('now);"
SQL error: unr
On Thu, Jul 16, 2009 at 1:20 PM, Michael Schlenker wrote:
> Your working far too hard. The sqlite Tcl binding already does all thats
> needed.
>
> This is perfectly safe:
> set result [db1 eval {select * from X where label = $myStringValue and id >
> $compId}]
>
> But you MUST use {} to quote your
Dear list,
Sorry for jumping onto the list mainly to ask a question, but it is an
imporant one, and I have failed to find the answer on Google.
I am developing a prototype of an application in Tcl using sqlite as
the backend database. Now, I know that I will be dealing with quite
naïve users, who
25 matches
Mail list logo