CentOS 5.x 上 sqlite 安装包版本太低（3.3.6），打算升级一下，找了半天也没有找到现成的RPM包。无奈，自己造一个吧。

%define__home%(echo$PWD)
%define_topdir%{__home}/RPM_DEV
%define_tmppath%{_topdir}/tmp
%define_rpmdir%{_topdir}/RPMS
#%define_sourcedir%{_topdir}/SOURCES
%define_sourcedir%{__home}
%define_specdir%{_topdir}/SPECS
%define_srcrpmdir%{_topdir}/SRPM
%define_builddir%{_topdir}/BUILD

%define_BUILD%(cat$PWD/BUILD)


%definerealver3080403
%definedocver3080403
%definerpmver3.8.04

Summary:Librarythatimplementsanembeddablesqldatabaseengine
Name:sqlite
Version:%{rpmver}
Release:%{_BUILD}.el5
#Release:1%{?dist}
License:PublicDomain
Group:Applications/Databases
URL:http://www.sqlite.org/
Source0:sqlite-autoconf-%{realver}.tar.gz

BuildRequires:ncurses-develreadline-develglibc-devel

BuildRoot:%{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u}-n)

%description
sqliteisaClibrarythatimplementsansqldatabaseengine.Alarge
subsetofsql92issupported.Acompletedatabaseisstoredina
singlediskfile.TheAPIisdesignedforconvenienceandeaSEOfuse.
Applicationsthatlinkagainstsqlitecanenjoythepowerand
flexibilityofansqldatabasewithouttheadministrativehasslesof
supportingaseparatedatabaseserver.Version2andversion3binaries
arenamedtopermiteachtobeinstalledonasinglehost

%packagedevel
Summary:Developmenttoolsforthesqlite3embeddablesqldatabaseengine
Group:Development/Libraries
Requires:%{name}=%{version}-%{release}
Requires:pkgconfig

%descriptiondevel
Thispackagecontainstheheaderfilesanddevelopmentdocumentation
for%{name}.Ifyouliketodevelopprogramsusing%{name},youwillneed
toinstall%{name}-devel.

%prep
%setup-n%{name}-autoconf-%{realver}

%build
%configure
make

%install
rm-rf$RPM_BUILD_ROOT
makeinstallDESTDIR=$RPM_BUILD_ROOT

%clean
rm-rf$RPM_BUILD_ROOT
makeclean

%files
%defattr(-,root,root)
%docREADME
%{_bindir}/sqlite3
%{_libdir}/*.so.*
%{_mandir}/man?/*

%filesdevel
%defattr(-,root)
%{_includedir}/*.h
#%{_libdir}/*.so
%{_libdir}/pkgconfig/*.pc
%{_libdir}/*.a
%exclude%{_libdir}/*.la

%changelog
*ThuMay212014Kuerant-3.8.04-03
-Firstversionorautoconf.

执行

rpmbuild-basqlite.rpm.spec

齐活