Re: [sqlite] the 2.8 database ananysis tool
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 database analysis tool for version 2.8 databases that will help us to better understand how information is stored on disk for your database, and possibly provide some clues about why you are having problems. Will a tool like this be available for version 3.0 databases some time in the near future? Or is this something that only paid customers used to get, and you're releasing it now for 2.8 because the 2.x line is now end-of-lifed? -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Steve - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] How to deal with Filesize-Limit of 2GB on Windows 95
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 have no control? Why not just indicate operating systems that support files larger than 2GB in the requirements for your application? Or more specifically, state that they must have a good operating system in order to use Multimedia data collections that are individually larger than 2GB. Those with less capable operating systems can explicitely use multiple data collections (SQLite files), or keep theirs under 2GB. That's how I suggest you deal with the problem. Trying to support larger files on operating systems that aren't designed for it is a cludge and probably won't help a lot of people. The only reason I see you may have to go to a lot of trouble is if you were explicitely given requirements that the application must support files over 2GB on Windows 95. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] How to deal with Filesize-Limit of 2GB on Windows 95
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 with sqlite in the upcoming 3.0 release, because it has native BLOB support. Well, I haven't done any test yet about performance, but one concern I have is the filesize limit of 2 GB on MS Windows 95. Does sqlite provide some way of splitting the database file in small pieces ? How are other developers dealing with this filesize isssue for old MS Windows systems ? regards Roberto P.S. if this qustion has been anwsered before, this is my first post to the list, and I really googeled a lot about the topic, but didn't found anything. I suggest you could upgrade to a better operating system. Any computer new enough to have hard drives much larger than 2GB should also be able to handle a better operating system without choking. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] sqlite with Visual Basic
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 Windows, so why propose a solution that isn't even proven on Windows? JavaScript and KDE, you're having a laugh? Steve -Original Message- From: Hihn, Jason [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 18:52 To: [EMAIL PROTECTED] Subject: RE: [sqlite] sqlite with Visual Basic 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. There is a qt-only port that binds against Qt (www.trolltech.com) (Qt includes a SQLite driver) so you can, with Qt, use SQLite. Now this is still not 100%, because it only works under Linux, and you need the CVS version ATM. BUT shortly (days - weeks maximally) they will be releasing Win32-Qt-Only-KJSEmbed. It'll be a couple DLLs and an EXE to run the script. http://xmelegance.org/kjsembed/ http://xmelegance.org/kjsembed/examples/sql/sql.js Currently, I am using KJSEmbed to create and run dialogs platform-independently. There are glitches, but they usually get everything fixed or added with 7 days (1 week) -Original Message- From: Jorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 4:41 PM To: Jalil Vaidya; Jorge; [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Visual Basic No, no... there is not mentioned VBWrapper.zip 1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina. http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.ht ml isn't active Visual Basic 6 http://www.ag-software.com/SQLite/default.asp it's OK, but it isn't VBWrapper.zip SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 & VB6; Get both pssql.zip and psvbutls32.zip ) I am not yahoo group member SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL). http://www.sqliteplus.com ($$) it isn't my favourite price!!! TIA Jorge - Original Message - From: "Jalil Vaidya" <[EMAIL PROTECTED]> To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 5:50 PM Subject: Re: [sqlite] sqlite with Visual Basic Check out COM Wrappers / Visual Basic DLLs section in the wiki: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers HTH, Jalil Vaidya --- Jorge <[EMAIL PROTECTED]> wrote: > Hi, > > Are there any site whehe can I found the mentioned > VBWrapper.zip? > > I have tried in http://f4.grp.yahoofs.com/..., but > this URL isn't OK > > TIA > > Jorge Colaccini = 01001010 0111 01101100 01101001 01101100 __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] How to deal with Filesize-Limit of 2GB on Windows 95
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 it has native BLOB support. Well, I haven't done any test yet about performance, but one concern I have is the filesize limit of 2 GB on MS Windows 95. Does sqlite provide some way of splitting the database file in small pieces ? How are other developers dealing with this filesize isssue for old MS Windows systems ? regards Roberto P.S. if this qustion has been anwsered before, this is my first post to the list, and I really googeled a lot about the topic, but didn't found anything. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available
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 along. > "Weeks" of work was reduced to days. > I guess what I'm saying is MSVC didn't embrace ANSI enough. In the past SQLite (and my programs using SQLite) compiled just fine with MSVC and run without any problems. I don't think there would be problems with the new version 3.0 if there wasn't the problem with the 'long long' datatype. Just using a suitable typdef for this datatype would resolve the problem (maybe there have to be changes to printf() too, I haven't checked it yet). And I think using another compiler than GNUC would be a good test for the new version too. > Could minw32 work for you? Yes, but I want to have a good IDE to work with. :-) Gruss Hans-Jürgen - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available
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 guess what I'm saying is MSVC didn't embrace ANSI enough. Could minw32 work for you? http://www.mingw.org/ -Original Message- From: Hans-Juergen Taenzer [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 2:37 PM To: [EMAIL PROTECTED] Subject: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available D. Richard Hipp ([EMAIL PROTECTED]) wrote: > Version 3.0.0 (alpha) of SQLite is now available on the > website. Will there be support for other compilers than GNUC? For example the datatype "long long" is not supported by MSVC. In the prior versions there were the typedef off_t, which was defined suitable as __int64. Hans-Jürgen Tänzer - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] about SQL feature requests
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 locking or data integrity are properly implemented, and if the new C API works well. These sorts of things are the hardest to change later if we want to freeze the file format. So I strongly suggest saving SQL questions until some time later, such as when SQLite 3 is past its beta phase (or at least past its alpha phase). Meanwhile, they can be distracting from the important tasks at hand. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] sqlite with Visual Basic
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. There is a qt-only port that binds against Qt (www.trolltech.com) (Qt includes a SQLite driver) so you can, with Qt, use SQLite. Now this is still not 100%, because it only works under Linux, and you need the CVS version ATM. BUT shortly (days - weeks maximally) they will be releasing Win32-Qt-Only-KJSEmbed. It'll be a couple DLLs and an EXE to run the script. http://xmelegance.org/kjsembed/ http://xmelegance.org/kjsembed/examples/sql/sql.js Currently, I am using KJSEmbed to create and run dialogs platform-independently. There are glitches, but they usually get everything fixed or added with 7 days (1 week) -Original Message- From: Jorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 4:41 PM To: Jalil Vaidya; Jorge; [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Visual Basic No, no... there is not mentioned VBWrapper.zip 1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina. http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.ht ml isn't active Visual Basic 6 http://www.ag-software.com/SQLite/default.asp it's OK, but it isn't VBWrapper.zip SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 & VB6; Get both pssql.zip and psvbutls32.zip ) I am not yahoo group member SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL). http://www.sqliteplus.com ($$) it isn't my favourite price!!! TIA Jorge - Original Message - From: "Jalil Vaidya" <[EMAIL PROTECTED]> To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 5:50 PM Subject: Re: [sqlite] sqlite with Visual Basic Check out COM Wrappers / Visual Basic DLLs section in the wiki: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers HTH, Jalil Vaidya --- Jorge <[EMAIL PROTECTED]> wrote: > Hi, > > Are there any site whehe can I found the mentioned > VBWrapper.zip? > > I have tried in http://f4.grp.yahoofs.com/..., but > this URL isn't OK > > TIA > > Jorge Colaccini = 01001010 0111 01101100 01101001 01101100 __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] sqlite with Visual Basic
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 mail you or it may be linked since the wiki pages (but I don't know how to do it) Excuse me for my english. Jérôme - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] sqlite with Visual Basic
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 mail you or it may be linked since the wiki pages (but I don't know how to do it) Excuse me for my english. Jérôme -Message d'origine- De : Steve O'Hara [mailto:[EMAIL PROTECTED] Envoyé : vendredi 18 juin 2004 14:05 À : [EMAIL PROTECTED] Objet : RE: [sqlite] sqlite with Visual Basic This is what you're looking for I think. http://www.pivotal-solutions.co.uk/downloads/vbwrapper.zip This is a wrapper that calls the sqlite.dll dynamically so that you can transplant any version of the DLL you like. The compiled DLL is included along with source and a sample VB project (Make sure that pssqlite.dll and sqlite.dll are in the path). If you can think of improvements, let me know. Steve -Original Message- From: Jorge [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 22:41 To: Jalil Vaidya; Jorge; [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Visual Basic No, no... there is not mentioned VBWrapper.zip 1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina. http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html isn't active Visual Basic 6 http://www.ag-software.com/SQLite/default.asp it's OK, but it isn't VBWrapper.zip SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 & VB6; Get both pssql.zip and psvbutls32.zip ) I am not yahoo group member SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL). http://www.sqliteplus.com ($$) it isn't my favourite price!!! TIA Jorge - Original Message - From: "Jalil Vaidya" <[EMAIL PROTECTED]> To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 5:50 PM Subject: Re: [sqlite] sqlite with Visual Basic Check out COM Wrappers / Visual Basic DLLs section in the wiki: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers HTH, Jalil Vaidya --- Jorge <[EMAIL PROTECTED]> wrote: > Hi, > > Are there any site whehe can I found the mentioned > VBWrapper.zip? > > I have tried in http://f4.grp.yahoofs.com/..., but > this URL isn't OK > > TIA > > Jorge Colaccini = 01001010 0111 01101100 01101001 01101100 __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Version 3.0.0 ALPHA now available
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 ? "D. Richard Hipp" <[EMAIL PROTECTED]> To 18/06/2004 13:33 [EMAIL PROTECTED] cc Subject [sqlite] Version 3.0.0 ALPHA now available 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 API freeze is scheduled for July 1. Users are encouraged to evaluate this release and make suggestions on how to improve the interface prior to that date. Anonymous CVS access has been reenabled. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Variable sub-queries?
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 Message- From: J.W. Janssen [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 2:03 PM To: [EMAIL PROTECTED] Subject: [sqlite] Variable sub-queries? Hi, The documentation on SQLite states that variable subqueries aren't supported. I whether SQLite will support this in the (near) future, and if not, why not. TiA, Jan Willem -- ` | J.W. Janssen, Groesbeekseweg 191 , (o< | 6523 NS Nijmegen, The Netherlands | /\ | mail: j dot w dot janssen at lxtreme dot nl | v_/_ | http: www.lxtreme.nl ' ` -- "Statistics are like bikinis. What they reveal is suggestive, but what they hide is vital." -- anonymous /.'er - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Thank you. Richard Boehme Senior Programmer and Development Coordinator eyeMaginations, Inc 410-321-5481 x18 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] SELECT statements in transactions
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 impression was that I couldn't just do the SELECT and then process it, the next select, etc. until ending the transaction. If I can run SELECTs in a transaction, I think parts of my app might be speeded up considerably. Thanks again to the people on this mailing list for clarifying my understanding of SQLite (a bit more, at least). Richard Boehme - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Variable sub-queries?
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? Hi, The documentation on SQLite states that variable subqueries aren't supported. I whether SQLite will support this in the (near) future, and if not, why not. TiA, Jan Willem -- ` | J.W. Janssen, Groesbeekseweg 191 , (o< | 6523 NS Nijmegen, The Netherlands | /\ | mail: j dot w dot janssen at lxtreme dot nl | v_/_ | http: www.lxtreme.nl ' ` -- "Statistics are like bikinis. What they reveal is suggestive, but what they hide is vital." -- anonymous /.'er - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Version 3.0.0 ALPHA now available
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 API freeze is scheduled for July 1. Users are encouraged to evaluate this release and make suggestions on how to improve the interface prior to that date. Anonymous CVS access has been reenabled. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] VxWorks port for Sqlite
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]