This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
Log of /sql
Directory Listing
Revision
50 -
Directory Listing
Modified
Mon Nov 3 15:33:52 2008 UTC
(15 years, 6 months ago)
by
dpavlin
make sure that id isn't null because Exhibit doesn't like it
Revision
39 -
Directory Listing
Modified
Sat Oct 25 22:10:45 2008 UTC
(15 years, 6 months ago)
by
dpavlin
simple visualisation of irc-logger data with nicks, first/last date
and message counts
Revision
38 -
Directory Listing
Modified
Sat Oct 25 16:45:32 2008 UTC
(15 years, 6 months ago)
by
dpavlin
sort years by number to get cronological order
Revision
37 -
Directory Listing
Modified
Sat Oct 25 16:39:22 2008 UTC
(15 years, 6 months ago)
by
dpavlin
added interval from create to modify time which we fake to
be single day if it's longer than 30 days (for old data
which seem to have wrong last modify date)
Revision
34 -
Directory Listing
Modified
Sat Oct 25 12:47:24 2008 UTC
(15 years, 6 months ago)
by
dpavlin
encode property valueType for Exhibit in column name
Original idea was to get it directly from DBI, but that
didn't turn out to work well, so we extend column name
in SQL query with valueType and name of type
Revision
33 -
Directory Listing
Added
Sat Oct 25 12:02:49 2008 UTC
(15 years, 6 months ago)
by
dpavlin
convert SQL query using DBI to exhibit JSON
- example using Movable Type database