Re: [sqlite] FTS and postfix search

[John Machin]

On 6/08/2009 12:07 PM, Jim Showalter wrote:
> Sorry--I read my emails arrival order, not reverse chronological--so I 
> didn't see that John had already solved it.

Not me ... this is ancient lore e.g. Knuth vol 3 of TAOCP 1973 edition 
page 391 "If we make two copies of the file, one in which the keys are 
in normal alphabetic order and another in which they are ordered from 
right to left (as if the words were spelled backwards), a misspelled 
word will probably agree up to half or more of its length with an entry 
in one of those two files."
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS and postfix search

[Jim Showalter]

Sorry--I read my emails arrival order, not reverse chronological--so I 
didn't see that John had already solved it.

- Original Message - 
From: "John Machin" 
To: "General Discussion of SQLite Database" 
Sent: Wednesday, August 05, 2009 6:40 PM
Subject: Re: [sqlite] FTS and postfix search


> On 6/08/2009 11:16 AM, Lukas Haase wrote:
>> Wes Freeman schrieb:
>
>>
>>> Strange that it's implemented for prefix and not postfix?
>>
>> Well, an explanation is easy: Same as with LIKE, LIKE 'xxx' or LIKE
>> 'xxx%' can be performed easy because only the beginning of words 
>> need to
>> be compared.
>>
>> However, there /is/ a way to also do postfix searches. I have the 
>> *same*
>> database in *.hlp format and with WinHelp it's possible to search
>> '*otor' (and others) with almost zero CPU and time consumption. I'd 
>> be
>> curious how they did this.
>
> In memory: maybe a suffix tree.
>
> In a database: have a column with the words stored backwards. SELECT 
> ...
> WHERE back_word LIKE "roto%"
> ___
> 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] ANN: C#-SQLite 3.6.16

[Noah Hart]

C#-SQLite is now ready for review.  The project is located at
http://code.google.com/p/csharp-sqlite/

This is SQLite ver 3.6.16 ported into managed code, written in C#

Please keep in mind the following:

* C#-SQLite is an independent reimplementation of the SQLite software
library
* This is not an official version of SQLite
* Bugs should not be reported to the SQLite.org ticket tracking system 

SQLite® is a registered trademark of Hipp, Wyrick & Company, Inc


Enjoy,

Noah Hart

-- 
View this message in context: 
http://www.nabble.com/ANN%3A-C--SQLite-3.6.16-tp24839242p24839242.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] FTS and postfix search

[Jim Showalter]

Forgot to conclude by saying the search gives you a list of words that 
you then need to further reduce by the actual number of characters you 
want to search by.

That's why storing them in reverse order might be preferable.

Also, just thought of something--if you store them in reverse order, 
you don't need to also store them in forward order. Just reverse the 
strings before displaying them.

- Original Message - 
From: "Jim Showalter" 
To: "General Discussion of SQLite Database" 
Sent: Wednesday, August 05, 2009 7:04 PM
Subject: Re: [sqlite] FTS and postfix search


> You could store the words reversed (in addition to storing them in 
> forward order). Then like 'xxx%' would be fast.
>
> This would double your disk footprint, but could give you the search 
> performance you're looking for.
>
> If that's too goofy, you could create a table of all one, two, and 
> three-character word endings, and join to it from all of your words 
> (stored in forward order). Then search first for the primary key of 
> the word ending you want to search for, then search your words for 
> that key.
>
> Index the join.
>
> - Original Message - 
> From: "Lukas Haase" 
> To: 
> Sent: Wednesday, August 05, 2009 6:16 PM
> Subject: Re: [sqlite] FTS and postfix search
>
>
>> Wes Freeman schrieb:
>>> I clearly am not in the right mindset to be answering list emails.
>>> Please ignore my response (it's too late now)--back to my 
>>> stressful
>>> deadline.
>>
>> :-)
>>
>>> Strange that it's implemented for prefix and not postfix?
>>
>> Well, an explanation is easy: Same as with LIKE, LIKE 'xxx' or LIKE
>> 'xxx%' can be performed easy because only the beginning of words 
>> need to
>> be compared.
>>
>> However, there /is/ a way to also do postfix searches. I have the 
>> *same*
>> database in *.hlp format and with WinHelp it's possible to search
>> '*otor' (and others) with almost zero CPU and time consumption. I'd 
>> be
>> curious how they did this.
>>
>> For a solution for SQLite I would accept a small performance 
>> penalty in
>> that case (but very few secs max); additionally I would also accept 
>> the
>> index being bigger.
>>
>> Regards,
>> Luke
>>
>>> Wes
>>>
>>> On Wed, Aug 5, 2009 at 8:58 PM, Lukas Haase 
>>> wrote:
 Wes Freeman schrieb:
> Why not LIKE '%otor'?
 SELECT topic_title FROM topics
 WHERE topic LIKE '%otor%'
 ORDER BY topic_title ASC;

 This is very, very slow, especially on my > 100 MB database. 
 "Realtime"
 search in the GUI is a requirement. This is exactly the reason 
 why I
 want to use FTS instead of LIKE...

 Regards,
 Luke

> Wes
>
> On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase 
> wrote:
>> Hi,
>>
>> It's me again, sorry. The next big problem concerning FTS. I 
>> have the
>> requirement to do postfix searches, like:
>>
>> SELECT topic_title FROM topics
>> WHERE topic MATCH '*otor'
>> ORDER BY topic_title ASC;
>>
>> should find Motor, motor, Monotor etc. But this does not seem 
>> to work.
>> Is there any chance to get this working?
>>
>> Best regards,
>> Luke
>>
>> ___
>> 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-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

Re: [sqlite] FTS and postfix search

[Jim Showalter]

You could store the words reversed (in addition to storing them in 
forward order). Then like 'xxx%' would be fast.

This would double your disk footprint, but could give you the search 
performance you're looking for.

If that's too goofy, you could create a table of all one, two, and 
three-character word endings, and join to it from all of your words 
(stored in forward order). Then search first for the primary key of 
the word ending you want to search for, then search your words for 
that key.

Index the join.

- Original Message - 
From: "Lukas Haase" 
To: 
Sent: Wednesday, August 05, 2009 6:16 PM
Subject: Re: [sqlite] FTS and postfix search


> Wes Freeman schrieb:
>> I clearly am not in the right mindset to be answering list emails.
>> Please ignore my response (it's too late now)--back to my stressful
>> deadline.
>
> :-)
>
>> Strange that it's implemented for prefix and not postfix?
>
> Well, an explanation is easy: Same as with LIKE, LIKE 'xxx' or LIKE
> 'xxx%' can be performed easy because only the beginning of words 
> need to
> be compared.
>
> However, there /is/ a way to also do postfix searches. I have the 
> *same*
> database in *.hlp format and with WinHelp it's possible to search
> '*otor' (and others) with almost zero CPU and time consumption. I'd 
> be
> curious how they did this.
>
> For a solution for SQLite I would accept a small performance penalty 
> in
> that case (but very few secs max); additionally I would also accept 
> the
> index being bigger.
>
> Regards,
> Luke
>
>> Wes
>>
>> On Wed, Aug 5, 2009 at 8:58 PM, Lukas Haase 
>> wrote:
>>> Wes Freeman schrieb:
 Why not LIKE '%otor'?
>>> SELECT topic_title FROM topics
>>> WHERE topic LIKE '%otor%'
>>> ORDER BY topic_title ASC;
>>>
>>> This is very, very slow, especially on my > 100 MB database. 
>>> "Realtime"
>>> search in the GUI is a requirement. This is exactly the reason why 
>>> I
>>> want to use FTS instead of LIKE...
>>>
>>> Regards,
>>> Luke
>>>
 Wes

 On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase 
 wrote:
> Hi,
>
> It's me again, sorry. The next big problem concerning FTS. I 
> have the
> requirement to do postfix searches, like:
>
> SELECT topic_title FROM topics
> WHERE topic MATCH '*otor'
> ORDER BY topic_title ASC;
>
> should find Motor, motor, Monotor etc. But this does not seem to 
> work.
> Is there any chance to get this working?
>
> Best regards,
> Luke
>
> ___
> 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-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

Re: [sqlite] FTS and postfix search

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Lukas Haase wrote:
> additionally I would also accept the index being bigger.

You could have a second FTS table where you store the keywords in reverse
order :-)

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkp6ONUACgkQmOOfHg372QTg8wCgvUYTChJ48xnUBcNVeRUHoSQY
5X4AoMwt7vsNzc5yMHDo1x9gXImuiJKw
=q1HB
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS and postfix search

[John Machin]

On 6/08/2009 11:16 AM, Lukas Haase wrote:
> Wes Freeman schrieb:

> 
>> Strange that it's implemented for prefix and not postfix?
> 
> Well, an explanation is easy: Same as with LIKE, LIKE 'xxx' or LIKE 
> 'xxx%' can be performed easy because only the beginning of words need to 
> be compared.
> 
> However, there /is/ a way to also do postfix searches. I have the *same* 
> database in *.hlp format and with WinHelp it's possible to search 
> '*otor' (and others) with almost zero CPU and time consumption. I'd be 
> curious how they did this.

In memory: maybe a suffix tree.

In a database: have a column with the words stored backwards. SELECT ... 
WHERE back_word LIKE "roto%"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI design & managment tool?

[Rob Sciuk]

On Wed, 5 Aug 2009, Allen Fowler wrote:
>> I would recommend SQLite Studio without hesitation.  I think it pretty
>> much covers your criteria, have a look:
>>
>> http://sqlitestudio.one.pl/index.rvt?act=about
>>
>> It is fast, graphical, a single executable install (eg: trivial), and
>> works well with existing databases ...  I've just started playing with
>> it on FreeBSD, and I must say that so far, I'm much impressed with the
>> tool.
>>
>
> very nice.  simple & functional.  Works on Linux and windows.
>
> However, sadly, I do not see any GUI tool for relationship design.  Did I 
> miss it?

Sorry, Allen, I've just stumbled onto it in the past 24 hours, and I'm 
still learning myself.  Mostly I've used it to explore existing 
applications, and it truly shines at this ... anyway, I hope it is of some 
help to you ...

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

Re: [sqlite] FTS and postfix search

[Lukas Haase]

Wes Freeman schrieb:
> I clearly am not in the right mindset to be answering list emails.
> Please ignore my response (it's too late now)--back to my stressful
> deadline.

:-)

> Strange that it's implemented for prefix and not postfix?

Well, an explanation is easy: Same as with LIKE, LIKE 'xxx' or LIKE 
'xxx%' can be performed easy because only the beginning of words need to 
be compared.

However, there /is/ a way to also do postfix searches. I have the *same* 
database in *.hlp format and with WinHelp it's possible to search 
'*otor' (and others) with almost zero CPU and time consumption. I'd be 
curious how they did this.

For a solution for SQLite I would accept a small performance penalty in 
that case (but very few secs max); additionally I would also accept the 
index being bigger.

Regards,
Luke

> Wes
> 
> On Wed, Aug 5, 2009 at 8:58 PM, Lukas Haase wrote:
>> Wes Freeman schrieb:
>>> Why not LIKE '%otor'?
>> SELECT topic_title FROM topics
>> WHERE topic LIKE '%otor%'
>> ORDER BY topic_title ASC;
>>
>> This is very, very slow, especially on my > 100 MB database. "Realtime"
>> search in the GUI is a requirement. This is exactly the reason why I
>> want to use FTS instead of LIKE...
>>
>> Regards,
>> Luke
>>
>>> Wes
>>>
>>> On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase wrote:
 Hi,

 It's me again, sorry. The next big problem concerning FTS. I have the
 requirement to do postfix searches, like:

 SELECT topic_title FROM topics
 WHERE topic MATCH '*otor'
 ORDER BY topic_title ASC;

 should find Motor, motor, Monotor etc. But this does not seem to work.
 Is there any chance to get this working?

 Best regards,
 Luke

 ___
 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-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] FTS and postfix search

[Wes Freeman]

I clearly am not in the right mindset to be answering list emails.
Please ignore my response (it's too late now)--back to my stressful
deadline.

Strange that it's implemented for prefix and not postfix?

Wes

On Wed, Aug 5, 2009 at 8:58 PM, Lukas Haase wrote:
> Wes Freeman schrieb:
>> Why not LIKE '%otor'?
>
> SELECT topic_title FROM topics
> WHERE topic LIKE '%otor%'
> ORDER BY topic_title ASC;
>
> This is very, very slow, especially on my > 100 MB database. "Realtime"
> search in the GUI is a requirement. This is exactly the reason why I
> want to use FTS instead of LIKE...
>
> Regards,
> Luke
>
>>
>> Wes
>>
>> On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase wrote:
>>> Hi,
>>>
>>> It's me again, sorry. The next big problem concerning FTS. I have the
>>> requirement to do postfix searches, like:
>>>
>>> SELECT topic_title FROM topics
>>> WHERE topic MATCH '*otor'
>>> ORDER BY topic_title ASC;
>>>
>>> should find Motor, motor, Monotor etc. But this does not seem to work.
>>> Is there any chance to get this working?
>>>
>>> Best regards,
>>> Luke
>>>
>>> ___
>>> 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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS and postfix search

[Lukas Haase]

Wes Freeman schrieb:
> Why not LIKE '%otor'?

SELECT topic_title FROM topics
WHERE topic LIKE '%otor%'
ORDER BY topic_title ASC;

This is very, very slow, especially on my > 100 MB database. "Realtime" 
search in the GUI is a requirement. This is exactly the reason why I 
want to use FTS instead of LIKE...

Regards,
Luke

> 
> Wes
> 
> On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase wrote:
>> Hi,
>>
>> It's me again, sorry. The next big problem concerning FTS. I have the
>> requirement to do postfix searches, like:
>>
>> SELECT topic_title FROM topics
>> WHERE topic MATCH '*otor'
>> ORDER BY topic_title ASC;
>>
>> should find Motor, motor, Monotor etc. But this does not seem to work.
>> Is there any chance to get this working?
>>
>> Best regards,
>> Luke
>>
>> ___
>> 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

Re: [sqlite] FTS and postfix search

[Wes Freeman]

Why not LIKE '%otor'?

Wes

On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haase wrote:
> Hi,
>
> It's me again, sorry. The next big problem concerning FTS. I have the
> requirement to do postfix searches, like:
>
> SELECT topic_title FROM topics
> WHERE topic MATCH '*otor'
> ORDER BY topic_title ASC;
>
> should find Motor, motor, Monotor etc. But this does not seem to work.
> Is there any chance to get this working?
>
> Best regards,
> Luke
>
> ___
> 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] FTS and postfix search

[Lukas Haase]

Hi,

It's me again, sorry. The next big problem concerning FTS. I have the 
requirement to do postfix searches, like:

SELECT topic_title FROM topics
WHERE topic MATCH '*otor'
ORDER BY topic_title ASC;

should find Motor, motor, Monotor etc. But this does not seem to work. 
Is there any chance to get this working?

Best regards,
Luke

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

[sqlite] virtual tables may not be indexed

[Lukas Haase]

Hi list,

I have a huge problem: A database with 2 HTML fragements should 
contain a fulltext index. For that reason I put all data into a virtual 
table:

CREATE VIRTUAL TABLE topics USING fts3(
topicID INTEGER,
topic_title VARCHAR(200) COLLATE NOCASE,
topic TEXT,
TOKENIZE simple);

topic contains the HTML fragments, topic_title the title and topicID is 
needed for locating a specific entry. Well, and that's actually the 
problem... Before (i.e. without FTS) I did:

SELECT topic FROM topics WHERE topicID=9874;

which was quite fast. Now this is very, very slow (a few seconds!). I 
guess this is because topicID is not a primary key any more and no index 
is defined. So I wanted to create an index but I got the error in the 
subject. Really big problem :-( But I really need a way to *quickly* 
locate an entry by its ID. I do NOT want to store the data twice :-(

What I am doing wrong?

Best regards,
Luke

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

Re: [sqlite] GUI design & managment tool?

[Allen Fowler]

> 
> I would recommend SQLite Studio without hesitation.  I think it pretty 
> much covers your criteria, have a look:
> 
> http://sqlitestudio.one.pl/index.rvt?act=about
> 
> It is fast, graphical, a single executable install (eg: trivial), and 
> works well with existing databases ...  I've just started playing with 
> it on FreeBSD, and I must say that so far, I'm much impressed with the 
> tool.
> 

very nice.  simple & functional.  Works on Linux and windows.

However, sadly, I do not see any GUI tool for relationship design.  Did I miss 
it?



  

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

Re: [sqlite] GUI design & managment tool?

[Rob Sciuk]

From: Allen Fowler 
> 
> Hello,
> 
> Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for 
> creating and maintaining an SQlite databases that can run on both Windows 
> and Linux?
> 
> (Support for visual relation design would be great, too.)
> 
> I found a list at: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> 
> But, I was wondering if anyone has personal experience to share...
> 
> Thanks, :)

I would recommend SQLite Studio without hesitation.  I think it pretty 
much covers your criteria, have a look:

http://sqlitestudio.one.pl/index.rvt?act=about

It is fast, graphical, a single executable install (eg: trivial), and 
works well with existing databases ...  I've just started playing with 
it on FreeBSD, and I must say that so far, I'm much impressed with the 
tool.

HTH.
Cheers,
Rob Sciuk

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

Re: [sqlite] sort by in Sqlite

[Nuno Lucas]

Kalyani Phadke wrote:
> but I am getting 
> Test
> aaa
> test
>  
> Do I need to use COLLATE NOCASE while performing sorting on name column?

Yes, because the default COLLATE is memory based (just compares bytes).

You get what you expect either by using "ORDER BY lower(Name)" (or 
upper, off course) or using "ORDER BY Name COLLATE NOCASE". But even so 
you only get ASCII order, that is, accented characters will not be 
ordered as you expect.

You can fix this last issue by looking into the "ICU" extension.

 > Why?

The reason is because SQLite can't guess what's the collation sequence 
you are interested. If you want to use the native system locale then 
your cased indexes could not be correct when used by another user (note 
that even some "standard" orderings may be different on different 
systems, although mostly on corner cases).

The only way to really fix this issue is by having SQLite embed all 
possible collations into the library or use a 3rd party library that 
does this (the ICU extension does this, by relying on libicu). As the 
former would make SQLite not "lite" anymore, it's up to the user to 
either use the second or roll their own collating extensions.

Note that it's easy enough to roll your own "icu" like extension (for 
example, if you only use Win32, you could just use the native system 
collation functions), but then you would need to make sure every access 
of your database would have available to this extensions.


Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Leading spaces in columns

[Jim Dodgen]

In what software is the select being executed?

How do you know they are suppressed?

On Wed, Aug 5, 2009 at 2:16 PM, Paul Claessen wrote:
> I have a number of leading spaces in one of my sqlite columns, but SELECT 
> result suppresses them.
>
> Yet I see that the SqliteManager add-on for Firefox displays them quite 
> nicely.
>
> What is the secret of retrieving those leading spaces?
>
>
>
>
>
> Kind regards,
>
>
>
> ~ Paul Claessen
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Jim "Jed" Dodgen
j...@dodgen.us
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sort by in Sqlite

[Simon Slavin]

On 5 Aug 2009, at 8:43pm, Kalyani Phadke wrote:

> My query "select Name from ABCD order by Name" The expected result
> aaa
> Test
> test
>
> but I am getting
> Test
> aaa
> test

How are you getting these results from ?  Are you typing your SELECT  
command into the command-line tool or using another program to execute  
it ?

Are you creating your database from scratch each time you test this  
sequence of commands or are you using an existing database file ?

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

[sqlite] Leading spaces in columns

[Paul Claessen]

I have a number of leading spaces in one of my sqlite columns, but SELECT 
result suppresses them.

Yet I see that the SqliteManager add-on for Firefox displays them quite nicely.

What is the secret of retrieving those leading spaces?

 

 

Kind regards,

 

~ Paul Claessen

 

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

[sqlite] sort by in Sqlite

[Kalyani Phadke]

CREATE TABLE ABCD
(

ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ,


Name VARCHAR
(
50
)
NULL

)
 
Table ABCD has following data:-
ID Name
1  Test
2  test
3  aaa  
My query "select Name from ABCD order by Name" The expected result
aaa
Test
test 
 
but I am getting 
Test
aaa
test
 
Do I need to use COLLATE NOCASE while performing sorting on name column?
Why?
 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Bad CPU type in executable"?

[Beau Wilkinson]

>> Sounds like I'm not welcome on this list.  Go hassle someone else.
>> Goodbye.
>A bit sensitive, no?
>I was actually defending you.

With the mix of top and bottom posting, it's difficult to tell who's talking to 
whom. My preference would be for a forum or email system that enforces one or 
the other. I don't really care which; what I really dislike is anything that's 
on the honor system. One way or the other ought to be enforced by the tools 
wherever possible. Too often the "wrong way" becomes little more than a straw 
man for mockery ("he didn't call 'MARSHALL(_widgelet_)' at the end of his 
method... ha! what an idiot").

The sad result of this misunderstanding is that the world will just have to do 
without the "Texas State Probation Officer Visit Scheduler App," "Texas Death 
Penalty Last Meal Expense Calculator," etc.

The information contained in this e-mail is privileged and confidential 
information intended only for the use of the individual or entity named.  If 
you are not the intended recipient, or the employee or agent responsible for 
delivering this message to the intended recipient, you are hereby notified that 
any disclosure, dissemination, distribution, or copying of this communication 
is strictly prohibited.  If you have received this e-mail in error, please 
immediately notify the sender and delete any copies from your system.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Bad CPU type in executable"?

[Nuno Lucas]

Jimmy Verner wrote:
> Sounds like I'm not welcome on this list.  Go hassle someone else.   
> Goodbye.

A bit sensitive, no?
I was actually defending you.


Regards,
~Nuno Lucas

> Jimmy Verner
> www.vernerlegal.com

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

Re: [sqlite] "Bad CPU type in executable"?

[Hamish Allan]

On Wed, Aug 5, 2009 at 5:50 PM, Jean-Denis Muys wrote:

> You're top-posting, it's evil, the thread is becoming messy.

You need to look up the word "evil" sometime. There are pros and cons
to top-posting; to my mind, the most annoying thing about it is that
it seems to draw comments from people who seriously lack perspective.

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

Re: [sqlite] "Bad CPU type in executable"?

[Bruce Robertson]

Exactly.

> Thank you both.  Sorry about the top-posting - my experience on other
> lists is that top-posting is preferred.
> 
> Jimmy Verner
> www.vernerlegal.com
> 
>> 
>> You're top-posting, it's evil, the thread is becoming messy. That
>> said...
>> 
>> It's apparent your DB3 file is the SQLite file you are looking for,
>> not a
>> Dbase III file.
>> 
>> To open it, you can use any utility that can open a SQLite file. I
>> personnaly use MesaSQLite. Or you can use the SQLite3 command line
>> utility
>> that's included with your Mac. Open a terminal and type something like
>> 
>> sqlite3 /path/to/mydb.db3
>> 
>> Then you can use all the SQLite commands.
>> 
>> I hope that let's you get started.
>> 
>> Jean-Denis
>> 
>> 
>> 
>> ___
>> 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] "Bad CPU type in executable"?

[Jimmy Verner]

Sounds like I'm not welcome on this list.  Go hassle someone else.   
Goodbye.

Jimmy Verner
www.vernerlegal.com



On Aug 5, 2009, at 12:37 PM, Nuno Lucas wrote:

> Jean-Denis Muys wrote:
>> You're top-posting, it's evil, the thread is becoming messy. That  
>> said...
>
> And you are including everything of the earlier mail, which is even  
> more evil
> than top-posting by itself.
>
> Ok, I'm done with my rant-per-year mails.
>
>
> Regards,
> ~Nuno Lucas
> ___
> 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] SQLite Memory Pool overflow probelm

[Simon Slavin]

On 5 Aug 2009, at 10:27am, shankar m wrote:

> I am running SQLite on a embedded device. For SQLite memory pool I  
> am using
> memsys5 memory allocator with size of 256 KB.
> When i execute  "insert into" command for around 5*1000 times the  
> memory
> pool is full but my database file has space. I cannot insert anymore.
>
> How to free the memory pool for further insertion? Do I need to do any
> further configuration?.

Are you using transactions around your 5000 inserts ?  Do you use  
BEGIN at all ?  If so, do you use COMMIT after each INSERT or each  
1000 INSERTs ?  Or are you still inside the same transaction when you  
hit your 5000th INSERT ?

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

Re: [sqlite] "Bad CPU type in executable"?

[Nuno Lucas]

Jean-Denis Muys wrote:
> You're top-posting, it's evil, the thread is becoming messy. That said...

And you are including everything of the earlier mail, which is even more evil 
than top-posting by itself.

Ok, I'm done with my rant-per-year mails.


Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Bad CPU type in executable"?

[Jimmy Verner]

Thank you both.  Sorry about the top-posting - my experience on other  
lists is that top-posting is preferred.

Jimmy Verner
www.vernerlegal.com

>
> You're top-posting, it's evil, the thread is becoming messy. That  
> said...
>
> It's apparent your DB3 file is the SQLite file you are looking for,  
> not a
> Dbase III file.
>
> To open it, you can use any utility that can open a SQLite file. I
> personnaly use MesaSQLite. Or you can use the SQLite3 command line  
> utility
> that's included with your Mac. Open a terminal and type something like
>
> sqlite3 /path/to/mydb.db3
>
> Then you can use all the SQLite commands.
>
> I hope that let's you get started.
>
> Jean-Denis
>
>
>
> ___
> 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] "Bad CPU type in executable"?

[Jean-Denis Muys]

On 8/5/09 18:40 , "Jimmy Verner"  wrote:

> Thx. for your note.  The dylib file is visible only when the app is is
> opened with xcode.  I then clicked on the file.  The Terminal window
> opened and I received the message set forth below.
> 
> There is a db3 file within the app.  When I try to open the db3 file
> in xcode, nothing happens.  The db3 file is visible in Finder.  When I
> try to open it there, Finder says there is no default app with which
> to open it.  I am able to open it with Text Wrangler where there is
> much gibberish but also the data.  The file begins with SQ Lite format
> 3 and then includes setup commands to set up a table.
> 
> I now understand that a db3 file is a dBase III file.  Perhaps you
> could point me to some resources so I can learn about dBase III files
> and how they interact with dylib files?
> 
> Thx. again.
> 
> Jimmy Verner
> www.vernerlegal.com
> 
> 
> 
> On Aug 5, 2009, at 11:22 AM, Jean-Denis Muys wrote:
> 
>> 
>> On 8/5/09 17:48 , "Jimmy Verner"  wrote:
>> 
>>> A developer built an iPhone app for me.  I am exploring using it as a
>>> template for another app.  The data file is called
>>> libsqlite3.0.dylib.  When I try to open the file, I receive this
>>> message:
>>> 
>>> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/
>>> iPhoneOS3.0.sdk/
>>> usr/lib/libsqlite3.dylib ; exit;
>>> [76-209-121-92:~] jimmyverner% /Developer/Platforms/
>>> iPhoneOS.platform/
>>> Developer/SDKs/iPhoneOS3.0.sdk/usr/lib/libsqlite3.dylib ; exit;
>>> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/
>>> iPhoneOS3.0.sdk/
>>> usr/lib/libsqlite3.dylib: Bad CPU type in executable.
>>> logout
>>> [Process completed]
>>> 
>>> How do I open this file?
>>> 
>>> Running OS X 10.5.7, Xcode 3.1.3.
>>> 
>> 
>> A dylib file is not a data file, but a dynamic library, similar to
>> a .dll
>> file under Windows. It must be linked against in you Xcode project.
>> 
>> The path you give suggests that dynamic library is coming with the
>> standard
>> iPhone SDK. How did you try to "open" it, as you said?
>> 
>> If indeed you need to open the data (ie database) file, then you need
>> another file, possibly with a .db extension.
>> 
>> 
>> Jean-Denis
>> 

You're top-posting, it's evil, the thread is becoming messy. That said...

It's apparent your DB3 file is the SQLite file you are looking for, not a
Dbase III file.

To open it, you can use any utility that can open a SQLite file. I
personnaly use MesaSQLite. Or you can use the SQLite3 command line utility
that's included with your Mac. Open a terminal and type something like

sqlite3 /path/to/mydb.db3

Then you can use all the SQLite commands.

I hope that let's you get started.

Jean-Denis



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

Re: [sqlite] "Bad CPU type in executable"?

[P Kishor]

On Wed, Aug 5, 2009 at 11:40 AM, Jimmy Verner wrote:
> Thx. for your note.  The dylib file is visible only when the app is is
> opened with xcode.  I then clicked on the file.  The Terminal window
> opened and I received the message set forth below.
>
> There is a db3 file within the app.  When I try to open the db3 file
> in xcode, nothing happens.  The db3 file is visible in Finder.  When I
> try to open it there, Finder says there is no default app with which
> to open it.  I am able to open it with Text Wrangler where there is
> much gibberish but also the data.  The file begins with SQ Lite format
> 3 and then includes setup commands to set up a table.
>
> I now understand that a db3 file is a dBase III file.  Perhaps you
> could point me to some resources so I can learn about dBase III files
> and how they interact with dylib files?


Your understanding is incorrect. The db3 file is not a dbase 3 file,
but is a sqlite3 db file, created by version 3 of sqlite. You need
sqlite to open that file, which is provided by your application and
the .dylib in question.

Perhaps you should ask your developer who gave you all this for more
help. She or he would be best placed to guide you.


>
> Thx. again.
>
> Jimmy Verner
> www.vernerlegal.com
>
>
>
> On Aug 5, 2009, at 11:22 AM, Jean-Denis Muys wrote:
>
>>
>> On 8/5/09 17:48 , "Jimmy Verner"  wrote:
>>
>>> A developer built an iPhone app for me.  I am exploring using it as a
>>> template for another app.  The data file is called
>>> libsqlite3.0.dylib.  When I try to open the file, I receive this
>>> message:
>>>
>>> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/
>>> iPhoneOS3.0.sdk/
>>> usr/lib/libsqlite3.dylib ; exit;
>>> [76-209-121-92:~] jimmyverner% /Developer/Platforms/
>>> iPhoneOS.platform/
>>> Developer/SDKs/iPhoneOS3.0.sdk/usr/lib/libsqlite3.dylib ; exit;
>>> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/
>>> iPhoneOS3.0.sdk/
>>> usr/lib/libsqlite3.dylib: Bad CPU type in executable.
>>> logout
>>> [Process completed]
>>>
>>> How do I open this file?
>>>
>>> Running OS X 10.5.7, Xcode 3.1.3.
>>>
>>
>> A dylib file is not a data file, but a dynamic library, similar to
>> a .dll
>> file under Windows. It must be linked against in you Xcode project.
>>
>> The path you give suggests that dynamic library is coming with the
>> standard
>> iPhone SDK. How did you try to "open" it, as you said?
>>
>> If indeed you need to open the data (ie database) file, then you need
>> another file, possibly with a .db extension.
>>
>>
>> Jean-Denis
>>
>> ___
>> 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
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Bad CPU type in executable"?

[Jimmy Verner]

Thx. for your note.  The dylib file is visible only when the app is is  
opened with xcode.  I then clicked on the file.  The Terminal window  
opened and I received the message set forth below.

There is a db3 file within the app.  When I try to open the db3 file  
in xcode, nothing happens.  The db3 file is visible in Finder.  When I  
try to open it there, Finder says there is no default app with which  
to open it.  I am able to open it with Text Wrangler where there is  
much gibberish but also the data.  The file begins with SQ Lite format  
3 and then includes setup commands to set up a table.

I now understand that a db3 file is a dBase III file.  Perhaps you  
could point me to some resources so I can learn about dBase III files  
and how they interact with dylib files?

Thx. again.

Jimmy Verner
www.vernerlegal.com



On Aug 5, 2009, at 11:22 AM, Jean-Denis Muys wrote:

>
> On 8/5/09 17:48 , "Jimmy Verner"  wrote:
>
>> A developer built an iPhone app for me.  I am exploring using it as a
>> template for another app.  The data file is called
>> libsqlite3.0.dylib.  When I try to open the file, I receive this
>> message:
>>
>> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/ 
>> iPhoneOS3.0.sdk/
>> usr/lib/libsqlite3.dylib ; exit;
>> [76-209-121-92:~] jimmyverner% /Developer/Platforms/ 
>> iPhoneOS.platform/
>> Developer/SDKs/iPhoneOS3.0.sdk/usr/lib/libsqlite3.dylib ; exit;
>> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/ 
>> iPhoneOS3.0.sdk/
>> usr/lib/libsqlite3.dylib: Bad CPU type in executable.
>> logout
>> [Process completed]
>>
>> How do I open this file?
>>
>> Running OS X 10.5.7, Xcode 3.1.3.
>>
>
> A dylib file is not a data file, but a dynamic library, similar to  
> a .dll
> file under Windows. It must be linked against in you Xcode project.
>
> The path you give suggests that dynamic library is coming with the  
> standard
> iPhone SDK. How did you try to "open" it, as you said?
>
> If indeed you need to open the data (ie database) file, then you need
> another file, possibly with a .db extension.
>
>
> Jean-Denis
>
> ___
> 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] "Bad CPU type in executable"?

[Jean-Denis Muys]

On 8/5/09 17:48 , "Jimmy Verner"  wrote:

> A developer built an iPhone app for me.  I am exploring using it as a
> template for another app.  The data file is called
> libsqlite3.0.dylib.  When I try to open the file, I receive this
> message:
> 
> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS3.0.sdk/
> usr/lib/libsqlite3.dylib ; exit;
> [76-209-121-92:~] jimmyverner% /Developer/Platforms/iPhoneOS.platform/
> Developer/SDKs/iPhoneOS3.0.sdk/usr/lib/libsqlite3.dylib ; exit;
> /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS3.0.sdk/
> usr/lib/libsqlite3.dylib: Bad CPU type in executable.
> logout
> [Process completed]
> 
> How do I open this file?
> 
> Running OS X 10.5.7, Xcode 3.1.3.
> 

A dylib file is not a data file, but a dynamic library, similar to a .dll
file under Windows. It must be linked against in you Xcode project.

The path you give suggests that dynamic library is coming with the standard
iPhone SDK. How did you try to "open" it, as you said?

If indeed you need to open the data (ie database) file, then you need
another file, possibly with a .db extension.


Jean-Denis

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

[sqlite] "Bad CPU type in executable"?

[Jimmy Verner]

A developer built an iPhone app for me.  I am exploring using it as a  
template for another app.  The data file is called  
libsqlite3.0.dylib.  When I try to open the file, I receive this  
message:

/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS3.0.sdk/ 
usr/lib/libsqlite3.dylib ; exit;
[76-209-121-92:~] jimmyverner% /Developer/Platforms/iPhoneOS.platform/ 
Developer/SDKs/iPhoneOS3.0.sdk/usr/lib/libsqlite3.dylib ; exit;
/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS3.0.sdk/ 
usr/lib/libsqlite3.dylib: Bad CPU type in executable.
logout
[Process completed]

How do I open this file?

Running OS X 10.5.7, Xcode 3.1.3.

TIA

Jimmy Verner
www.vernerlegal.com



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

Re: [sqlite] GUI design & managment tool?

[Allen Fowler]

> Thank you for this message. We've just fixed the bug you mentioned and
> uploaded an updated version of SQLite Maestro at
> http://www.sqlmaestro.com/products/sqlite/maestro/download/
> 

Wow.  Nice to see you folks monitoring this list.

> > (Support for visual relation design would be great, too.)
> 
> Yes, SQLite Maestro does include such a tool.
> http://www.sqlmaestro.com/products/sqlite/maestro/screenshots/getting_started/database_designer/
> 
>

I've been playing with the demo...Out of curiosity, is there any way to 
have the connecting lines automatically route themselves around the other 
shapes and automatically connect to the table next to the key they represent?  
(Like MS Access, but perhaps less buggy...)


  

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

Re: [sqlite] GUI design & managment tool?

[stormtrooper]

I recommend 2 free tools:

1. The Firefox Sqlite Manager extension.

2. AnySQL Maestro (Windows) - this is an excellent tool, it can connect to
almost any database or ODBC - Excel, Access, dbase, txt, sqlite, SQL Server,
... It has so many features. Please try it.

Keith


Allen Fowler wrote:
> 
> 
> Hello,
> 
> Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for
> creating and maintaining an SQlite databases that can run on both Windows
> and Linux?
> 
> (Support for visual relation design would be great, too.)
> 
> I found a list at:
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> 
> But, I was wondering if anyone has personal experience to share...
> 
> Thanks,
> :)
> 
> 
>   
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/GUI--design---managment-tool--tp24810111p24829338.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] GUI design & managment tool?

[SQL Maestro Group]

Hi!

> SQLite Maestro: http://www.sqlmaestro.com/products/sqlite/maestro/
> This is a shareware tool that is free for 30 days.  This tool is
> very good and does everything you would expect a SQL database tool to
> do.  One of my subtle gripes with it however is how it displays certain
> data.  I have many many several text-type foreign keys and instead of
> displaying the text value, it displays it as "MEMO".  Other than that
> though the tool is much better than any others I've tried prior to
> Firefox's plugin.

Thank you for this message. We've just fixed the bug you mentioned and
uploaded an updated version of SQLite Maestro at
http://www.sqlmaestro.com/products/sqlite/maestro/download/

> (Support for visual relation design would be great, too.)

Yes, SQLite Maestro does include such a tool.
http://www.sqlmaestro.com/products/sqlite/maestro/screenshots/getting_started/database_designer/

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

[sqlite] SQLite Memory Pool overflow probelm

[shankar m]

Hi,

I am running SQLite on a embedded device. For SQLite memory pool I am using
memsys5 memory allocator with size of 256 KB.
When i execute  "insert into" command for around 5*1000 times the memory
pool is full but my database file has space. I cannot insert anymore.

How to free the memory pool for further insertion? Do I need to do any
further configuration?.


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

[sqlite] error: sqlite doesn't free mutexe s on windows

[Дмитрий Соколов]

sqlite-amalgamation-3_6_16.zip
win32
msvc 2008 sp1

func sqlite3_open_v2() is called with 'flag' param = SQLITE_OPEN_FULLMUTEX | 
SQLITE_OPEN_READWRITE


in sqlite3_initialize() func winMutexInit() is indirectly called three times:
  1) in sqlite3MutexInit()
  2) in sqlite3PcacheInitialize()
  3) in sqlite3_os_init() (in func sqlite3_vfs_register())
so var winMutex_lock == 3

in sqlite3_shutdown() functions
  sqlite3PcacheShutdown()
  sqlite3_os_end()
  sqlite3MutexEnd()
are called, but sqlite3PcacheShutdown() and sqlite3_os_end() do not decrement 
var winMutex_lock
so when sqlite3MutexEnd() is called the var winMutex is still == 3, and mutexes 
are not destroyed
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users