Re: [sqlite] ANN: C#-SQLite 3.6.16
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/listinfo/sqlite-users
Re: [sqlite] ANN: SQLite 3.6.16.C#
> -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 answer for himself > here) while there are a lot of SQLite based projects with that name > usage. Well, he's already answered it: he doesn't want to get support requests for the port. I think I'm right in saying that most of the SQLite-named projects out there are wrappers rather than ports, albeit some of them link the code into their own executables. Are there any ports to other languages called SQLite? It may also be a kind of compliment - that he thinks the port could prove popular. If it is pure C# with no interop, I agree - would be very useful for Silverlight, for example. Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] ANN: SQLite 3.6.16.C#
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 ideal about what to call it ... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] SQLite article, Adobe info
> -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 today's printed paper (21st June); that's the one which looks best. Or you can get a PDF by subscribing to the digital edition. Tim - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] SQLite article, Adobe info
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 post of mine: http://probertson.com/articles/2007/06/19/air-sql-docs-dont-mention-sqli te-my-response/ Tim - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Why do you use SQLite? Comments for an article needed
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 PROTECTED] -
[sqlite] Why do you use SQLite? Comments for an article needed
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.com or comment here if you prefer - but to use your quote I'd need at least a full name, what you do and the company you work for Thanks in advance for your help. Tim http://www.itwriting.com/blog - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] ANN: SQLiteSpy 1.5.1 released
> -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 your changes to the > SQLite sources, so they can become part of SQLite and > SQLiteSpy as well? This isn't a good answer. The problem is that if everyone added their favourite custom functions etc to the SQLite source it would become bloated and lose part of its appeal. I much prefer keeping the SQLite DLL external. Tim Read my tech blog: http://www.itwriting.com/blog
RE: [sqlite] Java bindings
> -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 Windows. My build is here: http://www.itwriting.com/sqlite_jni_win.zip (Apologies for missing link in previous message). Note that the author also offers a binary on his site: http://www.ch-werner.de/javasqlite/ Tim Read my tech blog: http://www.itwriting.com/blog
RE: [sqlite] Java bindings
> -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 Windows. My build is here:
[sqlite] Compiling with Visual Studio 2005
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. Easiest solution is to use static linking (/MT rather than /MD); but dynamic linking is the default. Or use a different compiler. I'm not sure that I've nailed every last nuance of this problem, so comments welcome. Tim
[sqlite] SQLite in OS X 10.4
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? Tim Is Microsoft imploding? http://www.itwriting.com/blog/?postid=146
RE: [sqlite] How to do: move to Next/Prev record?
> -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 mean here. The Sqlite API lets you step forward through a result set, but not back. I'm not sure how other wrappers do it, but in my simple Delphi wrapper (http://www.itwriting.com/sqlitesimple.php) I copy the data into an array (actually a TList) so that you can step back and forward. There's a trade-off between convenience and efficiency. Tim
RE: [sqlite] ticket 1147
> -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? That > would avoid ambiguity in cases where users create dodgy > column names that contain characters like space and '.' If > such a new API appears soon, would people (please!) stop > using those short_column_names and long_column_names pragmas? Yes, of course. I'd rather use an API than rely on a pragma. Tim
RE: [sqlite] ticket 1147
> -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, Title, Books.ID, Authors.ID FROM Books inner > join Authors > > on Books.AuthorID = Authors.ID ORDER BY Authors.Name, Books.Title; > Well, that looks like correct behavior to me. If you wanted > the column to be called something different you should have > done "... Authors.ID as Authors_ID" or something like that in > your query. So if these various db interface layers need special features > from SQLite in order to rewrite those column names Not quite. You wanted the column called "Books.ID" so that was specified. Is it unreasonable to then expect to retrieve it as "Books.ID"? More important, this used to work, so 3.1.3 broke code. No big deal IMO but annoying. Tim
RE: [sqlite] ticket 1147
> -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 select > statement with more than one table in it is really bad > practice - and I do not think the ANSI standard specifies how > that should be dealt with so I do not think sqlite CAN do it > "wrong" in that case. This isn't the only case at issue though. The reason I had to amend my simple Delphi wrapper was to deal with queries such as this one: SELECT Name, Title, Books.ID, Authors.ID FROM Books inner join Authors on Books.AuthorID = Authors.ID ORDER BY Authors.Name, Books.Title; In this case, the query is unambiguous, but by default Sqlite returns the column names as: Name Title ID ID In may case, all I need to do is to execute: PRAGMA full_column_names = 1; and this fixes the problem, even in 3.1.3 (in my limited testing). Of course you could also do: SELECT Name, Title, Books.ID as BooksID, Authors.ID as AuthorsID FROM Books inner join Authors on Books.AuthorID = Authors.ID ORDER BY Authors.Name, Books.Title; but I don't see why you shouldn't use the first approach if you want to. Tim Behlendorf on open source: http://www.itwriting.com/behlendorf1.php
RE: [sqlite] Mac
> -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 put it up for download if you are stuck, but it is honestly very easy to build. The only uncertainty I had was whether to use --disable-shared; I did in the end, but I'm not sure if it is still necessary. Tim
RE: [sqlite] Re: sqlite performance variationin linux and windows
> -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 interest you're > showing, I am testing the performance of linux and windows > using a. same testing data for both. > b. db schema is common for both. > c. though the test is conducted on two different machines but > the machine configurations are similar. I would say you need to do some profiling to find out which calls are taking longer. Which version of Windows is this? At one time I discovered an extraordinary slowdown with Sqlite on Windows 98 (but not 2000 or XP). Keeping a transaction open fixed the problem in that case. Tim
[sqlite] Updated simple Delphi wrapper
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 not available, and added the utility function TableExists. The test application now includes a demonstration of one way to load, save and display images in a Sqlite 3 database. Tim
[sqlite] strcasecmp build error in VC++
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
> -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 incorrect > on any of these items. Do we have any speed comparisons > between SQLite and SQL Server 7? I have an application that can use either SQLite or local SQL Server. I've not benchmarked it but performance is similar. That's a good result for SQL Server since it is far more feature-rich. SQLite is a fantastic piece of work and some of your points are valid (eg. simplicity of installation). But there is no need to bash at SQL Server which is an excellent and very different product. I think you would do better to promote SQLite on its merits rather than presenting this misleading comparison. Tim
RE: [sqlite] Advice needed for a new group member
> -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 there are several strong reasons to prefer Sqlite 3.0. Some of the ones which matter to me are: 1. Supports blobs. 2. Supports case-insensitive comparison. 3. Doesn't store everything as strings (saves space). I also have a simple Sqlite 3.0 wrapper for D7: http://www.itwriting.com/sqlitesimple.php Tim
RE: [sqlite] Is the mailing list working
> -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 messages has just come through (including one of mine) but they were held up for some reason - some that have just arrived are dated Sunday. Tim
RE: [sqlite] Newbie's first question about using SQLite in C++
> -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 managed C++ code. See www.sqliteplus.com. Why would you want the overhead of COM interop? Better to use one of the ADO.NET providers for SQLite I would have thought. Tim
RE: [sqlite] sqlite and Visual Basic
> -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 > wrapper as > > these languages don't support the C style interfaces > > > > Greg I'm not sure what you mean by "without a wrapper". You can call the dll directly from C# (and I would think VB.Net) provided you don't use the callback. You can even use the callback if you are willing to do a little hack on the compiled .Net executable. See http://www.itwriting.com/sqlitenotes.php Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Select statements returned column names
> -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 been a persistent source of > complaint. The problem comes up on joins more than anyplace else. > > Question to all: If I modified SQLite to use the same column > naming rules as (say) PostgreSQL, how much existing code > would it break? Is this something that should be done, even > though it is a (slightly) incompatible change? I actually prefer it with the table name prefixes. So one vote for leaving it as-is. Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Performance...there must be a reason
> -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 is used. The same pragmas are executed. The > compiler options are identical (unless I've missed a > directive lurking in the code somewhere). > > Just wondering what I'm missing? Solved. The reason is that the faster wrapper issues a BEGIN TRANSACTION on app startup and leaves the transaction open until an update is required. This makes hardly any difference on WinXP and an astonishing difference on Win98. It is no good surrounding the SELECT statement with BEGIN TRANSACTION and ROLLBACK (or COMMIT); this takes just as long. You have to leave the transaction open. Logically a transaction is never necessary for a read-only SELECT. So in a sense it should make no difference, and on WinXP that's the case. But in my test installation of Win98 I get a huge speed-up. Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Performance...there must be a reason
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 wrapper but I can't work out a performance issue. On Win XP the 2 wrappers have similar perf. On Windows 98 (ugh) the SQLite for Delphi project populates a dataset approximates 3 times faster (not a small difference). I thought at first this was because the simple wrapper uses sqlite_get_table(). So I changed it to use a callback instead. I then tuned the callback in various ways. By using a profiler, I can see that my implementation of the callback is about 4 times quicker than the other (not surprising, as it doesn't implement a fully-fledged Delphi dataset). Yet overall it remains 3 times slower. All the profiler tells me is that the call to sqlite_exec takes 3 times longer (I haven't tried to profile the Sqlite dll as yet). What I can't work out is why. The same database is used. The same Sqlite dll is used. The same pragmas are executed. The compiler options are identical (unless I've missed a directive lurking in the code somewhere). Just wondering what I'm missing? Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] .Net provider performance
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 - The SQLite.Net project here http://sourceforge.net/projects/adodotnetsqlite/ The database is not huge. For the example query, there are two tables joined using a subquery. Table A has 11,000 rows; Table B has 200,000 rows. The performance of the three .Net providers is near-identical. On the first run, with the system restarted to eliminate any caching by the file system, it takes about 4 seconds to execute the query and fill a datagrid with the results. On subsequent runs it takes about 0.25 seconds, showing the dramatic effect of the caching. The JET provider is an interesting case. The first run takes about 9 seconds. However, subsequent runs are about 0.15 seconds. Aside from indexing, I've not made any special effort to optimize. I know how difficult it is to do performance tests, and I don't pretend these notes have any authority. They are just offered as a point of general interest. Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Java wrapper
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 other projects for this? I had a little difficulty compiling for Win32, mainly because it is based on 2.8.3 and I wanted to use the latest source. I now have a working build though. Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]