Re: [sqlite] Feature suggestion / requesst

May I ask whether this suggestion has been considered being added to SQlite? - Original Message - From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Sent: Friday, June 8, 2018, 08:25:25 Subject: [sqlite] Feature suggestion / requesst Hick Gunter wrote: >> I've encou

Re: [sqlite] Feature suggestion / requesst

On Fri, Jun 8, 2018 at 5:25 AM Rowan Worth wrote: > On 3 June 2018 at 07:28, Scott Robison wrote: > > > I've encountered a feature that I think would be awesome: > > https://www.postgresql.org/docs/9.3/static/dml-returning.html > > > > Example: INSERT INTO blah (this, that, another) VALUES (x,

Re: [sqlite] Feature suggestion / requesst

Hick Gunter wrote: >> I've encountered a feature that I think would be awesome: >> https://www.postgresql.org/docs/9.3/static/dml-returning.html >> >> Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) RETURNING >> id; > > What does this do if the INSERT creates multiple rows? It

Re: [sqlite] Feature suggestion / requesst

On Thu, Jun 7, 2018, 9:25 PM Rowan Worth wrote: > On 3 June 2018 at 07:28, Scott Robison wrote: > > > I've encountered a feature that I think would be awesome: > > https://www.postgresql.org/docs/9.3/static/dml-returning.html > > > > Example: INSERT INTO blah (this, that, another) VALUES (x, y,

Re: [sqlite] Feature suggestion / requesst

Agreed. Would be good. On Fri, Jun 8, 2018 at 1:25 PM, Rowan Worth wrote: > On 3 June 2018 at 07:28, Scott Robison wrote: > > > I've encountered a feature that I think would be awesome: > > https://www.postgresql.org/docs/9.3/static/dml-returning.html > > > > Example: INSERT INTO blah (this,

Re: [sqlite] Feature suggestion / requesst

On 3 June 2018 at 07:28, Scott Robison wrote: > I've encountered a feature that I think would be awesome: > https://www.postgresql.org/docs/9.3/static/dml-returning.html > > Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) RETURNING > id; > > my thoughts are just that this

[sqlite] Feature suggestion / requesst

Background: I never finished a degree back in the dark ages, but recently was provided an opportunity to earn a degree to go along with my experience at a really affordable price. As a result, I'm taking various classes to demonstrate my worthiness. :) Last semester I had a class that used

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

I didn't interpret your statement properly. I thought you were referring to a warning thrown by the library itself, not the SQLite CLI. For the CLI, since its application based, I can see the use. If it were to state the DB version versus the CLI version of the library on load, that'd be cool,

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

On 12/30/2016 5:25 PM, Stephen Chrzanowski wrote: IMO, the responsibility of checking database versions should be owned by the application, not the library. The logic that the application can or cannot, should or should not use the database is an application decision. If the library just were

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

On 12/30/16, Bennett Haselton wrote: > My other suggestion was that if you open a database file with a > *newer* version of the library than the one that was used to create it, > you can also warn, "This file was created using SQLite version a.b.c, > but you're

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

IMO, the responsibility of checking database versions should be owned by the application, not the library. The logic that the application can or cannot, should or should not use the database is an application decision. If the library just were to provide what version of SQLite made or last

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

On 12/29/2016 9:20 PM, Richard Hipp wrote: On 12/30/16, Bennett Haselton wrote: Presumably it's not possible for a tool to output a detailed message like "Your file was generated by SQLite library version 3.6.2, but this tool only supports versions up to 3.5.1",

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

For what it's worth the file stores the version number of library that most recently opened the file as part of the 100 byte header (the last four bytes specifically). It's just not in the first 16 byte magic portion. Changing this would immediately cause all previous versions to report

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

It was SQLite 3.3.6 -- I know, more than 10 years old, but it's the latest version that CentOS 5.5 will update to automatically, and I was strongly advised against updating individual components to anything more recent than what "yum update" would do by default. In any case it wasn't worth

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

On 12/30/16, Bennett Haselton wrote: > > Presumably it's not possible for a tool to output a detailed message > like "Your file was generated by SQLite library version 3.6.2, but this > tool only supports versions up to 3.5.1", OK. I have your request to enhance the

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

On 12/29/16, Bennett Haselton wrote: > Yesterday I spent some time trying to solve a SQLite problem that turned > out to be due to using an old version of sqlite3, so that when I tried > to open a database created with a newer SQLite library, it would output > "Error:

[sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

Yesterday I spent some time trying to solve a SQLite problem that turned out to be due to using an old version of sqlite3, so that when I tried to open a database created with a newer SQLite library, it would output "Error: file is encrypted or is not a database". Later I found out this was

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

On 11/9/16, Luca Ferrari wrote: > Hi all, > this could be trivial, but assuming I need some shell script to query > SQLite3 databases with variable-interpolated queries, what can I do? I typically using "tclsh" for this. https://www.tcl-lang.org/ SQLite is really a TCL

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

On 11/09/2016 02:39 PM, Luca Ferrari wrote: Hi all, this could be trivial, but assuming I need some shell script to query SQLite3 databases with variable-interpolated queries, what can I do? Of course the following does not work because ticks prevent variable interpolation: COUNT=`sqlite3 $db

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

COUNT=$(sqlite3 "$db" "SELECT COUNT(*) FROM foo WHERE baz='$BAZ'") should totally work (I quoted $BAZ as a string, don't do that if it is a number, and you should escape any ' in $BAZ). On Wed, Nov 9, 2016 at 11:40 AM Clemens Ladisch wrote: > Luca Ferrari wrote: > > this

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

Luca Ferrari wrote: > this could be trivial, but assuming I need some shell script to query > SQLite3 databases with variable-interpolated queries, what can I do? > Of course the following does not work because ticks prevent variable > interpolation: > > COUNT=`sqlite3 $db 'SELECT COUNT(*) FROM

[sqlite] [OT] suggestion for shell script and variable interpolation

Hi all, this could be trivial, but assuming I need some shell script to query SQLite3 databases with variable-interpolated queries, what can I do? Of course the following does not work because ticks prevent variable interpolation: COUNT=`sqlite3 $db 'SELECT COUNT(*) FROM foo WHERE baz=$BAZ'` and

[sqlite] Docs suggestion - Attach

qlite.org] On Behalf Of Richard Hipp Sent: Friday, May 15, 2015 3:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Docs suggestion - Attach Change implemented now on the website. On 5/15/15, Jonathan Moules wrote: > Hi, > A relatively simple suggesti

[sqlite] Docs suggestion - Attach

Hi, A relatively simple suggestion for the ATTACH doc page - https://sqlite.org/lang_attach.html - can it include a link to DETACH (https://www.sqlite.org/lang_detach.html)? I ask because if you don't know what the syntax is (the word "DETACH"), it's a pain to find out (in my case I

[sqlite] Docs suggestion - Attach

Change implemented now on the website. On 5/15/15, Jonathan Moules wrote: > Hi, > A relatively simple suggestion for the ATTACH doc page - > https://sqlite.org/lang_attach.html - can it include a link to DETACH > (https://www.sqlite.org/lang_detach.html)? I ask because if you don't

[sqlite] Documentation suggestion

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

Re: [sqlite] Need suggestion for database scheama

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

Re: [sqlite] Need suggestion for database scheama

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

Re: [sqlite] Need suggestion for database scheama

-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

Re: [sqlite] Need suggestion for database scheama

On Thu, 7 Nov 2013 14:50:44 +0400 dd 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

Re: [sqlite] Need suggestion for database scheama

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 wrote: > On Thu, Nov 7, 2013 at 12:15 PM, dd wrote: > >> Thanks for pointing multimedia id, Stephan Beal. I missed it. I

Re: [sqlite] Need suggestion for database scheama

On Thu, Nov 7, 2013 at 12:15 PM, dd 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

Re: [sqlite] Need suggestion for database scheama

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 wrote: > On Thu, Nov 7, 2013 at 11:50 AM, dd wrote: > >> CREATE TABLE if not exists AllFilesTbl (Id INTEGER

Re: [sqlite] Need suggestion for database scheama

On Thu, Nov 7, 2013 at 11:50 AM, dd 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

[sqlite] Need suggestion for database scheama

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

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with 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 : > See > http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl > > 09.02.2011 17:49 пользователь "Fredrik Karlsson"

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

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);} >> db eval {select * from a

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

See http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl 09.02.2011 17:49 пользователь "Fredrik Karlsson" написал: > 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 >

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

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

[sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

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

Re: [sqlite] Query suggestion?

-users- > boun...@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

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 > 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. >

Re: [sqlite] Query suggestion?

; From: sqlite-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: > >

Re: [sqlite] Query suggestion?

Doug 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

[sqlite] Query suggestion?

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

[sqlite] Feature suggestion - default busy handler

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

Re: [sqlite] Simple Suggestion

Behalf Of ivo welch 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 in

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 be happy to have something that works across the board. why not have all of them? I hope my logarithm and

Re: [sqlite] Memory suggestion for DRH

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

Re: [sqlite] Memory suggestion for DRH

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

[sqlite] Memory suggestion for DRH

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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. > >

Re: [sqlite] a suggestion to write tutorial for sqlite

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]

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

lto:[EMAIL 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

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 > 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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] a suggestion to write tutorial for sqlite

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

Re: [sqlite] Improvment suggestion for "BOOLEAN"-type fields

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 > >

Re: [sqlite] Improvment suggestion for "BOOLEAN"-type fields

> 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",

[sqlite] Improvment suggestion for "BOOLEAN"-type fields

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,

[sqlite] "Parameter suggestion" for Makefile...

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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.

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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]>

Re: [sqlite] FTS2 suggestion

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 >

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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

Re: [sqlite] FTS2 suggestion

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, >

Re: [sqlite] FTS2 suggestion

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

[sqlite] FTS2 suggestion

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

Re: [sqlite] A suggestion

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

Re: [sqlite] A suggestion

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

Re: [sqlite] A suggestion

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

Re: [sqlite] A suggestion

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

Re: [sqlite] A suggestion

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

Re: [sqlite] A suggestion

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 sugg

Re: [sqlite] A suggestion

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

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 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

[sqlite] A suggestion

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

[sqlite] SQLite_Exec16 - suggestion

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

Re: [sqlite] any suggestion for the database file extension?mine is xxx.drh

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

Re: [sqlite] any suggestion for the database file extension?mine is xxx.drh

Hi, several tools use .db3 (for sqlite3 - Format) Martin Huanghongdong schrieb: >sqlite-users，您好！ > > > >致 >礼！ > > >Huanghongdong >[EMAIL PROTECTED] >　　2005-09-27 > >

RE: [sqlite] any suggestion for the database file extension?mine is xxx.drh

] 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

[sqlite] any suggestion for the database file extension?mine is xxx.drh

sqlite-users，您好！ 致 礼！ Huanghongdong [EMAIL PROTECTED] 　　2005-09-27

Re: [sqlite] Patch suggestion for sqlite3.h

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: > >

Re: [sqlite] Patch suggestion for sqlite3.h

On Sat, 2005-04-30 at 13:51 +0200, VÃclav 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]>

  1   2   >