Re: Flyer nr. 1

Hello all,

since my last mail seems to have vanished in the dungeons of the
PostgreSQL mailservers, here is another attempt:

I started creating new flyers, first in english:

http://andreas.scherbaum.la/writings/pgug/en/

If you have comments or want to add a bit text, just let me know.
Any help is kindly appreciated.

Kind regards

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

Hi,

Andreas 'ads' Scherbaum wrote:
> Hello all,
>
> since my last mail seems to have vanished in the dungeons of the
> PostgreSQL mailservers, here is another attempt:
>
> I started creating new flyers, first in english:
>
> http://andreas.scherbaum.la/writings/pgug/en/
>
> If you have comments or want to add a bit text, just let me know.
> Any help is kindly appreciated.

Well, in the "Client Software for PostgreSQL" section pl/Pearl should be
really pl/Perl. Is it possible to add pl/PHP there ?

I think the text could use a spellchecker run to avoid things like
Indizes and Projekt.

--
Alexey Klyukin http://www.commandprompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 10 Jan 2008 19:33:00 +0200
Alexey Klyukin <alexk(at)commandprompt(dot)com> wrote:

> Hi,
>
> Andreas 'ads' Scherbaum wrote:
> > Hello all,
> >
> > since my last mail seems to have vanished in the dungeons of the
> > PostgreSQL mailservers, here is another attempt:
> >
> > I started creating new flyers, first in english:
> >
> > http://andreas.scherbaum.la/writings/pgug/en/
> >
> > If you have comments or want to add a bit text, just let me know.
> > Any help is kindly appreciated.
>
> Well, in the "Client Software for PostgreSQL" section pl/Pearl should
> be really pl/Perl. Is it possible to add pl/PHP there ?
>
> I think the text could use a spellchecker run to avoid things like
> Indizes and Projekt.

IMO: Stored-Languages sounds better (and more applicable) as Function
Languages.

Joshua D. Drake

- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHhlkkATb/zqfZUUQRAkNhAJ9lvui4Pp8oizOQO0s3UqvIQrpJeACeKfvH
pAPtx7H4+lFuBF7jgZUJIMs=
=8LUV
-----END PGP SIGNATURE-----

On 10/01/2008 17:14, Andreas 'ads' Scherbaum wrote:

> If you have comments or want to add a bit text, just let me know.
> Any help is kindly appreciated.

One correction - I don't think PgAdmin requires GTK2.

Looks good otherwise!

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

On 10/01/2008, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> On 10/01/2008 17:14, Andreas 'ads' Scherbaum wrote:
>
> > If you have comments or want to add a bit text, just let me know.
> > Any help is kindly appreciated.
>
> One correction - I don't think PgAdmin requires GTK2.

It is required on Unix, but I don't know of any distro that hasn't
shipped it for many years. I certainly wouldn't bother to mention it
on the flyers.

/D

Hello all,

thanks for your replies, suggestions and corrections.

On Thu, Jan 10, 2008 at 06:14:00PM +0100, Andreas 'ads' Scherbaum wrote:
>
> I started creating new flyers, first in english:
>
> http://andreas.scherbaum.la/writings/pgug/en/

I should have applied all of them and uploaded a new version. If you
want to take a look ...

Can we provide some additional content for:

- client software (much more)
- links (URLs at end of document)
- technical data
- the feature list
- usage examples
- last but not least: PostgreSQL 8.3

Thank you all

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

Andreas 'ads' Scherbaum a écrit :
| Hello all,
|
| thanks for your replies, suggestions and corrections.
| Can we provide some additional content for:
|
| - client software (much more)

ERP/CRM
- -------
TinyERP (Belgium) http://www.tinyerp.org/
Xtuples (USA) http://www.xtuple.com/

Forum
- -----
phpBB3 http://www.phpbb.com/community/viewtopic.php?f=14&t=615945

Wiki
- ----
Mediawiki http://www.mediawiki.org/

Regards,

Christophe Chauvet.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)

iD8DBQFHhyfpMl/S4ZhUIzERAsTNAJ46WJNA9nNVwLowSKfX0d9kVCNzsACgxMx1
fcGqmCBQP4Syr6lGa5JgUko=
=eKUJ
-----END PGP SIGNATURE-----

Christophe Chauvet a écrit :
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi
>
> Andreas 'ads' Scherbaum a écrit :
> | Hello all,
> |
> | thanks for your replies, suggestions and corrections.
> | Can we provide some additional content for:
> |
> | - client software (much more)
>
> ERP/CRM
> - -------
> TinyERP (Belgium) http://www.tinyerp.org/
> Xtuples (USA) http://www.xtuple.com/
>
> Forum
> - -----
> phpBB3 http://www.phpbb.com/community/viewtopic.php?f=14&t=615945

<troll> realy need to say something about that ?</troll>
>
> Wiki
> - ----
> Mediawiki http://www.mediawiki.org/
>

mediawiki integrate tsearch2 search engine.

> Regards,
>
> Christophe Chauvet.
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (MingW32)
>
> iD8DBQFHhyfpMl/S4ZhUIzERAsTNAJ46WJNA9nNVwLowSKfX0d9kVCNzsACgxMx1
> fcGqmCBQP4Syr6lGa5JgUko=
> =eKUJ
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

Hello again,

On Thu, Jan 10, 2008 at 06:14:00PM +0100, Andreas 'ads' Scherbaum wrote:
>
> I started creating new flyers, first in english:
>
> http://andreas.scherbaum.la/writings/pgug/en/

ok, the flyer is now almost ready. Some proof-reading would be fine and
if someone has additional comments: just shout ;-)

Kind regards

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

On Sat, 2008-01-19 at 03:30 +0100, Andreas 'ads' Scherbaum wrote:

> On Thu, Jan 10, 2008 at 06:14:00PM +0100, Andreas 'ads' Scherbaum wrote:
> >
> > I started creating new flyers, first in english:
> >
> > http://andreas.scherbaum.la/writings/pgug/en/
>
> ok, the flyer is now almost ready. Some proof-reading would be fine and
> if someone has additional comments: just shout ;-)

Very good work. We always need something to give out at trade shows.

Few random ones:

There is only one SQL Standard and it is called SQL:2003. It supercedes
all previous versions, so quoting compliance with multiple versions has
no meaning. (If you are compliant with SQL-92 but not SQL:2003 then you
are no longer compliant with the SQL Standard). There are no RDBMS yet
fully compliant with SQL:2003.

PHP & PostgreSQL was co-authored by Robert Treat.

Front page could probably just say a few quick bullets to catch the eye
- Very scalable and highly concurrent database access
- SQL:2003 compliant in all major aspects
- Variety of replication solutions exist
- Advanced SQL optimizer
Those are the ones that most people throw at us.

Any chance we could pick a different font? Not sure which one...

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

On Sun, Jan 20, 2008 at 01:29:07PM +0000, Simon Riggs wrote:
> On Sat, 2008-01-19 at 03:30 +0100, Andreas 'ads' Scherbaum wrote:
>
> > ok, the flyer is now almost ready. Some proof-reading would be fine and
> > if someone has additional comments: just shout ;-)
>
> Very good work. We always need something to give out at trade shows.

The old ones are very outdated.

> There is only one SQL Standard and it is called SQL:2003. It supercedes
> all previous versions, so quoting compliance with multiple versions has
> no meaning. (If you are compliant with SQL-92 but not SQL:2003 then you
> are no longer compliant with the SQL Standard). There are no RDBMS yet
> fully compliant with SQL:2003.

This is correct, but ...
As you state, no RDBMS is fully compliant with SQL:2003. So in most
cases people go and look, what else from previous standards is
available.

> PHP & PostgreSQL was co-authored by Robert Treat.

The books listed there are from the original BSD flyer. If someone has
other, better ideas ...
Anyway, co-author added, thanks for the info.

> Front page could probably just say a few quick bullets to catch the eye
> - Very scalable and highly concurrent database access
> - SQL:2003 compliant in all major aspects
> - Variety of replication solutions exist
> - Advanced SQL optimizer
> Those are the ones that most people throw at us.

Usually the flyers are all together in a put-up hinge. So ppl see (at
max) the headline. That's why i added the name and the flagg for the
language.

> Any chance we could pick a different font? Not sure which one...

This was already a topic on IRC but nobody could name a new font.

Kind regards

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

On Sun, 2008-01-20 at 14:48 +0100, Andreas 'ads' Scherbaum wrote:
>
> > There is only one SQL Standard and it is called SQL:2003. It
> supercedes
> > all previous versions, so quoting compliance with multiple versions
> has
> > no meaning. (If you are compliant with SQL-92 but not SQL:2003 then
> you
> > are no longer compliant with the SQL Standard). There are no RDBMS
> yet
> > fully compliant with SQL:2003.
>
> This is correct, but ...
> As you state, no RDBMS is fully compliant with SQL:2003. So in most
> cases people go and look, what else from previous standards is
> available.

"Previous standards" are historical, so comparing current features with
the previous standard is like saying I would have come first if I'd gone
back in time to the Moscow Olympics.

It's much easier just to mention the present standard and our present
level of compliance to it.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

I don't see anything about GiST, which is an important part of
PostgreSQL's extendability

GiST - a Generalized Search Tree provides a possibility to create
custom data types with indexed access methods and extensible set of
queries for specific domain experts not a database one.

On Sun, 20 Jan 2008, Simon Riggs wrote:

> On Sat, 2008-01-19 at 03:30 +0100, Andreas 'ads' Scherbaum wrote:
>
>> On Thu, Jan 10, 2008 at 06:14:00PM +0100, Andreas 'ads' Scherbaum wrote:
>>>
>>> I started creating new flyers, first in english:
>>>
>>> http://andreas.scherbaum.la/writings/pgug/en/
>>
>> ok, the flyer is now almost ready. Some proof-reading would be fine and
>> if someone has additional comments: just shout ;-)
>
> Very good work. We always need something to give out at trade shows.
>
> Few random ones:
>
> There is only one SQL Standard and it is called SQL:2003. It supercedes
> all previous versions, so quoting compliance with multiple versions has
> no meaning. (If you are compliant with SQL-92 but not SQL:2003 then you
> are no longer compliant with the SQL Standard). There are no RDBMS yet
> fully compliant with SQL:2003.
>
> PHP & PostgreSQL was co-authored by Robert Treat.
>
> Front page could probably just say a few quick bullets to catch the eye
> - Very scalable and highly concurrent database access
> - SQL:2003 compliant in all major aspects
> - Variety of replication solutions exist
> - Advanced SQL optimizer
> Those are the ones that most people throw at us.
>
> Any chance we could pick a different font? Not sure which one...
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Hello Oleg,

On Sun, Jan 20, 2008 at 05:09:31PM +0300, Oleg Bartunov wrote:
> I don't see anything about GiST, which is an important part of
> PostgreSQL's extendability

good point, added.

> GiST - a Generalized Search Tree provides a possibility to create
> custom data types with indexed access methods and extensible set of
> queries for specific domain experts not a database one.

I shortened the text a bit.

Kind regards

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

On Sun, Jan 20, 2008 at 02:03:23PM +0000, Simon Riggs wrote:
> On Sun, 2008-01-20 at 14:48 +0100, Andreas 'ads' Scherbaum wrote:
> >
> > > There is only one SQL Standard and it is called SQL:2003. It
> > > supercedes all previous versions, so quoting compliance with
> > > multiple versions has no meaning. (If you are compliant with
> > > SQL-92 but not SQL:2003 then you are no longer compliant with the
> > > SQL Standard). There are no RDBMS yet fully compliant with
> > > SQL:2003.
> >
> > This is correct, but ...
> > As you state, no RDBMS is fully compliant with SQL:2003. So in most
> > cases people go and look, what else from previous standards is
> > available.
>
> "Previous standards" are historical, so comparing current features with
> the previous standard is like saying I would have come first if I'd gone
> back in time to the Moscow Olympics.

What if no one really implements the current standard?

> It's much easier just to mention the present standard and our present
> level of compliance to it.

Anyway, i changed the first chapter, but i'm not very happy with the
second chapter on the first page. Someone a good proposal here?

Bye

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

Andreas 'ads' Scherbaum wrote:
> Hello all,
>
> since my last mail seems to have vanished in the dungeons of the
> PostgreSQL mailservers, here is another attempt:
>
> I started creating new flyers, first in english:
>
> http://andreas.scherbaum.la/writings/pgug/en/
>
> If you have comments or want to add a bit text, just let me know.
> Any help is kindly appreciated.
>
>
> Kind regards
>
>
Andreas,

looks nice. But can you change the blue from the text. Can you try to
get it more similiar to the blue of the elephant?
Or much darker blue. I would try to make the blue text darkgreen or
bordeaux and look, if this looks a little bit nicer.

For the English text. Please let a native Speaker (because it's
European, a British English native speaker) correct the text, if the
English isn't perfect.

A second picture would be nice too.

Great work.

Susanne

--
Susanne Ebrecht
52066 Aachen, Germany

PostgreSQL European Group
Email: miracee(at)miracee(dot)de