The problem with ICU is that it's a rather large library, and mozilla
already has it's own unicode system. That's we we opted on doing
unicode support ourselves (less code duplication, and a smaller
binary).
Cheers,
Shawn Wilsher
On Jan 24, 2008 11:35 PM, Dan <[EMAIL PROTECTED]> wrote:
>
> On
There is two way of compiling DBD::SQLite:
1. to use his own internal version of SQLite
USE_LOCAL_SQLITE=1 perl Maker.pl
2. to use shared library of SQLite
SQLITE_LOCATION=/path/to/libsqlite perl Makefile.pl
So if you install 3.5.4 in /usr/local/lib, you should set
SQLITE_LOCATION=/usr/local/lib/
On Jan 25, 2008, at 7:26 AM, Myk Melez wrote:
Hi all,
I'm working to enable FTS3 in the next version of Firefox [1] so
that extenders can take advantage of it, although Firefox itself
isn't using it for the next release.
Given Firefox's international audience, it would be useful for
I have tend to build the DBD::SQLite from source, when ever I have built
with it looking for sqlite libs it reports a old version older than
3.3.9 or something
and then uses the current 3.4.2 stuff supplied in the module.
I do have 3.5.4 installed, it migh be that there could be a older
I tried to install newest sqlite3 on OpenBSD 4.2 - unfortunately, when using
sqlite3 module for TCL, immediately after exiting tclsh, there's always
"core dump" occurence. It seems, that sqlite needs some patching by OpenBSD
port maintainers. But it wasn't a big problem, there is binary package
Did you try to use it on real drive disk?
On Jan 25, 2008 3:17 AM, Rasanth Akali Kandoth <[EMAIL PROTECTED]> wrote:
> Hi All,
> i have an application that uses sqlite3 version 3.3.17 to create a DB on a
> ramdisk. I see a strange issue that the DB disappears at times( the DB size
> is becoming
I have no problem with 3.5.4.
Maybe your DBD::SQLite is linked with libsqlite in other dirrectory?
For example your DBD::SQLite is linked against
/usr/lib/libsqlite3.so.0, and you installed new 3.5.2 into
/usr/local/lib ?
Here is my linking information:
# ldd
sorry I attached another email by accident, it's content is not related
to my question
Jim
Jim Dodgen wrote:
the latest DBD::SQLite (a Perl module) was buit with 3.4.2 I have
attempted to get a version up to 3.5.2 with no success so far.
anyone have any success yet? If so what is the
the latest DBD::SQLite (a Perl module) was buit with 3.4.2 I have
attempted to get a version up to 3.5.2 with no success so far.
anyone have any success yet? If so what is the magic.
Jim
John Stanton wrote:
Using Apache is the problem. The connections are not persistent so
caching is
Alexander Batyrshin wrote:
Hello John,
Right now i am using apache + fcgid (fast-cgi).
I will try to keep database handler open. But i need to implement it,
because i am using now more than 200 databases.
That means keeping open 200 connections if you want to maximize
performance by
Hi All,
i have an application that uses sqlite3 version 3.3.17 to create a DB on a
ramdisk. I see a strange issue that the DB disappears at times( the DB size
is becoming zero. it was arround 16k after all my tables are created). i
dont have any code in my application which deletes the db file or
Hi all,
I'm working to enable FTS3 in the next version of Firefox [1] so that
extenders can take advantage of it, although Firefox itself isn't using
it for the next release.
Given Firefox's international audience, it would be useful for FTS3 to
support Unicode. We currently do this for
Dennis Cote <[EMAIL PROTECTED]> wrote: Ken wrote:
>
> I think the issue however was that sqlite uses Signed integers And my Number
> although a valid 64bit hex number was to large to fit into a 64 bit signed
> value.
Yes, that's what I said. :-)
> Sqlite simply coerced it into a "text"
Latest SQLite version with the VB wrapper from Olaf Schmidt,
dhRichClient.dll. Running this in VBA Excel on Windows XP.
Have a suspicion that maybe you could get slow queries if a table repeatedly
gets a DELETE FROM TABLE followed by re-populating the table with inserts,
so cyling this
Ken wrote:
I think the issue however was that sqlite uses Signed integers And my Number although a valid 64bit hex number was to large to fit into a 64 bit signed value.
Yes, that's what I said. :-)
Sqlite simply coerced it into a "text" field for storage.
No, SQLite converted in to a
Hello John,
Right now i am using apache + fcgid (fast-cgi).
I will try to keep database handler open. But i need to implement it,
because i am using now more than 200 databases.
On Jan 24, 2008 9:38 PM, John Stanton <[EMAIL PROTECTED]> wrote:
> Using Apache is the problem. The connections are
Deinnis Thanks for the help.
That worked quited well. I think the issue however was that sqlite uses Signed
integers And my Number although a valid 64bit hex number was to large to fit
into a 64 bit signed value. Sqlite simply coerced it into a "text" field for
storage.
I'll proceed with
Using Apache is the problem. The connections are not persistent so
caching is destroyed. It sounds like you are using CGI, and that makes
it more so. Somevariant like fastcgi (?) might give you what you look for.
Clark Christensen wrote:
I don't think you're going to get the kind of
As an add on: it looks like this is interpreted correctly.
fff
1152921504606781440
select to_hex((val&1152921504606781440)) from x;
to_hex((val&1152921504606781440))
0x92bbd42
0x99
Could this be related to the sign bit, causing
0x not to be a valid number?
Joanne Pham wrote:
I am new to sqlite and I want to build the sqlite library. What is the step to
build the library.
Joanne,
See the following pages for more info:
http://www.sqlite.org/cvstrac/wiki?p=SqliteBuildProcess
http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
Also, you were well
Sorry!! I didn't make it clear.
I am new to sqlite and I want to build the sqlite library. What is the step to
build the library.
-JP
- Original Message
From: Roger Binns <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, January 24, 2008 10:40:24 AM
Subject: Re: [sqlite]
Joanne Pham wrote:
> If you know how to build sqlite library for 64bits please help me with the
> detail information.
What problems did you encounter when you tried to build it on a 64 bit
machine?
http://catb.org/~esr/faqs/smart-questions.html
Roger
On Wed, Jan 23, 2008 at 10:24:53PM -0800, Scott Hess wrote:
> Seems to me that GLOB is a poor substitute for REGEXP. At the shell
If, as I suspect, many more users can enter simple globs than can enter
simple regexps, then providing a GLOB operator and function in SQLite is
very useful indeed.
Hi All,
If you know how to build sqlite library for 64bits please help me with the
detail information.
Thanks in advance,
JP
- Original Message
From: Joanne Pham <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, January 23, 2008 4:09:42 PM
Subject: [sqlite] sqlite 3.5.2
Hello Clark,
I am using Apache + Fast-CGI :)
But my next move will be to mod_perl.
Currently I have only idea to use something like
Cache::SharedMemoryCache or Cache::Memcached for implementing caching
inside my application.
What are you thinking about this?
If you have any interesting ideas or
I feel compelled to throw in my $0.02 here.
To everyone who thinks that SQLite should allow 'foo ' == 'foo':
SQL was originally conceived as a query *language* -- a way for a
human being to request a set of data from a database. It was
specifically designed for ad-hoc queries.
This little
I don't think you're going to get the kind of caching you want using Perl and a
web server (Apache, right?). There's just no persistence across processes, no
shared memory, no database connections.
Now, Apache's mod_perl and some associated modules could get you all that and
more. For me,
From Nico:
You could always copy the users_history table records to an attached DB
and "delete from users_history;" after every, or every N, transactions
on your main DB. This ways your users_history table size is bounded in
the main DB and you still get to keep all your history in a separate
Hi Sam,
Brainstorming your suggestion a bit, rather than allowing triggers to
function across databases (which is understandably not practical given
the architecture), perhaps there could be a way to define a "partition"
within a database (similar to creating a folder on a drive). Borrowing
from
On Thu, Jan 24, 2008 at 10:59:17AM -0500, Samuel R. Neff wrote:
> Due to the restriction that triggers cannot span databases, I have my main
> data tables, history tables, and the ActiveTransaction table all in the same
> database. I'd really rather the history tables be in a separate database
>
I've run into two situations recently where I would have preferred to write
triggers across databases. Both related to audit tracking of data.
The first situation is that for every table, I have a corresponding history
table that records the history of every record. So let's say I have
CREATE
Hi all,
Could the 'Shared Cache' option in SQLite theoretically improve the
performance of the db if used by multiple processes? The application in
particular is Apache using pre-fork processes accessing the same db.
The info at http://www.sqlite.org/sharedcache.html seems to indicate it
could
Hi,
I'm looking into adding cache statistics (at the pager level) to SQLite
to try to better understand how often SQLite is 'hitting' the disk for a
particular application. Two ways I've considered doing this are:
1. Add a static array to SQLite and populate from function
'pagerAcquire'. -
On Jan 24, 2008 4:03 PM, Doug <[EMAIL PROTECTED]> wrote:
> I don't know of a daemon, but based on someone else's post where they
> described keeping a pool of sqlite3* handles to the database, and always
> reusing the most recently used handle first (so that the SQLite page cache
> is most likely
Hi,
Is there any limitation on the number of elements in IN clause ?
Thanks.
Felix Radensky
Embedded Solutions Ltd.
drh-2 wrote:
>
> Jerry Krinock <[EMAIL PROTECTED]> wrote:
>> My query:
>>
>> DELETE FROM `table1` WHERE (`id`=1 OR `id`=2 OR `id`=3 OR ... OR `id`=N)
>>
>> using the C API.
I don't know of a daemon, but based on someone else's post where they
described keeping a pool of sqlite3* handles to the database, and always
reusing the most recently used handle first (so that the SQLite page cache
is most likely still valid) I saw a very big jump in performance.
Perhaps
You're right, % is standard. MS Access used * and more recently supports
both * and %. I'm not aware of any other DB that supports using * as
wildcard for LIKE.
It's in the docs, but is kinda buried in the middle of this page:
http://sqlite.org/lang_expr.html
Sam
Hello All,
I've used SQLite for half of year and find it perfect.
But for my case (web-site) there is a gap in feature like cache.
I know that file-system cache do a lot of work for SQLite, but it is
still not perfect.
For example IMHO it's possible to crate something like "daemon" which will be
As usual your answer is perfect in explanation!
Thank you very much.
On Jan 24, 2008 2:49 AM, <[EMAIL PROTECTED]> wrote:
> "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > Hello All,
> > I've found that SQLite-3.5.4 doesnt use index in this situation:
> >
> > sqlite> create table t1 (id int
Pavel Kosina <[EMAIL PROTECTED]> wrote:
I was still trying "*jup*"
You are thinking about GLOB. This should work too:
SELECT * FROM some WHERE xyz GLOB '*jup*'
Could you show me documentation page, where this is mentioned?
http://sqlite.org/lang_expr.html
Igor Tandetnik
Oh I have no idea. I thought LIKE with '%' was a standard, % being the wildcard.
/Jonas
On Jan 24, 2008 1:25 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote:
> I was still trying "*jup*"
> Could you show me documentation page, where this is mentioned?
>
> Pavel Kosina
>
>
>
> Jonas Sandman
On Jan 23, 2008, at 10:07 PM, [EMAIL PROTECTED] wrote:
I have been trying to implement the paradigm of using Triggers to
emulate referential integrity, for example cascading updates and
deletes between two database tables. This works when the two
database tables are in “main” but when I try
1. SELECT * FROM some WHERE xyz LIKE '%jup%'
2. SELECT * FROM SOME WHERE zyx LIKE 'jul%'
should work.
On Jan 24, 2008 12:44 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote:
> Hello,
>
> How to do following queries?:
>
> 1/ select * from some where xyz CONTAINS "jup" (anywhere in xyz could be
> text
Hello,
How to do following queries?:
1/ select * from some where xyz CONTAINS "jup" (anywhere in xyz could be
text "jup")
2/ select * from some where xyz STARTSWITH "jup" (the xyz starts with "jup")
Thank you.
--
Pavel Kosina
44 matches
Mail list logo