pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWisconsin Circuit Court Access (WCCA) on PostgreSQL
9+ messages / 8 participants
[nested] [flat]
* Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 19:27 Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 3 replies; 9+ messages in thread
From: Kevin Grittner @ 2006-03-13 19:27 UTC (permalink / raw)
To: pgsql-admin; pgsql-advocacy@postgresql.org; pgsql-general@postgresql.org
The Consolidated Court Automation Programs (CCAP) of the Wisconsin Court
System has migrated to PostgreSQL for all of its Circuit Court web
operations. Eight production databases have been converted, six of them
around 180 GB each, holding statewide information replicated real-time
from 72 county databases. The central copies support audit functions,
statewide statistics and report generation, and this web site:
http://wcca.wicourts.gov/
Given the success of this effort, we expect to be converting the other
court databases to PostgreSQL.
We've been very happy with both the performance of the product and the
support we have received from the mailing lists. Overall, PostgreSQL
has been faster than the commercial product from which we converted.
Even more important is the fast response we have had when posting
problems to the lists. We have normally had a fix within 24 hours.
Frankly, the support has been amazing.
We wonder how widespread the use of PostgreSQL is within government
agencies; I would love to hear from anyone with experience with this.
With tight budgets, it seems likely that there may be others moving in
this direction.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [GENERAL] Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 19:38 Richard Huxton <dev@archonet.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
2 siblings, 0 replies; 9+ messages in thread
From: Richard Huxton @ 2006-03-13 19:38 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin; pgsql-advocacy@postgresql.org; pgsql-general@postgresql.org
Kevin Grittner wrote:
> The Consolidated Court Automation Programs (CCAP) of the Wisconsin Court
> System has migrated to PostgreSQL for all of its Circuit Court web
> operations. Eight production databases have been converted, six of them
> around 180 GB each, holding statewide information replicated real-time
> from 72 county databases. The central copies support audit functions,
> statewide statistics and report generation, and this web site:
>
> http://wcca.wicourts.gov/
>
> Given the success of this effort, we expect to be converting the other
> court databases to PostgreSQL.
Always good to hear. Two obvious questions:
1. Have you completed a case-study questionnaire (and if not, would you
be prepared to?)
2. People on the advocacy lists occasionally get asked for
quotes/interviewees by the press. Would you be up for this?
> We've been very happy with both the performance of the product and the
> support we have received from the mailing lists. Overall, PostgreSQL
> has been faster than the commercial product from which we converted.
> Even more important is the fast response we have had when posting
> problems to the lists. We have normally had a fix within 24 hours.
> Frankly, the support has been amazing.
You can spend more time on hold calling commercial vendors than it takes
to get a patch with PostgreSQL :-)
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 19:57 Josh Berkus <josh@agliodbs.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
2 siblings, 0 replies; 9+ messages in thread
From: Josh Berkus @ 2006-03-13 19:57 UTC (permalink / raw)
To: pgsql-advocacy@postgresql.org; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Kevin,
> We've been very happy with both the performance of the product and the
> support we have received from the mailing lists. Overall, PostgreSQL
> has been faster than the commercial product from which we converted.
> Even more important is the fast response we have had when posting
> problems to the lists. We have normally had a fix within 24 hours.
> Frankly, the support has been amazing.
This is way cool. Do we have permission to quote you on the PostgreSQL
home page?
> We wonder how widespread the use of PostgreSQL is within government
> agencies; I would love to hear from anyone with experience with this.
> With tight budgets, it seems likely that there may be others moving in
> this direction.
There are. Unfortunately, a lot of them are in Defense or Homeland
Security, which means that they will never go on the record about what
software they use. Publically known users include:
Library of Congress
California Attorney General
National Gallery of Art
City of Garden Grove
National Weather Service
NOAA
Lawerence Berkeley Labs
University of California
U.S. Army
Gov't of Venezuala
Sao Paolo Metro
San Francisco MUNI
... and a bunch more I can't remember right now ...
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 21:16 Tony Caduto <tony_caduto@amsoftwaredesign.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
2 siblings, 2 replies; 9+ messages in thread
From: Tony Caduto @ 2006-03-13 21:16 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-general@postgresql.org
Kevin Grittner wrote:
> Overall, PostgreSQL
> has been faster than the commercial product from which we converted.
>
Kevin,
Are you allowed to say what commercial product you converted from?
Thanks,
Tony Caduto
AM Software Design
Milwaukee WI
http://www.amsoftwaredesign.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 21:26 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Tony Caduto <tony_caduto@amsoftwaredesign.com>
1 sibling, 1 reply; 9+ messages in thread
From: Scott Marlowe @ 2006-03-13 21:26 UTC (permalink / raw)
To: Tony Caduto <tony_caduto@amsoftwaredesign.com>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql general <pgsql-general@postgresql.org>
On Mon, 2006-03-13 at 15:16, Tony Caduto wrote:
> Kevin Grittner wrote:
> > Overall, PostgreSQL
> > has been faster than the commercial product from which we converted.
> >
>
>
> Kevin,
> Are you allowed to say what commercial product you converted from?
And whether he can or not, this would make a GREAT case study for the
advocacy folks.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 22:28 Michael Schmidt <michaelmschmidt@msn.com>
parent: Tony Caduto <tony_caduto@amsoftwaredesign.com>
1 sibling, 0 replies; 9+ messages in thread
From: Michael Schmidt @ 2006-03-13 22:28 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; Tony Caduto <tony_caduto@amsoftwaredesign.com>; +Cc: pgsql-general@postgresql.org
Regarding other government users, I read a case study awhile back on the web regarding ease of installation of databases. This was from a fellow in Texas - I think he was with the department of agriculture. He said that he had tried Oracle but had a lot of trouble getting it up and running. After several weeks, he tried PostgreSQL and found it much easier to install and work with, and his department was using it.
Michael Schmidt
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-13 22:41 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 9+ messages in thread
From: Scott Marlowe @ 2006-03-13 22:41 UTC (permalink / raw)
To: Tony Caduto <tony_caduto@amsoftwaredesign.com>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql general <pgsql-general@postgresql.org>
On Mon, 2006-03-13 at 15:26, Scott Marlowe wrote:
> On Mon, 2006-03-13 at 15:16, Tony Caduto wrote:
> > Kevin Grittner wrote:
> > > Overall, PostgreSQL
> > > has been faster than the commercial product from which we converted.
> > >
> >
> >
> > Kevin,
> > Are you allowed to say what commercial product you converted from?
>
> And whether he can or not, this would make a GREAT case study for the
> advocacy folks.
Yeah, anyone who says installing postgresql is hard should have to
install Oracle first. Or compile MySQL from source. :)
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-14 12:45 Andrew Rawnsley <ronz@investoranalytics.com>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 9+ messages in thread
From: Andrew Rawnsley @ 2006-03-14 12:45 UTC (permalink / raw)
To: pgsql general <pgsql-general@postgresql.org>
One doesn't 'install' oracle. That implies you have control of the
situation. One attempts to convince it to condescend to install itself onto
your machine.
Of course, this is like convincing my 3 year old to go to bed on time. Such
powers of persuasion are not common.
On 3/13/06 5:41 PM, "Scott Marlowe" <smarlowe@g2switchworks.com> wrote:
> On Mon, 2006-03-13 at 15:26, Scott Marlowe wrote:
>> On Mon, 2006-03-13 at 15:16, Tony Caduto wrote:
>>> Kevin Grittner wrote:
>>>> Overall, PostgreSQL
>>>> has been faster than the commercial product from which we converted.
>>>>
>>>
>>>
>>> Kevin,
>>> Are you allowed to say what commercial product you converted from?
>>
>> And whether he can or not, this would make a GREAT case study for the
>> advocacy folks.
>
> Yeah, anyone who says installing postgresql is hard should have to
> install Oracle first. Or compile MySQL from source. :)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
@ 2006-03-14 16:21 Guy Fraser <guy@incentre.net>
parent: Andrew Rawnsley <ronz@investoranalytics.com>
0 siblings, 0 replies; 9+ messages in thread
From: Guy Fraser @ 2006-03-14 16:21 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On Tue, 2006-14-03 at 07:45 -0500, Andrew Rawnsley wrote:
> One doesn't 'install' oracle. That implies you have control of the
> situation. One attempts to convince it to condescend to install itself onto
> your machine.
>
> Of course, this is like convincing my 3 year old to go to bed on time. Such
> powers of persuasion are not common.
>
> On 3/13/06 5:41 PM, "Scott Marlowe" <smarlowe@g2switchworks.com> wrote:
>
> > On Mon, 2006-03-13 at 15:26, Scott Marlowe wrote:
> >> On Mon, 2006-03-13 at 15:16, Tony Caduto wrote:
> >>> Kevin Grittner wrote:
> >>>> Overall, PostgreSQL
> >>>> has been faster than the commercial product from which we converted.
> >>>>
> >>>
> >>>
> >>> Kevin,
> >>> Are you allowed to say what commercial product you converted from?
> >>
> >> And whether he can or not, this would make a GREAT case study for the
> >> advocacy folks.
> >
> > Yeah, anyone who says installing postgresql is hard should have to
> > install Oracle first. Or compile MySQL from source. :)
> >
I'll agree with that, we had a tech who tried for a week to install
Oracle, only having to resort to buying third party books, to
figure out how to configure it. Managing it, is another scary task
when that guy left, I soon discovered the jumble of tools required
to administer it. We stopped supporting Oracle when our last
customer using it stopped using it.
I use PostgreSQL for most projects but have been supporting MySQL
for customers who request it, and usually build any new libraries
to be able to support either transparently, just by changing the
driver and user credentials in the config file. The hard part is
usually getting the MySQL to do what I expect, and what PostgreSQL
does by default.
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-03-14 16:21 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-13 19:27 Wisconsin Circuit Court Access (WCCA) on PostgreSQL Kevin Grittner <Kevin.Grittner@wicourts.gov>
2006-03-13 19:38 ` Richard Huxton <dev@archonet.com>
2006-03-13 19:57 ` Josh Berkus <josh@agliodbs.com>
2006-03-13 21:16 ` Tony Caduto <tony_caduto@amsoftwaredesign.com>
2006-03-13 21:26 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-03-13 22:41 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-03-14 12:45 ` Andrew Rawnsley <ronz@investoranalytics.com>
2006-03-14 16:21 ` Guy Fraser <guy@incentre.net>
2006-03-13 22:28 ` Michael Schmidt <michaelmschmidt@msn.com>
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