Ah I see now. Thank you Keith!
Tom
Message: 14
Date: Tue, 04 Feb 2020 14:57:06 -0700
From: "Keith Medcalf"
To: "SQLite mailing list"
Subject: Re: [sqlite] unsafe use of virtual table
Message-ID: <62147479ae781d49902e13c3c23a3...@mail.dessus.com>
Content-Type: text/pla
Hi,
I have noticed a change between 3.30 and 3.31.1 and searched for more
info on "unsafe use of virtual table" on sqlite.org but could not find
anything relevant.
In 3.30:
SQLite version 3.30.0 2019-10-04 15:03:17
Enter ".help" for usage hints.
Connected to a transient in-
Hi,
The Release date of SQLite 3.30.1 is listed on your website as
2019-10-11, but the SQLite shell, as well as the SQLITE_SOURCE_ID
constant, say it is 2019-10-10 20:19:45.
Is this a typo on your website?
https://sqlite.org/index.html
https://sqlite.org/chronology.html
SQLite version 3.30.1
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
sqlite-users@mailinglists.sqlite.org wrote:
> It's quite often (for me, at least) the case I need to do something like this
> from the command line:
>
> >sqlite3.exe my.db "insert into t values(`simple field','multi-line text
> >copied
> >from som
sqlite-users@mailinglists.sqlite.org wrote:
> Your schema implies that there can be more than one TIME for any GNAME and AN
> combination (otherwise the primary key would not need to include alle three
> fields). This contradicts your statement that AN and TIME are "the
uot; will be the same order.
(I also have a table "ART" where "AN" is the rowid, and again the order by
"TIME" will be the same order.)
How can you make SQLite to make that assumption in order to optimize the query?
(It should be done presumably without adding another
the integer primary key:
CREATE TABLE t(rowid integer primary key);
insert into t values(15);
select rowid, oid from t;
Results:
15|15
Thanks,
Tom
_______
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Ah I see now. Sorry I should have read the docs more carefully -- it is working
according to spec in all cases.
Great answers. Thanks guys!
Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin
particular
database.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
lang_expr.html, and lang_select.html mention window functions at all
except as part of the syntax diagram in lang_expr.html (although window
definitions are also mentioned in lang_select.html, not window functions)
___
sqlite-users mailing li
if it doesn't already.
_______
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
we could see was a
reference to a very, very old and outdated page
(https://sqlite.org/speed.html) which talks about speed and at the
bottom of that page the comments
"SQLite is slower than the other databases when it comes to dropping
tables. This probably is because when SQLite drops
Hi
I'm trying to build the SQLite packages from the source. I **only** want
it to get a copy of sqlite_analyse which for some reason doesn't appear
to be easily available as a compiled option. The download package
doesn't work on Ubuntu 16.04 and as far as we can see, ther
rgc,char**argv) {
if(argc!=3) return 1;
if(sqlite3_open(":memory:",&db)) return 1;
count=strtol(argv[1],0,0);
sqlite3_set_authorizer(db,xAuth,0);
printf("%d\n",sqlite3_exec(db,argv[2],0,0,0));
return 0;
}
___
sqlite-users
ting the sqlite3_interrupted() function (or whatever you want to call
it) should be very easy to implement. However, it must be added into the
extension loading mechanism, so if I do it by myself then it will be
incompatible.
___
sqlite-users mailing list
sqli
The documentation for the xCreate and xConnect methods for virtual tables give
the incorrect type.
It says "char**argv" but the actual type should be "const char*const*argv".
___
sqlite-users mailing list
sqlite-users@mailingl
11. How to test the build? Testers needed and a test plan needs to be
put together. SQLite has an excellent reputation, this shouldn't sully
it.
12. Profit?
Just my 2p worth,
Rob
On 13 Jun 2018, at 19:59, Richard Hipp wrote:
Cross-posted to the fossil-users mailing list since www.fos
s a table name within the select_stmt. Both of these
are separate from table-valued functions (parameterized views) though.
_______
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I have some proposals for feature requests for virtual table mechanism of
SQLite. Some of this can be useful when accessing remote data over the
internet or whatever. Here is the list:
* A new method "xInterrupt", called when sqlite3_interrupt() is called.
This can be used to cancel
761D8
MetadataHash=-1228563750
COM32on64.exe is VB6 ActiveX exe that loads my VB6 dll. This is needed as
this dll is called from 64 bits Excel and that can't access that 32 bit VB6
dll the
normal way. This loading of the VB6 dll via COM32on64.exe is not the
problem as the dll works all fine, until i
Thanks for the infos.
__
If you reply to this email, your message will be added to the discussion below:
http://sqlite.1065341.n5.nabble.com/How-to-search-for-fields-with-accents-in-UTF-8-data-tp96249p96294.html
This email was sent by Winfried (via Nabble
lite3_reset(ins);
sqlite3_bind_blob(sel,1,"test",4,NULL);
if(SQLITE_ROW != sqlite3_step(sel)) {
printf("no results? %s\n",sqlite3_errmsg(db));
} else {
printf("Got ID %d\n",sqlite3_column_int(sel,0));
}
return 0;
}
-
_reset(ins);
sqlite3_bind_blob(sel,1,"test",4,NULL);
if(SQLITE_ROW != sqlite3_step(sel)) {
printf("no results? %s\n",sqlite3_errmsg(db));
} else {
printf("Got ID %d\n",sqlite3_column_int(sel,0));
}
sqlite3_reset(sel);
return 0;
}
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 29 October 2015 at 09:46, SQLite mailing list <
sqlite-users at mailinglists.sqlite.org> wrote:
>
> which I understood to mean, "if you can represent it in decimal, you
> can represent it in binary". I didn't think that was true, but there
> seemed to be concen
On Wed, Oct 28, 2015 at 6:52 PM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> Effective immediately, the sender email address for mailing list posts
> will be elided. All replies must go back to the mailing list itself.
>
Please
On 29 Oct 2015, at 2:09am, SQLite mailing list wrote:
> The consensus was the other way: "If you can represent it in binary, you
> can represent it in decimal."
Well that one is actually true. If you can represent any non-recurring
fraction in binary, in decimal it's a n
gt; > binary floating-point values and back into decimal strings.
>
> > -scott
>
>This explains the deficiency in the SQLite print function, but it doesn't
>have to be that way.
>
>See: Steele, Jr., Guy L., and White, Jon L. How to print floating-point
>numbers acc
I think I received about four, which I removed in a couple of seconds.
Obviously it is a problem, but I don't think it calls for a change that
makes it impossible to see the sender of each message. I always open
messages from the SqLite developers sort of by default, for instance,
which
On 28 Oct 2015, at 11:23pm, SQLite mailing list wrote:
> This can't possibly work. "Fuzzy equality" is not transitive (x is close
> enough to y, y is close enough to z, but x is just far enough from z to be
> non-equal), which would break any indexing scheme.
Oh c
On Thu, 29 Oct 2015 10:09:28 +0800
SQLite mailing list wrote:
> The consensus was the other way: "If you can represent it in binary,
> you can represent it in decimal."
Gah, I see now. Thank you for the clarification.
--jkl
Sorry, I missed out my point:
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> CREATE TABLE t(r REAL PRIMARY KEY,t TEXT);
sqlite> INSERT INTO t VALUES (21.0,'twenty one point zero');
sqlite> INSERT INTO t VALUES (9.2+7.9+0+1.0+1.
On 2015-10-28 10:34 PM, SQLite mailing list wrote:
> On 10/28/15, SQLite mailing list
> wrote:
>> This is ridiculous. I know how to handle spam. I can do nothing
>> about not knowing who sent these emails.
>>
> One thing you could do is add a signature line, to te
On 28 Oct 2015, at 10:34pm, SQLite mailing list wrote:
> This explains the deficiency in the SQLite print function, but it doesn't
> have to be that way.
I'm with a previous poster. SQLite is primarily a database system. Its
primary jobs are storage and retrieval. It sho
Yeah. Let's not admit defeat to a lone a**hole. My spam filter is bored
anyway -- let's give it something to do.
Eric
Sent from my iPhone
> On Oct 28, 2015, at 19:12, SQLite mailing list mailinglists.sqlite.org> wrote:
>
> I agree. This cure is worse than the dise
minor inconvenience and the solution imposed
is much more of a PITA than she was.
On 28 October 2015 at 20:34, SQLite mailing list
wrote:
> On 10/28/15, SQLite mailing list
> wrote:
>>
>> This is ridiculous. I know how to handle spam. I can do nothing
>> about no
On Wed, 28 Oct 2015 17:52:25 + Simon wrote:
> On 28 Oct 2015, at 5:08pm, James K. Lowden
> wrote:
>
> > If we accept what you say, above, then why should
> >
> >> (9.2+7.8+0+3.0+1.3+1.7)
> >
> > in particular present any problem? There's no division. Each value
> > has an exact decimal
On Wed, Oct 28, 2015 at 9:08 PM, SQLite
wrote:
>
> On 28 Oct 2015, at 7:36pm, General Discussion of SQLite Database
> wrote:
>
>> Has anybody received email from Alexa since the policy change? I have
>> not
>
> Nor me. I reliably got one for every post I ma
On 10/28/2015 7:25 PM, SQLite mailing list wrote:
> On 28 Oct 2015, at 11:23pm, SQLite mailing list mailinglists.sqlite.org> wrote:
>
>> This can't possibly work. "Fuzzy equality" is not transitive (x is close
>> enough to y, y is close enough to z, but x is
On 28 Oct 2015, at 7:36pm, General Discussion of SQLite Database wrote:
> Has anybody received email from Alexa since the policy change? I have not
Nor me. I reliably got one for every post I made for about a week before the
change.
Simon.
Actually looking at this thread (in gmail) since the policy change is
a very retrograde step - all messages are displayed as from SQLite.
There are numerous scenarios where I want to see the name of the
sender (not necessarily the email address) so that I can pick and
choose which messages I
: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence
On 28 October 2015 at 19:42, SQLite
wrote:
> On Wed, Oct 28, 2015 at 11:22 AM, General Discussion
On 10/28/2015 6:52 PM, SQLite mailing list wrote:
> However, I would support improvement in its floating point calculations,
> including implementing 'slop' in testing for equality. This is not only for
> use when expressions include the equal sign, but also for cases whe
On 28.10.2015 18:52, General Discussion of SQLite Database wrote:
> Hence, we have token the radical approach of denying the sender email
> address to*everyone*.
Could you preserve the sender's name in the from header instead of
substituting the generic "General Discussion of
On Wed, Oct 28, 2015 at 6:29 PM, SQLite mailing list <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 10/28/2015 7:25 PM, SQLite mailing list wrote:
>
>> On 28 Oct 2015, at 11:23pm, SQLite mailing list <
>> sqlite-users at mailinglists.sqlite.org> wrote:
decimal strings.
>
> -scott
This explains the deficiency in the SQLite print function, but it doesn't
have to be that way.
See: Steele, Jr., Guy L., and White, Jon L. How to print floating-point
numbers accurately. In Proc. ACM SIGPLAN ?90 Conf. Prog. Lang. Design and
Implementation. ACM (White P
>
> Could you preserve the sender's name in the from header instead of
> substituting the generic "General Discussion of SQLite Database"?
>
> This would make it possible to automatically highlight messages by
> author, i.e. the SQLite dev team.
I second t
On 28 Oct 2015, at 5:52pm, General Discussion of SQLite Database wrote:
> All replies must go back to the mailing list itself.
Erm ... just a warning from an experienced mailadmin. If you do this exactly
the way you described they can trigger an endless loop of spam just by
subscrib
On 28 Oct 2015, at 5:08pm, James K. Lowden wrote:
> If we accept what you say, above, then why should
>
>> (9.2+7.8+0+3.0+1.3+1.7)
>
> in particular present any problem? There's no division. Each value
> has an exact decimal representation.
You didn't work it out yourself, did you ?
0.2 i
>> (9.2+7.8+0+3.0+1.3+1.7)
>in particular present any problem? There's no division. Each value
>has an exact decimal representation. I'm prepared to assert that any
>permutation of their sums also has an exact decimal representation.
>Therefore they should have an exact binary representation,
> Has anybody received email from Alexa since the policy change? I have
> not
I have never received any ... presumably Alexa's MTA (s if more than one) is
blacklisted ...
On 10/28/15, SQLite mailing list
wrote:
>
> This is ridiculous. I know how to handle spam. I can do nothing
> about not knowing who sent these emails.
>
One thing you could do is add a signature line, to tell the rest of us
who you are :-)
--
D. Richard Hipp
drh at sqlite.org
I agree. This cure is worse than the disease.
At least for now (from the 2 I got) the Alexa sender address was constant and
can be blacklisted. Regardless of how Alexa got our email addresses, they have
them and can send spam like any spammer.
-- Darren Duncan
On 2015-10-28 2:50 PM, SQLite
On Wed, Oct 28, 2015 at 3:52 PM, SQLite mailing list <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 28 Oct 2015, at 10:34pm, SQLite mailing list <
> sqlite-users at mailinglists.sqlite.org> wrote:
> > This explains the deficiency in the SQLite print function, but i
On 10/28/15, General Discussion of SQLite Database
wrote:
> On 2015-10-28 10:52 AM, General Discussion of SQLite Database wrote:
>> The reason for this change is to combat the "Alexa" spam. For the
>> past few weeks, whenever anybody posts to the mailing list, that
&g
On Wed, Oct 28, 2015 at 1:46 PM, SQLite <
sqlite-users at mailinglists.sqlite.org> wrote:
> Is this over-reacting a bit. I have had one email from alexa (about
> 3/4 weeks ago). If it starts to become a real problem then do
> something about it - until then I would think w
Effective immediately, the sender email address for mailing list posts
will be elided. All replies must go back to the mailing list itself.
The reason for this change is to combat the "Alexa" spam. For the
past few weeks, whenever anybody posts to the mailing list, that
person gets a reply from
On Wed, Oct 28, 2015 at 1:32 PM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 2015-10-28 10:52 AM, General Discussion of SQLite Database wrote:
>
>> The reason for this change is to combat the "Alexa" spam. For the
On Wed, Oct 28, 2015 at 11:22 AM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 28.10.2015 18:52, General Discussion of SQLite Database wrote:
>
>> Hence, we have token the radical approach of denying the sender email
>
On 2015-10-28 10:52 AM, General Discussion of SQLite Database wrote:
> The reason for this change is to combat the "Alexa" spam. For the
> past few weeks, whenever anybody posts to the mailing list, that
> person gets a reply from "Alexa"...
While that was often the
On 2015-10-28 11:25 AM, General Discussion of SQLite Database wrote:
>>
>> Could you preserve the sender's name in the from header instead of
>> substituting the generic "General Discussion of SQLite Database"?
>>
>> This would make it possible to autom
On Wed, Oct 28, 2015 at 10:08 AM, James K. Lowden
wrote:
> On Fri, 23 Oct 2015 10:43:44 -0700 Scott Hess wrote:
> > You're right, any base-2 representation right of the decimal should be
> > precise to represent in base-10. But it's the kind of thing where if
> > you find yourself counting on i
Hi, everyone.
I've been auditing the OpenBSD codebase for calls to ctype functions
with potentially signed chars. This is undefined on some platforms. I
found a number of instances in Sqlite, so I cloned your repo and ran my
script on it.
Here's the relevant CERT entry:
; Tue Aug 25 2015 19:45:27 CEST from "Simon Slavin"
>Subject: Re: [sqlite] Why sqlite show qualified column names when selecting
>from views ?
>
> On 25 Aug 2015, at 6:13pm, sqlite-mail wrote:
>
>
>>When querying views sqlite shows qualified column names if
Hello !
When querying views sqlite shows qualified column names if they are specified
individually.
Is this the expected result or a bug ?
This behavior breaks some of my code that uses column names for other
purposes.
Cheers !
output of "test-view-alias"
SQL: SELEC
eric user
defined functions.
Anyone have any idea about this ?
?
Cheers !
?
> Sat Aug 22 2015 13:01:32 CEST from "Richard Hipp"
>Subject: Re: [sqlite] There is any reason to sqlite not expand "*" in
>function calls ?
>
> On 8/22/15, sqlite-mail wrote:
>
Hello !
I'm testing the new json functions and when I tried this:
select json_array(*) as json from one_table;
I've got :
[]
[]
..
Then I tried with some custom functions accepting variable number of
parameters and realize that "*" is not expanded for function calls.
There i
That's why I think that expose a basic SQL ANSI catalog would make this kind
of work and others a lot easier.
?
> Fri Aug 21 2015 22:13:00 CEST from "Simon Slavin"
>Subject: Re: [sqlite] Is this a bug ? How to rename a table and all
>dependencies ?
>
> On
Thank you for your attention !
I'm pointing this here because postgresql do manage this case properly !
And I'm creating a tool to prototype database applications and I'm using
sqlite as the primary database, when we are prototyping things can change
drastically at any
Thanks for your attention!
Only to remark on this I tested on postgresql and somehow it knows how deal
with it ! "so few (none?)"
Cheers !
?
> Fri Aug 21 2015 19:08:58 CEST from "J Decker" Subject:
>Re: [sqlite] Is this a bug ? How to rename a table and all
Then do you think this is a bug ?
> Fri Aug 21 2015 18:57:33 CEST from "Simon Slavin"
>Subject: Re: [sqlite] Is this a bug ? How to rename a table and all
>dependencies ?
>
> On 21 Aug 2015, at 12:20pm, sqlite-mail wrote:
>
>
>>Does anybody kno
Thank you !
That's what I want and looking back in the sqlite documentation I can see now
that I was misinterpreting it, in reality I was applying the same principle
used on other places to qualify/prefix tables/views/... objects but with your
help I could realize that pragmas are an exce
Hello !
Today I'm working with sqlite3 with attached databases and when I tried to
get info about a tbale using "PRAGMA TABLE_INFO" I discovered that pragmas do
not work with qualified/prefixed names like:
PRAGMA table_info(attached_db.one_table)
?
Is this a bug ?
Cheers !
Hello !
Here I'm fixing some typos and I also tested on postgresql and there all
views are updated properly then I'll say is a bug in sqlite.
Does anybody knows how to rename a table and all it's dependencies in one go
?
?
The problem: a database has several tables
BLE b(id integer primary key, a_id integer references a(id), name
text);
CREATE VIEW aview AS select * from a;
CREATE VIEW bview AS select b.*, a.name from b left join a on b.a_id =aid;
===
?
Now if we do "alter table a rename to a2;" actually sqlite only rename the
&quo
performed on
all dependent tables and that can be a lot time consuming depending on the
number of records on then.
? I've got this problem on a heavily foreign key constrained database and it
took me a bit to realize that !
Cheers !
> @nameless person known as sqlite-mail,
> Yes
Hello !
Do you have foreign keys on your tables ? And if so do you have indexes on
then ?
A database with foreign keys and no indexes can run very slow for mas
insert/update/delete ?
Cheers !
?
> Tue Aug 18 2015 12:38:51 CEST from "Paolo Bolzoni"
> Subject: Re:
Hello !
The query you mention is not the same as:
INSERT INTO table_of_intergers SELECT seqno FROM generate ORDER BY seqno;
Cheers !
> Mon Aug 17 2015 17:44:58 CEST from "John McKown"
> Subject: [sqlite] Enhance the SELECT
>statement?
>
> I use both SQLite3
traced.
This is a link to a gist on github
https://gist.github.com/mingodad/f32b680c901e360803bb
The license for this contribution is the same of sqlite.
Cheers !
====
diff -urB sqlite-src-3081101/src/loadext.c sqlite-src-3081101-2/src/loadext.c
--- sqlite-src-308110
Hello !
?
This request is a common requirement and in my opinion would be better solved
by an extension to the actual sqlite3 api functions.
?
Actually there is sqlite3_trace that can be used to watch all sql statements
executed on a given session.
?
One possible way would be to a
Hello !
Working with sqlite3 I noticed that sqlite3 ".dump", ".schema" and
".fullschema" outputs the contents of the field "sql" stored in
"sqlite_master" and if the sql statement ends with a comment the resulted
dump will be invalid see example:
=== valid sql statement stored on sqli
fullschema" with a transaction with this extended patch.
Again the same license of sqlite apply to this patch.
=patch to shell.c
--- shell.c
+++ shell.c
@@ -550,10 +550,12 @@
?? sqlite3_stmt *pStmt;?? /* Current statement if any */
?? FILE *pLog;??? /* Write log outp
Hello !
Here is a small patch that adds ".dumpdata" for "shell.c" in sqlite3.
This command should behave exactly like ".dump" but without the database
schema.
I 'm giving it with the same license as sqlite.
Cheers !
ot;sqlite3_trace_explain_query" that
would also show at high level the internal sqlite3 operations a kind of mix
of sqlite3_trace + "explain" that would give for this database example an
output like this:
---
/test-sqlite-bug
SQL: INSERT INTO "aa"("id"
d (most of then without an
index) deleting anything on res_users become a very costly operation.
It also shows that sqlite is not capable to merge table scans for the same
value on more than one column and execute several table scans (optimization
opportunity), but I'm still not s
Hello again !
I forgot also to mention that sqlite do not check for duplicates table
constraint declarations see the extended example bellow:
-
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE aa(id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE ab(id INTEGER PRIMARY KEY
> CREATE TABLE ad(id INTEGER PRIMARY KEY, name TEXT);
>
> CREATE TABLE aconstrained(
> id INTEGER PRIMARY KEY,
> a_id INTEGER NOT NULL,
> b_id INTEGER NOT NULL,
> c_id INTEGER NOT NULL,
> d_id INTEGER NOT NULL,
> CONSTRAINT constrained_fkey_aa_id FOREIGN
Hello? !
?
I'm using sqlite for a project and with this specific database
https://dev.dadbiz.es/tmp/odoo.db.zip (12MB compressed / 38MB uncompressed)
this is happening:
?
-1 Registering an sqlite3_trace function when trying to delete a record just
inserted on the table "res_users"
I don't know if it actually causes a problem, but isn't the
"?command.Dispose()" not needed? Doesn't the "using" take care of disposing?
Graham.
Sent from Samsung Mobile
Original message
From: Artem
Date: 28/04/2015 14:29 (GMT+00:00
I don't know if it will actually cause problems, but is the
"?command.Dispose()" needed? Doesn't the "using" handle disposing?
Graham
Sent from Samsung Mobile
Original message
From: Artem
Date: 28/04/2015 14:29 (GMT+00:00)
To: General
Rob van der Stel wrote:
>Hello,
>
> Currently I am investigating a SQLite performance problem that started to
> occur when we switched from using Windows XP to Windows 8.1 for our
> applications.
I don't know anything about SQLite, but faced with what you're seeing I
his case,
> For which OS platform is the generated binary?
> for 32bits win OS or 64bits win OS?
32 bits.
Charles
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
>
> Which does /not/ describe it as "The official SQLite database engine", which
> is the point I was making.
I used NuGet.
http://www.nuget.org/packages/Syst
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of RSmith
>
>
> System.DBNull is not a native SQLite construct, it is probably one of the
> third
> party connectors.
In C#, using the System.Data.Sqlite.Core package, which
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Edward Ned Harvey (sqlite)
>
> I would really love to have an easy way of putting a long? into the database,
> and then getting a long? back out. Maybe it exists and I'm just doi
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Hick Gunter
>
> Why is the column nullable if you require a default value to be returned?
The default value for long? or string or byte[] is null. Which makes pe
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Random Coder
>
> Could you not do something like this to handle the nullable types?
>
> T GetValue(string field)
> {
> object obj = reader[field];
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Joseph L. Casale
>
> > I would really love to have an easy way of putting a long? into the
> > database,
> and then getting a long? back out.
>
> What do you want to
I understand there are only 5 data types in Sqlite, and that the column type
isn't necessarily the type of object returned in a query. Is there a more
seamless way to cast responses than this?
I would really love to have an easy way of putting a long? into the database,
and then gett
c (lsm_unix.c:472)
==1741==by 0x4046C5: lsmMallocZero (lsm_mem.c:50)
==1741==by 0x404730: lsmMallocZeroRc (lsm_mem.c:69)
In a more complex program, lsm seems to leak memory to no bounds, causing my
application.
Are bug reports against LSM even helpful?
Charles
______
1 - 100 of 242 matches
Mail list logo