The problem with your suggestion of 'two uses => two fields' is that no sooner
do you do that then somebody comes up with additional uses, for example, formal
greeting, informal greeting, the appropriate form for government form X123, and
so on
John Hascall
IT Services
Io
This is a really terrible idea. It is dependent on the internals of sqlite
which makes it extremely fragile.
Have you profiled your code to show that this is your bottleneck? If so,
it's still a terrible idea,
but at least has some basis for considering the idea.
John
On Wed, Sep 24, 2014 at 8:
Is the approach of 'just try it and if it goes badly fix it' doable?
mid = (lo + hi) / 2;
if ((mid <= lo) || (mid >= hi)) {
Fix it
}
John Hascall
IT Services
Iowa State Univ.
> On Sep 24, 2014, at 11:49 AM, RSmith wrote:
>
> I'm trying to find what the lim
Would dropping the non-functioning default clause from the schema be a
"breaking change"?
That is from:
# sqlite3 dummy.db
sqlite> CREATE TABLE x(
...> id INTEGER PRIMARY KEY DEFAULT (random()),
...> val VARCHAR
...> );
sqlite> .schema
CREATE TABLE x(
*id INTEG
I think his point was:
illegal to create a view referring to a non-existing table
AND
illegal to later create a situation where you have a view referring to a
non-existing table
is logical
legal to create a view referring to a non-existing table
AND
legal to later create a situation where you hav
You got bit by integer division...
asw-1# {773} *sqlite3*
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> *select round(133.0/122000.0,10) as t;*
0.0010901639
sqlite>
BTW, there are other tools for simple math...
asw-1# {772} *bc -l*
*sc
Some code you may find useful to enforce the readonly byte (do this before
your program opens the DB).
John
#include
#include
#define
int setRObyte (
const char * sqDBfn
) {
int fd = open(sqDBfn, O_WRONLY, 0);
int rc = -1;
if (fd == -1) return
Well some keystroke I hit apparently made the stupid browser send that
before I finished editing it, but you get the idea
Sigh,
John
On Tue, Oct 14, 2014 at 9:12 AM, John Hascall wrote:
> Some code you may find useful to enforce the readonly byte (do this before
> your program ope
If you do
ORDER BY t1c.t1_id, t1c.id;
then you won't have the b-tree step, but including the name fields means
it has the extra work to do to satisfy your order by. Or am I missing
something?
John
On Sun, Nov 16, 2014 at 1:18 PM, Oliver Smith wrote:
> In the following scenario:
>
>
See also http://www.sqlite.org/pragma.html#pragma_encoding
John
On Tue, Nov 18, 2014 at 4:42 AM, ARVIND KUMAR
wrote:
> Hi,
>
> I am using SQLite version 3.8.7.1
>
> I am not able to insert Hindi Language into table. So please help me
> regarding this.
>
> May you send me the table structure and
10 matches
Mail list logo