ta
in the db, then use the power of the db to morph the data into whatever
views your heart desires.
>
>
> -Original Message-
> From: Steve O'Hara [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 30, 2005 5:28 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Insert all r
SQLite doesn't have a free text search capability - the Like and Glob
functions are not free text just simple pattern matching on the scanned
text. Performance is very poor because there is no suitable index.
It's not a simple task to create free text searching - you have to create an
inverted
?
On 7/6/05, Steve O'Hara <[EMAIL PROTECTED]> wrote:
>
> SQLite doesn't have a free text search capability - the Like and Glob
> functions are not free text just simple pattern matching on the scanned
> text. Performance is very poor because there is no suitable index.
>
>
Is that statement correct Richard?
I assumed that something clever was going on with OR's such that under the
bonnet they got translated into UNION statements or similar.
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of Dan Kennedy
Sent: 11 July
I think the point about multi-threaded apps is not that there might be a few
instances where they are useful, but how easy is it to debug and support
them and is it worth the price for a little more concurrency?
In my experience, most debugging IDE's can't handle multiple threads and
actually
Don't want to dampen your enthusiasm for this route but. why do you
think there are so many VB wrappers for SQLite?
It's because you can't use the SQLite DLL directly from VB - some functions
will work but the essential ones won't. It's because the DLL returns things
like pointers to arrays
the 3.0
anyone known 3.0 wrapper ?
Steve O'Hara a écrit :
>Don't want to dampen your enthusiasm for this route but. why do you
>think there are so many VB wrappers for SQLite?
>
>It's because you can't use the SQLite DLL directly from VB - some functions
>will work but the
Borror
Gregory Letellier <[EMAIL PROTECTED]> wrote:
all the wrapper ar for 2.8 and i wan't use the 3.0
anyone known 3.0 wrapper ?
Steve O'Hara a écrit :
>Don't want to dampen your enthusiasm for this route but. why do you
>think there are so many VB wrappers for SQLite?
>
>It's
Check out the WIKI, there's a myriad of possibilities.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of Scott Chapman
Sent: 11 August 2005 18:43
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite with visual basic?
I am having a look at Visual
Why don't you create and a very small version of the database, create the
indices and use the EXPLAIN command to see what it does for your queries.
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of John Sample
Sent: 12 August 2005 16:18
To:
Richard,
Not everything in life is free or immediate.
If you're going to do some decent SQL you need to invest in a reference
manual - my favourite SQL primer is "The Practical SQL Handbook" from
Addison-Wesley Publishing ISBN 0-201-62623-3
My edition is acient but well worth the 20
Here's a way to go with pure SQL;
create table cars (recid,qty,make,model,year,engine,color,state,price);
create table states (abbr,name);
insert into states values("ca","California");
insert into cars values(1,5,"Ford","Bandit",2005,2000,"Red","ca",5000);
select make,(select name from states
Your speed comparison is deeply flawed...
Your select statement is non-sensical (it returns 2 columns, A and
'32.0883' with 9,337,681 records and you haven't told us if you're using
PRAGMA synchronous = OFF;?
Assuming you do a proper search like "select * from T where
A='32.0883';" you
Hey, why not use the SQLite based spellchecker at
http://www.pivotal-solutions.co.uk/spellcheck/
I know it says it's for sale but we're going to start giving it away in
the next few weeks.
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of
I have used SQLite in a whole bundle of applications and I love it.
However, I've got an app that's being written in Java - I've got a JNI
library (Solaris & Windows) for SQLite, but I really want something
platform independent.
I've been worn down by my quest for a comparable product to SQLite
ert SQLite to Java
On Mon, Oct 24, 2005 at 09:58:53PM +0100, Steve O'Hara wrote:
> I've been worn down by my quest for a comparable product to SQLite
> written in pure Java and have come to the conclusion that it doesn't
> exit. I've looked at Derby, QED, Axion, blah blah and I'm not
Fred,
They are not nit-picking and they "are" actually contributing to the
robustness of the application by doing this research. Your
anti-Microsoft bigotry does no service to this list at all and is
neither a "contribution" or an offer of help.
I for one would be keen to see these warnings
Just a word of advice, make your binding to SQLite dynamic - it's more
code but ultimately you won't have to keep releasing new versions of
your driver everytime SQLite changes.
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of gnorman22
Sent: 31
There is a package in the SqliteWrappers WIKI to download that does all
this -
http://www.pivotal-solutions.co.uk/downloads/company/pssqlite.zip
It's a nice VC6 DLL wrapper for VB6 & Java with source code.
Dynamically binds to the sqlite.dll and sqlite3.dll at runtime so you
don't need to
Jay, If you're going to offer advice, at least do some basic research to
make sure it's accurate.
Firstly, having a column that has a random number in it and sorting by
it produces the same output each time you query on it - obviously
unsatisfactory and I would have thought, manor from heaven for
I did loads of research on this and even tinkered with a c to Java
converter, which got me a little bit further forward. However, I
realised that I would be facing a huge effort to create the code base
and then have to support it within our projects. So despite being an
SQLite zealot, I had to
d on a web page.
With all of our advances in programming we still have not evolved that
"perfect" language, and most likely never will. I spite of what those
"C" guys tell you :-)
Fred
> -----Original Message-
> From: Steve O'Hara [mailto:[EMAIL PROTECTED]
> S
Hi Ralf,
SqliteSpy is a nice tool but this is a weakness, not a strength - we
used to call this sort of thing "built-in obsolescence". Woudn't it be
better for you if you didn't have to track changes made by Richard to
the engine?
This is also a problem with quite a few of the wrappers that
Hi Teg,
Presumably you have a transaction in place around the whole of your
inserts and that you have the PRAGMA synchronous = OFF; set.
Have you looked at perhaps not creating the database on the server, but
merely creating the INSERT statements in one big file that you compress
and send down
In most cases (but not all - C++,Delphi) yes. A wrapper is a lump of C code
that bridges the SQLite environment with your own specific language.
I just did a bit of research for you and found that Frontier uses a scripting
language called UserTalk to allow users to interact with it. It also
This is the right approach, when I worked in the SGML world with a
component versioning system, we called it the "non-linear" design.
By going down this road, your table schema is static and can cope with
any type of DTD without change. However, you need to create a tool that
will convert your
Hi All,
I suppose this has to be the most boring topic that I've seen on SQLite
listservers for the past 2 years. However, since the switch away from
Yahoo, it has revealed how much I relied on the communication features of
the listserver.
The new listserver is making it very difficult for me
Why should case sensitive data comparisons be maintained ?
It seems to me that it's only in the most obtuse examples where it is of any
use e.g. algebra, formulae, equations etc. Even then, how many people will
search for a formula ?
However, I would agree, that there is an absolute need to
Use the SQLite ODBC driver and away you go. I think I saw that someone has
developed an OLEDB driver for SQLite which you could also use.
Or, if you want to get a bit closer to Crystal, write your own Crystal
Datasource Driver in VB/C++
Steve
-Original Message-
From: Jeff Edwards
Easiest way is to include the sqlite.lib file in your library path.
Steve
-Original Message-
From: Sören Krings [mailto:[EMAIL PROTECTED]
Sent: 17 December 2003 11:29
To: [EMAIL PROTECTED]
Subject: [sqlite] How to compile a standalone wrapper?!
Hello,
i´m new to SQLite, so to learn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 27 December 2003 16:19
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] Sqlite & COM/EXE server
> Hi,
>
> I've used SQLite in a variety of COM situations without problems.
>
> What is your application environment
> -Original Message-
> From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
> Sent: 29 December 2003 23:41
> To: Yogesh Vachhani
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Subject: Re: [sqlite] Let us make SQLite more
> powerful
>
>
> On Sat, 2003-12-27 at 07:16, Yogesh Vachhani wrote:
> > >
> -Original Message-
> From: David Morel [mailto:[EMAIL PROTECTED]
> Sent: 16 January 2004 17:32
> To: Brad Campbell
> Cc: George Ionescu; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Full text search implementation
>
>
> > My regex patch should do that
> >
> > SELECT * FROM Categories
> -Original Message-
> From: Bertrand Mansion [mailto:[EMAIL PROTECTED]
> Sent: 16 January 2004 19:18
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Full text search implementation
>
>
> <[EMAIL PROTECTED]> wrote :
>
> >
> >
> >> -Original Message-
> >> From:
Wouldn't this be due to SQLite storing everything as strings?
If your database is predominantly numbers then I imagine the differences
between Access and SQLite could be huge.
Steve
-Original Message-
From: Roy Black [mailto:[EMAIL PROTECTED]
Sent: 08 April 2004 04:38
To: [EMAIL
Ben,
I think you're asking for is a mechanism to define the nature of the primary
key.
e.g. If you could define the primary key as some kind of function or to use
a specific integer field, then the table will be naturally ordered by that
field.
I don't know about other SQL engines, but our baby
What about this;
SELECT * FROM stdcodes WHERE '0018764582' LIKE areacode || '%' order by
areacode desc limit 1;
Steve
-Original Message-
From: Lloyd thomas [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 15:00
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Matching telephone strings
>I
I agree with Greg, the most irksome feature of SQLite is the case
sensititvity - it's one of the few things MS got right with SQLserver. I
know this is more mainstream/standard SQL behaviour but it's outdated in
modern SQL applications that nearly always do some kind of linguistic
searching.
In
I've been watching the discussion about concurrency with interest. I find
I'm impressed by everybody's arguments.
I'd too would like to keep SQLite small and fast but equally, I'd like to
have better concurrency. Even if this is just a safeguard for the future.
However, I'm wondering why we're
oncurrency issues
On May 6, 2004, at 12:24 PM, Steve O'Hara wrote:
> I've been watching the discussion about concurrency with interest. I
> find
> I'm impressed by everybody's arguments.
>
> I'd too would like to keep SQLite small and fast but equally, I'd like
> to
>
per and to simplify again the code, I created
> littles classes which are very simple and look like the DAO
> classes. It permits to transform Simply a VB application
> using DAO to SQLITE
>
> Jérôme
>
> -Message d'origine-
> De : Steve O'Hara [mailto
Hi,
I find I have to agree with the opinion that says keep the ODBC driver
should be external to the SQLite source.
Why? Well, how many other database engines, client/server or otherwise, come
with an ODBC driver embedded with the engine? The answer of course is none.
Plenty of vendors supply
I think you've missed the point...
The VB wrapper allows VB programmers (this includes ASP) to interface
directly to SQLite.
No half way houses, no strange connection of disparate apps, just
straight-forward Windows code.
As you say, if you're talking VB then you're obviously talking
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic
"Steve O'Hara" >> If you can think of improvements, let me know.
I noticed that the output DLL shrank yet again to 45KB :-) What did you do
to make it
it ?
Where should I do my busy checking and recovery logic to prevent this mutual
exclusion?
Steve
-Original Message-
From: Steve O'Hara [mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 01:42
To: [EMAIL PROTECTED]
Subject: [sqlite] Locking in 3.0.6
I'm having difficulty
I'm wondering what logic I should employ to prevent mutual exclusion
occurring.
I'm using SQLite to record an audit trail from a web application - I count
the number of edits, searches and the maximum number of concurrent users.
Each user opens a connection to the database for the duration of
Hi Dave,
Wrap your update and select inside a transaction - the transaction is atomic
in this regard and locks the table after the update and doesn't let it go
until the commit/rollback. Others can read (they get the uncommitted values
of course) but can't update. You will always get the latest
Speaking as a wrapper writer myself (VB Wrapper), I too don't need or make
any use of the column names but I can see where they might be being used by
other wrappers e.g. ODBC/ADO/OLEDB.
It's a convenient way for these guys to pick up field name bindings from
select statements i.e. it saves them
Here's my tuppence worth.
I come from an engineering background where you're taught that rigour is the
most important feature of any development. I find that all the interpreted
environments tend not to be that great in this regard. Also, I don't have
an axe to grind when it comes to
I'd like England to win the World Cup...
Perhaps we can do a swap.
-Original Message-
From: Dinsmore, Jeff [mailto:[EMAIL PROTECTED]
Sent: 08 March 2005 13:58
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] thoughts on a web-based front end to sqlite3 db?
I personally would
There is no "queuing" of requests in SQLite - if a request (thread) is
blocked on a lock then it simply goes to sleep for a period of time and then
retries. It doesn't know how many other threads are doing the same thing,
just that a thread somewhere has control of the database.
Therefore, there
51 matches
Mail list logo