For your information, this is how I currently build sqlite3
from trunk on Solaris "SXCE" (OpenSolaris, yeah, it's old).

I'm probably kicking in open doors for some people, but it
might be interesting for some others.

Thanks to whoever did the autoconf/makefile effort for sqlite3 and fossil!

Paths:
~/src/sqlite3  : fossil checkout 
~/bld/sqlite3  : builddir
~/usr/bin      : installdir

$ cat /etc/release
                  Solaris Express Community Edition snv_130 X86
           Copyright 2009 Sun Microsystems, Inc.  All Rights Reserved.
                        Use is subject to license terms.
                           Assembled 14 December 2009

$ uname -a
SunOS ozon 5.11 snv_130 i86pc i386 i86pc

# function for sqlite3 in my generic build script:
mksqlite3 () {
        INSTALLDIR="${HOME}/usr/bin"

        test ! -z "${PULL}" \
        && cd ${HOME}/src/sqlite3 \
        && fossil pull \
        && fossil update trunk \
        && cd

        cd ${HOME}/bld/sqlite3 \
        && rm -rf ${HOME}/bld/sqlite3/* \
        && ../../src/sqlite3/configure \
        --prefix=${HOME}/usr \
        --enable-amalgamation \
        --disable-shared \
        --enable-static \
        --enable-load-extension \
        --enable-threadsafe \
        --enable-readline \
        --disable-tcl \
        --with-readline-lib="-L/usr/lib -R/usr/lib -lreadline -ltermcap" \
        --with-readline-inc=-I/usr/include/readline \
        && make sqlite3.c \
        && make \
        && make install \
        && make clean
}

# size
$ ls -nl ~/usr/bin/sqlite3
-rwxr-xr-x+  1 65536    10       1121820 Jan 16 23:46 
/extra/home/knu/usr/bin/sqlite3

# Obviously, I could add this to the function:
$ strip /extra/home/knu/usr/bin/sqlite3 

# stripped sized
$ ls -nl ~/usr/bin/sqlite3
-rwxr-xr-x+  1 65536    10        528628 Jan 17 00:07 
/extra/home/knu/usr/bin/sqlite3

# dependencies
$ ldd /extra/home/knu/usr/bin/sqlite3
        libreadline.so.5 =>      /usr/lib/libreadline.so.5
        libcurses.so.1 =>        /usr/lib/libcurses.so.1
        libc.so.1 =>     /usr/lib/libc.so.1
        libm.so.2 =>     /lib/libm.so.2

$ sqlite3
SQLite version 3.8.3 2014-01-16 15:31:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .q

BTW, the fossil build is even more simple:

mkfossil () {
        set -xv
        test ! -z "${PULL}" && cd ${HOME}/src/fossil && fossil pull && fossil 
update trunk && cd
        cd ${HOME}/src/fossil \
        && ./configure \
        && make \
        && mv -f fossil ${HOME}/usr/bin/fossil \
        && make clean \
        && cd
        set +xv
}

On Solaris, I complie trunk every now and then, on MS Windows, I run the 
released executables.

I'll try the same on XStreamOS shortly.
http://www.sonicle.com/index.jsp?pagename=xstreamos-desktop&parent=products
XStreamOS is an OpenSolaris fork.


-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

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

Reply via email to