Re: [sqlite] the 2.8 database ananysis tool

2004-06-18 Thread Steve Palmer
I see versions of this for Linux and Windows, but not for Mac OSX. Are the sources going to be made available so that we can build for our platform? On Jun 17, 2004, at 11:41pm, Darren Duncan wrote: At 7:15 AM -0400 6/17/04, D. Richard Hipp wrote: Also tomorrow, I will be making available a

Re: [sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Darren Duncan
At 2:28 AM +0200 6/19/04, Roberto Saccon wrote (by direct email): Thanks, but I have no control over the computers of people using my application. Of course this is not a problem for my own system, but believe me, there are millions of people ot there with such old systems. Roberto Who says you

Re: [sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Darren Duncan
At 1:58 AM +0200 6/19/04, Roberto Saccon wrote: Hi all I am a happy user of sqlite, but currently my filesizes are little, because I store Multimedia data on a Berkeley-DB-like storage (QDBM), which can be splitted into several files. Now I am thinking about storing the multimedia data also

RE: [sqlite] sqlite with Visual Basic

2004-06-18 Thread Steve O'Hara
I think you've missed the point... The VB wrapper allows VB programmers (this includes ASP) to interface directly to SQLite. No half way houses, no strange connection of disparate apps, just straight-forward Windows code. As you say, if you're talking VB then you're obviously talking

[sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Roberto Saccon
Hi all I am a happy user of sqlite, but currently my filesizes are little, because I store Multimedia data on a Berkeley-DB-like storage (QDBM), which can be splitted into several files. Now I am thinking about storing the multimedia data also with sqlite in the upcoming 3.0 release, because

Re: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available

2004-06-18 Thread Hans-Juergen Taenzer
Hihn, Jason ([EMAIL PROTECTED]) wrote: > I am not the one to answer this, but I do know the mains that > KJSEmbed is going through at the moment. The whole delay is trying > to get it to compile in MSVC, but they moved to mingw32, where > it's much more standard. They've since been chugging

RE: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available

2004-06-18 Thread Hihn, Jason
I am not the one to answer this, but I do know the mains that KJSEmbed is going through at the moment. The whole delay is trying to get it to compile in MSVC, but they moved to mingw32, where it's much more standard. They've since been chugging along. "Weeks" of work was reduced to days. I

[sqlite] about SQL feature requests

2004-06-18 Thread Darren Duncan
To those people who are asking about support for new SQL such as variable subqueries or 'alter table', keep in mind that these sorts of things can be added later without file format changes. What Richard really needs to know about now is if features related to transactions or concurrency or

RE: [sqlite] sqlite with Visual Basic

2004-06-18 Thread Hihn, Jason
Again, I'm coming to this late... While not VisualBasic, you could theoretically do it in JavaScript (just as easy) using KJSEmbed. KJSEmbed is a project that binds JavaScript to KDE. Now not Everyone is KDE users, and since you're asking for VB, I'll assume you're on windows. Well good news.

[sqlite] sqlite with Visual Basic

2004-06-18 Thread Jérôme VERITE
If you search a wrapper for VB6, I did one with a VB6 COM DLL which permit to use classes which look like the DAO classes for access (Database and Recordset). I have made little change to the C Dll to avoid create a SAFEARRAY and need less memory for big select statements. If you want it, I can

RE: [sqlite] sqlite with Visual Basic

2004-06-18 Thread Jérôme VERITE
If you search a wrapper for VB6, I did one with a VB6 COM DLL which permit to use classes which look like the DAO classes for access (Database and Recordset). I have made little change to the C Dll to avoid create a SAFEARRAY and need less memory for big select statements. If you want it, I can

Re: [sqlite] Version 3.0.0 ALPHA now available

2004-06-18 Thread VTenneti
Any chance of getting Correlated Subqueries, including the EXISTS / NOT EXISTS clause ? And since it is open season, could we have user defined expression evaluation functionality (other than user defined compares that 3.0 already has). For example arithmetic, substring etc ?

Re: [sqlite] Variable sub-queries?

2004-06-18 Thread Richard Boehme
Yes... in particular "ALTER TABLE" would be nice to have and it wouldn't need to be all that fast, either. Thank you. Richard Boehme Drew, Stephen wrote: I agree that minimising the SQL syntax that SQLite doesn't support would be a good addition to the new release. Steve -Original

[sqlite] SELECT statements in transactions

2004-06-18 Thread Richard Boehme
One thing that I've been getting from the conversation around here is that you can run SELECT statements in a transaction and run them like you normally would without waiting for the transaction to commit. Is this correct? I haven't been doing SELECT statements in a transaction because my

RE: [sqlite] Variable sub-queries?

2004-06-18 Thread Drew, Stephen
I agree that minimising the SQL syntax that SQLite doesn't support would be a good addition to the new release. Steve -Original Message- From: J.W. Janssen [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 2:03 PM To: [EMAIL PROTECTED] Subject: [sqlite] Variable sub-queries?

[sqlite] Version 3.0.0 ALPHA now available

2004-06-18 Thread D. Richard Hipp
Version 3.0.0 (alpha) of SQLite is now available on the website. http://www.sqlite.org/ http://www.sqlite.org/version3.html http://www.sqlite.org/capi3.html This is an alpha release intended for testing and evaluation only. Version 3 is not yet ready for production use. A file format and

[sqlite] VxWorks port for Sqlite

2004-06-18 Thread rajneesh . khanna
Hi All, Does anyone know , if there's any VxWorks port for SQlite available . Thanks Rajneesh Khanna - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]