/ Check-in [a154224b]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the build scripts and the homepage in preparation for version 3.3.14. (CVS 3797)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a154224b329423aef622be539f6e7dfb76dc4c21
User & Date: drh 2007-04-02 15:04:34
Context
2007-04-02
15:29
Changes to the download page. (CVS 3798) check-in: de8055bc user: drh tags: trunk
15:04
Update the build scripts and the homepage in preparation for version 3.3.14. (CVS 3797) check-in: a154224b user: drh tags: trunk
14:19
Cover an extra case in sqlite3PagerMovepage(). (CVS 3796) check-in: 7313688b user: danielk1977 tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to mkdll.sh.

     2      2   #
     3      3   # This script is used to compile SQLite into a DLL.
     4      4   #
     5      5   # Two separate DLLs are generated.  "sqlite3.dll" is the core
     6      6   # library.  "tclsqlite3.dll" contains the TCL bindings and is the
     7      7   # library that is loaded into TCL in order to run SQLite.
     8      8   #
     9         -make target_source
    10         -cd tsrc
            9  +make sqlite3.c
    11     10   PATH=$PATH:/opt/mingw/bin
    12     11   TCLDIR=/home/drh/tcltk/846/win/846win
    13     12   TCLSTUBLIB=$TCLDIR/libtcl84stub.a
    14         -OPTS='-DUSE_TCL_STUBS=1 -DNDEBUG=1 -DTHREADSAFE=1 -DBUILD_sqlite=1'
    15         -CC="i386-mingw32msvc-gcc -O2 $OPTS -I. -I$TCLDIR"
           13  +OPTS='-DUSE_TCL_STUBS=1 -DTHREADSAFE=1 -DBUILD_sqlite=1 -DOS_WIN=1'
           14  +CC="i386-mingw32msvc-gcc -O2 $OPTS -Itsrc -I$TCLDIR"
    16     15   NM="i386-mingw32msvc-nm"
    17         -rm shell.c
    18         -for i in *.c; do
    19         -  CMD="$CC -c $i"
    20         -  echo $CMD
    21         -  $CMD
    22         -done
           16  +CMD="$CC -c sqlite3.c"
           17  +echo $CMD
           18  +$CMD
           19  +CMD="$CC -c tsrc/tclsqlite.c -o tclsqlite.o"
           20  +echo $CMD
           21  +$CMD
    23     22   echo 'EXPORTS' >tclsqlite3.def
    24         -$NM *.o | grep ' T ' >temp1
           23  +$NM sqlite3.o tclsqlite.o | grep ' T ' >temp1
    25     24   grep '_Init$' temp1 >temp2
    26     25   grep '_SafeInit$' temp1 >>temp2
    27     26   grep ' T _sqlite3_' temp1 >>temp2
    28     27   echo 'EXPORTS' >tclsqlite3.def
    29     28   sed 's/^.* T _//' temp2 | sort | uniq >>tclsqlite3.def
    30     29   i386-mingw32msvc-dllwrap \
    31     30        --def tclsqlite3.def -v --export-all \
    32     31        --driver-name i386-mingw32msvc-gcc \
    33     32        --dlltool-name i386-mingw32msvc-dlltool \
    34     33        --as i386-mingw32msvc-as \
    35     34        --target i386-mingw32 \
    36         -     -dllname tclsqlite3.dll -lmsvcrt *.o $TCLSTUBLIB
    37         -#i386-mingw32msvc-strip tclsqlite3.dll
    38         -rm tclsqlite.o
    39         -$NM *.o | grep ' T ' >temp1
           35  +     -dllname tclsqlite3.dll -lmsvcrt tclsqlite.o sqlite3.o $TCLSTUBLIB
           36  +$NM sqlite3.o | grep ' T ' >temp1
    40     37   echo 'EXPORTS' >sqlite3.def
    41     38   grep ' _sqlite3_' temp1 | sed 's/^.* _//' >>sqlite3.def
    42     39   i386-mingw32msvc-dllwrap \
    43     40        --def sqlite3.def -v --export-all \
    44     41        --driver-name i386-mingw32msvc-gcc \
    45     42        --dlltool-name i386-mingw32msvc-dlltool \
    46     43        --as i386-mingw32msvc-as \
    47     44        --target i386-mingw32 \
    48         -     -dllname sqlite3.dll -lmsvcrt *.o
    49         -#i386-mingw32msvc-strip sqlite3.dll
    50         -cd ..
           45  +     -dllname sqlite3.dll -lmsvcrt sqlite3.o

Changes to publish.sh.

    16     16   cp $srcdir/Makefile.linux-gcc ./Makefile
    17     17   chmod +x $srcdir/install-sh
    18     18   
    19     19   # Get the current version number - needed to help build filenames
    20     20   #
    21     21   VERS=`cat $srcdir/VERSION`
    22     22   VERSW=`sed 's/\./_/g' $srcdir/VERSION`
           23  +echo "VERSIONS: $VERS $VERSW"
    23     24   
    24     25   # Start by building an sqlite shell for linux.
    25     26   #
    26     27   make clean
    27         -make sqlite3
           28  +make sqlite3.c
           29  +gcc -O2 -Itsrc sqlite3.c tsrc/shell.c -o sqlite3 -ldl -lpthread
    28     30   strip sqlite3
    29     31   mv sqlite3 sqlite3-$VERS.bin
    30     32   gzip sqlite3-$VERS.bin
           33  +chmod 644 sqlite3-$VERS.bin.gz
    31     34   mv sqlite3-$VERS.bin.gz doc
    32     35   
    33     36   # Build a source archive useful for windows.
    34     37   #
    35         -make target_source
    36         -cd tsrc
    37         -zip ../doc/sqlite-source-$VERSW.zip *
    38         -cd ..
           38  +make sqlite3.c
           39  +cp tsrc/sqlite3.h .
           40  +pwd
           41  +zip doc/sqlite-source-$VERSW.zip sqlite3.c sqlite3.h
    39     42   
    40     43   # Build the sqlite.so and tclsqlite.so shared libraries
    41     44   # under Linux
    42     45   #
    43         -. $srcdir/mkso.sh
    44         -cd tsrc
           46  +make sqlite3.c
           47  +TCLDIR=/home/drh/tcltk/846/linux/846linux
           48  +TCLSTUBLIB=$TCLDIR/libtclstub8.4g.a
           49  +gcc -O2 -shared -Itsrc sqlite3.c tsrc/tclsqlite.c $TCLSTUBLIB -o tclsqlite3.so
           50  +strip tclsqlite3.so
           51  +chmod 644 tclsqlite3.so
    45     52   mv tclsqlite3.so tclsqlite-$VERS.so
    46     53   gzip tclsqlite-$VERS.so
    47         -mv tclsqlite-$VERS.so.gz ../doc
           54  +mv tclsqlite-$VERS.so.gz doc
           55  +gcc -O2 -shared -Itsrc sqlite3.c -o sqlite3.so
           56  +strip sqlite3.so
           57  +chmod 644 sqlite3.so
    48     58   mv sqlite3.so sqlite-$VERS.so
    49     59   gzip sqlite-$VERS.so
    50         -mv sqlite-$VERS.so.gz ../doc
    51         -cd ..
           60  +mv sqlite-$VERS.so.gz doc
           61  +
    52     62   
    53     63   # Build the tclsqlite3.dll and sqlite3.dll shared libraries.
    54     64   #
    55     65   . $srcdir/mkdll.sh
    56         -cd tsrc
    57         -echo zip ../doc/tclsqlite-$VERSW.zip tclsqlite3.dll
    58         -zip ../doc/tclsqlite-$VERSW.zip tclsqlite3.dll
    59         -echo zip ../doc/sqlitedll-$VERSW.zip sqlite3.dll sqlite3.def
    60         -zip ../doc/sqlitedll-$VERSW.zip sqlite3.dll sqlite3.def
    61         -cd ..
           66  +echo zip doc/tclsqlite-$VERSW.zip tclsqlite3.dll
           67  +zip doc/tclsqlite-$VERSW.zip tclsqlite3.dll
           68  +echo zip doc/sqlitedll-$VERSW.zip sqlite3.dll sqlite3.def
           69  +zip doc/sqlitedll-$VERSW.zip sqlite3.dll sqlite3.def
    62     70   
    63     71   # Build the sqlite.exe executable for windows.
    64     72   #
    65     73   make target_source
    66         -cd tsrc
    67         -rm tclsqlite.c
    68     74   OPTS='-DSTATIC_BUILD=1 -DNDEBUG=1'
    69         -i386-mingw32msvc-gcc -O2 $OPTS -I. -I$TCLDIR *.c -o sqlite3.exe
    70         -zip ../doc/sqlite-$VERSW.zip sqlite3.exe
    71         -cd ..
           75  +i386-mingw32msvc-gcc -O2 $OPTS -Itsrc -I$TCLDIR sqlite3.c tsrc/shell.c \
           76  +      -o sqlite3.exe
           77  +zip doc/sqlite-$VERSW.zip sqlite3.exe
    72     78   
    73     79   # Construct a tarball of the source tree
    74     80   #
    75     81   ORIGIN=`pwd`
    76     82   cd $srcdir
    77     83   cd ..
    78     84   mv sqlite sqlite-$VERS

Changes to www/index.tcl.

    27     27   <li>A complete database is stored in a single disk file.</li>
    28     28   <li>Database files can be freely shared between machines with
    29     29       different byte orders.</li>
    30     30   <li>Supports databases up to 2 tebibytes
    31     31       (2<sup><small>41</small></sup> bytes) in size.</li>
    32     32   <li>Strings and BLOBs up to 2 gibibytes (2<sup><small>31</small></sup> bytes)
    33     33       in size.</li>
    34         -<li>Small code footprint: less than 250KiB fully configured or less
           34  +<li>Small code footprint: 
           35  +    <a href="http://www.sqlite.org/cvstrac/wiki?p=SizeOfSqlite">
           36  +    less than 250KiB</a> fully configured or less
    35     37       than 150KiB with optional features omitted.</li>
    36     38   <li><a href="speed.html">Faster</a> than popular client/server database
    37     39       engines for most common operations.</li>
    38     40   <li>Simple, easy to use <a href="capi3.html">API</a>.</li>
    39     41   <li><a href="tclsqlite.html">TCL bindings</a> included.
    40     42       Bindings for many other languages 
    41     43       <a href="http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers">
    42     44       available separately.</a></li>
    43         -<li>Well-commented source code with over 95% test coverage.</li>
           45  +<li>Well-commented source code with over 97% test coverage.</li>
           46  +<li>Available as a 
           47  +    <a href="http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation">
           48  +    single ANSI-C source-code file</a> that you can easily drop into
           49  +    another project.
    44     50   <li>Self-contained: no external dependencies.</li>
    45     51   <li>Sources are in the <a href="copyright.html">public domain</a>.
    46     52       Use for any purpose.</li>
    47     53   </ul>
    48     54   </p>
    49     55   
    50     56   <p>
................................................................................
    62     68   
    63     69   proc newsitem {date title text} {
    64     70     puts "<h3>$date - $title</h3>"
    65     71     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    66     72     puts "<p>$txt</p>"
    67     73     puts "<hr width=\"50%\">"
    68     74   }
           75  +
           76  +newsitem {2007-Apr-02} {Version 3.3.14} {
           77  +  This version focuses on performance improvements.  If you recompile
           78  +  <a href="http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation">
           79  +  the amalgamation</a> using GCC option -O3 (the precompiled binaries
           80  +  use -O2) you may see performance
           81  +  improvements of 35% or more over version 3.3.13 depending on your
           82  +  workload.  This version also
           83  +  adds support for <a href="pragma.html#pragma_locking_mode">
           84  +  exclusive access mode</a>.
           85  +}
    69     86   
    70     87   newsitem {2007-Feb-13} {Version 3.3.13} {
    71     88     This version fixes a subtle bug in the ORDER BY optimizer that can 
    72     89     occur when using joins.  There are also a few minor enhancements.
    73     90     Upgrading is recommended.
    74     91   }
    75     92   
................................................................................
    92    109     release.  Upgrading is recommended.
    93    110   }
    94    111   
    95    112   puts {
    96    113   <p align="right"><a href="oldnews.html">Old news...</a></p>
    97    114   </td></tr></table>
    98    115   }
    99         -footer {$Id: index.tcl,v 1.150 2007/02/13 02:03:24 drh Exp $}
          116  +footer {$Id: index.tcl,v 1.151 2007/04/02 15:04:34 drh Exp $}