Hi, A (long?) while ago I said, "let me play with sqlite3", since it was introduced into the ports. First thing I noticed was there was no man page for it. Looking closer it seems there is a man page but it isn't getting installed. This simple man page was helpful in getting me started with sqlite3. Not sure if this is on purpose or just an oversight.
Below patch installs sqlite3.1 man page included in tar-ball. comments/OK? --patrick Index: Makefile =================================================================== RCS file: /cvs/obsd/ports/databases/sqlite3/Makefile,v retrieving revision 1.49 diff -u -p Makefile --- Makefile 2 Apr 2010 20:07:11 -0000 1.49 +++ Makefile 20 Apr 2010 02:49:04 -0000 @@ -3,7 +3,7 @@ COMMENT-main= embedded SQL implementation COMMENT-tcl= TCL bindings for Sqlite3 COMMENT-lemon= LEMON LALR(1) parser generator -V= 3.6.23 +V= 3.6.23p0 DISTNAME= sqlite-${V} PKGNAME-main= sqlite3-${V} PKGNAME-tcl= sqlite3-tcl-${V} Index: patches/patch-Makefile_in =================================================================== RCS file: /cvs/obsd/ports/databases/sqlite3/patches/patch-Makefile_in,v retrieving revision 1.15 diff -u -p patches/patch-Makefile_in --- patches/patch-Makefile_in 2 Apr 2010 20:07:11 -0000 1.15 +++ patches/patch-Makefile_in 20 Apr 2010 02:49:04 -0000 @@ -1,7 +1,15 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 sthen Exp $ ---- Makefile.in.orig Mon Mar 8 15:08:54 2010 -+++ Makefile.in Fri Mar 26 19:44:15 2010 -@@ -176,11 +176,11 @@ OBJS0 = alter.lo analyze.lo attach.lo auth.lo backup.l +--- Makefile.in.orig Mon Mar 8 07:08:54 2010 ++++ Makefile.in Mon Apr 19 19:25:55 2010 +@@ -146,6 +146,7 @@ libdir = @libdir@ + pkgconfigdir = $(libdir)/pkgconfig + bindir = @bindir@ + includedir = @includedir@ ++mandir = @mandir@ + INSTALL = @INSTALL@ + LIBTOOL = ./libtool + ALLOWRELEASE = @ALLOWRELEASE@ +@@ -176,11 +177,11 @@ OBJS0 = alter.lo analyze.lo attach.lo auth.lo backup.l table.lo tokenize.lo trigger.lo update.lo \ util.lo vacuum.lo \ vdbe.lo vdbeapi.lo vdbeaux.lo vdbeblob.lo vdbemem.lo vdbetrace.lo \ @@ -15,7 +23,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 # Determine the real value of LIBOBJ based on the 'configure' script # -@@ -277,7 +277,8 @@ SRC = \ +@@ -277,7 +278,8 @@ SRC = \ $(TOP)/src/vdbeInt.h \ $(TOP)/src/vtab.c \ $(TOP)/src/walker.c \ @@ -25,7 +33,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 # Generated source code files # -@@ -448,7 +449,7 @@ HDR += \ +@@ -448,7 +450,7 @@ HDR += \ # hidden when the library is built via the amalgamation). # TESTFIXTURE_SRC0 = $(TESTSRC2) libsqlite3.la @@ -34,7 +42,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 TESTFIXTURE_SRC = $(TESTSRC) $(TOP)/src/tclsqlite.c $(TESTFIXTURE_SRC$(USE_AMALGAMATION)) -@@ -469,7 +470,7 @@ libsqlite3.la: $(LIBOBJ) +@@ -469,7 +471,7 @@ libsqlite3.la: $(LIBOBJ) libtclsqlite3.la: tclsqlite.lo libsqlite3.la $(LTLINK) -o $@ tclsqlite.lo \ @@ -43,7 +51,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 -rpath "$(TCLLIBDIR)" \ -version-info "8:6:8" \ -avoid-version -@@ -509,6 +510,9 @@ lemon$(BEXE): $(TOP)/tool/lemon.c $(TOP)/src/lempar.c +@@ -509,6 +511,9 @@ lemon$(BEXE): $(TOP)/tool/lemon.c $(TOP)/src/lempar.c sqlite3.lo: sqlite3.c $(LTCOMPILE) $(TEMP_STORE) -c sqlite3.c @@ -53,7 +61,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 # Rules to build individual files # alter.lo: $(TOP)/src/alter.c $(HDR) -@@ -690,8 +694,9 @@ select.lo: $(TOP)/src/select.c $(HDR) +@@ -690,8 +695,9 @@ select.lo: $(TOP)/src/select.c $(HDR) status.lo: $(TOP)/src/status.c $(HDR) $(LTCOMPILE) $(TEMP_STORE) -c $(TOP)/src/status.c @@ -65,7 +73,16 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 table.lo: $(TOP)/src/table.c $(HDR) $(LTCOMPILE) $(TEMP_STORE) -c $(TOP)/src/table.c -@@ -820,6 +825,8 @@ clean: +@@ -796,6 +802,8 @@ install: sqlite3$(BEXE) lib_install sqlite3.h sqlite3. + $(INSTALL) -m 0644 $(TOP)/src/sqlite3ext.h $(DESTDIR)$(includedir) + $(INSTALL) -d $(DESTDIR)$(pkgconfigdir) + $(INSTALL) -m 0644 sqlite3.pc $(DESTDIR)$(pkgconfigdir) ++ $(INSTALL) -d $(DESTDIR)$(mandir)/man1 ++ $(INSTALL) -m 0644 sqlite3.1 $(DESTDIR)$(mandir)/man1 + + pkgIndex.tcl: + echo 'package ifneeded sqlite3 $(RELEASE) [list load $(TCLLIBDIR)/libtclsqlite3.so sqlite3]' > $@ +@@ -820,6 +828,8 @@ clean: distclean: clean rm -f config.log config.status libtool Makefile sqlite3.pc Index: pkg/PLIST-main =================================================================== RCS file: /cvs/obsd/ports/databases/sqlite3/pkg/PLIST-main,v retrieving revision 1.3 diff -u -p pkg/PLIST-main --- pkg/PLIST-main 23 Jul 2008 17:31:18 -0000 1.3 +++ pkg/PLIST-main 20 Apr 2010 02:49:04 -0000 @@ -9,3 +9,4 @@ lib/libsqlite3.a lib/libsqlite3.la lib/pkgconfig/ lib/pkgconfig/sqlite3.pc +...@man man/man1/sqlite3.1