Jochen Kuehner wrote:
>
> I've now compiled the Library with this script without problems.
> (I changed it that the output filename ist: SQLite.Interop.dll
>
Please try without changing the output file name. Mono has its
own special transformations on the P/Invoke library names. The
file nam
> Drago, William wrote:
> >
> > I always reference System.Data.SQLite directly and have no idea how to
> > register it as a data source and what the implications of doing so are
> > (will it break applications that reference the .NET assy directly)?
> > Can anyone advise?
> >
>
> A data source for
Those look like the ODBC provider list...
http://www.ch-werner.de/sqliteodbc/
On Wed, Apr 27, 2016 at 3:55 PM, Joe Mistachkin
wrote:
>
> Drago, William wrote:
>>
>> I did look at Installer.cs, but I'm not knowledgeable enough to
>> understand what it's doing.
>>
>
> It modifies the registry and
All,
I always reference System.Data.SQLite directly and have no idea how to register
it as a data source and what the implications of doing so are (will it break
applications that reference the .NET assy directly)? Can anyone advise?
Thanks,
--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Morel
Drago, William wrote:
>
> I did look at Installer.cs, but I'm not knowledgeable enough to
> understand what it's doing.
>
It modifies the registry and several .NET configuration files in
order to "install" the ADO.NET provider for System.Data.SQLite.
>
> I noticed "what-if" mode and maybe now I'
Albert Banaszkiewicz wrote:
> 1. Is there a way to control (i.e. disable) check-pointing happening at DB
> closure ?
The internal sqlite3WalClose() function does a checkpoint if it is able
to get an exclusive lock (which implies that there are no other readers/
writers). So to prevent this check
On 27 April 2016 at 13:01, Mark Foley wrote:
>
> Can sqlite handle contention among multiple accessors with read/write if
> the
> accessors are not on the same host? I.e. is locking intrinsic in sqlite
> and any
> accessor from any host is able to determine and set a row/table lock?
>
That depend
Drago, William wrote:
>
> I always reference System.Data.SQLite directly and have no idea how
> to register it as a data source and what the implications of doing
> so are (will it break applications that reference the .NET assy
> directly)? Can anyone advise?
>
A data source for what? The .N
Hello,
I'm using the "System.Data.SQLite.Core" lib to connect to a sqlite-database
and try to query a dataset by using DateTime in the WHERE clause.
If I directly use the DateTime object as parameter to the WHERE clause I
don't get any result.
If I reproduce this against, for example, a MyS
Can you kill the process rather than shut down your application? If
the last connection doesn't get shut then the WAL will remain and will
be in opened (but not played) when the DB is re-opened.
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http:/
Hello
Can I rename an index generated by sqlite (autoindex)?
Thanks in advance
Hi Paul,
Interesting idea :) A bit hacky but that's something to be considered perhaps.
However, killing the application usually implies action being taken from
outside of the app. I don't believe such things are possible on i.e. iOS (one
of the platform supported by our app), though I might be
Hi Clemens,
Indeed, that would do the trick, however, during the device shutdown there is
no way to keep the connection open. And that is really an inconvenient time to
perform the operation due its duration.
Cheers,
Albert
Od: sqlite-users-bounces at
Hello.
I am new here, thus I would like to apologize in advance if the question I am
going to rise was already asked in the past.
I am using SQLite 3.11.1 (actually it is a NDS consortium customized version
based on it).
According to documentation, in case of WAL mode enabled databases, final
How are you storing the dates in the DB? Is the WHERE clause using the same
format?
Given SQLite's "duck" typing, I don't believe there is any built in definition
of a date time type. MSSQL, for instance, has a built in "datetime" type, and
when you build a WHERE clause with, e.g. a string, SQ
On 4/27/16, Albert Banaszkiewicz wrote:
> Hello.
>
> I am new here, thus I would like to apologize in advance if the question I
> am going to rise was already asked in the past.
>
> I am using SQLite 3.11.1 (actually it is a NDS consortium customized version
> based on it).
>
> According to docume
On 4/27/16, jose.campos.romero at andaluciajunta.es
wrote:
> Hello
>
> Can I rename an index generated by sqlite (autoindex)?
>
No. If you did, SQLite would not know how to find it when it reopened
the database and reparsed the schema.
--
D. Richard Hipp
drh at sqlite.org
On 27 Apr 2016, at 6:01am, Mark Foley wrote:
> I don't know that answer. Would the journal file be an actual file in the
> same
> folder as the database file?
Yes. Given that your database file is called 'local.sqlite', look for other
files in the same folder with names starting with 'local
Hello Everyone,
We're using SQLite SEE to encrypt our databases and I was wondering if there is
a version of SEE that is FIPS compliant/certificated? Even a version that made
use of the FIPS Windows APIs for encryption since our target platform is
limited to Windows. (I'm aware that the enter
On Tue, 26 Apr 2016 22:31:11 Scott Robison wrote:
> Is there a hot journal file with the database? If so it may need to roll
> back a transaction which will require write access anyway.
I don't know that answer. Would the journal file be an actual file in the same
folder as the database file? C
20 matches
Mail list logo
