How are you fetching the data? Are you using the generic reader[x] on a
datareader? Are you using a DataSet/DataTable?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tim Butterfield
Sent: Friday, May 06, 2011 8:58 AM
To:
the column number, calling reader.GetBytes to get the size of the
data, allocating the byte[], and then calling reader.GetBytes to read
into the buffer.
Tim
On Fri, May 6, 2011 at 11:12 AM, Robert Simpson <sqlite_l...@bcsft.com>
wrote:
> How are you fetching the data? Are you using the gener
> -Original Message-
> From: Christian Schwarz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 18, 2007 7:25 AM
> To: sqlite-users@sqlite.org
> Subject: AW: [sqlite] Still getting "Insertion failed because database
> isfull." errors
>
> > the database residing on removable media. When
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 28, 2007 9:11 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
>
> > SQLite does not have a dedicated DATE type.
>
> I know that, but why it does't create appropriate column
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 28, 2007 4:21 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> We actually do that with our Sqlite interfaces. We use the declared
> type to specify the type and perform a
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 6:18 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> Your comments endorse the approach we took which was to avoid the
> wrapper concept entirely with its inherent
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 8:40 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> You have just given an excellent explanation of why the wrapper
> approach
> is flawed. Think about it.
Every
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 3:56 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> You are looking for a fit to one particular restrictive, proprietary
> environment. Our approach has been to work
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 31, 2007 4:08 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> You have explained the problem, which is .NET not Sqlite. You have
> apparently done a fine job marrying the two
> -Original Message-
> From: WHITE, DANIEL [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 23, 2007 7:29 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Introducing... ManagedSQLite
>
> Howdy all!
>
> I am just writing tonight to let you know that a project of mine has
> opened up
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 25, 2007 2:39 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Trouble compiling with MSVC++ 6.0
>
> Ticket #2457 reports difficulty building SQLite version 3.4.0
> using MSVC++ 6.0. This
> -Original Message-
> From: Yves Goergen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 26, 2007 4:55 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Introducing... ManagedSQLite
>
> On 26.06.2007 00:24 CE(S)T, WHITE, DANIEL wrote:
> > The main advantage of mine is that it is
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 16, 2007 9:14 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Does Transaction object roll back
> automatically on exceptions?
>
> "Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote:
> > Hi
> -Original Message-
> From: James Forrester [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 20, 2007 6:37 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] sqlite Text fields Vista/ 64 bit/core 2 duo machines
>
> This may be a problem specific to Vista alone, but I'm
> running 64 bit
> -Original Message-
> From: Steinmaurer Thomas [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 23, 2007 1:12 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite Version 3.4.1
>
> Hi!
>
> has anybody tried to compile SQLite for the ARM CPU architecture?
>
Yup.
> -Original Message-
> From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 23, 2007 12:27 PM
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: [sqlite] Begining SQLite
>
> hello
>
> please help me:
> i am New to SQLITE
> i want to begin Using SQLite with my
> -Original Message-
> From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 23, 2007 3:33 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Begining SQLite
>
> Hello
>
> Thank you for this SQLite ADO .Net Data provider
> is working very correctly
> but ho to Create
> -Original Message-
> From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 24, 2007 3:04 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Begining SQLite
>
> Hello
>
> i create my SQLite Database, but it is blank
> ho to Create my Table, view, Query and procedure
> -Original Message-
> From: Stephen Sutherland [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 10:33 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] How to Speed of Inserts
>
[snip]
>
>So it makes me a bit concerned that when I have to drop my
> XML repository
> -Original Message-
> From: Gilles Ganault [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 11:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [VC++ 6] Error compiling VBified source
>
> At 09:53 03/08/2007 -0700, Joe Wilson wrote:
> >This has come up before on the
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 09, 2007 8:38 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Proposed incompatible change to SQLite
>
> We are considering a change to the SQLite API which is
> technically not
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 28, 2007 8:14 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Skype client using SQLite?
>
> In reference to
>
>http://www.sqlite.org/cvstrac/tktview?tn=2592
>
> This is the first
What .NET wrapper are you using?
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 7:13 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite.Net
>
> Hi all,
>
>
>
> I try to use SQLite (sqlite3.dll) in DotNet; this
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 7:42 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
> SQLite.NET.2.0.1
>
> -Message d'origine-
> De : Robert Simpson [mail
I am using this http://www.phpguru.org/static/SQLite.NET.html
>
> I have the "attempted to read or write protected memory"
> exception with this wrapper.
>
> If I try to define my own wrapper with sqlite3.dll it crashes
> on select statement.
>
> -Message d'orig
ichael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 8:29 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
> Ok, but why I can't use this wrapper
> http://www.phpguru.org/static/SQLite.NET.html ?
>
>
> -----Message d'o
> -Original Message-
> From: Cyrus Durgin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 09, 2007 5:02 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] how to get file handle from sqlite3 object?
>
> i'm wondering if there's a "standard" way to get an open file
> handle from an
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2007 7:19 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Proposed sqlite3_initialize() interface
>
> As currently implemented, SQLite3 requires no initialization.
> You just start
I was a die-hard Amiga programmer years ago and swore never to put a PC on
my desk at home. Unfortunately they used them at work, so I was forced to
learn it.
After a few years of being a broke enthusiast on the Amiga, I wrote a
business app on the PC in Visual C and VB3. It was my first
> -Original Message-
> From: Lothar Scholz [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 18, 2008 3:50 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Is there a difference between NULL und zero
> byte length BLOB/TEXT?
>
> Hello,
>
> The last question for today:
> Is there a
> -Original Message-
> From: RohitPatel [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 16, 2006 1:58 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite Vs VistaDB - Comparison ???
Getting back on track ...
> VistaDB
> HomePage : www.vistadb.com
> More Features :
> -Original Message-
> From: Gregory Letellier [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 03, 2006 8:54 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Open SQLite database from VB
>
> search finisar sqlite on google you will find a wrapper :o)
>
VB Express is a .NET 2.0
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 24, 2006 2:14 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Getting callback with an INSERT
>
> Olaf Beckman Lapré wrote:
> > No, that's not the case since I'm using an AUTOINCREMENT
>
> -Original Message-
> From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 25, 2006 8:07 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Sqlite Write and read a the same time
>
> Hello!
>
> The weekend I was reading a book "Programming in Linux" and I
> -Original Message-
> From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 7:48 AM
> To: SQLite
> Subject: [sqlite] Re: User function in WHERE clause
>
> Stan <[EMAIL PROTECTED]> wrote:
> > is there a way to create user function similar to LIKE?
> > I'd like to
Send e-mail to [EMAIL PROTECTED] to unsubscribe
> -Original Message-
> From: prabhu kumaravelu [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 7:53 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Please unsubscribe me from sqlite
>
>
> Please unsubscribe me from sqlite
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 8:33 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] User function in WHERE clause
>
> "param MYFUNCTION Name" is equivalent to
> "MYFUNCTION(Name, param)" onoly if
You'll have to report this on the forum where you got the wrapper you're
using. It looks like ASP and COM objects?
> -Original Message-
> From: Artie Pagan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, August 06, 2006 12:09 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Connection
For the last couple months I've been working on the ADO.NET vNext provider
for SQLite with support for eSQL, LINQ, etc (aka the Entity Framework).
I had a eureka moment today while struggling with the ADO.NET vNext bits as
it relates to SQLite's limited type support. I thought I'd share, and see
> -Original Message-
> From: Allan, Mark [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 06, 2006 10:06 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite vs MS Access
>
> Hi,
>
> After successfully using SQLite on an embedded device, we are
> now thinking of using
>From http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
Download the source with the .DEF file, then run:
LIB /DEF:sqlite.def
That will make a lib file.
Robert
> -Original Message-
> From: Richard Stern [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 11, 2006 7:19 PM
> To:
> -Original Message-
> From: He Shiming [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 18, 2006 10:02 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Quotation handling bug?
>
> Hi,
>
> I think I found a bug in sqlite version 3.3.7. The steps to
> reproduce it is
> as
> -Original Message-
> From: Andrew Cheyne [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 18, 2006 8:08 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] sqlite performance questions.
[snip]
> I have then been writing some sample C programs making use
> of the C API,
> but
> -Original Message-
> From: Mohd Radzi Ibrahim [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 18, 2006 3:23 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] sqlite performance questions.
>
> Hi,
> Could you tell me what breaks the transaction? Is create
> table/index
> -Original Message-
> From: Peter Siegmund [mailto:[EMAIL PROTECTED]
> Sent: Sunday, November 05, 2006 6:56 AM
> To: SQLite Mailingliste
> Subject: [sqlite] compile SQLite 3.3.8 for WinCE
>
> Hi,
>
> I want to compile SQLite 3.3.8 under VS2005 (for Windows Mobile 5). Is
> there any
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 07, 2006 6:18 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Q about new SQLite API
>
> I'm working on a new API routine for SQLite and I have
> questions for the community.
[snip]
>
> -Original Message-
> From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 07, 2006 8:15 AM
> To: SQLite
> Subject: [sqlite] Re: Q about new SQLite API
>
> Marco Bambini <[EMAIL PROTECTED]> wrote:
> > 2. maybe with the new sqlite3_compile routine there should also be
I tried that same SELECT statement in 3 builds of SQLite on VS2005. The
code was called from C# using the ADO.NET 2.0 wrapper, and I got 10 all 3
times. I tried /fp:fast, /fp:strict and /fp:precise
The rest of the build options were:
AdditionalOptions="/GS-"
dangerous) bug in Microsoft Compiler
>
> did you also compile the ado .net wrapper ?
>
> - Original Message -----
> From: "Robert Simpson" <[EMAIL PROTECTED]>
> To: <sqlite-users@sqlite.org>
> Sent: Wednesday, November 08, 2006 4:57 PM
> Subject:
You need to create an index on the columns you're joining. Otherwise I
believe 100,000,000 rows (10k x 10k) in table 2 will be scanned while SQLite
looks for matches against the 10,000 rows in table 1.
> -Original Message-
> From: Unit 5 [mailto:[EMAIL PROTECTED]
> Sent: Wednesday,
> -Original Message-
> From: Florent THIERY [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 15, 2006 9:27 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] unrecognized token error
>
> Hi
>
> My request:
>
> "create table %s (profileID char(32) etc...)" % (tableID) #
>
NULL is not equal to anything, including itself. ('' = NULL) is false,
(NULL = NULL) is also false. To test for NULL, use IS NULL, such as :
SELECT * FROM t WHERE (LastName = '' OR LastName IS NULL) AND (Name =
'Peter')
-Original Message-
From: Daniel Schumann [mailto:[EMAIL
> -Original Message-
> From: Isaac Raway [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 27, 2006 7:05 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SELECT on empty fields ??
>
> I'd like to strongly second this. Avoid NULL columns, even at apparent
> cost.
> Having a valid
> -Original Message-
> From: jfbaro [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 11, 2006 1:58 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite for .NET 1.1?
>
>
> Hi!
>
> Where can we find ADO for .NET 1.1?
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Robert
I wrote the original patch to loadext.c with the intent of making it as
minimally obtrusive as possible to the existing code structure. I know
firsthand how much DRH hates changing his codebase :)
As Brodie stated, FreeLibrary() takes a type HANDLE, which is returned from
a call to LoadLibrary()
> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 19, 2006 9:17 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Need a wince test
>
> There are a few problems with your patch.
>
> +# ifdef _WIN32_WCE
> +static HANDLE
> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 20, 2006 12:17 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Need a wince test
>
> Robert, does the patch I provided work as is on Windows CE or not?
>
> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 20, 2006 4:43 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Need a wince test
>
> Robert Simpson wrote:
> >> From: Brodie Thiesfield [mailto:[EMA
I've been too busy with the holidays to run any of the changes. I won't be
able to do anything with the code until after the 1st.
Robert
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 23, 2006 12:40 PM
> To: sqlite-users@sqlite.org
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 21, 2007 2:40 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: does select reliably return insert order?
>
>
> > If you use LIMIT/OFFSET without an
> > explicit ORDER BY, you are
logical user interface developed by working with
experienced first responders
More info can be found here:
http://wiser.nlm.nih.gov/
Robert Simpson
Programmer at Large
http://sqlite.phxsoftware.com
-
To unsubscrib
http://sqlite.phxsoftware.com is the site where I develop and maintain the
SQLite ADO.NET 2.0 wrapper. The project is 2 years old and is pretty
mature. You'll find the forums pretty informative and I try and answer
every question there fairly quickly.
Robert Simpson
> -Original Mess
For the SQLite ADO.NET wrapper, I actually wrote two functions into the core
engine to help me retrieve key information. My requirements were a little
more complex than just getting rowid, but here's what I did to get me that
far at least:
Given a sqlite_stmt pointer consisting of a SELECT on
> -Original Message-
> From: Robert Simpson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 07, 2007 8:25 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Is there a SQLiteSpy-like thing that will let me
> change data from a grid?
>
> __declsp
Issued from the 3.3.12 comand-line:
CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF string NOT NULL);
INSERT INTO blah (STUFF) VALUES('00302');
SELECT * FROM blah;
1|302
Same query, slightly different table definition:
CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF text NOT NULL);
There have been several posts on this issue just this week, and suggested
workarounds.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joachim Wickman
Sent: Wednesday, August 25, 2010 12:37 AM
To: sqlite-users@sqlite.org
SQLite.NET is being transitioned to sqlite.org ... you'll notice the new
site is http://system.data.sqlite.org -- it's being taken over by the fine
folks at sqlite.org, specifically Shane Harrelson who has the lead on the
project. I've been working with Dr. Hipp and Shane on the transition.
I wrote this behavior into the SQLite.NET provider as well. However, I make
a temp copy of the open statements in the db->Vdbe and finalize the copies
so that subsequent calls to sqlite3_finalize() on the original pointer will
not fail, but be a no op.
int ret = sqlite3_close (db);
if (ret
MAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Simpson
Sent: Wednesday, May 14, 2008 7:58 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Proposed SQLite C/C++ interface behavior change.
I wrote this behavior into the SQLite.NET provider as well. However, I ma
url below, which I was unaware of:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
I'm currently using the phxsoftware ado.net 2.0 wrapper for sqlite by
Robert Simpson, which is excellent. However, I am surprised to see that
the Mono project recently imported Simpson's code
(http://www.mono-p
Sounds like the new journal_mode pragma might be a solution for you.
http://www.sqlite.org/pragma.html#pragma_journal_mode
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Filip Navara
Sent: Wednesday, June 04, 2008 2:54 PM
To: General Discussion of
I'm not exactly sure what they've built on top of my (free) provider, but it
looks like a good portion of their core codebase is my code. It's a bummer
they decided to split with the free spirit of SQLite and charge for their
provider (based on my public domain code), but to each his own.
Robert
de from this little issue involving aggregates, SQLite is working nicely
with Microsoft's new Entity Framework.
Robert Simpson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Simpson
Sent: Monday, June 30, 2008 9:10 PM
To: 'General Discussion of SQLite Database'
Subject: [sqlite] Rigging up SQLite over LINQ (Entity Framework)
Just when I thought I was hitting the home stretch, I came across an
aggregate query test that I'm
Without causing a rehash of that long-debated topic, I'll say this: As it
relates to SQLite, generally you will get better performance out of an
optimized C application talking to SQLite than you will out of .NET talking
to SQLite.
The difference can be insignificant to a user application
I don't normally announce releases here, but this one's got some great stuff
in it. Those of you using the SQLite ADO.NET provider will want to check
out.
Some highlights in the 52 release:
3.6.0 code merge
Table and View designers - you can now create and design tables and views,
indexes and
compact framework?
--- On Wed, 7/16/08, Robert Simpson <[EMAIL PROTECTED]> wrote:
From: Robert Simpson <[EMAIL PROTECTED]>
Subject: [sqlite] ANN: SQLite .NET provider updated
To: "'General Discussion of SQLite Database'" <sqlite-users@sqlite.org>
Date: Wednesday, Jul
Does this work?
CREATE UNIQUE INDEX myidx ON test(str COLLATE path);
Robert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of C. Smith
Sent: Sunday, July 20, 2008 9:05 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] User-defined collation UNIQUE INDEX
on during index creation makes no difference. I also
tried
REINDEX with no luck.
I am using verison 3.5.9 on a winxp box (forgot to mention that).
csmith
Robert Simpson wrote:
> Does this work?
>
> CREATE UNIQUE INDEX myidx ON test(str COLLATE path);
>
> Robert
>
>
&
No, but that would be wicked cool and bring stored procs a lot closer to
reality.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alexey Pechnikov
Sent: Friday, July 25, 2008 11:08 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Return a
What should be the expected behavior of existing connections when
sqlite3_enable_shared_cache() is enabled, and then another database is
ATTACH'ed to the pre-cache-enabled connection?
And further complicate things by saying that the attached database is using
vtables and the original
I don't think the sqlite3.exe command-line tool converts its input strings
to utf8 before parsing them. I think its because non-Windows platforms have
utf8 console sessions, and Windows consoles use the default Windows
codepage.
So when you're inserting from the console, you're inserting
Can you give us a download link to the database? Does your select statement
fail in the sqlite3.exe command-line util?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Nelson
Sent: Saturday, August 02, 2008 11:44 AM
To: [EMAIL PROTECTED]; General
ome Windows folks will be able to help you.
>
> >
> >
> > On Sat, Aug 2, 2008 at 3:03 PM, Robert Simpson <[EMAIL PROTECTED]
> >wrote:
> >
> >
> > > Can you give us a download link to the database? Does your select
> > > statement
>
tx05A
you have all given me more help then i deserve... very appreciative
thanks
On Sat, Aug 2, 2008 at 5:17 PM, Robert Simpson <[EMAIL PROTECTED]>wrote:
> Nothing stands out ... is your callback being called at all? What's it
> look
> like?
>
> -Original Message-
>
The new VFS implementation is probably the way to go. If you wrote some
wrapper code around the default VFS, you could capture all the writes that
go to the main db and clone/wirexfer those writes to a 2nd sync file.
Just an idea -- haven't worked with VFS's yet, though I plan on implementing
I have never really liked #3 and agree wholeheartedly with its demise.
Removing it in a subsequent release will force all those people using them
for string literals to fix their code -- which isn't a bad idea at all!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
using (DbTransaction trans = connection.BeginTransaction())
{
// loop goes here
//
// loop ends here
trans.Commit();
}
Best place to get answers to .NET-related SQLite questions (and more) is at
http://sqlite.phxsoftware.com/forums
Robert
-Original Message-
From: [EMAIL
Coinciding with Visual Studio 2008 SP1 going RTM today, I've put out a new
version of the SQLite ADO.NET provider. The LINQ bits are fairly solid, but
still officially in beta. Nonetheless, it gains the distinction of being
the very first ADO.NET provider publically released (other than Sql
Show and tell time! Lets see some code :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 19, 2008 8:15 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] "Database is Locked"
I haven't changed
Sql Server 2005:
SELECT a AS b, b AS a FROM #t1 ORDER BY a;
b a
--- ---
1 2
9 8
SELECT b AS a, a AS b FROM #t1 ORDER BY a;
a b
--- ---
2 1
8 9
SELECT a, b AS a FROM #t1 ORDER BY a;
Msg 209, Level 16,
Slight change so you can see the order by results more clearly:
(Sql Server 2005)
CREATE TABLE #t1(a int, b int);
INSERT INTO #t1 VALUES(1,6);
INSERT INTO #t1 VALUES(9,5);
SELECT a AS b, b AS a FROM #t1 ORDER BY a;
b a
--- ---
9 5
1 6
SELECT b AS
There's not enough information in your post for us to comment -- which is
probably why nobody responded earlier. The unit tests for SQLite create
thousands of connections and run hundreds of thousands of commands without
leaking. So there's a probability that you may be doing something wrong,
I recently had a user of the ADO.NET provider report a problem on Vista.
His database is 5gb, and he's doing a full table scan of 16 million rows.
Yea.
I ran some tests using the command-line sqlite3.exe, and observed that
Windows Vista (SP1) is actually trying to cache the entire 5gb file
:[EMAIL PROTECTED] On Behalf Of Roger Binns
Sent: Wednesday, September 17, 2008 1:18 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Vista frustrations
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> To me this seems like an obvious bug in Vista,
Actually
PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> To me this seems like an obvious bug in Vista,
Actually I'd argue that it is behaving as designed. Generally
filesystem code will try to detect what is going on under the hood. In
particular if it looks like you are doing sequ
It's been reproduced on Vista x64 and x86 OS's. I don't have a pre-SP1
installation to verify if it happens against pre-patched versions.
Getting a database should be easy enough ...
CREATE TABLE FOO(a, b, c, d, e, f);
Then do this about 16 million times or so ... whatever it takes to pump the
]
[mailto:[EMAIL PROTECTED] On Behalf Of Jay A. Kreibich
Sent: quarta-feira, 17 de setembro de 2008 13:01
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Vista frustrations
On Wed, Sep 17, 2008 at 01:17:51AM -0700, Roger Binns scratched on the wall:
> Robert Simpson wrote:
> &
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger Binns
Sent: Wednesday, September 17, 2008 2:02 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Vista frustrations
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> The purpose of a ca
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> Ideally, at least on non-CE platforms, I'd like see SQLite not give the OS
> any hints about caching. However, I'm not sure what kind of performance
hit
> (if any) that would have on Windows. It's already been proven that
&g
1 - 100 of 248 matches
Mail list logo
