/[sql-web-session]/index.cgi
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Log of /index.cgi

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (annotate)
Sticky Revision:

Revision 32 - (view) (annotate) - [select for diffs]
Modified Tue Dec 8 20:08:29 2009 UTC (14 years, 3 months ago) by dpavlin
File length: 5973 byte(s)
Diff to previous 29 , to selected 25
added utf-8 charset and declare us html5 page


Revision 29 - (view) (annotate) - [select for diffs]
Modified Tue Dec 8 20:03:35 2009 UTC (14 years, 3 months ago) by dpavlin
File length: 5935 byte(s)
Diff to previous 27 , to selected 25
split $database out of $dsn, add $passwd

Revision 27 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 23:58:42 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5863 byte(s)
Diff to previous 26 , to selected 25
display SQL with embedded parametars using sql_html


Revision 26 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 23:54:30 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5785 byte(s)
Diff to previous 25
display SQL query on top of lookup


Revision 25 - (view) (annotate) - [selected]
Modified Sat Apr 18 23:35:57 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5750 byte(s)
Diff to previous 24
lookup is now scrollable and respects query limit


Revision 24 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 23:21:40 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5746 byte(s)
Diff to previous 23 , to selected 25
move form to top of page, between sql and table
if not fixed


Revision 23 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 23:14:41 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5738 byte(s)
Diff to previous 22 , to selected 25
pass checked where filters into lookup


Revision 22 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 14:18:48 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5409 byte(s)
Diff to previous 21 , to selected 25
toggle button for fixed position of form#sql


Revision 21 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 14:08:52 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5246 byte(s)
Diff to previous 20 , to selected 25
send header without charset


Revision 20 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 14:05:13 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5218 byte(s)
Diff to previous 19 , to selected 25
rename add_group_by into lookup_col


Revision 19 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 13:55:20 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5178 byte(s)
Diff to previous 18 , to selected 25
added joins for lookups by group_by
fixed defaults for form fields


Revision 18 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 12:13:40 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4414 byte(s)
Diff to previous 17 , to selected 25
make $limit also configurable in config.pl


Revision 17 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 12:08:07 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4395 byte(s)
Diff to previous 15 , to selected 25
make table configurable in config.pl


Revision 15 - (view) (annotate) - [select for diffs]
Modified Wed Apr 15 18:42:41 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4375 byte(s)
Diff to previous 14 , to selected 25
make group by values clickable to refine where value


Revision 14 - (view) (annotate) - [select for diffs]
Modified Wed Apr 15 15:35:15 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4359 byte(s)
Diff to previous 13 , to selected 25
push column types to javascript and select correct operator
based on it


Revision 13 - (view) (annotate) - [select for diffs]
Modified Wed Apr 15 15:26:38 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4162 byte(s)
Diff to previous 12 , to selected 25
fake firebug console.* methods instead of firebug lite
because it's much faster :-)


Revision 12 - (view) (annotate) - [select for diffs]
Modified Tue Apr 14 21:25:00 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4445 byte(s)
Diff to previous 10 , to selected 25
tweaks to design and changed highlights


Revision 10 - (view) (annotate) - [select for diffs]
Modified Tue Apr 14 19:54:56 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4436 byte(s)
Diff to previous 7 , to selected 25
split javascript in it's own file and implement lookup
to group by column with count


Revision 7 - (view) (annotate) - [select for diffs]
Modified Tue Apr 14 17:01:09 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5546 byte(s)
Diff to previous 6 , to selected 25
use firebug lite because we use console.* calls


Revision 6 - (view) (annotate) - [select for diffs]
Modified Tue Apr 14 12:43:07 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5299 byte(s)
Diff to previous 5 , to selected 25
added close link to sql popup form

Revision 5 - (view) (annotate) - [select for diffs]
Modified Mon Apr 13 22:12:38 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5194 byte(s)
Diff to previous 4 , to selected 25
don't include order_by which we overwrite anyway

Revision 4 - (view) (annotate) - [select for diffs]
Modified Mon Apr 13 21:26:43 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5213 byte(s)
Diff to previous 3 , to selected 25
order descending by default

Revision 3 - (view) (annotate) - [select for diffs]
Modified Mon Apr 13 20:23:55 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 5170 byte(s)
Diff to previous 2 , to selected 25
a little bit naive, but somewhat working group_by clicked column

Revision 2 - (view) (annotate) - [select for diffs]
Modified Mon Apr 13 17:55:51 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 4378 byte(s)
Diff to previous 1 , to selected 25
added where_parts so you now can drill down in data

Revision 1 - (view) (annotate) - [select for diffs]
Added Mon Apr 13 14:26:46 2009 UTC (14 years, 11 months ago) by dpavlin
File length: 3620 byte(s)
Diff to selected 25
first cut at web-based SQL generation which I see as replacement
for psql if you don't want to ssh into box

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.26