/[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 (9 years, 3 months ago) by dpavlin
File length: 5973 byte(s)
Diff to previous 29
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 (9 years, 3 months ago) by dpavlin
File length: 5935 byte(s)
Diff to previous 27
split $database out of $dsn, add $passwd

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


Revision 26 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 23:54:30 2009 UTC (9 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) - [select for diffs]
Modified Sat Apr 18 23:35:57 2009 UTC (9 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 (9 years, 11 months ago) by dpavlin
File length: 5746 byte(s)
Diff to previous 23
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 (9 years, 11 months ago) by dpavlin
File length: 5738 byte(s)
Diff to previous 22
pass checked where filters into lookup


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


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


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


Revision 19 - (view) (annotate) - [select for diffs]
Modified Sat Apr 18 13:55:20 2009 UTC (9 years, 11 months ago) by dpavlin
File length: 5178 byte(s)
Diff to previous 18
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 (9 years, 11 months ago) by dpavlin
File length: 4414 byte(s)
Diff to previous 17
make $limit also configurable in config.pl


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


Revision 15 - (view) (annotate) - [select for diffs]
Modified Wed Apr 15 18:42:41 2009 UTC (9 years, 11 months ago) by dpavlin
File length: 4375 byte(s)
Diff to previous 14
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 (9 years, 11 months ago) by dpavlin
File length: 4359 byte(s)
Diff to previous 13
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 (9 years, 11 months ago) by dpavlin
File length: 4162 byte(s)
Diff to previous 12
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 (9 years, 11 months ago) by dpavlin
File length: 4445 byte(s)
Diff to previous 10
tweaks to design and changed highlights


Revision 10 - (view) (annotate) - [select for diffs]
Modified Tue Apr 14 19:54:56 2009 UTC (9 years, 11 months ago) by dpavlin
File length: 4436 byte(s)
Diff to previous 7
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 (9 years, 11 months ago) by dpavlin
File length: 5546 byte(s)
Diff to previous 6
use firebug lite because we use console.* calls


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

Revision 5 - (view) (annotate) - [select for diffs]
Modified Mon Apr 13 22:12:38 2009 UTC (9 years, 11 months ago) by dpavlin
File length: 5194 byte(s)
Diff to previous 4
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 (9 years, 11 months ago) by dpavlin
File length: 5213 byte(s)
Diff to previous 3
order descending by default

Revision 3 - (view) (annotate) - [select for diffs]
Modified Mon Apr 13 20:23:55 2009 UTC (9 years, 11 months ago) by dpavlin
File length: 5170 byte(s)
Diff to previous 2
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 (9 years, 11 months ago) by dpavlin
File length: 4378 byte(s)
Diff to previous 1
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 (9 years, 11 months ago) by dpavlin
File length: 3620 byte(s)
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