Re: [sqlite] hfs+ on bootcamp -> database malformed?

[Simon Slavin]

On 21 Nov 2012, at 8:18pm, "E. Timothy Uy"  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

Re: [sqlite] hfs+ on bootcamp -> database malformed?

[E. Timothy Uy]

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  wrote:

>
> On 21 Nov 2012, at 6:32pm, E. Timothy Uy  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?

[Simon Slavin]

On 21 Nov 2012, at 6:32pm, E. Timothy Uy  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?

[Richard Hipp]

On Wed, Nov 21, 2012 at 1:32 PM, E. Timothy Uy  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] Help needed for validating SQLite under Linux/Cygwin

[Warren Young]

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

[sqlite] hfs+ on bootcamp -> database malformed?

[E. Timothy Uy]

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] Finding .db file in XCode project

[Ben]

On 21 Nov 2012, at 16:06, Donald Steele  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

Re: [sqlite] Finding .db file in XCode project

[Donald Steele]

I don't think so. The utility it specifically intended to build and edit 
SQLite3 
database files.




From: Paul Sanderson 
To: General Discussion of SQLite Database 
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  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 
> To: General Discussion of SQLite Database 
> 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  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

[Paul Sanderson]

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  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 
> To: General Discussion of SQLite Database 
> 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  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

[Simon Slavin]

On 21 Nov 2012, at 4:06pm, Donald Steele  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:



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

[Donald Steele]

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 
To: General Discussion of SQLite Database 
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  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

[Simon Slavin]

On 21 Nov 2012, at 3:53pm, Donald Steele  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] Finding .db file in XCode project

[Donald Steele]

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

[sqlite] Tcl API documentation "bug"

[Gerald W. Lester]

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] Help needed for validating SQLite under Linux/Cygwin

[brijesh_philips]

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