[sqlite] Help needed for validating SQLite under Linux/Cygwin
Hello, I need to validate few tools including Sqlite on Linux environment. Currently i'm using cygwin for validating the tools. I have downloaded the latest (3.7.14.1) SQLite amalgamation file from SQLite website and i'm able to create a library out of it. I need guidance/clarification on following things: - Do i need to include additional file as part of the amalgation file while building the SQLite library? - Link from where i can download TCL Test suite (scripts) to test SQLite version 3.7.14.1 for linux? Note: I would like to run all.test which covers most of the SQLite testing. - Where can i find the required files to build application (testfixture.exe) to run this test suite under cygwin? - Any additional tools i need to install in cygwin to run the TCL test suite? - Can we validate SQLite under cygwin? If that is not possible, what is the other alternative under which i can validate? Any help/guidance on the above query is greatly appreciated. Thanks, Brijesh -- View this message in context: http://sqlite.1065341.n5.nabble.com/Help-needed-for-validating-SQLite-under-Linux-Cygwin-tp65621.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Tcl API documentation bug
The documentation (http://sqlite.org/tclsqlite.html) states: The *sqlite3* command is used as follows: *sqlite3* /dbcmd database-name/ However, the following shows up in the console: $ tclsh % package require sqlite3 3.7.12 % sqlite3 wrong # args: should be sqlite3 HANDLE FILENAME ?-vfs VFSNAME? ?-readonly BOOLEAN? ?-create BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex BOOLEAN? ?-uri BOOLEAN? % What are the meaning of the additional optional arguments? P.S. -- I've not check other commands for mismatches. -- ++ | Gerald W. Lester, President, KNG Consulting LLC| | Cell: +1.504.236.6657 | Email: gerald.les...@kng-consulting.net| ++ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Finding .db file in XCode project
I have written an iOS app. Within that app I've created a SQLite3 database. I've used code inside the app to add data and then search the database and display results. I have now downloaded a freeware database editing utility (MesaSQLite) and attempted to connect to that database so that I can finish adding the rest of the data before submitting this app to Apple. The problem is that mesaSQLite can not open the database. I did try a different SQLite database editor and it can't open the file either but it give an error message stating the file is read only. In order to change it to read-write I need to find it. I have tried to look at the folders within my Xcode project. I fact I even turned on showallfiles and still can't find my database file. I've saved it in NSDocumentDirectory and I see no such when I search the hard drive. My hope is someone here has had this same problem and has a solution. Any help is appreciated, Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Finding .db file in XCode project
On 21 Nov 2012, at 3:53pm, Donald Steele xln...@sbcglobal.net wrote: The problem is that mesaSQLite can not open the database. I did try a different SQLite database editor and it can't open the file either Does it find a file with the right name in the location you're pointing it to ? Ignore the fact that you're looking for something to do with SQLite for the moment and just concentrate on looking for a file with the right name. but it give an error message stating the file is read only. In order to change it to read-write I need to find it. I have tried to look at the folders within my Xcode project. I fact I even turned on showallfiles and still can't find my database file. I've saved it in NSDocumentDirectory and I see no such when I search the hard drive. Files created by an iOS app are stored in a folder accessible only by that app. Depending on how you're looking at that app you would probably see that space as part of the app's bundle. You won't be able to use another app on the same iDevice to access them because that other app will be looking inside its own space. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Finding .db file in XCode project
I am not trying to access it on a iDevice. I am trying to access it on my Mac. How do I build the database and then give the iOS app access? From: Simon Slavin slav...@bigfraud.org To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wed, November 21, 2012 7:57:15 AM Subject: Re: [sqlite] Finding .db file in XCode project On 21 Nov 2012, at 3:53pm, Donald Steele xln...@sbcglobal.net wrote: The problem is that mesaSQLite can not open the database. I did try a different SQLite database editor and it can't open the file either Does it find a file with the right name in the location you're pointing it to ? Ignore the fact that you're looking for something to do with SQLite for the moment and just concentrate on looking for a file with the right name. but it give an error message stating the file is read only. In order to change it to read-write I need to find it. I have tried to look at the folders within my Xcode project. I fact I even turned on showallfiles and still can't find my database file. I've saved it in NSDocumentDirectory and I see no such when I search the hard drive. Files created by an iOS app are stored in a folder accessible only by that app. Depending on how you're looking at that app you would probably see that space as part of the app's bundle. You won't be able to use another app on the same iDevice to access them because that other app will be looking inside its own space. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Finding .db file in XCode project
On 21 Nov 2012, at 4:06pm, Donald Steele xln...@sbcglobal.net wrote: I am not trying to access it on a iDevice. I am trying to access it on my Mac. How do I build the database and then give the iOS app access? You can use any SQLite tools available to build the database. I recommend the SQLite shell tool which is already loaded on your Mac. You should be able to have it make you a database just by issuing a command something like sqlite3 ~/Desktop/mydatabase.sqlite then using SQL commands to create whatever tables and data you need, and make sure your SELECTs work the way you think they should. Documentation here: http://www.sqlite.org/sqlite.html Once you have made your database file, you need to use Xcode to add a copy of it to the app's bundle. You will find examples of this in the tutorials for making iApps. They show you how to add an arbitrary file to an iApp project, and what routines to use in your iApp to find the path of a file in the bundle. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Finding .db file in XCode project
Is it an extension issue - have you given your database an extension that the other tool can't see by default? On 21 November 2012 16:06, Donald Steele xln...@sbcglobal.net wrote: I am not trying to access it on a iDevice. I am trying to access it on my Mac. How do I build the database and then give the iOS app access? From: Simon Slavin slav...@bigfraud.org To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wed, November 21, 2012 7:57:15 AM Subject: Re: [sqlite] Finding .db file in XCode project On 21 Nov 2012, at 3:53pm, Donald Steele xln...@sbcglobal.net wrote: The problem is that mesaSQLite can not open the database. I did try a different SQLite database editor and it can't open the file either Does it find a file with the right name in the location you're pointing it to ? Ignore the fact that you're looking for something to do with SQLite for the moment and just concentrate on looking for a file with the right name. but it give an error message stating the file is read only. In order to change it to read-write I need to find it. I have tried to look at the folders within my Xcode project. I fact I even turned on showallfiles and still can't find my database file. I've saved it in NSDocumentDirectory and I see no such when I search the hard drive. Files created by an iOS app are stored in a folder accessible only by that app. Depending on how you're looking at that app you would probably see that space as part of the app's bundle. You won't be able to use another app on the same iDevice to access them because that other app will be looking inside its own space. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Finding .db file in XCode project
I don't think so. The utility it specifically intended to build and edit SQLite3 database files. From: Paul Sanderson sandersonforens...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wed, November 21, 2012 8:15:35 AM Subject: Re: [sqlite] Finding .db file in XCode project Is it an extension issue - have you given your database an extension that the other tool can't see by default? On 21 November 2012 16:06, Donald Steele xln...@sbcglobal.net wrote: I am not trying to access it on a iDevice. I am trying to access it on my Mac. How do I build the database and then give the iOS app access? From: Simon Slavin slav...@bigfraud.org To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wed, November 21, 2012 7:57:15 AM Subject: Re: [sqlite] Finding .db file in XCode project On 21 Nov 2012, at 3:53pm, Donald Steele xln...@sbcglobal.net wrote: The problem is that mesaSQLite can not open the database. I did try a different SQLite database editor and it can't open the file either Does it find a file with the right name in the location you're pointing it to ? Ignore the fact that you're looking for something to do with SQLite for the moment and just concentrate on looking for a file with the right name. but it give an error message stating the file is read only. In order to change it to read-write I need to find it. I have tried to look at the folders within my Xcode project. I fact I even turned on showallfiles and still can't find my database file. I've saved it in NSDocumentDirectory and I see no such when I search the hard drive. Files created by an iOS app are stored in a folder accessible only by that app. Depending on how you're looking at that app you would probably see that space as part of the app's bundle. You won't be able to use another app on the same iDevice to access them because that other app will be looking inside its own space. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Finding .db file in XCode project
On 21 Nov 2012, at 16:06, Donald Steele xln...@sbcglobal.net wrote: I am not trying to access it on a iDevice. I am trying to access it on my Mac. How do I build the database and then give the iOS app access? It will probably be in a subfolder of: ~/Library/Application Support/iPhone Simulator/6.0/Applications There's a load of UUID-named folders in there, one for each simulator app. Poke around in there and you'll likely find it. - Ben ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] hfs+ on bootcamp - database malformed?
I'm suddenly getting a database disk image is malformed on a customer after they had a bad HFS+ install. They are running Boot Camp on a Mac. I checked and the db is exactly the same on my machine and his, but he gets the error. Is anyone else seeing this? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help needed for validating SQLite under Linux/Cygwin
On 11/20/2012 06:42, brijesh_philips wrote: I need to validate few tools including Sqlite on Linux environment. Currently i'm using cygwin for validating the tools. Don't do that. Cygwin tries hard to be Linux compatible, but there are several cases where Cygwin simply cannot behave like Linux because the underlying Windows kernel doesn't have proper POSIX semantics, and it's too difficult -- even impossible sometimes -- to emulate those semantics on top of Windows semantics. If you want to test Linux behavior, test on a Linux machine. If you must use a Windows host for this, get one of the many virtual machine systems, and set up a Linux VM. If you're already on Windows 8, you may be able to use its new Client Hyper-V feature for this. If not, you can choose from VMware, VirtualBox, Parallels... Here is just one example of an incompatibility between Cygwin and Linux, which is directly relevant to SQLite: http://stackoverflow.com/questions/11007024/ - Do i need to include additional file as part of the amalgation file while building the SQLite library? I'm not sure what you're asking. Are you asking if the library you successfully built is somehow incomplete? The whole point of the amalgamation distribution is that it *is* functionally complete. - Link from where i can download TCL Test suite (scripts) to test SQLite version 3.7.14.1 for linux? https://www.sqlite.org/testing.html I found that with Google for SQLite Tcl test suite. What search terms did you try? And yes, I'm aware that I did not give you a direct link to the test code. If you cannot figure out what ...contained in the same source tree as the SQLite core... means, you have no business doing this evaluation. - Can we validate SQLite under cygwin? Sure. ...and when you have finished your validation tests, you will have validated that SQLite works within certain known parameters *on Cygwin*. You will also have learned enough to be able to make some informed guesses about how SQLite might behave on Linux, but you will not know if these guesses are correct until you actually test on Linux. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] hfs+ on bootcamp - database malformed?
On Wed, Nov 21, 2012 at 1:32 PM, E. Timothy Uy t...@loqu8.com wrote: I'm suddenly getting a database disk image is malformed on a customer after they had a bad HFS+ install. They are running Boot Camp on a Mac. I checked and the db is exactly the same on my machine and his, but he gets the error. Is anyone else seeing this? Maybe the customer is using a very old version of SQLite and the database is using some language feature that has been added more recently and that the older SQLite does not understand? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] hfs+ on bootcamp - database malformed?
On 21 Nov 2012, at 6:32pm, E. Timothy Uy t...@loqu8.com wrote: I'm suddenly getting a database disk image is malformed on a customer after they had a bad HFS+ install. They are running Boot Camp on a Mac. I checked and the db is exactly the same on my machine and his, but he gets the error. Is anyone else seeing this? What version of SQL are you both running ? Give us the result of SELECT sqlite_version() on both computers. If you copy the database from the HFS+ partition to the one you're booted from, does it still show as corrupt ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] hfs+ on bootcamp - database malformed?
No, I checked the hash of his version and mine, they are identical. It really is something strange on his machine. He claims that it stopped working after uninstalling HFS+. On Wed, Nov 21, 2012 at 12:02 PM, Simon Slavin slav...@bigfraud.org wrote: On 21 Nov 2012, at 6:32pm, E. Timothy Uy t...@loqu8.com wrote: I'm suddenly getting a database disk image is malformed on a customer after they had a bad HFS+ install. They are running Boot Camp on a Mac. I checked and the db is exactly the same on my machine and his, but he gets the error. Is anyone else seeing this? What version of SQL are you both running ? Give us the result of SELECT sqlite_version() on both computers. If you copy the database from the HFS+ partition to the one you're booted from, does it still show as corrupt ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] hfs+ on bootcamp - database malformed?
On 21 Nov 2012, at 8:18pm, E. Timothy Uy t...@loqu8.com wrote: No, I checked the hash of his version and mine, they are identical. It really is something strange on his machine. He claims that it stopped working after uninstalling HFS+. I think by the above you were checking the contents of the database file to make sure the file itself isn't corrupt. What I wanted to know is which version of SQLite you are using, on each computer, to access the file. Later versions of SQLite can put things into a database which will make earlier versions report it as corrupt. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users