Hello,
I have encountered the same problem as this: https://stackoverflow.com/q/4925084
The answers don't explain why there is a bitness difference at run-time between
the types retrieved from INT and INTEGER columns, and that's my question. From
reading https://sqlite.org/datatype3.html I
-insensitive and characters with
diacritics sorts. For example:
AAA
amigo
ándale
Andalucía
ángel
Azul
Now I need to have this function, CompareStringA or
similar/better, on linux. Does anybody have it or can
point me where to look for it?
jp
e routines.
Wouldn't it be nice to say that the sqlite reader
version is only 128k (or less)? Also, in theory,
since it doesn't have to worry about locks,
transactions, synchrounous=off, etc., shouldn't it run
even faster?
jp
--- [EMAIL PROTECTED] wrote:
> Building a read-only version of S
think sqlite
could have a "sqlite reader", suitable when you just
want to deploy the database.
Ideas, anyone?
jp
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arr
Thanks Ralf, that seems to be more stable - the
process is not crashing anymore (ran it twice, no
errors).
Pardon my ignorance - I am still using cdecl, how can
I use 'register'? Doesn't sqlite expects cdecl?
jp
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> Hello jp,
>
> with D
ible within the
> > sqlite3 shell command?
> >
> > Thanks,
> > Tom
>
> This requires that you produce a custom version of
> the sqlite3 shell
> incorporating the extra functions. That requires
> some basic programming
> understanding.
I think you can compi
nd NOCASE
collation.
Does anybody have similar experiences or have a clue
of what might be going on? The error happens after
processing several thousand records, but sometimes
happens on an INSERT, other times during a SELECT, and
never in exactly the same place (even with the same
set of
Thanks all! This worked (winxp, sqlite 3.3.13) and
does use the index:
> SELECT lastname FROM people
> WHERE country_id='US' AND lastname COLLATE
> mycollate >'A'
> ORDER BY country_id,lastname COLLATE mycollate
> LIMIT 100;
jp
--- Dennis Cote <[EMAIL PROTECTED]&g
--- Dan Kennedy <[EMAIL PROTECTED]> wrote:
>
>
> On Thu, 2007-03-01 at 15:13 -0800, jp wrote:
> > Hi, I have a custom collation sequence (e.g.
> > mycollate). Are there any advantages in terms of
> > performance of declaring this collation at the
&
ame COLLATE mycollate
LIMIT 100;
- - - - - -
I want to separate the table definition from the
search/query/sort order, to have the flexibility of
creating/dropping indexes as needed for different
collations depending on the user's locale.
, then
export to a separate database (zip it). On clients, apply the changes.
500k records don't say much - how big (in MB) is your DB? I can also
suggesst changing just the FTP site to another ISP who has unlimited (or
a very large GB monthly limit).
jp.
Juan Perez wrote:
(excuse me
Has anybody tried to estimate how many end-users are using sqlite? This
would include actual firefox users and users of any other product that
uses sqlite.
Somebody asked me, "how many people are using sqlite" (or sqlite based
produ
know of a PRAGMA or directive or method to disable
the usage of a custom collation once created? or a way to drop it?
jp.
I don't know if it is a bug or works as designed, but, should VACUUM be
changing the format of the DB?
I created a database with sqlite 3.2.7, and after a VACUUM in sqlite
3.3.6 I could no longer open it in the older program - error message #1,
unsupported file format.
jp
nybody done anything like this?
jp
o sort, easy to search, easy to handle, and very portable. I do
have to create routines in the particular programming language to do the
conversion, data entry and formatting, but it saves me a lot of work
knowing that storage is always the same.
jp
ing for Zach takes longer than
searching for Abigail. It seems it is not using any index, but rather
doing a record by record sweep on the 'count'.
jp
list # item
corresponds to 'foo'.
Any ideas?
jp
Sounds like an interesting setup! Maybe off topic, but, would you care
to elaborate on that topic? Server configuration, virtualization
software running, etc.?
[EMAIL PROTECTED] wrote:
Lenster <[EMAIL PROTECTED]> wrote:
The application needs to be available to about twenty users on a daily
select:
select * from mytable where name >= Coalesce(
(select name from mytable where name < 'A'
order by name desc limit 1 offset 50)
,'')
order by name limit 101;
This works well on the full range.
Thanks all!
jp
<"
and added an "order by" to the first one ("order is never guaranteed
unless specifically declared").
Using a UNION of those two SELECTs does not work in 3.3.4 (bug?).
Executing them separately does work.
Thanks,
jp.
Ulrik Petersen wrote:
Hi JP,
JP wrote:
Anyway, maybe separate topic, I tried to create a "snapshot" window of
the above using plain SQL, but it doesn't seem to work on Sqlite 3.3.4:
CREATE TABLE clients (custid integer primary key, lastname varchar(50));
CREATE INDEX cidx ON
more
SELECT '2' as idx,lastname
FROM (select lastname from customers where lastname>='sprenkle'
ORDER BY lastname ASC LIMIT 50)
)
order by 1,2;
Individually, the queries work fine. In UNION, each seems to lose the
inner order clause and show innacurate results.
jp
nything
similar?
jp
24 matches
Mail list logo