ust examples, i need a generic
solution if possivble.
All i can see so far is to build a table of all special characters ever
used in the 24000 names of cities which make problems and remap them
accordingly.
--
Christophe Leske
www.multimedial.de - i...@multimedial.de
http://www.linked
dy started looking into soundex() yet unfortunately, it does not seem to
be compiled into the normal command like executable. I also doubt that it would
help?
Any help much appreciated,
Christophe Leske
www.multimedial.de - i...@multimedial.de
http://www.linkedin.com/in/multimedial
Lessingstr.
less you put them in there
beforehand as blobs.
But then, maybe I misunderstood?
--
Christophe Leske
www.multimedial.de - i...@multimedial.de
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
+49(0)211- 17 80 48 94 // +49(0)177 249 70 31
***Note our new phone nu
I can provide further information on the 25th.
Thank you for your patience,
--
Christophe Leske
www.multimedial.de - i...@multimedial.de
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
__
uot;
sqlite> .s
sqlite> .s cl1;
sqlite>
We also experience crashes with the new version, but this may be due to the
component we are using (i am not sure it is supporting the new version of
sqlite.dll)
Do you want me to mail you the corrupted database for further inspection? I
also unders
t was supposed to do.
I think this is what I like best about it:
it does the stuff it is supposed to do, no more, but also not less.
--
Christophe Leske
www.multimedial.de - i...@multimedial.de
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 26
sqlite> .s
sqlite> .s cl1;
sqlite>
We also experience crashes with the new version, but this may be due to
the component we are using (i am not sure it is supporting the new
version of sqlite.dll)
Do you want me to mail you the corrupted database for further
inspection? I also underst
ning off my project, but how can I contribute ?
--
Christophe Leske
www.multimedial.de - i...@multimedial.de
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailin
> Think of HAVING as being analogous to WHERE. While WHERE applies to
> the TABLE, HAVING applies to the results of GROUP. Here is a contrive
yes, thank you.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duess
[EMAIL PROTECTED] wrote:
> http://www.w3schools.com/sql/default.asp
>
Thanks! That is great!
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249
Hi,
can someone point me to some docs where the difference between a normal
"where"-clause and the "Group by", and "having" statements are being
explained?
I don´t quite understand what these are actually good for.
Thanks,
--
Christophe Leske
www.multimedi
one of the records to be added are
already in the idlookup table.
It would be my understanding however that the "or ignore" statement
would silently let those inserts fail if they are already in?
What´s wrong here?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http:/
23 and lama<53.23);
>
Thanks, but sometimes it says "constraint failed"?
What does this mean?
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
and lami>53.23 and lama<53.23) and id
not in (select id from idlookup)
)
?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
omit the ID field.
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
x27;t
> do that.
>
Any chance to spare the ID field and get an index on the rowid for a given
table?
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261
Hi,
i am creating my table as such:
create temp table idlookup as select id from ...
I would like ID to be unique in my idlookup table. How would I do this
using this construct?
Or is it impossible?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in
ing, yet to a target "system" which
is at my client´s site through educated guesses in the code.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
> Any chance that you could hint at the subject matter of the questions
> in the Subject line ? In this case it would appear to be Performance ...
> Helps to get your questions answered !
> ;-)
>
Yes, will do so. My apologies.
Christophe Leske
www.multimedial.de - [EMAIL
r toilet. Once everything is working, then work slowly
> and carefully to make things faster better cheaper.
>
It IS doing what I want. However, it does not run on lower-spec machines, which
is why i am trying to optimize anything available.
Christophe Leske
www.multimedial.de - [EMAIL PRO
ed amongst
tables in such a way that the data is there only once, thus creating a smaller
file?
In the example provided, the iDs are exactly the same, yet they are there
twice...
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 -
> PRAGMA omit_readlock=ON;
>
Hm, should be documented, no?
I could use that as well...
Just wondering if this has any speed advantages?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211
e table).
This is all fine for that case, but if the new result set has LESS
results than the previous one, then I end up with a temporary table
holding the new result set and leftovers from the previous one...
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/m
uilding it. Am I being clear?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqlite-users@sqlit
that table. Are indices also
used for sorting results, or do they do just apply for searching?
Thanks in advance,
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
the big cities (c2) and the not so big cities (c3) and so forth.
Since it is depending on the distance from the ground and the rtree table only
works with coordinates, i cannot really include the class-attribute into the
rtree, hence several rtrees.
--
Christophe Leske
www.
ately
> and then UNION them together, but you have to apply the WHERE
> constraint only once because all the tables are identical.
>
Do you mind elaborating on this point? Is that what Igor wrote me?
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/
ave to build several statements which all have the where clause
in there.
Isn´t there something more tersed?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70
elements when needed.
Thanks for any info,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqlite
ory database with only 3 fields? (string, and two ints?)
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users
Hi,
is there a way to get the size of a :memory: db in the sqlite3.exe
command line interpreter?
Or any other way?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
> How many memory has your embedded project? You can create a new
> in-memory database and copy there your database data.
>
That´s what i am currently doing, but we are using too much memory this
way, we are out of specs.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTEC
> Speedup tip:
> http://article.gmane.org/gmane.comp.db.sqlite.general/41990
>
Hello Mike,
first of all, thank you for your tips.
Yes, i saw that posting, and i am already using it in my code.
But thanks again,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTEC
hould have
said that, I am sorry).
CramFS looks pretty promising, is there any extension to sqlite which
could read a DB file from it under Windows?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - German
> How about storing the DB file in a cramfs filesystem
Forgot to say that this is Windows XP, sorry.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70
Hi,
i was wondering if there is any compression/decompression extension for
read-only databases other than Dr Hipps compression extension, which
unfortunately is financially out of scope for my current project.
Thanks,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http
no problem, but it does not satisfy my criteria for a lean
and slim SQlite3 db access (read "command line interpreter") I can use
in my DVD-ROM project.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseld
f the call change all the time?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqlite-user
ers
Nope, just one from DVD.
Thanks again,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqli
nd then set that/those
> columns as INDEXed, that will help ...
>
Have done that. It almost doubles my database, but it is worth it.
How about the cache size? or does this only pertain to databases which
get inserts?
> (Techie note
> http://20bits.com/2008/05/13/interview-quest
performance.
Indices have been set, would augmenting the cache size for Sqlite do
something?
Grateful for any info,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
3.
Ideally, I?d like to get precompiled binaries, but any help on how to
compile the ICU extension in a workable fashion would be much
appreciated as well.
Thanks,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duessel
nterpreter does not correctly handle diacritic
characters, or my sqlite database was wrongly created (it was an
automatic conversion from an Access MDB file thought).
Thanks for any help,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessing
ows XP and ideally looking for a
precompiled version of the DLL.
Thanks,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sq
Hi Petr,
> I'm glad I can announce new stable version of Sqliteman - the GUI for
> developers and admins:
> http://sqliteman.com/
>
I gave it a try, and it seems as if SQLiteman can´t handle extensions
for databases, is this right?
--
Christophe Leske
www.multimedial.de -
countries where sub.iso=countries.iso;
>
Yes, that was it! I was looking for the "as sub" part, i didn´t know how
to name my subquery.
Thanks a bunch,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 -
name: ISO
I mean the ISO from the first selection? This used to work...
Can anyone help?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
> Use actual field names in lookup table for idField, xField and yField.
>
Thank you!
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249
Hi,
can someone remember me how to fill in a rtree table with values from
another table?
Something like
insert into lookup (select id, x,y from othertable) -- this doesnt work btw
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr
ilesize,
like 80Kb.
Smallest i am getting now is about 60Kb, and i can´t figure out what I
did, as this is exactly the same source code, minus the manifest file.
But even by readding it, the resulting dll is always bigger...
--
Christophe Leske
www.multimedial.de - [EMAIL P
> You can improve performance (space/speed) a little by changing the
> RTREE_MAX_DIMENSIONS at the top of rtree.c to match you data set. It
> defaults to 5 dimensions, but you could reduce to this to 2, or 3 with city
> size.
>
> #define RTREE_MAX_DIMENSIONS 5
>
Hi Shane,
thanks for the ans
ass the same).
I am interested in the inner workings of SQlite in order to get it to
know better, not to rant about it...
It is a cool tool I am using in many projects.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Dues
Hi,
i am now using the rtree extension in my project, yet still see some
slowdown for some scenarios (especially for searches in narrow/small
rectangles).
I was therefore wondering if...
- one can somehow index the fields of an rtree table, and if so how?
- if there could be any other informat
I would like to thank all the participatns of this list for the very
useful information i got here the last days.
A big thank you to everyone, including of course Mr Hipp. The rtree
implementation is really quick and does work like a charm.
Best regards,
--
Christophe Leske
new query is slow as hell.. so i
better duplicate the lat/long data then in my city table.
Uh, i am never satisfied! :-)
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 2
.latitude_min>-45.11050
2 and citylookup.latitude_max<44.889498)) and cities.class_dds<2 order
by class_
dds limit 50;
However, this doesn´t give me the city with the longitude and latitude
for its position (which i need to position a label).
--
Christophe Lesk
Hi,
every SQlite file that has extension files in it is being reported to me
by SQLite Database Browser as being empty.
Is there any GUI app on Windows that can handle databases which have
extension tables in it?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http
tude_min>21.477932 and
citylookup.longitude_max<29.315407) and
(citylookup.latitude_min>40.614945 and
citylookup.latitude_max<44.657669)) and cities.class_dds<6 order by
class_dds limit 80"
-- 36
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in
derable ones for small areas (a country like france for instance),
as well as very small areas (maximum zoom).
I added an index on the ID field for the search in the city database,
that helped a bit, but i am dissapointed that the rtree search is not
faster than the normal search for bigger ar
lat and
> long twice.
>
Well, my database holds only cities for the time being! Does it make
sense to use rtree then?
Sorry if i am abusing the help of this list - I like SQlite and have
studied it for personal pleasure so far, but I am by all means no
database expert.
Greets,
C
se this table for queries?
I reckon I would further use the IDs I got back from the query to look
up the corresponding records in my normal table, right?
Something like
select * from cities where cities.id=(select id from cityLookUp where
??? Long and Lat clause)
--
Christoph
u, I got it to work!!!
Now, let´s see how we can this thing to work with my data ...
Thank you,
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211
ll get the best results (short of switching to an RTree
> index) using a query like this.
>
Thank you very much, that was very helpful and informative. I will do so.
Thnks again,
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr.
instructions
sqlite> .load rtree.dll
Die angegebene Prozedur wurde nicht gefunden.
The last sentence says that the specified procedure can´t be found.
Any help is much appreciated - again, i am on Windows, using Visual Studio 2005.
Thanks and greets,
Christophe Leske
www.multimedial.de -
Sorry, I was too quick - i now got a 80Kb rtree.dll file which seems
fine. I will test it.
Thanks to everyone for your support,
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249
i am on Windows, and I got myself the source ZIP and the rtree files pointed
out by Dr Hipp. I am targeting Windows XP, single processor, and using Visual
Studio 2005, but i am not bound to this if there are better options.
I just got something by setting up a simpe project in Visual Studi
for this, i got the files. Is there any document that would show some
steps on how to compile the source for Windows in order to create an extension?
I am sorry, but i am complete newbie to Sqlite's source.
But SQLite rocks!
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
h
Besides, how do I recompile the current version? Or does anyone have a
precompiled DLL binary for me?
Any help is much appreciated
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
and
latitude_dds<44.424779) ORDER BY class_dds ASC Limit 20
Would that be quicker eventually?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
9"
-- 11
-- "TIME for <> statement without ORDER BY-clause:991"
-- 11
a 2 field index (longitude, latitude):
-- "TIME for Between statement:10"
-- 11
-- "TIME for <> statement:11"
-- 11
-- "TIME for <> statement without ORDER BY-clause:10&quo
Christophe Leske schrieb:
>> Question, have you tried an index on class_dds, longitude_DDS, and
>> latitude_DDS?
>>
>> CREATE INDEX tableidx ON table (class_dds, longitude_DDS, latitude_DDS);
>>
>> Since all three fields are used in the query, I am curio
-- 11
two indices (longitude and latitude separetely):
-- "TIME for Between statement:2786"
-- 11
-- "TIME for <> statement:2792"
-- 11
A 3 field index (class_dds, latitude_dds, longitude_dds):
-- "TIME for Between statement:2783"
-- 11
-- "TIME for <> s
as-le-Selvage',6,-1,6.867705,44.285194);
INSERT INTO table VALUES('Ferrere',6,-1,6.950052,44.354508);
INSERT INTO table VALUES('San Bernolfo',6,-1,7.039278,44.263371);
INSERT INTO table VALUES('Murenz',6,-1,6.998868,44.348969);
INSERT INTO table VALUES('Bagni di Vinadi
tantial speed gain to be found - it
probably has to do with the fact that i am sorting at the end?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 26
your time,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
expect from a
40Mb Sqlite database like the one I have?
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users
leLock 0 3 0 Cities 00
46Goto 0 110 00
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
__
on how to analyze my queries. I should probably do that,
yet i am unfamiliar with reading the output of the Explain command.
Thanks for your time and eventual help,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseld
a new thread right away,
thanks,
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
sqlite-users@sql
set PRAGME
CACHE as well...
Thanks in advance,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
___
sqlite-users mailing list
80 matches
Mail list logo