SQLite 2.2.0

pts/sqlite-2.2.0 - 28 April 2023 - Update against SQLite 3.41.2 upstream, adjust option value so it auto-populates up to the total number of CPU threads available. Closes: https://github.com/phoronix-test-suite/test-suites/pull/9

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>http://sqlite.org/2023/sqlite-autoconf-3410200.tar.gz</URL>
      <MD5>862075fd1c38324878ef809eda39edfe</MD5>
      <SHA256>e98c100dd1da4e30fa460761dab7c0b91a50b785e167f8c57acc46514fae9499</SHA256>
      <FileName>sqlite-autoconf-3410200.tar.gz</FileName>
      <FileSize>3125545</FileSize>
    </Package>
    <Package>
      <URL>http://sqlite.org/2023/sqlite-tools-win32-x86-3410200.zip</URL>
      <MD5>21cc89a2f1e4ec0dcb05a74386052e4e</MD5>
      <SHA256>1d0720c3a4c4619a91eb97f52931e3485f92b53d89e76b335c69c4d8c644c006</SHA256>
      <FileName>sqlite-tools-win32-x86-3410200.zip</FileName>
      <FileSize>1999045</FileSize>
      <PlatformSpecific>Windows</PlatformSpecific>
    </Package>
    <Package>
      <URL>http://www.phoronix-test-suite.com/benchmark-files/pts-sqlite-tests-1.tar.gz</URL>
      <MD5>153e725642619e38766ddf8359f65cfe</MD5>
      <SHA256>1067f047461e21fd56e2a6ae03043c687047d00192ffdbe5b52271cd39de442f</SHA256>
      <FileName>pts-sqlite-tests-1.tar.gz</FileName>
      <FileSize>42835</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh
tar -zxvf pts-sqlite-tests-1.tar.gz
tar -zxvf sqlite-autoconf-3410200.tar.gz
mkdir sqlite_/
cd sqlite-autoconf-3410200/
./configure --prefix=$HOME/sqlite_/
make
echo $? > ~/install-exit-status
make install
cd ..
rm -rf sqlite-autoconf-3410200/
echo "#!/bin/bash
thread_num=\$1
if ! [[ \"\$thread_num\" =~ ^[0-9]+$ ]]
    then
        thread_num=1
fi
cat sqlite-2500-insertions.txt > sqlite-insertions.txt
do_test() {
    DB=benchmark-\$1.db
    ./sqlite_/bin/sqlite3 \$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 sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$DB
    cat sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$DB
    cat sqlite-insertions.txt | ./sqlite_/bin/sqlite3 \$DB
}
pids=\"\"
for i in \$(seq 1 \$thread_num)
do
    do_test \$i &
    pids=\"\$pids \$!\"
done
wait \$pids" > sqlite-benchmark
chmod +x sqlite-benchmark

install_windows.sh

#!/bin/sh
tar -zxvf pts-sqlite-tests-1.tar.gz
unzip -o sqlite-tools-win32-x86-3410200.zip
echo "#!/bin/bash
thread_num=\$1
if ! [[ \"\$thread_num\" =~ ^[0-9]+$ ]]
    then
        thread_num=1
fi
cat sqlite-2500-insertions.txt > sqlite-insertions.txt
do_test() {
    DB=benchmark-\$1.db
    ./sqlite-tools-win32-x86-3410200/sqlite3.exe \$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 sqlite-insertions.txt | ./sqlite-tools-win32-x86-3410200/sqlite3.exe \$DB
    cat sqlite-insertions.txt | ./sqlite-tools-win32-x86-3410200/sqlite3.exe \$DB
    cat sqlite-insertions.txt | ./sqlite-tools-win32-x86-3410200/sqlite3.exe \$DB
}
pids=\"\"
for i in \$(seq 1 \$thread_num)
do
    do_test \$i &
    pids=\"\$pids \$!\"
done
wait \$pids" > sqlite-benchmark
chmod +x sqlite-benchmark

interim.sh

#!/bin/sh
rm -f benchmark*.db

post.sh

#!/bin/sh
rm -f benchmark*.db

pre.sh

#!/bin/sh
rm -f benchmark*.db

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <SystemMonitor>
    <Sensor>sys.time</Sensor>
  </SystemMonitor>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>SQLite</Title>
    <AppVersion>3.41.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 with a variable number of concurrent repetitions -- up to the maximum number of CPU threads available.</Description>
    <ResultScale>Seconds</ResultScale>
    <Proportion>LIB</Proportion>
    <Executable>sqlite-benchmark</Executable>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>2.2.0</Version>
    <SupportedPlatforms>Linux, BSD, MacOSX, Solaris, Windows</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>Disk</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <ExternalDependencies>build-utilities</ExternalDependencies>
    <EnvironmentSize>40</EnvironmentSize>
    <ProjectURL>https://sqlite.org/</ProjectURL>
    <RepositoryURL>https://github.com/sqlite/sqlite</RepositoryURL>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
  <TestSettings>
    <Option>
      <DisplayName>Threads / Copies</DisplayName>
      <Identifier>cpu-threads</Identifier>
      <Menu>
        <Entry>
          <Name>1</Name>
          <Value>1</Value>
        </Entry>
        <Entry>
          <Name>8</Name>
          <Value>8</Value>
        </Entry>
        <Entry>
          <Name>32</Name>
          <Value>32</Value>
        </Entry>
      </Menu>
    </Option>
  </TestSettings>
</PhoronixTestSuite>