Re: [sqlite] ANN: C#-SQLite 3.6.16

2009-08-09 Thread Tim Anderson
I hacked this port to run on Silverlight, as a proof of concept: http://www.itwriting.com/blog/1695-proof-of-concept-c-sqlite-running-in-silverlight.html Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/li

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-02 Thread Tim Anderson
> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Kosenko Max > Sent: 02 August 2009 19:40 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > I don't know why he insists on that (he actually can

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-02 Thread Tim Anderson
What about SqlSharp? Tim > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Noah Hart > Sent: 02 August 2009 13:58 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > > Also, if anyone has an ide

RE: [sqlite] SQLite article, Adobe info

2007-06-21 Thread Tim Anderson
> -Original Message- > From: Alberto Simões [mailto:[EMAIL PROTECTED] > Sent: 21 June 2007 09:46 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite article, Adobe info > > Hi, Tim. > > Is there any PDF or cleaner HTML we can use for printing? > Thank you ;) > Alberto It is in t

[sqlite] SQLite article, Adobe info

2007-06-21 Thread Tim Anderson
The article I wrote is here: http://technology.guardian.co.uk/weekly/story/0,,2107239,00.html Thanks again to those who gave feedback on SQLite. Another post I think is interesting is from Paul Robertson, who works on SQLite within the Adobe Integrated Runtime (formerly Apollo), responding to a

RE: [sqlite] Why do you use SQLite? Comments for an article needed

2007-06-09 Thread Tim Anderson
Many thanks to those who have commented (more are welcome of course; though I won't be able to use all of them). I'll post a link to the piece when it appears. Thanks again Tim - To unsubscribe, send email to [EMAIL PRO

[sqlite] Why do you use SQLite? Comments for an article needed

2007-06-07 Thread Tim Anderson
I'm writing an article about SQLite and I'd love to get some comments from users about why you use it. Performance? Features? Reliability? Cost? Is the open source aspect important? Anything else? For that matter, anything you really don't like about SQLite? You can email me at tim(at)itwriting.co

RE: [sqlite] ANN: SQLiteSpy 1.5.1 released

2006-02-03 Thread Tim Anderson
> -Original Message- > From: Ralf Junker [mailto:[EMAIL PROTECTED] > Sent: 03 February 2006 10:12 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLiteSpy 1.5.1 released > I am sorry that you can not use SQLiteSpy with your custom > DLL. Maybe you would like to contribute you

RE: [sqlite] Java bindings

2006-01-31 Thread Tim Anderson
> -Original Message- > From: Marian Olteanu [mailto:[EMAIL PROTECTED] > Sent: 31 January 2006 05:14 > To: sqlite-users@sqlite.org > Subject: [sqlite] Java bindings > any success. I failed to compile > http://www.ch-werner.de/javasqlite and > in Windows. I've compiled this for Window

RE: [sqlite] Java bindings

2006-01-31 Thread Tim Anderson
> -Original Message- > From: Marian Olteanu [mailto:[EMAIL PROTECTED] > Sent: 31 January 2006 05:14 > To: sqlite-users@sqlite.org > Subject: [sqlite] Java bindings > any success. I failed to compile > http://www.ch-werner.de/javasqlite and > in Windows. I've compiled this for Window

[sqlite] Compiling with Visual Studio 2005

2006-01-01 Thread Tim Anderson
This isn't specific to Sqlite; but the situation with msvcr80.dll is worth noting. See my blog post: http://www.itwriting.com/blog/?postid=261 In a nutshell: if you use the latest Microsoft compiler and choose dynamic linking to the C runtime library, you have a potentially complex deployment. Ea

[sqlite] SQLite in OS X 10.4

2005-04-25 Thread Tim Anderson
I attended a press launch for "Tiger" today and was glad to see SQLite on one of the slides. However Apple was a bit vague about how it is used and the people there weren't sure if it was 2.x or 3.x that is integrated. I wondered if anyone has a quick summary of how SQLite is used in the Apple OS

RE: [sqlite] How to do: move to Next/Prev record?

2005-04-04 Thread Tim Anderson
> -Original Message- > From: liigo [mailto:[EMAIL PROTECTED] > Sent: 04 April 2005 08:58 > To: sqlite-users@sqlite.org > Subject: [sqlite] How to do: move to Next/Prev record? > > > When wrap sqlite to anothe language, > How to do: move to Next/Prev record? Not sure exactly what you mea

RE: [sqlite] ticket 1147

2005-03-01 Thread Tim Anderson
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: 28 February 2005 19:25 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] ticket 1147 > Wouldn't it be better to provide this information with a new > API rather than depend on a column naming convention?

RE: [sqlite] ticket 1147

2005-02-28 Thread Tim Anderson
> -Original Message- > From: Andrew Piskorski [mailto:[EMAIL PROTECTED] > Sent: 28 February 2005 17:28 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ticket 1147 > > On Mon, Feb 28, 2005 at 05:05:37PM -, Tim Anderson wrote: > > > SELECT Name, Ti

RE: [sqlite] ticket 1147

2005-02-28 Thread Tim Anderson
> -Original Message- > From: Edward Macnaghten [mailto:[EMAIL PROTECTED] > Sent: 28 February 2005 16:47 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ticket 1147 > However - having duplicate column names (without aliasing > them), or using an unqualified "*" when querying a selec

RE: [sqlite] Mac

2005-02-26 Thread Tim Anderson
> -Original Message- > From: Richard Nagle [mailto:[EMAIL PROTECTED] > Sent: 26 February 2005 17:56 > To: sqlite-users@sqlite.org > Subject: [sqlite] Mac > > Okay: > First is there a current version (compiled) 3.1.3 of SQlite for mac os > x I built this the other day, on OS X 10.2. I can

RE: [sqlite] Re: sqlite performance variationin linux and windows

2005-02-25 Thread Tim Anderson
> -Original Message- > From: Neelamegam Appadurai [mailto:[EMAIL PROTECTED] > Sent: 25 February 2005 05:04 > To: sqlite-users@sqlite.org; [EMAIL PROTECTED] > Subject: Re: [sqlite] Re: sqlite performance variationin > linux and windows > > Hi, > Thanks for the quick response and the int

[sqlite] Updated simple Delphi wrapper

2005-02-19 Thread Tim Anderson
I've updated the wrapper at: http://www.itwriting.com/sqlitesimple.php for Sqlite 3.1.2. Sqlite 3.1 changes the way column names are returned, so I've added a call to set the Pragma full_column_names on. I've also amended the field type detection to use the actual type when the declared type is n

[sqlite] strcasecmp build error in VC++

2005-02-19 Thread Tim Anderson
I got a linker error when building sqlite3.exe with Visual Studio .NET 2003, sqlite version 3.1.2. The linker could not find strcasecmp (shell.c line 659). I replaced strcasecmp with _stricmp to get it to build. Tim

RE: [sqlite] SQLite Advocacy

2005-01-31 Thread Tim Anderson
> -Original Message- > From: Downey, Shawn [mailto:[EMAIL PROTECTED] > Sent: 31 January 2005 17:16 > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite Advocacy > > Thanks everyone for there input. See below for the arguments > I've compiled so far. Please let me know if I am i

RE: [sqlite] Advice needed for a new group member

2005-01-03 Thread Tim Anderson
> -Original Message- > From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] > Sent: 03 January 2005 11:07 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Advice needed for a new group member > > Hi Mike, > There are some reasons for me to prefer older versions: Ahmet, Good points, but th

RE: [sqlite] Is the mailing list working

2004-12-21 Thread Tim Anderson
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: 21 December 2004 19:23 > To: [EMAIL PROTECTED] > Subject: [sqlite] Is the mailing list working > > No messages in 3 days (*very* unusual!) I've reset the > server (qmail) twice. Still nothing. A bunch of m

[sqlite] Simple Delphi wrapper for Sqlite 3.0

2004-12-21 Thread Tim Anderson
A while back I started using a simple (no data binding or TDataset) Sqlite 2.x wrapper for Delphi. I found it very useful, although I amended it extensively. I've now updated it for Sqlite 3.0. I've posted a more detailed explanation and a download linke here: http://www.itwriting.com/sqlitesimp

RE: [sqlite] Newbie's first question about using SQLite in C++

2004-09-13 Thread Tim Anderson
> -Original Message- > From: EzTools Support [mailto:[EMAIL PROTECTED] > Sent: 11 September 2004 00:30 > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Newbie's first question about using > SQLite in C++ > > I would use the SqlitePlus COM DLL with .NET rather than try > to wrap it with m

RE: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Tim Anderson
> -Original Message- > From: Richard Kuo [mailto:[EMAIL PROTECTED] > Sent: 16 June 2004 05:04 > To: [EMAIL PROTECTED] > Subject: [sqlite] SQLite performance with mid-size databases > > Hi. We are using SQLite to store and retrieve data rows where > each row is roughly 2K total in siz

RE: [sqlite] sqlite and Visual Basic

2004-03-23 Thread Tim Anderson
> -Original Message- > From: Peter Mathijssen [mailto:[EMAIL PROTECTED] > Sent: 23 March 2004 20:10 > To: Greg Obleshchuk; [EMAIL PROTECTED] > Subject: Re: [sqlite] sqlite and Visual Basic > > Greg Obleshchuk schreef: > > You can't use sqlite in a VB app (VB, VB.net, C#) without a > wrap

RE: [sqlite] sqlite.jar with UTF-8

2004-03-04 Thread Tim Anderson
> -Original Message- > From: Ilian Iliev [mailto:[EMAIL PROTECTED] > Sent: 04 March 2004 08:40 > To: [EMAIL PROTECTED] > Subject: [sqlite] sqlite.jar with UTF-8 > Are there any info/hints how to compile sqlite.jar in Win32 > with UTF-8 support? Or download link for already build jar?

RE: [sqlite] Select statements returned column names

2004-02-19 Thread Tim Anderson
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: 19 February 2004 13:12 > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Select statements returned column names > SQLite does attach "different" names to the columns than > other database engines. This has bee

RE: [sqlite] Performance...there must be a reason

2004-01-18 Thread Tim Anderson
> -Original Message- > From: Tim Anderson [mailto:[EMAIL PROTECTED] > Sent: 17 January 2004 22:45 > To: [EMAIL PROTECTED] > Subject: [sqlite] Performance...there must be a reason > What I can't work out is why. The same database is used. The > same Sqlite dll

[sqlite] Performance...there must be a reason

2004-01-17 Thread Tim Anderson
I'm trying out two Delphi wrappers. One is the SQLite for Delphi project here: http://sourceforge.net/projects/sqlite4delphi the other is the much simpler wrapper here (warning: this links to the actual zip file): http://myhtpc.net/sqlite/sqlite-delphi.zip I actually want to use the simpler wr

RE: [sqlite] RE: SQLite in OpenOffice?

2004-01-12 Thread Tim Anderson
> -Original Message- > From: Pierre-Yves Delens [mailto:[EMAIL PROTECTED] > Sent: 12 January 2004 08:15 > To: 'Jonas Forsman / Axier.SE' > Cc: [EMAIL PROTECTED] > Subject: [sqlite] RE: SQLite in OpenOffice? > > With SqLite Odbc Driver : OK It's worth noting that Sqlite is not the equival

RE: [sqlite] .Net provider performance

2004-01-11 Thread Tim Anderson
> -Original Message- > From: Tim Anderson [mailto:[EMAIL PROTECTED] > Sent: 10 January 2004 11:40 > To: [EMAIL PROTECTED] > Subject: [sqlite] .Net provider performance > The performance of the three .Net providers is > near-identical. On the first run, with the s

[sqlite] .Net provider performance

2004-01-10 Thread Tim Anderson
I've been comparing three .Net providers along with the JET OLEDB provider. I have the same data in an MDB and also an Sqlite db. The providers I've used so far, all on Windows, are: - The Mono Sqlite client http://www.go-mono.com - The AGS Sqlite provider http://www.ag-software.com/sqlite.aspx -

[sqlite] Using Mono client in Microsoft.Net

2004-01-09 Thread Tim Anderson
The Mono project at http://www.go-mono.com has a Sqlite data provider written in C#. You can compile this on Windows for use with Microsoft .Net (as opposed to Mono) but it doesn't work as-is. I made the following changes to get it working: Added the Cdecl attribute to the PInvoke declarations: [

[sqlite] Mac OS X and Java

2004-01-08 Thread Tim Anderson
Using version 2.8.9 and OS X 10.2.8 I had no trouble compiling Sqlite, although if I enable-shared I get a bus error on one of the tests (in make test). I have to disable shared library support anyway because... I had considerable difficulty compiling the Java wrapper at http://www.ch-werner.de/j

[sqlite] Java wrapper

2004-01-05 Thread Tim Anderson
I'd like to hear from users of the Java wrapper at http://www.ch-werner.de/javasqlite/. It is marked as "experimental" but as far as I know is the only Java wrapper available. Has anyone any comments concerning the reliability of this wrapper or any other features or limitations? Or know of any o