./databases/sqlports [sqlite database of ports]
[+] Add this package to your ports tracker

[ CVSweb ] [ Homepage ] [ RSS feed ]

Version: 6.3, Package name: sqlports-6.3
Maintained by: Marc Espie
Master sites:
Description-compact
SQLite database of every port in the system. This can be queried through
e.g., sqlitebrowser, or any kind of programming interface.

This schema is mostly optimized for tools, and cumbersome to query by
hand.

Database Schema:
- Paths (ID, FULLPKGPATH, PKGPATH, CANONICAL)
PKGPATH points to a PATHS entry corresponding to the stripped down version of
FULLPKGPATH, without flavors or subpackage markers, or is null if FULLPKGPATH
is already stripped. Every other FULLPKGPATH, PKGPATH, DEPENDSPATH entry
in the database points to this table.
The FULLPKGPATH is complete, including flavors and pseudo flavors markers.
For every port with MULTI_PACKAGES settings, one entry is written
for each SUBPACKAGE.
CANONICAL points to the actual ID to use as an entry in other tables, for
FULLPKGPATH which don't have their own entry.

- Ports(FULLPKGPATH, ...)
holds all the information retrieved through various variables that is not
stored in specialized tables, e.g.,:
AUTOCONF_VERSION
AUTOMAKE_VERSION
BROKEN
COMMENT
DESCR
DISTFILES
DISTNAME
DIST_SUBDIR
EPOCH
FLAVORS
FULLPKGNAME
GH_*
HOMEPAGE
IS_INTERACTIVE
MAINTAINER
MULTI_PACKAGES
NO_*
PERMIT_*
PKGNAME
PKGSPEC
PKG_ARCH
PREFIX
PSEUDO_FLAVOR
PSEUDO_FLAVORS
TEST_IS_INTERACTIVE
REVISION
SEPARATE_BUILD
STATIC_PLIST
SUBPACKAGE
SUPDISTFILES
USE_*
README
WANT_CXX

This information is mostly unchanged, except for replacing Yes/No variables
with 1/0. Variables not present in a given port are left undefined.

README corresponds to README files (full text value) and only exists when
such files are present.

Note that USE_LIBTOOL is 3-valued: 2 is gnu, 1 is yes, undef is no.

MULTI_PACKAGES ports hold several entries with corresponding FULLPKGPATH

- Flavors(FULLPKGPATH, VALUE)
- PseudoFlavors(FULLPKGPATH, VALUE)
- Categories(FULLPKGPATH, VALUE)
- Multi(FULLPKGPATH, VALUE, SUBPKGPATH) ('-' values are not stored)
- Modules(FULLPKGPATH, VALUE)
- Configure(FULLPKGPATH, VALUE) (corresponds to CONFIGURE_STYLE)
- ConfigureArgs(FULLPKGPATH, VALUE)
- MasterSites(FULLPKGPATH, N, VALUE)
- Makefiles(FULLPKGPATH, VALUE)
- NotForArch(FULLPKGPATH, VALUE)
- OnlyForArch(FULLPKGPATH, VALUE)
All of these variable values are actually lists. These lists are taken apart
and result in many entries in these secondary tables (or none if the list
is completely empty)

The Makefiles table contains only Makefiles from MAKEFILE_LIST that are not
"default values" (always included makefiles).

Each keyword table follows the same scheme
TABLENAME(KEYREF, VALUE)


- Depends(FULLPKGPATH, FULLDEPENDS, PKGSPEC, REST, DEPENDSPATH, TYPE)
All depends are stored in a single table, including the type:
0 -> library
1 -> run
2 -> build
3 -> test
with FULLDEPENDS the full text of the dependency, DEPENDSPATH the PKGPATH
we depend upon, PKGSPEC the spec we depend upon (if explicit), and REST
the rest.
- Wantlib(FULLPKGPATH, VALUE, EXTRA)
All the libraries the FULLPKGPATH depends upon, with optional version
number specification stored in EXTRA
coming from either the WANTLIB variable or various LIB_DEPENDS.

- Multi(FULLPKGPATH, VALUE, SUBPKGPATH)
also contains the normalized pkgpath for the corresponding subpackage.
- Broken(FULLPKGPATH, ARCH, TEXT)
This is stored both in the main table (for now) and in a separate table, with
keywords since it may be arch-dependent

- Shared_Libs(FULLPKGPATH, LIBNAME, VERSION)

- TARGETS(FULLPKGPATH, VALUE)

Some information, both in the main table and in secondary tables
is stored as keyword references to other tables:
AUTOCONF_VERSION, AUTOMAKE_VERSION -> AUTOVERSION
MAINTAINER -> EMAIL
CATEGORIES -> CATEGORYKEYS
CONFIGURE -> CONFIGURE_KEYS
MAKEFILES -> FILENAMES
MODULES -> MODULEKEYS
PREFIX -> PREFIX
WANTLIB.VALUE, SHARED_LIBS.LIBNAME -> LIBRARY
PERMIT_*, SEPARATE_BUILD -> KEYWORDS2
FLAVORS, PSEUDO_FLAVORS -> KEYWORDS
NOT_FOR_ARCHS, ONLY_FOR_ARCHS, PKG_ARCH -> ARCH
TARGETS -> TARGETKEYS

Description-list
Reduced list of every fullpkgpath reachable in the ports tree, with
duplicate pkgnames removed, and with ports without static plists taken
out.

Description-main
SQLite database of every port in the system. This can be queried through
e.g., sqlitebrowser, or any kind of programming interface.

This is more suitable for human consumption, use sqlite-compact for
more structured information.

Database Schema:
- Ports(FULLPKGPATH, ...)
holds all the information retrieved through various variables, e.g.,:
AUTOCONF_VERSION
AUTOMAKE_VERSION
BROKEN
*DEPENDS
CATEGORIES
COMMENT
CONFIGURE_STYLE
DESCR
DISTFILES
DISTNAME
DIST_SUBDIR
EPOCH
FLAVORS
FULLPKGNAME
GH_*
HOMEPAGE
IS_INTERACTIVE
MAINTAINER
MAKEFILE_LIST
MASTER_SITES*
MODULES
MULTI_PACKAGES
NO_*
NOT_FOR_ARCHS
ONLY_FOR_ARCHS
PERMIT_*
PKGNAME
PKGSPEC
PKG_ARCH
PREFIX
PSEUDO_FLAVOR
PSEUDO_FLAVORS
TEST_IS_INTERACTIVE
REVISION
SEPARATE_BUILD
SHARED_LIBS
SUBPACKAGE
SUPDISTFILES
TARGETS
USE_*
WANTLIB
README
WANT_CXX

This information is mostly unchanged, except for replacing Yes/No variables
with 1/0. Variables not present in a given port are left undefined.

README corresponds to README files (full text value) and only exists when
such files are present.

Note that USE_LIBTOOL is 3-valued: 2 is gnu, 1 is yes, undef is no.

The FULLPKGPATH is complete, including flavor and pseudo-flavors markers.
For every port with MULTI_PACKAGES settings, one entry is written for
each SUBPACKAGE.

- Paths (FULLPKGPATH, PKGPATH, CANONICAL)
PKGPATH is the stripped down version or FULLPKGPATH, without flavors
or subpackage markers.
CANONICAL points to the reduced version.

- Flavors(FULLPKGPATH, VALUE)
- Categories(FULLPKGPATH, VALUE)
- Multi(FULLPKGPATH, VALUE, SUBPKGPATH)
- Makefiles(FULLPKGPATH, VALUE)
- Modules(FULLPKGPATH, VALUE)
- Configure(FULLPKGPATH, VALUE)
- ConfigureArgs(FULLPKGPATH, VALUE)
- NotForArch(FULLPKGPATH, VALUE)
- OnlyForArch(FULLPKGPATH, VALUE)
- Targets(FULLPKGPATH, VALUE)
All of these variable values are actually lists. These lists are taken apart
and result in many entries in these secondary tables (or none if the list
is completely empty)

Makefiles holds the stuff from MAKEFILE_LIST that's specific to a given port
with all default entries stripped away.

- Depends(FULLPKGPATH, FULLDEPENDS, PKGSPEC, REST, DEPENDSPATH, TYPE)
All depends are stored in a single table, including the type:
R -> run
L -> lib
B -> build
T -> test
with FULLDEPENDS the full text of the dependency, DEPENDSPATH the PKGPATH
we depend upon, PKGSPEC the spec we depend upon (if explicit), and REST
the rest.
- Wantlib(FULLPKGPATH, VALUE)
All the libraries the FULLPKGPATH depends upon, with and without version number,
coming from either the WANTLIB variable or various LIB_DEPENDS.

- Multi(FULLPKGPATH, VALUE, SUBPKGPATH)
with SUBPKGPATH the normalized pkgpath for that subpackage.

- BROKEN(FULLPKGPATH, ARCH, VALUE)
All the broken entries, which might be arch-dependent.

- Shared_Libs(FULLPKGPATH, LIBNAME, VERSION)


Version History (View Complete History)
  • (2017-05-13) Updated to version: sqlports-6.3
  • (2017-04-11) Updated to version: sqlports-6.2
  • (2017-01-30) Updated to version: sqlports-6.1
  • (2016-08-18) Updated to version: sqlports-6.0
  • (2016-03-21) Updated to version: sqlports-5.0
  • (2015-05-15) Updated to version: sqlports-4.4
  • (2014-11-04) Updated to version: sqlports-4.3
  • (2014-09-03) Updated to version: sqlports-4.2
  • (2014-07-12) Updated to version: sqlports-4.1
  • (2013-11-25) Updated to version: sqlports-4.0
[show/hide] View available PLISTS (Can be a lot of data)

CVS Commit History:

   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-04-10 13:11:11 by Marc Espie | Files touched by this commit (2)
Log message:
hack things so that LIBCXX doesn't get expanded for sqlports.
This will probably be revisited and cleansed later.
okay sthen@
   2017-04-10 13:11:11 by Marc Espie | Files touched by this commit (2)
Log message:
hack things so that LIBCXX doesn't get expanded for sqlports.
This will probably be revisited and cleansed later.
okay sthen@
   2017-01-30 09:39:22 by Stuart Henderson | Files touched by this commit (1)
Log message:
add RDEP on sqlite3, ok espie@
   2016-09-23 03:16:58 by Stuart Henderson | Files touched by this commit (124)
Log message:
Cope with moving sqlite3 back to ports.
   2016-08-18 06:28:53 by Stuart Henderson | Files touched by this commit (2)
Log message:
Add an USE_WXNEEDED flag for ports, to write an ld wrapper script in
${WRKDIR}/bin that adds -z wxneeded to linker command lines. It won't work
everywhere but provides an easy (and easily identifiable) way to add this
flag without fiddling with build systems.
Feedback/ok jca@ jasper@
   2016-08-18 06:28:53 by Stuart Henderson | Files touched by this commit (2)
Log message:
Add an USE_WXNEEDED flag for ports, to write an ld wrapper script in
${WRKDIR}/bin that adds -z wxneeded to linker command lines. It won't work
everywhere but provides an easy (and easily identifiable) way to add this
flag without fiddling with build systems.
Feedback/ok jca@ jasper@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-16 09:49:37 by Christian Weisgerber | Files touched by this commit (2)
Log message:
remove NO_SHARED_ARCHS and the resulting unreachable code
   2016-03-16 09:49:37 by Christian Weisgerber | Files touched by this commit (2)
Log message:
remove NO_SHARED_ARCHS and the resulting unreachable code
   2015-05-14 12:01:08 by Jasper Lievisse Adriaanse | Files touched by this commit (2)
Log message:
store PORTROACH_COMMENT
ok sthen@ (previous bsd.port.mk commit was ok with stuart too)
   2015-05-14 12:01:08 by Jasper Lievisse Adriaanse | Files touched by this commit (2)
Log message:
store PORTROACH_COMMENT
ok sthen@ (previous bsd.port.mk commit was ok with stuart too)
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-01-04 14:55:19 by Marc Espie | Files touched by this commit (2)
Log message:
handle PATCHFILES, ignore CHECKSUM_FILE
   2011-01-04 14:55:19 by Marc Espie | Files touched by this commit (2)
Log message:
handle PATCHFILES, ignore CHECKSUM_FILE
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-14 17:22:54 by Marc Espie | Files touched by this commit (427)
Log message:
convert to new style depends
zap default spec that are not needed
convert libspecs as well
convert p* to REVISION.
No package changes
   2010-11-14 01:42:00 by Marc Espie | Files touched by this commit (2)
Log message:
prepare for new specs
   2010-11-14 01:42:00 by Marc Espie | Files touched by this commit (2)
Log message:
prepare for new specs
   2010-10-30 17:00:28 by Marc Espie | Files touched by this commit (1)
Log message:
fix. stupid. me.
   2010-10-28 05:11:17 by Marc Espie | Files touched by this commit (1)
Log message:
make sure sqlports will stop in case of an error.
problem noticed by steven@, sneaky solution by me ;)
   2010-10-24 14:44:50 by Antoine Jacoutot | Files touched by this commit (1)
Log message:
Remove obsolete USE_X11 from $vars.
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-04-26 04:20:51 by Marc Espie | Files touched by this commit (3)
Log message:
whitespace
   2010-04-26 04:20:51 by Marc Espie | Files touched by this commit (3)
Log message:
whitespace
   2010-04-26 04:20:51 by Marc Espie | Files touched by this commit (3)
Log message:
whitespace
   2010-04-26 04:19:02 by Marc Espie | Files touched by this commit (1)
Log message:
get ready to coalesce columns
   2010-04-26 02:52:09 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks + whitespace
   2010-04-26 02:52:09 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks + whitespace
   2010-04-25 06:35:26 by Marc Espie | Files touched by this commit (1)
Log message:
view_schema always follows the same format, so just do that...
   2010-04-19 03:21:31 by Marc Espie | Files touched by this commit (1)
Log message:
fix, should build correctly even if SUBDIR is defined
   2010-04-17 08:48:15 by Marc Espie | Files touched by this commit (2)
Log message:
simplify mapping slightly for now...
   2010-04-17 08:48:15 by Marc Espie | Files touched by this commit (2)
Log message:
simplify mapping slightly for now...
   2010-04-17 08:37:02 by Marc Espie | Files touched by this commit (3)
Log message:
turn on foreign key constraints, as they seem to work ;-)
   2010-04-17 08:37:02 by Marc Espie | Files touched by this commit (3)
Log message:
turn on foreign key constraints, as they seem to work ;-)
   2010-04-17 08:37:02 by Marc Espie | Files touched by this commit (3)
Log message:
turn on foreign key constraints, as they seem to work ;-)
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 03:33:18 by Marc Espie | Files touched by this commit (3)
Log message:
sanitize code, no functional changes
   2010-04-17 03:33:18 by Marc Espie | Files touched by this commit (3)
Log message:
sanitize code, no functional changes
   2010-04-17 03:33:18 by Marc Espie | Files touched by this commit (3)
Log message:
sanitize code, no functional changes
   2010-04-13 04:56:42 by Marc Espie | Files touched by this commit (3)
Log message:
rename stuff to try to make it clearer.
   2010-04-13 04:56:42 by Marc Espie | Files touched by this commit (3)
Log message:
rename stuff to try to make it clearer.
   2010-04-13 04:56:42 by Marc Espie | Files touched by this commit (3)
Log message:
rename stuff to try to make it clearer.
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-02-12 04:53:09 by Marc Espie | Files touched by this commit (2)
Log message:
get mksqlitedb to handle IGNORE and COMES_WITH if they show up.
Also don't spazz out if we meet variables we don't know. This makes us
safe from changes in dump-vars.
   2010-02-12 04:53:09 by Marc Espie | Files touched by this commit (2)
Log message:
get mksqlitedb to handle IGNORE and COMES_WITH if they show up.
Also don't spazz out if we meet variables we don't know. This makes us
safe from changes in dump-vars.
   2009-12-01 11:27:46 by Marc Espie | Files touched by this commit (3)
Log message:
tag sqlports as "always-update".
If you don't have current pkgtools, *this will break*.
(@option always-update was introduced over a month ago).
   2009-12-01 11:27:46 by Marc Espie | Files touched by this commit (3)
Log message:
tag sqlports as "always-update".
If you don't have current pkgtools, *this will break*.
(@option always-update was introduced over a month ago).
   2009-12-01 11:27:46 by Marc Espie | Files touched by this commit (3)
Log message:
tag sqlports as "always-update".
If you don't have current pkgtools, *this will break*.
(@option always-update was introduced over a month ago).
   2009-08-25 03:23:03 by Marc Espie | Files touched by this commit (1)
Log message:
oops
   2009-08-25 03:15:43 by Marc Espie | Files touched by this commit (2)
Log message:
use left join on optional values, otherwise we lose a lot of _ports entries.
   2009-08-25 03:15:43 by Marc Espie | Files touched by this commit (2)
Log message:
use left join on optional values, otherwise we lose a lot of _ports entries.
   2009-08-15 21:24:28 by Marc Espie | Files touched by this commit (1)
Log message:
make internals more consistent
   2009-08-15 06:43:58 by Marc Espie | Files touched by this commit (2)
Log message:
start building the _Ports view.
   2009-08-15 06:43:58 by Marc Espie | Files touched by this commit (2)
Log message:
start building the _Ports view.
   2009-08-14 08:02:12 by Marc Espie | Files touched by this commit (1)
Log message:
consistent capitalization
   2009-08-14 06:41:56 by Marc Espie | Files touched by this commit (2)
Log message:
create views for most of the subsidiary tables
   2009-08-14 06:41:56 by Marc Espie | Files touched by this commit (2)
Log message:
create views for most of the subsidiary tables
   2009-08-14 05:31:37 by Marc Espie | Files touched by this commit (2)
Log message:
create the ports table in the same way
   2009-08-14 05:31:37 by Marc Espie | Files touched by this commit (2)
Log message:
create the ports table in the same way
   2009-08-14 04:45:52 by Marc Espie | Files touched by this commit (2)
Log message:
higher level table creation for individual tables except Ports:
create column objects, and ask the inserter to "render" them.
   2009-08-14 04:45:52 by Marc Espie | Files touched by this commit (2)
Log message:
higher level table creation for individual tables except Ports:
create column objects, and ask the inserter to "render" them.
   2009-08-14 03:23:10 by Marc Espie | Files touched by this commit (2)
Log message:
even though sqlite doesn't really care, this fixes the column types and adds
foreign key constraints to all the sql compact stuff.
   2009-08-14 03:23:10 by Marc Espie | Files touched by this commit (2)
Log message:
even though sqlite doesn't really care, this fixes the column types and adds
foreign key constraints to all the sql compact stuff.
   2008-11-25 11:01:15 by Marc Espie | Files touched by this commit (2)
Log message:
kill oldish wantlib syntax that no longer exists, results in saner wantlib
tables.
   2008-11-25 11:01:15 by Marc Espie | Files touched by this commit (2)
Log message:
kill oldish wantlib syntax that no longer exists, results in saner wantlib
tables.
   2008-10-26 17:42:24 by Marc Espie | Files touched by this commit (1)
Log message:
fixes some inheritance issues. Problem noticed by bernd@
   2008-10-26 09:12:30 by Marc Espie | Files touched by this commit (1)
Log message:
recognize more wrong depends errors
   2008-08-20 15:02:47 by Marc Espie | Files touched by this commit (1)
Log message:
style nitpick, no functional changes
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2007-09-15 16:27:39 by Simon Bertrang | Files touched by this commit (29)
Log message:
remove surrounding quotes from COMMENT/BROKEN/PERMIT_*
   2007-02-15 01:04:49 by Steven Mestdagh | Files touched by this commit (2)
Log message:
NO_CHECKSUM and remove empty distinfo
from mikolaj.kucharski at gmail.com
go for it espie@


   2007-02-15 01:04:49 by Steven Mestdagh | Files touched by this commit (2)
Log message:
NO_CHECKSUM and remove empty distinfo
from mikolaj.kucharski at gmail.com
go for it espie@


   2006-12-27 04:16:10 by Steven Mestdagh | Files touched by this commit (2)
Log message:
put USE_X11 in the table.
sure espie@
   2006-12-27 04:16:10 by Steven Mestdagh | Files touched by this commit (2)
Log message:
put USE_X11 in the table.
sure espie@
   2006-11-03 16:26:41 by Marc Espie | Files touched by this commit (2)
Log message:
optimize table structure, idea from Martynas Venckus
   2006-11-03 16:26:41 by Marc Espie | Files touched by this commit (2)
Log message:
optimize table structure, idea from Martynas Venckus
   2006-11-03 16:03:09 by Marc Espie | Files touched by this commit (2)
Log message:
use DROP IF EXISTS (from Martynas Venckus)
fix WANTLIB, regexp to strip version was totally wrong...
(more to come)
   2006-11-03 16:03:09 by Marc Espie | Files touched by this commit (2)
Log message:
use DROP IF EXISTS (from Martynas Venckus)
fix WANTLIB, regexp to strip version was totally wrong...
(more to come)
   2006-10-15 03:41:44 by Marc Espie | Files touched by this commit (2)
Log message:
move mksqlitedb in the port that uses it.
   2006-10-15 03:41:44 by Marc Espie | Files touched by this commit (2)
Log message:
move mksqlitedb in the port that uses it.
   2006-08-01 10:22:22 by Marc Espie | Files touched by this commit (2)
Log message:
tweak for PKGPATH, name it correctly as FULLPKGPATH, and add a subsidiary
table to map FULLPKGPATH to PKGPATH, e.g.,
SELECT DISTINCT PKGPATH, VALUE FROM Wantlib,Paths WHERE Wantlib.FULLPKGPATH=Paths.FULLPKGPATH ORDER BY PKGPATH


   2006-08-01 10:22:22 by Marc Espie | Files touched by this commit (2)
Log message:
tweak for PKGPATH, name it correctly as FULLPKGPATH, and add a subsidiary
table to map FULLPKGPATH to PKGPATH, e.g.,
SELECT DISTINCT PKGPATH, VALUE FROM Wantlib,Paths WHERE Wantlib.FULLPKGPATH=Paths.FULLPKGPATH ORDER BY PKGPATH


   2006-07-10 08:34:01 by Marc Espie | Files touched by this commit (2)
Log message:
Handle CONFIGURE_ARGS as a list, e.g.,
SELECT DISTINCT VALUE FROM ConfigureArgs
makes sense.


   2006-07-10 08:34:01 by Marc Espie | Files touched by this commit (2)
Log message:
Handle CONFIGURE_ARGS as a list, e.g.,
SELECT DISTINCT VALUE FROM ConfigureArgs
makes sense.


   2006-07-10 05:44:30 by Marc Espie | Files touched by this commit (2)
Log message:
Really process SHARED_LIBS


   2006-07-10 05:44:30 by Marc Espie | Files touched by this commit (2)
Log message:
Really process SHARED_LIBS