Sqlite3 site says users can fix the configuration, like *scratch memory
size, shared_memory, page cache size* etc, by using Sqlite3
API(sqlite3_config). But I'm not familiar with using sqlite and dbt2(I'm
doing my school project with dbt2 benchmark on sqlite).
Before installing sqlite we first
That connection string mod doesn't seem to help. Let me know what you need from
me to clarify.
-Original Message-
From: Joe Mistachkin
Sent: 5/29/2013 9:57 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider
Eric Schneider wrote:
>
> That's. For parsing, what about inserts?
>
5/25/2013 1:18:20 PM
The new connection string property should apply to any operation that
requires
converting a string to a DateTime or vice-versa (e.g. parsing or
formatting).
When inserting a row using a parameterized
That's. For parsing, what about inserts?
-Original Message-
From: Joe Mistachkin
Sent: 5/29/2013 9:57 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE wrote:
>
> Just realized I left in the work around
eschneider FE wrote:
>
> Just realized I left in the work around code, the date issue is still a
> problem.
>
I'm still not sure exactly what the problem actually is. That being said,
I've just added a new connection string property named DateTimeFormatString
to give people full control over
Just realized I left in the work around code, the date issue is still a
problem.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of eschneider FE
Sent: Wednesday, May 29, 2013 6:26 PM
To: 'General Discussion of SQLite Database'
The default is a non-working default though.
So inserting using best practices of SQL statement & parameters does not
work, and queries also.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Wednesday,
eschneider FE wrote:
>
> Ok; re-reading last and saw connection string. So adding ;DateTimeKind=
> DateTimeKind.Utc to connection string works. Why isn't this the default?
>
Primarily because making it the default would alter the behavior in a very
subtle and non-backward compatible way.
--
Ok; re-reading last and saw connection string. So adding ;DateTimeKind=
DateTimeKind.Utc to connection string works. Why isn't this the default?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of eschneider FE
Sent: Wednesday,
I understand that Joe, but if I'm inserting using parameters; the Sqlite
.net lib is determining the format not me the developer, I'm just passing in
a DateTime. In fact other people are complaining they cannot insert using
parameters; I assume in that case the specify the check constraint.
I
eschneider FE wrote:
>
> So when using System.Data.SQLite and inserting data using a parameter of
> datetime, I believe the System.Data.SQLite .net lib is doing a ToString()
on
> datetime when it should be using a specific date format supported by
SQlite.
>
The DateTime parsing and formatting
HI Ivor.
> it doesn't matter how long and complicated a chain of
> generators you string together - you cannot make entropy where there was
>none before.
Agreed. However I have control over what rand() is seeded with (without hacking
the SQLite codebase - that would be sacrilege) and have
So when using System.Data.SQLite and inserting data using a parameter of
datetime, I believe the System.Data.SQLite .net lib is doing a ToString() on
datetime when it should be using a specific date format supported by SQlite.
-Original Message-
From: eschneider FE
> However, running inside the WinRT sandbox will introduce some complications
> for dynamic loading
For whatever it’s worth, my use case seems to work okay. I’m building my own
extension as a DLL and am able to deploy it with a test WP8 app, load it via
sqlite3_load_extension, and
I am not getting your replies Keith; I'm new so maybe it's just delayed.
To clarify, I think this is a .NET Sqlite lib problem, not a database issue;
sorry for the confusion.
I am currently inserting the data with the Sqlit .NET library using sql with
a parameter of datetime type, so If the date
It says on the page http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
"If you know of a driver or wrapper for SQLite that is not listed below, please
feel free to add it to the list."
But I can't seem to find an "Edit" button.
How do I go about adding an API to the list? Do I need a login (if
On 5/29/2013 8:54 AM, Udon Shaun wrote:
I have decided to hash the sqlite random with the normal rand() then
use that as the seed for the FORTUNA algo to mitigate this scenario.
That should then ensure that the seed is always different.even if
the OS specific random function isn't that
Hi Dr Hipp.
Thanks for the qualitative reply. I have seen comments about RC4 being biased
towards the first few bytes (some suggestions are to drop the first n bytes
etc). I just don't have the confidence from the replies that it is usable
as-is. You have convinced me of the repetition rate
18 matches
Mail list logo