[sqlite] System.Data.SQLite.Core and Core-Linux version Mismatch [nuget]

2019-12-13 Thread Jonathon Koyle
When trying to install the current stable NuGet of System.Data.SQLite.Core
I get the following error:

Error Unable to resolve dependencies. 'System.Data.SQLite.Core 1.0.112' is
not compatible with 'System.Data.SQLite.Core-Linux 1.0.110 constraint:
System.Data.SQLite.Core (= 1.0.110)'.

As I understand, to develop cross-platform with this NuGet both packages
are needed, is that correct?  It seems that System.Data.SQLite.Core-Linux
1.0.110 and is the latest stable for that package and
System.Data.SQLite.Core 1.0.110  is not available.  It seems that I can
neither update the Linux package nor install a previous version of
SQLite.Core.  What is the suggested path forward?

-- 
Jonathon K.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Many ML emails going to GMail's SPAM

2017-11-21 Thread jonathon
On 11/21/2017 08:20 PM, Keith Medcalf wrote:

> Strict RFC compliance is very simple:

Which explains why virtually every email client on mobile devices is
unable to send email that complies with the relevant RFCs.

Using  RFC-compliance as a spam detection tool is useful, because it
eliminates 100% of the spam out there.
Unfortunately, it also eliminates at least 70% of the legitimate email
out there.


jonathon



signature.asc
Description: OpenPGP digital signature
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Typical suffixes of sqlite database files

2016-10-21 Thread jonathon
On 20/10/2016 23:17, Rolf Ade wrote:

> What suffixes to sqlite database files do you use or see in the wild?

Too many for suffix identification to be a viable option.

One program I use, has 20 different suffixes, for the SQLite databases
that it utilizes. Most of its competitors use between 3 and 5 suffixes
for the SQLite databases that they utilize.

Use the magic number.  Much more reliable, easier to maintain, and less
chance of a false positive.

jonathon

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Whish List for 2015

2014-12-21 Thread jonathon



On 21/12/14 09:47, big stone wrote:


that I hope may help end-user/students popularity [2]
[2] http://db-engines.com/en/ranking_trend


The methodology used by that site is tilted in favour of big data, and
complex databases. Consequently, even if there are ten million SQLite
databases for every non-SQLite database, SQLite won't rank very high.

SQLite shines something that is created for a one time use, and then can
be deleted, because it is no longer needed. Which is not to say that
SQLite is not a good database engine. But for quick and dirty and work,
SQLite is more suitable than Oracle, MySQL, Microsoft SQL Server, or
PostgreSQL. (Most databases are created for a one time use, where quick
and dirty is the most important criterion. Then, because of their
usefulness, they are re-used, and made even more complex, and relied
upon for more things. Until the original database has become "mission
critical", without anybody noticing it. Fortunately for all, SQLite can
scale to that usage, without undue damage.)


sqlite4 is dead because sqlite3 did progress quicker than expected ?



From reading the blogs, etc, SQLite4 is "experimental" and to be used

only when you don't object to losing everything --- OS, database,
applications, hardware --- on your system, and everything that is
networked to it, and all backups made since the dawn of the computer age.

Those same sources imply that things that work, are useful, and _will
not break_ existing setups, will be migrated to SQLite 3.x.

jonathon




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] New kids on block the SQLite Master Suite.

2014-10-29 Thread jonathon


On 29/10/14 19:46, Billy Huynh wrote:

> the SQLite Master Suite.
> It mainly designed to handle a very large database file with lightning fast 
> import and export of data and

Support for Windows Server 2003, which EOLs on Bastille Day 2015, but no
support for Windows Server 2012?

If that really is the case, then you just shot yourself in the foot.
No rational Sysadmin is going to install something on a platform that
they will be migrating away from within a year.  (Admins of legacy
hardware and software won't install any new software, because they won't
be able to fix any resulting issues.)

jonathon





signature.asc
Description: OpenPGP digital signature
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Strategies for protecting sql queries

2011-08-29 Thread Jonathon
Hello,

I am using a sqlite database to store/retrieve sensitive information.
I am currently encrypting the database to secure the actual data, but
I am still concerned about my actual sql statements.  The sql
statements themselves are left in plaintext in memory so if someone
was ambitious enough, they could just attach a debugger to my process
and see the plain strings.

Does sqlite provide any functionality to protect against this?  I know
that some databases have encrypted stored procedures.  Does sqlite
have something similar?

J
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Sqlite and OpenOffice

2010-02-13 Thread jonathon
On Thu, Feb 11, 2010 at 11:11, Phil Hansen - Info  wrote:

> Found that OO base can be used to access Sqlite.
> However the literature is a bit vague.
> I downloaded the .zip file which should be copied to 
> openoffice1.1/user/uno_packages.

Your problem is right there.

The package you downloaded is for OOo 1.x, and you are using OOo 3.x.
That package, and the instructions that go with it, are obsolete.

Install libsqliteodbc in the Ubuntu repository.
(I've forgotten if SQLite also has to be installed.  I automatically
installed both that and SQLite Browser.)

One of the problems with using OOo for SQLite databases, is that the
wizard keeps getting in the way.   :(

Note:  OOo creates everything in Base, then copies the content to the
database that one is actually using.  Likewise, everything is edited
in a Basse database, then copied to the database that is actually
being used.

jonathon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

2009-03-04 Thread Jonathon
Thanks Dan for the reply,

How would I go about creating a sql dump?

As for the ORDER BY clause, I do this:

SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN
tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id =
d.id AND c.e_id = e.id ORDER BY a.some_other_value ASC;

Although a.some_other_value is not displayed in the tableA below, I forgot
to add it.  So, I add the ORDER BY clause on a.some_other_value and it
returns a ton of records (mostly duplicates).  I am pretty sure this is a
bug because if I wrap this query inside of a subquery and perform the ORDER
BY on the subquery, everything works.

This is what WORKS:

SELECT * FROM (
SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN
tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id =
d.id AND c.e_id = e.id ) ORDER BY a.some_other_value ASC;

So for now, I am just leaving my original query inside the subquery to fix
it.  However, I wouldn't mind posting some debugging information if it will
help fix the bug.

Thanks,
J


On Tue, Mar 3, 2009 at 8:23 PM, Dan  wrote:

>
> On Mar 4, 2009, at 4:41 AM, Jonathon wrote:
>
> > Hello,
> >
> > I am executing a query such as:
>
> Can you post a database (or sql dump thereof) to run your queries
> against? Also say exactly what ORDER BY clause you are adding to
> the end of the query that causes it to return incorrect results?
>
> Thanks,
> Dan.
>
>
>
> >   1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c
> > INNER
> >   JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id
> > AND
> >   a.d_id = d.id AND c.e_id = e.id;
> >   2.
> >   3. CREATE TABLE tableA (
> >   4. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
> >   5. b_idINTEGER NOT NULL,
> >   6. c_idINTEGER NOT NULL,
> >   7. d_idINTEGER NOT NULL
> >   8. )
> >   9.
> >   10. CREATE TABLE tableB (
> >   11. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
> >   12. );
> >   13.
> >   14. CREATE TABLE tableC (
> >   15. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
> >   16. e_idINTEGER NOT NULL
> >   17. );
> >   18.
> >   19. CREATE TABLE tableD (
> >   20. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
> >   21. );
> >   22.
> >   23. CREATE TABLE tableE (
> >   24. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
> >   25. );
> >
> >
> > This seems to be returning the correct records.   However, when I
> > append an
> > ORDER BY at the end of the query, it seems to be changing the number
> > of
> > records that are returned back to me.  From my understanding, an
> > ORDER BY
> > can not change the number of records correct?  If I do not use the
> > ORDER BY,
> > I get around 150 records.   If I do an ORDER BY on any column that
> > is not in
> > tableA, the number of records blows up (~4k) and there are duplicates.
> >
> > Any ideas?
> >
> > I thought that it was because of a buggy parser, so I wrote the
> > query again
> > as:
> >
> >
> >   1. SELECT * FROM tableA a
> >   2. INNER JOIN tableB b
> >   3. ON a.b_id = b.id
> >   4. INNER JOIN tableD d
> >   5. ON a.d_id = d.id
> >   6. INNER JOIN tableC c
> >   7. LEFT JOIN tableE e ON c.e_id = e.id
> >   8. ON ON a.c_id = c.id
> >
> > and it still gave me the same results...
> >
> > Thanks,
> > J
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

2009-03-03 Thread Jonathon
Hello,

I am executing a query such as:


   1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER
   JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND
   a.d_id = d.id AND c.e_id = e.id;
   2.
   3. CREATE TABLE tableA (
   4. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   5. b_idINTEGER NOT NULL,
   6. c_idINTEGER NOT NULL,
   7. d_idINTEGER NOT NULL
   8. )
   9.
   10. CREATE TABLE tableB (
   11. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
   12. );
   13.
   14. CREATE TABLE tableC (
   15. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   16. e_idINTEGER NOT NULL
   17. );
   18.
   19. CREATE TABLE tableD (
   20. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
   21. );
   22.
   23. CREATE TABLE tableE (
   24. id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
   25. );


This seems to be returning the correct records.   However, when I append an
ORDER BY at the end of the query, it seems to be changing the number of
records that are returned back to me.  From my understanding, an ORDER BY
can not change the number of records correct?  If I do not use the ORDER BY,
I get around 150 records.   If I do an ORDER BY on any column that is not in
tableA, the number of records blows up (~4k) and there are duplicates.

Any ideas?

I thought that it was because of a buggy parser, so I wrote the query again
as:


   1. SELECT * FROM tableA a
   2. INNER JOIN tableB b
   3. ON a.b_id = b.id
   4. INNER JOIN tableD d
   5. ON a.d_id = d.id
   6. INNER JOIN tableC c
   7. LEFT JOIN tableE e ON c.e_id = e.id
   8. ON ON a.c_id = c.id

and it still gave me the same results...

Thanks,
J
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Odd very SLOW query in SQLITE - Optimizer is not working!?

2009-02-27 Thread Jonathon
Hello All,

I have a simple query that seems to be going very very very slow.   I am not
sure why sqlite is behaving this way, which is why I decided to burden you
guys with my question.  My guess is that the query optimizer might not be
able to decipher what exactly I want to do, and thus computes some
inefficient query.

Here is my query:

SELECT * FROM tableR r
INNER JOIN tableU u ON u.id = r.u_id
LEFT JOIN tableP p ON u.p_id = p.id
ORDER BY p.p_name;

CREATE TABLE tableR (
   id   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   u_id   INTEGER NOT NULL
);

CREATE TABLE tableU (
   id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   p_id  INTEGER NOT NULL
);

CREATE TABLE tableP (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
p_name INTEGER NOT NULL
);

CREATE INDEX p_name_index ON tableP (p_name);
CREATE INDEX p_id_index ON tableU (p_id);
CREATE INDEX u_id_index ON tableR (u_id);

tableR has about 5 million records.
tableU has 100k records.
table P has 1k records.

It's very weird.  If I change the last join to an INNER JOIN, everything
works great.  Any information on how I could improve this query would
greatly help.   I know it can't be THIS slow..

Thanks,
J
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Exporting database to CSV file

2009-01-07 Thread Jonathon
Thanks for the replies... Actually, it seems my requirements have changed..

Is there a way to do this entirely through php?  I would like to make a
query on a table and write the results to a csv file so that the user can
have the option of downloading it.  Has anyone ever done something similar
to this?

Thanks

J

On Tue, Jan 6, 2009 at 8:02 AM, Alexey Pechnikov wrote:

> Hello!
>
> В сообщении от Tuesday 06 January 2009 15:33:42 Sylvain Pointeau
> написал(а):
> > The import has the big limitation to not be able to import the file when
> a
> > field is on multiple lines.I don't know if this is the same for the
> > export...
>
> See virtualtext extension from spatialite project.
>
> Best regards, Alexey.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Exporting database to CSV file

2009-01-05 Thread Jonathon
Awesome.  Thanks for the quick reply Deech :)

J

On Mon, Jan 5, 2009 at 2:34 PM, aditya siram  wrote:

> Open the sqlite database using:
> > sqlite3 database.sqlite
> >> .mode csv
> >> .output yourfilename
> >> your-sql -query
>
> -deech
>
> On Mon, Jan 5, 2009 at 4:21 PM, Jonathon  wrote:
>
> > Hello all,
> >
> > I am interested in exporting a particular table to a CSV file.  I've
> > browsed
> > google for a bit, but all I could find is third party programs.  I was
> > hoping this functionality was provided in sqlite and that it was super
> > duper
> > fast :)
> >
> > Thanks!
> >
> > J
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Exporting database to CSV file

2009-01-05 Thread Jonathon
Hello all,

I am interested in exporting a particular table to a CSV file.  I've browsed
google for a bit, but all I could find is third party programs.  I was
hoping this functionality was provided in sqlite and that it was super duper
fast :)

Thanks!

J
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Creating Histogram fast and efficiently :)

2008-12-31 Thread Jonathon
Thanks Russell :)

It works great.

J

On Wed, Dec 31, 2008 at 5:52 AM, Russell Leighton  wrote:

>
> create table numbers (val integer);
>
> insert into numbers values (1);
> insert into numbers values (5);
> 
>
> sqlite> select * from numbers order by val;
> 1
> 5
> 10
> 12
> 12
> 15
> 20
> 20
> 20
>
>
>
> select case when val < 10 then 1 when val >=10 and val < 20 then 2
> else 3 end  as bin,
>count(1) as c
> from numbers  group by bin;
>
>
> sqlite> select case when val < 10 then 1 when val >=10 and val < 20
> then 2 else 3 end  as bin,
>...>    count(1) as c
>...> from numbers  group by bin;
> 1|2
> 2|4
> 3|3
>
>
> On Dec 31, 2008, at 6:16 AM, Jonathon wrote:
>
> > Hello all,
> >
> > I have a column of numbers in a table, and I was wondering if it is
> > possible
> > to create a histogram out of it fast and efficiently?
> >
> > For example, assuming the data in the column is:  1, 5, 10, 12, 12,
> > 15, 20,
> > 20, 20.. I would like to return:
> >
> > 'less than 10' --> 2
> > 'less than 20 and greater than or equal to 10' --> 4
> > 'great than or equal to 20' --> 3
> >
> > I hope that makes sense.  I checked all over Google, and it seems that
> > different databases seem to tackle this problem differently.  So.. I
> > was
> > just curious how sqlite can help me make this calculation fast :)
> >
> > Thanks,
> > J
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Creating Histogram fast and efficiently :)

2008-12-31 Thread Jonathon
Hello all,

I have a column of numbers in a table, and I was wondering if it is possible
to create a histogram out of it fast and efficiently?

For example, assuming the data in the column is:  1, 5, 10, 12, 12, 15, 20,
20, 20.. I would like to return:

'less than 10' --> 2
'less than 20 and greater than or equal to 10' --> 4
'great than or equal to 20' --> 3

I hope that makes sense.  I checked all over Google, and it seems that
different databases seem to tackle this problem differently.  So.. I was
just curious how sqlite can help me make this calculation fast :)

Thanks,
J
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Convert integer IP address to string IP address in Sqlite

2008-10-31 Thread Jonathon
Hello all,

I was just curious if there is a way to convert an integer representation of
an IP address that I store in my DB, to it's string equivalent
(xxx.xxx.xxx.xxx)?  I would also need to convert it to host-byte order as
well.

Thanks,
J
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Seeking documentation on writing own Tokenizer

2008-10-15 Thread Jonathon
Hello all,

I am interested in writing my own tokenizer for sqlite3.  I've gone through
Google, as well as the sqlite documentation and unfortunately, I haven't
found anything helpful.  I am interested in writing my own tokenizer so that
I could perform "partial string" matches in sqlite's full-text search
(FTS3).  For example, I would like to find the word 'some' in the string:
'/path/to/some/file'.

Can someone point me in the right direction on what I would need to do to
implement my own Tokenizer?

Thanks,
Jon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Quick FTS3 question: partial matches

2008-10-10 Thread Jonathon
So while trying to find a solution to my problem of finding partial strings
in several columns ( finding 'this' in 'HellothisIsATest' using MATCH
'*this*' ), I found out that sqlite fts3 only supports prefix matching and
that if I want to do partial string matching, I would be forced to use LIKE,
or create my own tokenizer in order to index my terms the way I want.  I
wouldn't mind sacraficing size for performance since I do not have a size
constraint for my project.

My question is, has anyone already written a tokenizer that would do what I
want?  It seems as if this problem should have already been solved for me,
and I really don't want to reinvent the wheel if it already has been done :)

Thanks,
Jon


On Thu, Oct 9, 2008 at 9:51 PM, Jonathon <[EMAIL PROTECTED]> wrote:

> Thanks for the reply.   I was just curious if anyone has found a viable
> workaround for this issue?  Using the dreaded "Like" is a bit too slow for
> what I need.
>
> Jon
>
>
> On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]>wrote:
>
>> > I would like to look up partial strings across several columns using
>> FTS3
>> > and MATCH.   For example, if I have a column that has data,
>> > 'helloThisIsATest'... and I do:
>> >
>> > select * from myTable where myTable match '*This*';
>>
>> You can only use wildcards as a suffix - this is due to the nature of
>> the indexes fts3 uses.
>>
>> I don't know of a possible workaround for this while still using fts3.
>> I'd say that for this kind of request, you are condemned to use '...
>> like "%This%".
>>
>> Alex.
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Quick FTS3 question: partial matches

2008-10-09 Thread Jonathon
Thanks for the reply.   I was just curious if anyone has found a viable
workaround for this issue?  Using the dreaded "Like" is a bit too slow for
what I need.

Jon

On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote:

> > I would like to look up partial strings across several columns using FTS3
> > and MATCH.   For example, if I have a column that has data,
> > 'helloThisIsATest'... and I do:
> >
> > select * from myTable where myTable match '*This*';
>
> You can only use wildcards as a suffix - this is due to the nature of
> the indexes fts3 uses.
>
> I don't know of a possible workaround for this while still using fts3.
> I'd say that for this kind of request, you are condemned to use '...
> like "%This%".
>
> Alex.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Quick FTS3 question: partial matches

2008-10-09 Thread Jonathon
Hello all,

I've looked through the archived mailing list and although I am sure my
question is common, for some reason, I couldn't find an answer.

I would like to look up partial strings across several columns using FTS3
and MATCH.   For example, if I have a column that has data,
'helloThisIsATest'... and I do:

select * from myTable where myTable match '*This*';

I would like to return the row above.  However, I've tried this and it
doesn't seem to work.  It seems that prefix matching works though.  So, if I
do:  select * from myTable where myTable match 'hello*';  that seems to
return the right result.

I am currently using FTS3 in version 3.6.2 and I have all the columns that I
would like to index in the same virtual table.

Thanks,
Jon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] How does SQLite store data?

2007-03-24 Thread Jonathon Blake

John wrote:


A TEXT string is stored at its actual length.  You may declare a text
column as 80 characters wide but you could store a string 32K long in
that column.  The 80 is stored by Sqlite but ignored.


Stupid question.

Does that mean that SQLite:
* truncates the field at 80 characters?
* only returns the first 80 characters in the field?
* stores and returns the entire string?

My impression was that it did that third option. [And that it didn't
care what the data in that field was. It is up to the client program
to verify the data.]

xan

jonathon

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Release / development timeline

2004-11-01 Thread Jonathon Blake
D Richard Hipp wrote:

> How much more announcing do you think we should do?

The timeline page is great, for finding out when things were done.

Changes is great for saying what is in the new versions, and when they
were released

How about a simple page that gives projected release date for upgrades? 

Something like

Version 3.0.9 beta  10 November 
Version 3.0.9 final   20 November
Version 3.0.10 beta 1 December 
Version 3.0.10 final 15 December 

xan

jonathon
-- 
How to have Hittite, Alibata, Orkhon, Ogham, Manchu, Meroïtic, Pahawh
Hmong, Tengwar, Tsalagi, Hangul, Lepcha, and Nushu in the same
document.

http://oooauthors.org/groups/members/tutorials/


[sqlite] Release / development timeline

2004-11-01 Thread Jonathon Blake
All:

I've hunted around on sqlite.org, and the mailing list archives, [and
googled] for a timeline of when the next version9s) of SqLite will be
released.

Does such a critter exist, and if so, where can I find it?

xan

jonathon
-- 
How to have Hittite, Alibata, Orkhon, Ogham, Manchu, Meroïtic, Pahawh
Hmong, Tengwar, Tsalagi, Hangul, Lepcha, and Nushu in the same
document.

http://oooauthors.org/groups/members/tutorials/