what encoding does sqlite_exec() callback function receive data in ?
some tests i've done seem to suggest UTF-8
other tests show chars U+80 to U+FF are returned as single chars with
values 128-255. (suggesting its not UTF-8)
where is *any* documentation about this?
--
Not sent from an iPhon
problem:
SQL error: no such table: input_queue
but when i check it using the commandline app, its clearly there.
i just created another table called 'test' with 1 col of integers and
inserted '34'and it .dumps OK (using the command line app)
but says :SQL error: no such table: test
ha
Oh, it created one in the cwd, not the place where i thought the DB
should be...
is there a way to turn that 'feature' off, so that i can prevent that
from happening, i'd prefer just an error.
Will Leshner wrote:
On 9/21/06, AJ <[EMAIL PROTECTED]> wrote:
any
I hackish method might be something like this:
struct s
{
...
};
struct s myS;
char buf[sizeof(s)*2]; // *2 as base64 encoding will be approx 33% bigger.
base64_encode( &myS, buf, sizeof(s) );
INSERT INTO table ( myTextField ) VALUES ( 'buf' );
then retrieval is the opposite.
Narendran wrote:
thanks a lot,
I believe i can store a structure now, but there is still a cache . I am in
the process on creating a Independant API,I can store a structure in SQLite
thro the above specified ways. what if some one else wants to use my API's
which i used to create the DBI's ,and
use your chosen OS's reader/writer locks per user.
Some additional info
User (Client App) connects to middle-tier application-server and then user
may access any one company in normal or exclusive mode. Only
application-server communicates with database. If user wants exclusive
access, Applic
I would like to use math with more then one table, for example
I know how to do this
(Factors & Potential = columns)
UPDATE Records
SET Factors= (Factors * Potential)
but i don't know how with an additional table, i came up with
UPDATE Records,Table2
SET Factors= (Factors * Potential Table2
Defragging the database just removes empty pages making the database
file smaller. It doesn't actually touch any data.
Have a look here:
http://www.sqlite.org/lang.html#vacuum
AJ
On Tue, 28 Dec 2004 17:30:10 +0100, D.W. <[EMAIL PROTECTED]> wrote:
> I have deleted some objects
I have 6, too. Haven't been able to get rid of them :) If you want
them, you're more than welcome to have them.
AJ
On Wed, 29 Dec 2004 17:03:28 +0100, Nemanja Corlija <[EMAIL PROTECTED]> wrote:
> If somebody didn't get an Gmail invite from Joseph, I have 4 more to
>
It is an auto-response email generated because Stiaan is(was)
apparently subscribed to this mailing list at one point.
On Sat, 01 Jan 2005 16:15:56 +0200, Ahmet Aksoy <[EMAIL PROTECTED]> wrote:
> Hi,
> When I send a message to the group, I get the following message.
> What is it? Who is Stiaan? W
on-obvious in the Python package, and
since I haven't done the experiment, I don't know to what extent that would
help.
Thank you for any insight into this. The database is working fine as-is,
but I am trying to see for the sake of convenience and education if I
compiled Python version, but for my own personal
projects I will try to fiddle with attach. The ability to split the database
into multiple files will come in handy if I end up tackling anything larger.
-AJ
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
my integer table. This makes up some of the
difference. These rows are probably on the order of 200-300 bytes each so if
I do the math, something in the 210-250 gb range seems reasonable.
-AJ
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sq
Ah, this tool seems very handy. For those curious, I'll paste the results
below. The index approximately doubles the storage size, but I am
intentionally making that tradeoff to avoid the slow down when enforcing a
unique/primary key on the Reference table while inserting.
-AJ
/** Disk-
fts4(content="", a, b, c);
CREATE VIRTUAL TABLE fts USING fts4(content="data", name TEXT, path TEXT);
Result:
unrecognized parameter: content=""
Was this never implemented? Is it deprecated? Does it require special build
options? Any thoughts?
AJ ONeal
___
do it like this
sqlite3 -init meta-fts.table.sql meta-fts-new.sqlite3
where `meta-fts.table.sql` is https://gist.github.com/3154874
wget
https://raw.github.com/gist/3154874/8f582883d62c82aeafed5eabf639e603ec1ac379/meta-fts.table.sql
Then it throws the error.
AJ ONeal
On Fri, Jul 20, 2012 at 11:34
While I respect that many users will want to implement a custom solution,
it seems that the solutions mentioned solve the 90/10 problem.
If not, to whom should I propose that the 'good enough' functions mentioned
in the documentation should be part of the stan
rk again.
And when I go back to the previous terminal window it fails again.
What about my terminal session / environment might be contributing to this
behavior?
AJ ONeal
On Sat, Jul 21, 2012 at 12:48 AM, AJ ONeal wrote:
> I'm on OS X
>
> brew install sqlite3
#
which sqlite3
/usr/local/bin/sqlite3
It appears that the original version of sqlite3 that shipped with OS X is
still in the PATH of the old terminal, but the new one installed with brew
in loaded in the new on.
Thanks for helping me figure this out!
AJ ONeal
On Sat, Jul 21, 2012 at 1:11 AM
using the right
search terms to find it.
AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
That example isn't from a 3rd party. It's the rank function listed here:
http://www.sqlite.org/fts3.html#appendix_a
Can you give me a link to documentation for what options to pass to gcc and
what functions to call to activate such an extension?
I've never done this before.
A
search terms I used were 'sqlite3 loadable extensions'.
The search terms that I was using before were things like 'sqlite3 custom
function' and 'sqlite3 user extension'.
Luckily one of my searches lead me to a forum which
.
AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ack an empty string.
SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction';
returns two empty strings
sqlite3 --version
3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc
AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> matchinfo returns a blob. Try running "hex(matchinfo(t1))" so that you can
> see the blob content.
Now I see a number which matches my expectations:
SELECT hex(matchinfo(t1)) FROM t1 WHERE t1 MATCH 'default transaction
"these semantics"';
0300020001000300020001000
be used.
I imagine that most users who are following this documentation for the
first time are using the sqlite3 binary and following along by copying and
pasting the examples.
AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
0000000100010001000000
AJ ONeal
On Sat, Jul 21, 2012 at 2:06 PM, AJ ONeal wrote:
> > Now I see a number which matches my expectations:
>> > SELECT hex(matchinfo(t1))
should be
used.
AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
sqlite3_create_function(db, "testfn", -1, SQLITE_ANY, 0, testfn, 0, 0);
testfn("1", "2", "3"); -- nVal is 3
testfn("1", "2"); -- nVal is 2
testfn(matchinfo(documents)); -- nVal is 1
testfn(matchinfo(documents), 2, 3, 4,
(documents))
Seems that it would be best to assign a default weight of 1 if nVal == 1 or
the double value of apVal[1] otherwise.
Also the line
double weight = sqlite3_value_double(apVal[iCol+1]);
should be simplified to:
double weight = sqlite3_value_double(apVal[1]);
AJ ONeal
I also found an error in the signedness of ints (using -Wall -Werror).
The corrected code here functions as described in the documentation's
example:
https://github.com/coolaj86/sqlite3-fts4-rank/blob/master/fts4-rank.c#L59
AJ ONeal
On Sat, Jul 21, 2012 at 4:39 PM, AJ ONeal wrote:
>
rint
native objects when they are to be represented as text.
What about that paragraph indicates that the sqlite3 cli doesn't know how
to pretty-print understand its own native types?
AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
see looks like, it's been
hand-formatted for easy-reading
But y'all do whatcha gon' do.
AJ ONeal
On Sat, Jul 21, 2012 at 6:22 PM, Pavel Ivanov wrote:
> On Sat, Jul 21, 2012 at 7:35 PM, AJ ONeal wrote:
> >>
> >> Read the documentation carefully:
> >>
the case
that a column isn't supplied it makes sense to use a default weight of 1.0
if the weights aren't supplied.
AJ ONeal
On Sat, Jul 21, 2012 at 5:27 PM, AJ ONeal wrote:
> I also found an error in the signedness of ints (using -Wall -Werror).
>
> The corrected cod
postfixes changed to _au and _ad.
CREATE TRIGGER t2_au AFTER UPDATE ON t2 BEGIN
INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
END;
CREATE TRIGGER t2_ad AFTER INSERT ON t2 BEGIN
INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
END;
AJ ONeal
35 matches
Mail list logo