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)
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
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
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:
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,
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
On 8/5/09 17:48 , Jimmy Verner jver...@vernerlegal.com 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:
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
On Wed, Aug 5, 2009 at 11:40 AM, Jimmy Vernerjver...@vernerlegal.com 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
On 8/5/09 18:40 , Jimmy Verner jver...@vernerlegal.com 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.
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,
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
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
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
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
On Wed, Aug 5, 2009 at 5:50 PM, Jean-Denis Muysjdm...@kleegroup.com 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
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
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
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
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
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
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 Claessenp...@claessen.com 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
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
From: Allen Fowler allen.fow...@yahoo.com
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
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
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,
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
Why not LIKE '%otor'?
Wes
On Wed, Aug 5, 2009 at 7:47 PM, Lukas Haaselukasha...@gmx.at 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
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
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 Haaselukasha...@gmx.at wrote:
Wes Freeman
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
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
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,
-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
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
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,
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
*
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 sjmac...@lexicon.net
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wednesday, August 05, 2009 6:40 PM
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
39 matches
Mail list logo