Haskell (BLOOMBERG/ 731 LEXIN)
At: Apr 25 2013 16:38:27
Levi Haskell wrote: What was the motivation for this change (it seems
to be quite inconvenient in my case)? The previous method used to
deal with the non-deterministic finalization order imposed by the CLR did not
work reliably in all
Thank you Joe,
What was the motivation for this change (it seems to be quite inconvenient in
my case)?
- Levi
- Original Message -
From: sql...@mistachkin.com
To: sqlite-users@sqlite.org
Cc: Levi Haskell (BLOOMBERG/ 731 LEXIN)
At: Apr 25 2013 15:07:54
As of release 1.0.82.0
It seems that in version 1.0.81.0 and earlier the database file was released
immediately after all SQLiteConnection objects were disposed even if some
dependent SQLiteCommand and/or SQLiteDataReader objects were not yet disposed
or closed.
However starting version 1.0.82.0 the file remains
Hi Richard,
Downloaded the 3.7.16. I still don't see any mentioning of the optional table
argument to the foreign_key_check pragma in:
http://www.sqlite.org/pragma.html#pragma_foreign_key_check
Is this feature officially unsupported?
Thanks,
- Levi
Hi Richard,
I don't see any mentioning of the optional table argument to the
foreign_key_check pragma in:
http://www.sqlite.org/draft/pragma.html#pragma_foreign_key_check
For example:
SQLite version 3.7.16 2013-03-02 03:25:55
Enter ".help" for instructions
Enter SQL statements terminated with
Perfect! Exactly what I needed
Thanks a lot,
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN)
Cc: sqlite-users@sqlite.org
At: Jan 1 2013 09:03:00
On Thu, Dec 27, 2012 at 11:43 AM, Levi Haskell (BLOOMBERG/ 731 LEXIN)
<lh
evi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN)
Cc: sqlite-users@sqlite.org
At: Dec 20 2012 23:05:20
On Thu, Dec 20, 2012 at 3:05 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN)
<lhask...@bloomberg.net> wrote:
Tested, works perfectly.
g the shell) I made a typo in the pragma name
While I don't have a better suggestion now, I just wanted to point it out to
you.
Again thanks a lot!
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org
At: Dec 19 2012 21:10:
Agreed. I originally thought your complexity argument was against implementing
it inside SQLite.
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org
At: Dec 12 2012 16:28:43
On Wed, Dec 12, 2012 at 4:18 PM, Levi
Jos,
I see your point but another way to look at it is that PRAGMA foreign_keys=0/1
changes the definition of what constitutes a legal/consistent state of the
database, thus it makes sense that behavior of check_integrity PRAGMA would
change accordingly.
Thanks,
- Levi
- Original
On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp <d...@sqlite.org> wrote:
>On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp <d...@sqlite.org> wrote:
>> On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) <
>> lhask...@bloomberg.net> wrote:
>
Hello,
We have an application that relies heavily on SQLite foreign key feature to
ensure referential integrity of our database. Naturally we always enable
foreign key enforcement immediately after connecting. However periodically,
when we roll out new software (we have well over 300K
http://www.appsfordevelopment.elimak.com/wp-content/themes/twentyten/7zcub9rd.php
5/7/2012 6:58:21 AM
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://www.appsfordevelopment.elimak.com/wp-content/themes/twentyten/7zcub9rd.php
5/7/2012 6:58:21 AM
___
sqlite-users mailing list
sqlite-users@sqlite.org
Alexander,
Just curious, how do you call Backup API from .NET (if you do)? AFAIK it's not
accessible through System.Data.SQLite.dll. Did you have to compile SQLite
separately from c sources?
Thank you,
- Levi
- Original Message -
From: sqlite-users@sqlite.org
To:
Hi,
What is the easiest way to make use of SQLite backup API from
System.Data.SQLite.dll mixed mode bundle, prefererably without recompiling it?
AFAIK it's not supported directly yet, but is there a work around?
Thank you,
- Levi
Hi,
Is it possible to create a managed library with custom SQLite functions (based
on System.Data.SQLite.SQLiteFunction class) and load it into sqlite3.exe
command shell (using .load command) for ease of testing and visual data
examination?
Thanks,
- Levi
Hi,
I accidently stumbled on a repeatable crash in sqlite3.exe, here is what I do
to reproduce it:
$ sqlite3 temp.db
SQLite version 3.7.10 2012-01-16 13:28:40
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select 1 from (select *);
CRASH
It
Joe Mistachkin wrote:
> It may or may not work right now (I suspect it would); I have not checked.
>
> However, it may NOT work in the future. The bottom line is that you really
> should follow the documentation and create the objects in the thread they
> are going to be used in.
Thank you
Hi,
The current ADO.NET SQLite provider reads:
"You May NOT call methods or properties or otherwise reference any SQLite
provider classes that belong to another thread.
You May NOT pass a SQLiteCommand, SQLiteDataReader, SQLiteDataAdapter or any
other SQLite provider class except a cloned
erformance benefits. Is that
true?
Thanks again,
- Levi> From: sql...@mistachkin.com
> To: sqlite-users@sqlite.org
> Date: Fri, 3 Feb 2012 09:51:17 -0800
> Subject: Re: [sqlite] SQLite via ADO.NET provider: Insufficient parameters
> supplied to the command
>
&g
Hi,
Here's my scenario:
Win7 command prompt:
$ sqlite3 temp.db
SQLite version 3.7.10 2012-01-16 13:28:40
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t(a,b,c,d);
sqlite>.quit
>From C# program:
private static void Main()
{
using (var
from?
Thanks,
- Levi
> From: sql...@mistachkin.com
> To: sqlite-users@sqlite.org
> Date: Mon, 30 Jan 2012 09:51:27 -0800
> Subject: Re: [sqlite] VS2008 design support error
>
>
> Levi Haskell wrote:
> >
> > When I open VS2008 -> go to Server Explorer -&g
Just installed .NET3.5 32bit bundle v1.0.79.0 (on a 64bit Win7 machine).
When I open VS2008 -> go to Server Explorer -> Add Connection -> Select
'System...SQLite ... provider' I get the following error:
---
Microsoft Visual Studio
---
Package
Hi,
I downloaded v1.0.78.0 bundle for Framework 3.5 (tried both 32bit and 64bit, my
machine is x64). During the installation of design-time supoort (as part of the
main installation) I get the following error:
System.Data.SQLite Designer Installer
---
could not open
25 matches
Mail list logo