Re: [sqlite] How to build a new sqlite3.dylib?

[Clive Hayward]

Tobias,

Heres how you can make your own shared library under Mac OS X.

Download http://www.sqlite.org/download.html/sqlite-amalgamation-3071300.zip

# In the terminal
export LD_LIBRARY_PATH=.

# Make the library call it libsqlite3_mybuild.dylib
gcc -o libsqlite3_mybuild.dylib sqlite3.c -dynamiclib

# Build the shell using the new libsqlite3_mybuild.dylib shared library.
gcc -o shell shell.c -lsqlite3_mybuild -L$LD_LIBRARY_PATH

./shell
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .exit

# Display the names and version numbers of the shared libraries that
the object file uses.
otool -L ./shell
./shell:
libsqlite3_mybuild.dylib (compatibility version 0.0.0, current version 
0.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
version 159.1.0)

Best of Luck,

Clive Hayward

On Mon, Aug 6, 2012 at 3:48 PM, Tobias Giesen  wrote:
>> Do you absolutely need to use a dynamic library ?
>
> I have spent a full day trying to compile & link the c and h file with
> my Pascal code and I have given up. The DB library I have expects a
> dylib so I will have to feed it what it can eat.
>
> Trouble is, I don't know how to build the dylib either so I need some
> mercy from somebody who has a recent build.
>
> Thanks!
>
> Cheers,
> Tobias

-- 
Clive Hayward
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Simon Slavin]

On 6 Aug 2012, at 11:48pm, Tobias Giesen  wrote:

>> Do you absolutely need to use a dynamic library ? 
> 
> I have spent a full day trying to compile & link the c and h file with
> my Pascal code and I have given up. The DB library I have expects a
> dylib so I will have to feed it what it can eat.

Fair enough.  It seems you do need to.  Good luck with it.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Tobias Giesen]

> Do you absolutely need to use a dynamic library ? 

I have spent a full day trying to compile & link the c and h file with
my Pascal code and I have given up. The DB library I have expects a
dylib so I will have to feed it what it can eat.

Trouble is, I don't know how to build the dylib either so I need some
mercy from somebody who has a recent build.

Thanks!

Cheers,
Tobias


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Tim Streater]

On 06 Aug 2012 at 22:49, Simon Slavin  wrote: 

> On 6 Aug 2012, at 10:29pm, Tobias Giesen  wrote:
>
>> would you be willing to share your dylib with me? I don't know how to
>> do this with Xcode.
>
> Do you absolutely need to use a dynamic library ?  The recommendation from the
> SQLite team is that people build sqlite3 into their application  by including
> the .c and .h files, rather than call an external library.

I'm inclined to agree with this. I did it largely as an exercise in the use of 
Xcode.

--
Cheers  --  Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Simon Slavin]

On 6 Aug 2012, at 10:29pm, Tobias Giesen  wrote:

> would you be willing to share your dylib with me? I don't know how to
> do this with Xcode.

Do you absolutely need to use a dynamic library ?  The recommendation from the 
SQLite team is that people build sqlite3 into their application  by including 
the .c and .h files, rather than call an external library.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Tobias Giesen]

Hello,

would you be willing to share your dylib with me? I don't know how to
do this with Xcode.

Cheers
Tobias


> On 04 Aug 2012 at 11:54, Tobias Giesen  wrote: 
> 
> > I was able to compile the sqlite3 shell, but how to create the latest
> > dylib, or where can I download it?
> 
> I use xcode for this purpose, using the amalgamation.
> 
> --
> Cheers  --  Tim

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Tim Streater]

On 04 Aug 2012 at 11:54, Tobias Giesen  wrote: 

> I was able to compile the sqlite3 shell, but how to create the latest
> dylib, or where can I download it?

I use xcode for this purpose, using the amalgamation.

--
Cheers  --  Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to build a new sqlite3.dylib?

[Tobias Giesen]

Hi,
great I will try it!

Cheers,
Tobias
 
> On 4 Aug 2012, at 11:54am, Tobias Giesen  wrote:
> 
> > I was able to compile the sqlite3 shell, but how to create the latest
> > dylib, or where can I download it?
> 
> The most accepted way to write an application which uses the sqlite3 API is 
> to include the .c and .h file from the amalgamation version in your project.  
> sqlite3 is tiny.  You don't get much space saved from using it as a dynamic 
> library, and there are all sorts of problems when you have different versions 
> of the same library on your computer.  By compiling the routines into your 
> own applications you know exactly which version each application is working 
> with.
> 
> 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] How to build a new sqlite3.dylib?

[Simon Slavin]

On 4 Aug 2012, at 11:54am, Tobias Giesen  wrote:

> I was able to compile the sqlite3 shell, but how to create the latest
> dylib, or where can I download it?

The most accepted way to write an application which uses the sqlite3 API is to 
include the .c and .h file from the amalgamation version in your project.  
sqlite3 is tiny.  You don't get much space saved from using it as a dynamic 
library, and there are all sorts of problems when you have different versions 
of the same library on your computer.  By compiling the routines into your own 
applications you know exactly which version each application is working with.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users