SQLite 1.9.0

pts/sqlite-1.9.0 - 09 June 2015 - Big update to SQLite

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v5.8.0 (Belev)-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://www.sqlite.org/2015/sqlite-autoconf-3081002.tar.gz</URL>
      <MD5>a18bfc015cd49a1e7a961b7b77bc3b37</MD5>
      <SHA256>8382e55a4e7d853c93038562ca3dd00307937fccf1c6b65ddd813e503a56d626</SHA256>
      <FileSize>2049387</FileSize>
    </Package>
    <Package>
      <URL>http://www.phoronix-test-suite.com/benchmark-files/pts-sqlite-tests-1.tar.gz, http://www.phoronix.net/downloads/phoronix-test-suite/benchmark-files/pts-sqlite-tests-1.tar.gz</URL>
      <MD5>153e725642619e38766ddf8359f65cfe</MD5>
      <FileSize>42835</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh

tar -zxvf pts-sqlite-tests-1.tar.gz
tar -zxvf sqlite-autoconf-3081002.tar.gz
mkdir sqlite_/

cd sqlite-autoconf-3081002/
./configure --prefix=$HOME/sqlite_/
make
echo $? > ~/install-exit-status
make install
cd ..
rm -rf sqlite-autoconf-3081002/

echo "#!/bin/sh

if [ \"X\$@\" = \"X\" ]
then
	TEST_PATH=\`pwd\`
else
	TEST_PATH=\$@
fi

cat sqlite-2500-insertions.txt > \$TEST_PATH/sqlite-insertions.txt
./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db  \"CREATE TABLE pts1 ('I' SMALLINT NOT NULL, 'DT' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 'F1' VARCHAR(4) NOT NULL, 'F2' VARCHAR(16) NOT NULL);\"

cat \$TEST_PATH/sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db
cat \$TEST_PATH/sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db
cat \$TEST_PATH/sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$TEST_PATH/benchmark.db" > sqlite-benchmark
chmod +x sqlite-benchmark

interim.sh

#!/bin/sh

if [ "X$@" = "X" ]
then
	TEST_PATH=`pwd`
else
	TEST_PATH=$@
fi

rm -f $TEST_PATH/benchmark.db

post.sh

#!/bin/sh

if [ "X$@" = "X" ]
then
	TEST_PATH=`pwd`
else
	TEST_PATH=$@
fi

rm -f $TEST_PATH/benchmark.db

pre.sh

#!/bin/sh

if [ "X$@" = "X" ]
then
	TEST_PATH=`pwd`
else
	TEST_PATH=$@
fi

rm -f $TEST_PATH/benchmark.db

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v5.8.0 (Belev)-->
<PhoronixTestSuite>
  <SystemMonitor>
    <Sensor>sys.time</Sensor>
  </SystemMonitor>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v5.8.0 (Belev)-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>SQLite</Title>
    <AppVersion>3.8.10.2</AppVersion>
    <Description>This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database.</Description>
    <ResultScale>Seconds</ResultScale>
    <Proportion>LIB</Proportion>
    <SubTitle>Timed SQLite Insertions</SubTitle>
    <Executable>sqlite-benchmark</Executable>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.9.0</Version>
    <SupportedPlatforms>Linux, BSD, MacOSX, Solaris</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>Disk</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <ExternalDependencies>build-utilities</ExternalDependencies>
    <EnvironmentSize>22</EnvironmentSize>
    <ProjectURL>http://www.sqlite.org/</ProjectURL>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
  <TestSettings>
    <Option>
      <DisplayName>Test Target</DisplayName>
      <Identifier>auto-disk-mount-points</Identifier>
      <DefaultEntry>0</DefaultEntry>
    </Option>
  </TestSettings>
</PhoronixTestSuite>