.Dd March 22, 2013
.Os SQLite\ UDF
.Dt GLOB \&3s "SQLite User-defined Functions"
.Sh NAME
.Nm glob
.Nd virtual table expanding shell wildcard specification
.Sh LIBRARY
SQLite User-defined function Library (glob.so)
.Sh SYNOPSIS
.Li create virtual table 
.Ar tablename
using
.Nm Pf ( Pa pattern Ns )
.Sh DESCRIPTION
The 
.Nm
virtual table renders
.Pa pattern
in the filesystem as a table with one column:
.Bl -tag -width name
.It name
filename matching 
.Pa pattern
.El
.Pp
The contents of the virtual table are 
.Em not
cached.  That is, every query initiates a call to 
.Xr glob 3
and each row is an element in the structure returned by that function. 
.Sh EXAMPLES
.Bd -literal
sqlite> \f[CB].load /usr/local/lib/sqlite3/glob.so\f[]
sqlite> \f[CB]create virtual table f using glob(*.o);\f[]
sqlite> \f[CB]select * from f;\f[]
name      
----------
shell.o
sqlite3.so   
sqlite> 
.Ed
.Sh IMPLEMENTATION NOTES
To use 
.Nm
in the SQLite shell
.Ic sqlite3 ,
add the following to your 
.Pa ${HOME}/.sqliterc 
file:
.Bd -literal
\&.load /usr/local/lib/sqlite3/glob.so
.Ed
.Sh SEE ALSO
.Xr stat 3s
.Xr strmode 3s
.Pp
The above SQLite user-defined functions are intended for use with 
.Nm .
.Sh AUTHORS
.Nm
was contributed by James K. Lowden
.\" .Sh BUGS