SEO

Hey everyone,

I know we started a discussion a month or so ago regarding ideas for
SoC projects. However, after reading through the thread, I didn't see
us nail down any actual items.

As such, we need to quickly put together a list of oh, 15-20 midlevel
project ideas. I'm sure we can pull some off the TODO list, but we
should also look at project ideas for porting some of the most used
third-party OSS software to PostgreSQL too (portals, CMS systems,
accounting systems, etc.).

All ideas welcome!

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

OpenMFG has done some work on getting PostgreSQL working with the Drupal CMS and the Mantis bugtracker (and also integrating those two, btw). We're in contact with the respective projects about getting our patches worked in, but if anyone's keeping a tally, just wanted you to be aware.

Regards,
Ned


Jonah H. Harris wrote:
> Hey everyone,
>
> I know we started a discussion a month or so ago regarding ideas for
> SoC projects. However, after reading through the thread, I didn't see
> us nail down any actual items.
>
> As such, we need to quickly put together a list of oh, 15-20 midlevel
> project ideas. I'm sure we can pull some off the TODO list, but we
> should also look at project ideas for porting some of the most used
> third-party OSS software to PostgreSQL too (portals, CMS systems,
> accounting systems, etc.).
>
> All ideas welcome!
>
> --
> Jonah H. Harris, Database Internals Architect
> EnterpriseDB Corporation
> 732.331.1324
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

* Jonah H. Harris (jonah.harris@gmail.com) wrote:
> I know we started a discussion a month or so ago regarding ideas for
> SoC projects. However, after reading through the thread, I didn't see
> us nail down any actual items.

I got an email already for a good idea, actually, which is to work on
having pg_hba.conf modifiable from SQL. The only problem with that is
that it really needs to be done in an acceptable way which requires
probably as much design work as actual programming. Another idea along
those same lines would be having .k5login-style support for Kerberos.
We'd need a conf-flag for that for backwards compatibility (once the
..k5login-style support exists we should clean up our Kerberos
credentials matching to, for example, not accept 'sfrost/root' for
'sfrost' or 'sfrost@ABC.COM' for 'sfrost@XYZ.com').

It'd also be nice to support SASL, and better hashes than md5.

Thanks,

Stephen

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

iD8DBQFEQ6eurzgMPqB3kigRAohXAJ0XAln8b1QjsTYq3xfRsN ADl+Ml/wCeOcAl
jAc2iIVUzm1tuvLiEZ0CXDU=
=i7rd
-----END PGP SIGNATURE-----

On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote:
> All ideas welcome!

I know it's not directly PostgreSQL related, but I'd love to see the
dbt* code improved. Items on my wish-list:

- make it easy to run the test framework and clients on a seperate
machine from the database server
- keep results in a database
- provide a front-end to allow users to schedule tests in a queue
- add support for windows, at least for the database (theoretically
possible to run that way now, but you have to do everything by hand)

Another idea: afaik, spikesource is still offering a bounty for
improvements to OSS test suites, something that'd fit well with SoC.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Jim C. Nasby wrote:
> On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote:
>> All ideas welcome!
>
> I know it's not directly PostgreSQL related, but I'd love to see the
> dbt* code improved. Items on my wish-list:
>
> - make it easy to run the test framework and clients on a seperate
> machine from the database server
> - keep results in a database
> - provide a front-end to allow users to schedule tests in a queue
> - add support for windows, at least for the database (theoretically
> possible to run that way now, but you have to do everything by hand)
>
> Another idea: afaik, spikesource is still offering a bounty for
> improvements to OSS test suites, something that'd fit well with SoC.

I second this. There are also the TPC-App (Java) fair-use
implementation that I've started and the TPC-E (next gen OLTP) that I
would like to start.

Mark

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Tue, Apr 18, 2006 at 11:27:40AM -0700, Mark Wong wrote:
> Jim C. Nasby wrote:
> >On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote:
> >>All ideas welcome!
> >
> >I know it's not directly PostgreSQL related, but I'd love to see the
> >dbt* code improved. Items on my wish-list:
> >
> >- make it easy to run the test framework and clients on a seperate
> > machine from the database server
> >- keep results in a database
> >- provide a front-end to allow users to schedule tests in a queue
> >- add support for windows, at least for the database (theoretically
> > possible to run that way now, but you have to do everything by hand)
> >
> >Another idea: afaik, spikesource is still offering a bounty for
> >improvements to OSS test suites, something that'd fit well with SoC.
>
> I second this. There are also the TPC-App (Java) fair-use
> implementation that I've started and the TPC-E (next gen OLTP) that I
> would like to start.

Maybe before starting on TPC-E it makes sense to try and get a common
framework for all the different tests built? AFAIK most of the
benchmarks all use a fairly standard client-server infrastructure, so we
should hopefully be able to share that between the different tests...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On 4/18/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Tue, Apr 18, 2006 at 11:27:40AM -0700, Mark Wong wrote:
> > Jim C. Nasby wrote:
> > >On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote:
> > >>All ideas welcome!
> > >
> > >I know it's not directly PostgreSQL related, but I'd love to see the
> > >dbt* code improved. Items on my wish-list:
> > >
> > >- make it easy to run the test framework and clients on a seperate
> > > machine from the database server
> > >- keep results in a database
> > >- provide a front-end to allow users to schedule tests in a queue
> > >- add support for windows, at least for the database (theoretically
> > > possible to run that way now, but you have to do everything by hand)
> > >
> > >Another idea: afaik, spikesource is still offering a bounty for
> > >improvements to OSS test suites, something that'd fit well with SoC.
> >
> > I second this. There are also the TPC-App (Java) fair-use
> > implementation that I've started and the TPC-E (next gen OLTP) that I
> > would like to start.
>
> Maybe before starting on TPC-E it makes sense to try and get a common
> framework for all the different tests built? AFAIK most of the
> benchmarks all use a fairly standard client-server infrastructure, so we
> should hopefully be able to share that between the different tests...

I agree with Jim. A framework would really help out here. All of the
tests are basically the same and would benefit from a framework.

However, Mark, do you think Java is a reliable benchmarking platform?
At EnterpriseDB, we've tried several Java benchmarks and could never
get as repeatable or reliable of a benchmark as DBT2 gives you.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jonah H. Harris wrote:
> On 4/18/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
>> On Tue, Apr 18, 2006 at 11:27:40AM -0700, Mark Wong wrote:
>>> Jim C. Nasby wrote:
>>>> On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote:
>>>>> All ideas welcome!
>>>> I know it's not directly PostgreSQL related, but I'd love to see the
>>>> dbt* code improved. Items on my wish-list:
>>>>
>>>> - make it easy to run the test framework and clients on a seperate
>>>> machine from the database server
>>>> - keep results in a database
>>>> - provide a front-end to allow users to schedule tests in a queue
>>>> - add support for windows, at least for the database (theoretically
>>>> possible to run that way now, but you have to do everything by hand)
>>>>
>>>> Another idea: afaik, spikesource is still offering a bounty for
>>>> improvements to OSS test suites, something that'd fit well with SoC.
>>> I second this. There are also the TPC-App (Java) fair-use
>>> implementation that I've started and the TPC-E (next gen OLTP) that I
>>> would like to start.
>> Maybe before starting on TPC-E it makes sense to try and get a common
>> framework for all the different tests built? AFAIK most of the
>> benchmarks all use a fairly standard client-server infrastructure, so we
>> should hopefully be able to share that between the different tests...
>
> I agree with Jim. A framework would really help out here. All of the
> tests are basically the same and would benefit from a framework.

This has crossed my mind before. I haven't been able to come up with
something that I've felt good about on my own though.

> However, Mark, do you think Java is a reliable benchmarking platform?
> At EnterpriseDB, we've tried several Java benchmarks and could never
> get as repeatable or reliable of a benchmark as DBT2 gives you.

I don't have much experience here yet. I've only got a portion of the
TPC-App implemented, although probably enough now to see how repeatable
it is thus far. Do you want to give my DBT4 kit a shot? I'm curious
to what platforms you've tried Java on as I've heard the Linux
implementations aren't as good as their Windows counterparts. I'm not
sure how true that is today though.

Mark

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Proposed item: Improve PL/PHP support, especially installation on non-
Linux platforms. PL/PHP does not currently work on OS X (not sure
about Windows, but I doubt it).

Alvaro indicated he would be willing to provide direction on this
with testing support from me. He also said there are several other
possible PL/PHP issues that would warrant a SoC project.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On 4/19/06, John DeSoi <desoi@pgedit.com> wrote:
> Alvaro indicated he would be willing to provide direction on this
> with testing support from me. He also said there are several other
> possible PL/PHP issues that would warrant a SoC project.

Cool... let's get 'em all listed here so we can move forward.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster