There is no mention in the write-up of PRAGMA table_info that it
works for a VIEW as well as for a TABLE.
It takes only a few seconds to verify this, but saving others the
trouble of doing so seems like a good idea to me.
Thank you,
Gerry Snyder
On 2013/11/08 05:47, James K. Lowden wrote:
Not that you asked, but I also suggest you consider dropping the Tbl from the table names. Noting that at table is a table in
its name is like calling every file data. It makes it harder to read and conveys no information. I myself prefer plurals for
Hi James K. Lowden,
Sorry. My backup application pulls tracks from albums and upload to
server. Here, I need to store these Albums and Tracks information into
database. From my application point of view, Every Track is a
file.File may be track. When same track avail with different albums,
then
Hi All,
I am working on sqlite database schema for Music/Track files. I am
posting few tables schema here.
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
UNIQUE(file_path));
CREATE TABLE if not exists AlbumTbl
On Thu, Nov 7, 2013 at 11:50 AM, dd durga.d...@gmail.com wrote:
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
UNIQUE(file_path));
Some years ago i worked on something similar to keep track of my multimedia
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad this to my schema.
On Thu, Nov 7, 2013 at 3:07 PM, Stephan Beal sgb...@googlemail.com wrote:
On Thu, Nov 7, 2013 at 11:50 AM, dd durga.d...@gmail.com wrote:
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
On Thu, Nov 7, 2013 at 12:15 PM, dd durga.d...@gmail.com wrote:
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad this to my schema.
If you're only storing the list for local use on one machine, adding the
media ID is almost certainly overkill, but i found it useful for
It has to work with multiple devices in future. This is valid point
for me. Thanks.
On Thu, Nov 7, 2013 at 3:42 PM, Stephan Beal sgb...@googlemail.com wrote:
On Thu, Nov 7, 2013 at 12:15 PM, dd durga.d...@gmail.com wrote:
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad
On Thu, 7 Nov 2013 14:50:44 +0400
dd durga.d...@gmail.com wrote:
I am working on sqlite database schema for Music/Track files. I am
posting few tables schema here.
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/11/13 19:47, James K. Lowden wrote:
You might guess from my email domain name that I take an interest in
posts like yours. And it's pretty good first cut, no pun intended.
;-)
It is also worthwhile looking at musicbrainz
On Wed, Feb 9, 2011 at 6:15 PM, Eric Smith eas@gmail.com 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);}
db eval {select * from a where id in
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 pechni...@mobigroup.ru:
See
http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl
09.02.2011 17:49 пользователь Fredrik Karlsson dargo...@gmail.com
See
http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl
09.02.2011 17:49 пользователь Fredrik Karlsson dargo...@gmail.com
написал:
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
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
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);}
db eval {select * from a where id in (1,3);} vals {parray vals}
vals(*) = id
vals(id) = 1
set alist [list 1
I'm wondering if the SQL gurus here can give me some direction. I have a
very simple stats table:
CREATE TABLE StatData
(
StatID INTEGER NOT NULL,
Value REAL NOT NULL,
Date INTEGER NOT NULL
);
I'd like to pull out the most recent date and associated value for each
StatID.
I initially thought
Doug pa...@poweradmin.com wrote:
I'm wondering if the SQL gurus here can give me some direction. I have a
very simple stats table:
CREATE TABLE StatData
(
StatID INTEGER NOT NULL,
Value REAL NOT NULL,
Date INTEGER NOT NULL
);
I'd like to pull out the most recent date and associated
-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: Thursday, September 09, 2010 10:59 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Query suggestion?
Doug pa...@poweradmin.com wrote:
I'm wondering if the SQL gurus here can give me
On 9/9/2010 11:32 AM, Doug wrote:
Thank you Igor.
You've helped me before with what also turned out to be a similar
select referencing the same table twice. I guess it's a concept
that I don't fully get. If there is a name for this technique
I'll go Google and study up on it.
You
...@sqlite.org] On Behalf Of Gerry Snyder
Sent: Thursday, September 09, 2010 1:52 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Query suggestion?
On 9/9/2010 11:32 AM, Doug wrote:
Thank you Igor.
You've helped me before with what also turned out to be a similar
Hi Everyone,
On the basis of the number of times it comes up on the mailing list,
and the grounds that most 'casual' users will want Sqlite to work as
well as possible 'out the box' -
I'd like to suggest the that the default busy handler is changed from
being none to being
the 'standard' busy
I know I could get columne names. nevertheless, I find that
SHOW columns FROM table
was a pretty intuitive way to get this information. information
schema is less intuitive, but I would be happy to have something that
works across the board. why not have all of them?
I hope my logarithm and
Sent: Sunday, September 21, 2008 9:43 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Simple Suggestion
I know I could get columne names. nevertheless, I find that
SHOW columns FROM table
was a pretty intuitive way to get this information. information schema
is less intuitive, but I would
My suggestion for a future enhancement:
Provide a temporary storage pool of memory.
If the temporary pool overflows then go to disk based temp store.
That way order by query results can generally be quickly satisfied by the
average case memory consumption and Large order by queries will
On Sep 10, 2008, at 2:02 PM, Ken wrote:
My suggestion for a future enhancement:
Provide a temporary storage pool of memory.
If the temporary pool overflows then go to disk based temp store.
That way order by query results can generally be quickly satisfied
by the average case memory
DRH,
Many thanks.
I learned something new everyday thanks to Sqlite !!!
Regards,
Ken
--- On Wed, 9/10/08, D. Richard Hipp [EMAIL PROTECTED] wrote:
From: D. Richard Hipp [EMAIL PROTECTED]
Subject: Re: [sqlite] Memory suggestion for DRH
To: General Discussion of SQLite Database sqlite-users
http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730
Excellent book!
On Sat, Apr 19, 2008 at 12:37 PM, mikeobe [EMAIL PROTECTED] wrote:
i found it boring to learn how to use sqlite, maybe we can write a
tutorial for it, with examples,
it will be much easier for the beginner to start
P Kishor wrote:
For starters, a database of every single email from Igor and Dennis
Cote should be mandatory reading for anyone wanting to do anything
with SQLite.
And drh and Dan Kennedy and Scott Hess.
You probably assumed that the first of these went without saying.
Gerry
Along these lines, also note that the quickstart (url below) still
shows the callback method instead of the v2 methods. The last time
another programmer asked me for help, I referred him there and I was
shocked later at the code he produced. Nice code, but you could have
done the same thing a
FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious sqlite.org email alias to anybody who is
willing to step up and make some improvements and
updates to the current documentation.
D. Richard Hipp
[EMAIL PROTECTED]
D. Richard Hipp wrote:
FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious sqlite.org email alias to anybody who is
willing to step up and make some improvements and
updates to the current documentation.
D.
On 4/21/08, D. Richard Hipp [EMAIL PROTECTED] wrote:
FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious sqlite.org email alias to anybody who is
willing to step up and make some improvements and
updates to the
For what it is worth, while I had done a few simple things in MySQL prior to
using SQLite, I think it would be nice if there were a couple of different
tracks of tutorials. Maybe they could be one for the Novice, one for an
Experienced user, and then one for those that are doing actual C
I'm sorry if this reply seems jumbled - I wrote the middle bit (about
the sugested content) after the bits above and below it.
Jay A. Kreibich wrote:
On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
mikeobe wrote:
i found it boring to learn how to use
Agreed - I had to learn from the 5 minute introduction (which I was
later told was a poor way of doing it), and then by using the reference,
which leaves a lot to be desired when it comes to having little
knowledge of SQLite - and it's still giving me trouble now!
Toby
mikeobe wrote:
i found
On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
mikeobe wrote:
i found it boring to learn how to use sqlite, maybe we can write a
tutorial for it, with examples, it will be much easier for the
beginner to start with sqlite.
Agreed - I had to learn from the 5
On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote:
This is a bit off-topic for the mailing list, so please feel free
to send stuff directly to the address below.
It would be good, I think, to have a public record of this
conversation. We can create an [EMAIL PROTECTED]
mailing list if
PROTECTED]
Sent: Saturday, April 19, 2008 05:47 PM
To: [EMAIL PROTECTED], 'General Discussion of SQLite Database'
Subject: Re: [sqlite] a suggestion to write tutorial for sqlite
On Apr 19, 2008, at 5:44 PM,
Jay A. Kreibich wrote:
This is a bit off-topic for the mailing list, so please feel free
D. Richard Hipp wrote:
On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote:
This is a bit off-topic for the mailing list, so please feel free
to send stuff directly to the address below.
It would be good, I think, to have a public record of this
conversation. We can create an
I think one of the most lacking aspects of the documentation are
examples. Perhaps this is better addressed in the proposed tutorial, but
not all the SQL Syntax pages make it clear how to use the statement,
especially the more complex ones like SELECT, and expressions.
The datetime use is also
Taking into consideration a declared close relativity between SQLite and
TCL, I would to suggest an improvement in boolean-type fields treatment.
In my opinion, field of that type should be treated equally, when it does
contain a values: f, false, 0, no - and, respectively: t, true,
1, yes.
You
Taking into consideration a declared close relativity between SQLite and
TCL, I would to suggest an improvement in boolean-type fields treatment.
In my opinion, field of that type should be treated equally, when it does
contain a values: f, false, 0, no - and, respectively: t, true,
1, yes.
On Thu, Mar 13, 2008 at 05:59:54PM +, Brad Stiles wrote:
Taking into consideration a declared close relativity between SQLite and
TCL, I would to suggest an improvement in boolean-type fields treatment.
In my opinion, field of that type should be treated equally, when it does
contain
I tried to install newest sqlite3 on OpenBSD 4.2 - unfortunately, when using
sqlite3 module for TCL, immediately after exiting tclsh, there's always
core dump occurence. It seems, that sqlite needs some patching by OpenBSD
port maintainers. But it wasn't a big problem, there is binary package
Hello Scott,
I have several clarifications with respect to full text search. I'm a newbie in
open source development, so please bear with me if some of the questions are
irrelevant/obvious/nonsense.
I was given to understand that the potter stemming algorithm implemented in
fts2 is not robust
N-gram is a sequense of N Letters of a word or set of words...
http://en.wikipedia.org/wiki/N-gram
On 29/08/2007, Uma Krishnan [EMAIL PROTECTED] wrote:
Hello Scott,
I have several clarifications with respect to full text search. I'm a
newbie in open source development, so please bear with
On 8/24/07, Scott Hess [EMAIL PROTECTED] wrote:
My current focus for the next generation is international support
(this is more of a Google Gears project, but with focus on SQLite so
there is likely to be stuff checked in on the SQLite side), and more
scalable/manageable indexing.
Thanks for
A primary constraint of the porter algorithm in fts is that it's
completely unencumbered open-source. That may-or-may-not make it a
great stemmer, of course :-). One of the reasons it's in there in the
first place is as an example of an alternative to the very basic
simple fts tokenizer. One of
What was fts3 will now be fts4. fts3 will now be
fts2-with-rowid-fixed. fts3 is already in the tree, but with an
#error at the top to force people to not use it without reading a
comment. I was planning to turn that off this week (what with the
SQLite 3.5 stuff going on, might as well!).
The
Hmm, and a clarification on the n-gram case ... there are no current
plans to implement any n-gram capabilities in fts. This kind of thing
has been discussed, but since it still seems like a nice-to-have type
thing and not a must-have type thing, no time is being spent on it. I
have somewhat of
On 8/29/07, Scott Hess [EMAIL PROTECTED] wrote:
What was fts3 will now be fts4. fts3 will now be
fts2-with-rowid-fixed. fts3 is already in the tree, but with an
#error at the top to force people to not use it without reading a
comment. I was planning to turn that off this week (what with
Would it not be more useful to first implement potter stemmer algorithm, and
then to implement n-gram (as I understand n-gram is for cross column fuzzy
search?). What is the general game plan for FTS3 with regard to fuzzy search?
Thanks in advance
Cesar D. Rodas [EMAIL PROTECTED] wrote:
Porter stemmer is already in there. The main issue with Porter is
that it's English only.
There is no general game-plan for fuzzy search at this time, though if
someone wants to step into the breech, go for it! Even a prototype
which demonstrates the concepts and problems but isn't
On 8/20/07, Cesar D. Rodas [EMAIL PROTECTED] wrote:
As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
words right? It could not be
And also no FT extension to db ( as far I know) is miss spell tolerant,
Yes, fts is matching exactly. There is some primitive support
On 23/08/07, Scott Hess [EMAIL PROTECTED] wrote:
On 8/20/07, Cesar D. Rodas [EMAIL PROTECTED] wrote:
As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
words right? It could not be
And also no FT extension to db ( as far I know) is miss spell tolerant,
Yes, fts
It's all interesting, but categorization is hard. Not so hard to get
some results, sort of hard to get quality results. Might work as a
nice adjunct to fts, so that you can throw the search terms into the
categorization engine and put up suggestions for re-running the search
with a tighter
Could fts3 (the next fts) have the option to override the default
'match' function with one passed in (similar to the tokenizer)?
The reason I ask is then the fts table could be used as smart index
when the tokenizer is
something like bigram, trigram, etc. and the 'match' function computes
I
On 23/08/07, Russell Leighton [EMAIL PROTECTED] wrote:
Could fts3 (the next fts) have the option to override the default
'match' function with one passed in (similar to the tokenizer)?
The reason I ask is then the fts table could be used as smart index
when the tokenizer is
something
Hello SQLite community
This is suggestion for the core team suggestion.
As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
words right? It could not be
And also no FT extension to db ( as far I know) is miss spell tolerant, And
I've found this Paper that talks about
Doskey was the history TSR.
On Wed, 9 May 2007, Rich Shepard wrote:
On Wed, 9 May 2007, John Stanton wrote:
That program does have the capability, but may not be implemented that way
on Windows. Why not make the change yourself?
A.J.Millan wrote:
As a suggestion, and even in the
Works for me straight out of the box on Windows XP.
That program does have the capability, but may not be implemented that way
on Windows. Why not make the change yourself?
A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's patience.
Would
it be possible to
As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would
it be possible to include in the command-line program (sqlite3.exe) the
ability to edit, an repeat at least the five or six last commands, as in
Linux?. Is to say with up-arrow and down-arrow. I believe it would be too
On 9-mei-2007, at 11:06, A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's
patience. Would
it be possible to include in the command-line program (sqlite3.exe)
the
ability to edit, an repeat at least the five or six last commands,
as in
Linux?. Is to say with
In old versions it work... But in new versions (3.* I think) its not
working!
On Wed, 2007-05-09 at 12:11 +0200, Peter van Dijk wrote:
On 9-mei-2007, at 11:06, A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's
patience. Would
it be possible to include in the
ZATOR Systems
- Original Message -
From: Peter van Dijk [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, May 09, 2007 12:11 PM
Subject: Re: [sqlite] A suggestion
On 9-mei-2007, at 11:06, A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's
That program does have the capability, but may not be implemented that
way on Windows. Why not make the change yourself?
A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would
it be possible to include in the command-line program (sqlite3.exe) the
On Wed, 9 May 2007, John Stanton wrote:
That program does have the capability, but may not be implemented that way on
Windows. Why not make the change yourself?
A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would
it be possible to include in the
Rich Shepard wrote:
On Wed, 9 May 2007, John Stanton wrote:
That program does have the capability, but may not be implemented that
way on Windows. Why not make the change yourself?
A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's patience.
Would
it be
Full UTF-16 support functions are present, except SQLite_Exec16. As I havely
using UTF-16 and scripts (UPDATE and INSERT), I created such addon to
SQLiteAPI as Delphi function). However, it may be worted to be natively
supported from SQLiteAPI, instead to be simulated.
Sasa
--
www.szutils.net
]
Sent: Tuesday, September 27, 2005 10:05 AM
To: sqlite-users
Subject: [sqlite] any suggestion for the database file extension?mine is xxx.drh
sqlite-users,您好!
致
礼!
Huanghongdong
[EMAIL PROTECTED]
2005-09-27
Hi,
several tools use .db3 (for sqlite3 - Format)
Martin
Huanghongdong schrieb:
sqlite-users,您好!
致
礼!
Huanghongdong
[EMAIL PROTECTED]
2005-09-27
I recommend not using SDB (on windows machines)
SQLite DataBase sounded like a good name too :)
That is the default extension for something called Appfix Package
and in certain circumstances, Windows will automatically back the DB
up every time it is changed thinking that a DLL or Application
Hi, for me to be able to use SQLite3 with C++ sources that use -ansi
-pedantic with GCC I need following tiny patch:
--- sqlite/sqlite3.h
+++ sqlite/sqlite3.h
@@ -81,9 +81,12 @@
#if defined(_MSC_VER) || defined(__BORLANDC__)
typedef __int64 sqlite_int64;
typedef unsigned __int64
On Sat, 2005-04-30 at 13:51 +0200, Vclav Haisman wrote:
Hi, for me to be able to use SQLite3 with C++ sources that use -ansi
-pedantic with GCC I need following tiny patch:
Wouldn't it be easier to *not* compile with -ansi -pedantic?
--
D. Richard Hipp [EMAIL PROTECTED]
Easier for whom?
I want my C++ code to be as close to standard as possible and -ansi
-pedantic helps me a lot. I do not see any reason why should SQLite
force me not to use those switches when there is easy way to fix the
problem.
VH
On Sat, 2005-04-30 at 13:51 +0200, VÃclav Haisman wrote:
75 matches
Mail list logo