df6b1ce612
* Added support for WITHOUT ROWID virtual tables.
* Improved the query planner so that the OR optimization can be
used on virtual tables even if one or more of the disjuncts use
the LIKE, GLOB, REGEXP, MATCH operators.
* Added the CSV virtual table for reading RFC 4180 formatted
comma-separated value files.
* Added the carray() table-valued function extension.
* Enabled persistent loadable extensions using the new
SQLITE_OK_LOAD_PERMANENTLY return code from the extension entry point.
* Added the SQLITE_DBSTATUS_CACHE_USED_SHARED option to sqlite3_db_status().
* Add the vfsstat.c loadable extension - a VFS shim that measures
I/O together with an eponymous virtual table that provides access to the measurements.
* Improved algorithm for running queries with both an ORDER BY
and a LIMIT where only the inner-most loop naturally generates rows in the correct order.
* Enhancements to Lemon parser generator, so that it generates a faster parser.
* The PRAGMA compile_options command now attempts to show the version number
of the compiler that generated the library.
* Enhance PRAGMA table_info so that it provides information about eponymous virtual tables.
* The query planner uses a full scan of a partial index instead of a full scan
of the main table, in cases where that makes sense.
* Allow table-valued functions to appear on the right-hand side of an IN operator.
* Added two new C-language interfaces: sqlite3_expanded_sql() and sqlite3_trace_v2().
These new interfaces subsume the functions of sqlite3_trace() and sqlite3_profile()
which are now deprecated.
* Added the json_quote() SQL function to the json1 extension.
* Disable the authorizer callback while reparsing the schema.
* Added the SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option and
turned that option on by default when building the command-line shell.
* Fix the ALTER TABLE command so that it does not corrupt descending indexes when
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=165
163 lines
5.1 KiB
RPMSpec
163 lines
5.1 KiB
RPMSpec
#
|
|
# spec file for package sqlite3
|
|
#
|
|
# Copyright (c) 2016 SUSE LINUX GmbH, Nuernberg, Germany.
|
|
#
|
|
# All modifications and additions to the file contributed by third parties
|
|
# remain the property of their copyright owners, unless otherwise agreed
|
|
# upon. The license for this file, and modifications and additions to the
|
|
# file, is the same license as for the pristine package itself (unless the
|
|
# license for the pristine package is not an Open Source License, in which
|
|
# case the license is the MIT License). An "Open Source License" is a
|
|
# license that conforms to the Open Source Definition (Version 1.9)
|
|
# published by the Open Source Initiative.
|
|
|
|
# Please submit bugfixes or comments via http://bugs.opensuse.org/
|
|
#
|
|
|
|
|
|
%define oname sqlite
|
|
%define tarversion 3140000
|
|
Name: sqlite3
|
|
Version: 3.14.0
|
|
Release: 0
|
|
Summary: Embeddable SQL Database Engine
|
|
License: SUSE-Public-Domain
|
|
Group: Productivity/Databases/Servers
|
|
Url: http://www.sqlite.org/
|
|
Source0: http://www.sqlite.org/2016/sqlite-autoconf-%{tarversion}.tar.gz
|
|
Source1: baselibs.conf
|
|
Source2: http://www.sqlite.org/2016/sqlite-doc-%{tarversion}.zip
|
|
Patch1: sqlite-fts5-link.patch
|
|
BuildRequires: autoconf
|
|
BuildRequires: automake
|
|
BuildRequires: libtool
|
|
BuildRequires: pkgconfig
|
|
BuildRequires: readline-devel
|
|
BuildRequires: unzip
|
|
BuildRequires: update-desktop-files
|
|
Requires: libsqlite3-0 = %{version}
|
|
Provides: %{oname} = %{version}
|
|
Obsoletes: %{oname} < %{version}
|
|
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
|
|
|
%description
|
|
SQLite is a C library that implements an embeddable SQL database
|
|
engine. Programs that link with the SQLite library can have SQL
|
|
database access without running a separate RDBMS process.
|
|
|
|
SQLite is not a client library used to connect to a big database
|
|
server. SQLite is a server and the SQLite library reads and writes
|
|
directly to and from the database files on disk.
|
|
|
|
SQLite can be used via the sqlite command line tool or via any
|
|
application that supports the Qt database plug-ins.
|
|
|
|
%package -n libsqlite3-0
|
|
Summary: Shared libraries for the Embeddable SQL Database Engine
|
|
Group: Development/Libraries/C and C++
|
|
|
|
%description -n libsqlite3-0
|
|
This package contains the shared libraries for the Embeddable SQL
|
|
Database Engine.
|
|
|
|
SQLite is a C library that implements an embeddable SQL database
|
|
engine. Programs that link with the SQLite library can have SQL
|
|
database access without running a separate RDBMS process.
|
|
|
|
SQLite is not a client library used to connect to a big database
|
|
server. SQLite is a server and the SQLite library reads and writes
|
|
directly to and from the database files on disk.
|
|
|
|
SQLite can be used via the sqlite command line tool or via any
|
|
application that supports the Qt database plug-ins.
|
|
|
|
%package devel
|
|
Summary: Embeddable SQL Database Engine
|
|
Group: Development/Libraries/C and C++
|
|
Requires: glibc-devel
|
|
Requires: libsqlite3-0 = %{version}
|
|
Suggests: %{name}-doc
|
|
Provides: %{oname}-devel = %{version}
|
|
Obsoletes: %{oname}-devel < %{version}
|
|
|
|
%description devel
|
|
SQLite is a C library that implements an embeddable SQL database
|
|
engine. Programs that link with the SQLite library can have SQL
|
|
database access without running a separate RDBMS process.
|
|
|
|
SQLite is not a client library used to connect to a big database
|
|
server; SQLite is the server. The SQLite library reads and writes
|
|
directly to and from the database files on disk.
|
|
|
|
SQLite can be used via the sqlite command-line tool or via any
|
|
application which supports the Qt database plug-ins.
|
|
|
|
%package doc
|
|
Summary: Documentation for %{name}
|
|
Group: Documentation/Other
|
|
%if 0%{?suse_version} >= 1130
|
|
BuildArch: noarch
|
|
%endif
|
|
|
|
%description doc
|
|
|
|
Contains HTML documentation for SQLite: SQL Syntax, C/C++ API and
|
|
other documentation found on sqlite.org. The files can be found in
|
|
%{_docdir}/%{name}-doc.
|
|
|
|
%prep
|
|
%setup -q -n sqlite-autoconf-%{tarversion} -a2
|
|
%patch1 -p1
|
|
rm -v sqlite-doc-%{tarversion}/releaselog/current.html
|
|
ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html
|
|
|
|
%build
|
|
autoreconf -fiv
|
|
export CFLAGS="%{optflags} \
|
|
-DSQLITE_ENABLE_API_ARMOR \
|
|
-DSQLITE_ENABLE_COLUMN_METADATA \
|
|
-DSQLITE_ENABLE_DBSTAT_VTAB \
|
|
-DSQLITE_ENABLE_HIDDEN_COLUMNS \
|
|
-DSQLITE_ENABLE_FTS4 \
|
|
-DSQLITE_ENABLE_FTS5 \
|
|
-DSQLITE_ENABLE_JSON1 \
|
|
-DSQLITE_ENABLE_RBU \
|
|
-DSQLITE_ENABLE_RTREE \
|
|
-DSQLITE_SOUNDEX \
|
|
-DSQLITE_ENABLE_UNLOCK_NOTIFY \
|
|
-DSQLITE_SECURE_DELETE \
|
|
"
|
|
%configure --disable-static \
|
|
--disable-static-shell \
|
|
--enable-readline
|
|
make %{?_smp_mflags}
|
|
|
|
%install
|
|
make %{?_smp_mflags} DESTDIR=%{buildroot} install
|
|
find %{buildroot} -type f -name "*.la" -delete -print
|
|
|
|
%post -n libsqlite3-0 -p /sbin/ldconfig
|
|
%postun -n libsqlite3-0 -p /sbin/ldconfig
|
|
|
|
%files
|
|
%defattr(-,root,root)
|
|
%{_bindir}/sqlite3
|
|
%{_mandir}/man1/*
|
|
|
|
%files -n libsqlite3-0
|
|
%defattr(-,root,root)
|
|
%{_libdir}/libsqlite*.so.*
|
|
|
|
%files devel
|
|
%defattr(-,root,root)
|
|
%{_includedir}/*.h
|
|
%{_libdir}/libsqlite*.so
|
|
%{_libdir}/pkgconfig/sqlite3.pc
|
|
|
|
%files doc
|
|
%defattr(-,root,root)
|
|
%doc sqlite-doc-%{tarversion}/*
|
|
|
|
%changelog
|