A few minutes ago I wrote that:
>I think that as a general rule, the "combining" accents should be disregared
>during collation.
>
> etc.
I just read that "collation" page from Unicode.org and it seems to be
completely at odds with what I suggested, e.g. in its insistence that some
sequences
>> On 17 Nov 2009, at 5:52pm, Igor Tandetnik wrote:
>>
>>> But for your goals, it has to be sortable, right? In a proper
>>> Unicode collation, U+0041 U+0301 would behave quite differently from
>>> U+0301 U+0041. Consider "A ' E" (where ' stands for a combining
>>> acute accent). In most locales,
>My current query looks something like this:
> SELECT tblA.someValue from tblB inner join tblA on
> tblB.fkcol = tblA.col1 where tblB.col1 = ?
>
> Couldn't it just be:
> SELECT fkcol.someValue from tblB where col1 = ?
I think you can, under
kes no difference- the
standard should not, in my opinion, be built into Sqlite. Basic software
engineering sense must still trump even the best standard.
Forgive me if I have missed something here, but this seems like what I would
call "Standardizationism" run amok.
__
> Correct, ARM's emulate hardware floating point using software.
That doesn't really say anything about compliance with standards/
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On
Behalf Of O'Neill, Owen
>I'm guessing that your hardward does not implement IEEE 754 floating
>point correctly. We've seen that sort of thing before, especially
>with GCC. There are some options to GCC (which escape my memory right
>now) that can force it to use strict IEEE 754 floating point rather
>than its
>Is it possible that the library is sorting the CUSTOMER.id list
>alphabetically not numerically, and jumping into the sorted PK list at
>the correct offset but finding the wrong value in that location as a
>result of the improper sort?
That seems plausible. But speaking as a programmer, I do not
>You could use EXPLAIN to see if there is a different query plan, but I'd
>bet there isn't. * will generally be slower, just because you usually
>won't need EVERY column. If you can specify only certain columns, that
>will save you some time.
This will "save you some time" in the sense that the
>Hello,
>
>We are trying to find an ETL tool open source. Basically, we need our
>software to perform ETL, data migration and data synchronization.
>
>The program should not be used on larger projects. A few open source tools
>are on the market.
>Some ideas? Thanks.
What is ETL?
>The point I was trying to make is that the majority of commands cygwin
>supports don't have to do any forking. They could just be method
>calls. Pipes would be parameters going in and return values coming
>out, all running in a single process. If fork() is specifically called
>in a script, then
n though both are still larger than the integer
100). But if INT simply doesn't have the necessary range, your options are
limited.
--- El mié 2-sep-09, Beau Wilkinson <b...@mtllc.us> escribió:
> De: Beau Wilkinson <b...@mtllc.us>
> Asunto: Re: [sqlite] Integer Storage class
&g
I probably wouldn't use INT for that data. I would use TEXT. My feeling is that
the data is not so much a number as it is an incoming stream of characters from
an IO device. So, I suspect code built around a TEXT column will ultimately be
more rational looking. For example, you won't have to
> I want a query language that non-techies can use easily, but also
> supports arbitrarily complex queries. Does such a language exist?
I remember reading once, in an old book about RDBMS, that SQL was intended to
be something that non-technical decision-maker types could learn in a few
hours.
>On Tue, Aug 18, 2009 at 08:28:13AM -0500, Beau Wilkinson scratched on the wall:
>> To me that seems like an annoying deviation from standard practice.
>> Do other databases support such an INSERT?
>
>Yes. MySQL, PostgreSQL, and SQLServer all support this syntax.
>
>
To me that seems like an annoying deviation from standard practice. Do other
databases support such an INSERT? Is it envisioned by standards? I suspect the
answer is "no" in both cases, and this is a classic example of how "less"
functionality is actually "more" useful.
That said, if you're in
>> 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
I think this may involve a subquery, probably in the SELECT list itself, which
uses ROWID (or ROWNUMBER... I can't remember which one is a part of the SQL
standard rather than proprietary).
From: sqlite-users-boun...@sqlite.org
pard [rshep...@appl-ecosys.com]
Sent: Monday, July 27, 2009 10:46 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What is a Relation?
On Mon, 27 Jul 2009, Beau Wilkinson wrote:
> I am dealing with such a project now. The schema consists of time stamp
> plus blob, where the
>> There are still people who just want
>> a cursor to a chunk of data which they pull in and iterate over rather than
>> use SQL's power to manage data a set-at-a-time
I am dealing with such a project now. The schema consists of time stamp plus
blob, where the blobs "map" directly to C++
I wholeheartedly agree about the importance of source control, even though my
specific advice didn't really involve that.
To the OP in particular:
How do you plan to statically link your new library into multiple projects? Are
you planning to make a copy of the code files for each C# project
n
though it introduces a very undesirable parallel maintenance burden!
-
Beau Wilkinson
Software Development Engineer, DP
MARINE TECHNOLOGIES, LLC
985-612-1313 (office)
x52913 (ECO phone)
985-705-5203 (cell)
From: sqlite-users-boun...@sqlite.org [sqlite-users-
arm a la Dr.
Strangelove to do so. What's done is done.
-
Beau Wilkinson
Software Development Engineer, DP
MARINE TECHNOLOGIES, LLC
985-612-1313 (office)
x52913 (ECO phone)
985-705-5203 (cell)
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun
ecause I'm dealing with a fairly brittle (and critical) app here, and I
want to tread lightly.
____
From: Beau Wilkinson
Sent: Tuesday, May 05, 2009 9:02 AM
To: General Discussion of SQLite Database
Subject: RE: [sqlite] sqlite3_prepare returns SQLITE_MISU
] On
Behalf Of Igor Tandetnik [itandet...@mvps.org]
Sent: Monday, May 04, 2009 5:18 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3_prepare returns SQLITE_MISUSE
Beau Wilkinson <b...@mtllc.us> wrote:
> Nevertheless, I am getting some very puzzling errors. In p
I have inherited a large Sqlite project recently. The project is
multi-threaded, but has thus far kept Sqlite calls in a single thread.
Recently, I have complicated this somewhat by adding a second thread that deals
with other, essentially independent databases. No connections, statements, etc.
25 matches
Mail list logo