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 unde
case-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
d of data update 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:
> Buildi
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,
&g
essible 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
I have a custom collation which worked well in 3.3.6,
but now gives random errors on 3.3.13. Might just be
coincidence but wanted to get feedback from the
community.
Under random circumstances, my Delphi function
(compare function defined in sqlite3_create_collation)
doesn't seem to receive the r
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 <
--- 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
> tab
BY country_id,lastname 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
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 fo
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
e.
Has anybody done anything like this?
jp
lways UTC).
Easy to 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
le, searching 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
so that the selected 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
#x27;)", where x is the inner 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
t; instead of "<"
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 ci
50)
UNION
-- get names matching search criteria plus 50 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
