pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedContribute to the PL/pgSQL CookBook !!
5+ messages / 2 participants
[nested] [flat]
* Contribute to the PL/pgSQL CookBook !!
@ 2001-03-15 21:13 Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Roberto Mello @ 2001-03-15 21:13 UTC (permalink / raw)
To: pgsql-docs; pgsql-hackers@postgresql.org; pgsql-sql@postgresql.org
I have started the "PL/pgSQL CookBook" project. The goal is to
create a cookbook of PL/pgSQL functions that will be catalogued and made
available for others to use and learn from.
Come to http://www.brasileiro.net/postgres and contribute your own
PL/pgSQL (or PL/Tcl, PL/Perl) function or trigger! This will help many
Postgres users, both novice and experienced, to use its procedural
languages.
The CookBook has several sections, and you can add your own. No login
is required, just come and contribute.
Once again http://www.brasileiro.net/postgres
Oh, did I mention that you get your own "PostgreSQL Powered" button
when you contribute a function/trigger? :)
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
Pimentus annus alter, refrescum est.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Contribute to the PL/pgSQL CookBook !!
@ 2001-03-15 22:45 Roberto Mello <rmello@cc.usu.edu>
2001-03-16 08:23 ` Re: [SQL] Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
2001-03-17 00:41 ` Re: [SQL] Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
0 siblings, 2 replies; 5+ messages in thread
From: Roberto Mello @ 2001-03-15 22:45 UTC (permalink / raw)
To: pgsql-sql@postgresql.org
I have started the "PL/pgSQL CookBook" project. The goal is to
create a cookbook of PL/pgSQL functions that will be catalogued and made
available for others to use and learn from.
Come to http://www.brasileiro.net/postgres and contribute your own
PL/pgSQL (or PL/Tcl, PL/Perl) function or trigger! This will help many
Postgres users, both novice and experienced, to use its procedural
languages.
The CookBook has several sections, and you can add your own. No login
is required, just come and contribute.
Once again http://www.brasileiro.net/postgres
Oh, did I mention that you get your own "PostgreSQL Powered" button
when you contribute a function/trigger? :)
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
DOS = Damned Old Software
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] Contribute to the PL/pgSQL CookBook !!
2001-03-15 22:45 Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
@ 2001-03-16 08:23 ` Roberto Mello <rmello@cc.usu.edu>
2001-03-16 09:37 ` Re: Re: [SQL] Contribute to the PL/pgSQL CookBook !! Richard Huxton <dev@archonet.com>
1 sibling, 1 reply; 5+ messages in thread
From: Roberto Mello @ 2001-03-16 08:23 UTC (permalink / raw)
To: Richard H <dev@archonet.com>; +Cc: pgsql-docs
On Fri, Mar 16, 2001 at 12:21:58AM +0000, Richard H wrote:
>
> Just checked it out - very nice indeed.
Thanks! It's really just bare-bones as I didn't have time to make it
pretty or work on the UI. I plan to improve it of course. Suggestions
(such as yours) are very welcome.
> Made my first upload, and I think someone else did while I was checking
> mine.
I noticed :) Keep them coming !
> A FREE BUTTON! And they said the dot-com frenzy was over!
I really like that button. PostgreSQL needs more advocacy.
> You do realise you've built something that will grow to take over your
> life and possibly the rest of the world?
I hope we can get lots and lots of recipes. It'd be a great resource.
Python has something of the sorts (association of O'Reilly and Active
State if I am not mistaken).
> If I can suggest some early enhancements (well, it's been running for
> several hours now :-)
>
> 1. People will want to change their entries - take their email and send
> them a password so they can edit it later.
I thought about that, but my thinking was that if people had to
register a login/password first, that might stop some people from
cnotributing.
What do others think? Allow for editing or not?
> 2. Perhaps add a "Title" field - something shorter than the description.
Good point.
> Very impressive though (and I though I was going to be clever adding a
> "please respond" form to my notes 8-)
There's even a tree function already!
The OpenACS project (www.openacs.org, of which I am part) makes heavy
use of PL/pgSQL, so I'll be adding a number of recipes in the near future.
Hope others will do the same.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
Sit vis vobiscum!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re: [SQL] Contribute to the PL/pgSQL CookBook !!
2001-03-15 22:45 Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
2001-03-16 08:23 ` Re: [SQL] Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
@ 2001-03-16 09:37 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 5+ messages in thread
From: Richard Huxton @ 2001-03-16 09:37 UTC (permalink / raw)
To: Roberto Mello <rmello@cc.usu.edu>; +Cc: pgsql-docs
From: "Roberto Mello" <rmello@cc.usu.edu>
> On Fri, Mar 16, 2001 at 12:21:58AM +0000, Richard H wrote:
> >
>
> > You do realise you've built something that will grow to take over your
> > life and possibly the rest of the world?
>
> I hope we can get lots and lots of recipes. It'd be a great resource.
> Python has something of the sorts (association of O'Reilly and Active
> State if I am not mistaken).
No reason why you shouldn't end up with a library of useful chunks like CPAN
(well ish) - there are a host of standard templates and routines that people
don't need to keep re-inventing: international phone number formats,
email/URL format validation, standard contact templates...
> > If I can suggest some early enhancements (well, it's been running for
> > several hours now :-)
> >
> > 1. People will want to change their entries - take their email and send
> > them a password so they can edit it later.
>
> I thought about that, but my thinking was that if people had to
> register a login/password first, that might stop some people from
> cnotributing.
> What do others think? Allow for editing or not?
I was thinking about another slot for email and if they fill it in, you
generate a random password and email it to them automatically. They only
need to login next time, when they want to edit an existing entry.
You could store the email/password pairs in Access or MySQL or something ;-)
- Richard Huxton
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] Contribute to the PL/pgSQL CookBook !!
2001-03-15 22:45 Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
@ 2001-03-17 00:41 ` Roberto Mello <rmello@cc.usu.edu>
1 sibling, 0 replies; 5+ messages in thread
From: Roberto Mello @ 2001-03-17 00:41 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-docs
On Fri, Mar 16, 2001 at 09:02:30AM -0800, Josh Berkus wrote:
> Robert,
>
> I wanted to thank you for taking the time to re-write the PL/pgSQL docs.
> I'll be contributing functions soon. Actually, since I have a huge
> number of functions (my entire app runs off PL/pgSQL and PHP) is there
> anything in particular you want?
Np Josh. I am glad to help. This really should be in pg.org but it
seems that the pg web team is not very fond of db-backed websites.
I'd like to see functions to the main sections we have up right now,
for these are where people need more help at:
- Recursive functions
- Tree-structure functions
- Date manipulation functions
- String manipulation functions
- Triggers
Anything you can contribute would be great!
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer
let length(Long_Walk) > length(Short_Pier)
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-03-17 00:41 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-15 21:13 Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
2001-03-15 22:45 Contribute to the PL/pgSQL CookBook !! Roberto Mello <rmello@cc.usu.edu>
2001-03-16 08:23 ` Roberto Mello <rmello@cc.usu.edu>
2001-03-16 09:37 ` Richard Huxton <dev@archonet.com>
2001-03-17 00:41 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox