Sunday, January 21. 2007
phpPgAdmin 4.1 Released
The phpPgAdmin Team is proud to announce a new major release of
phpPgAdmin. Version 4.1 adds many new features, bug fixes and
updated translations over the previous version.
To download right now, visit:
[http://phppgadmin.sourceforge.net/?page=download http://phppgadmin.sourceforge.net/?page=download]
To give the fully-functional demo a try, visit:
[http://phppgadmin.kattare.com/phppgadmin4/ http://phppgadmin.kattare.com/phppgadmin4/]
New icons by Niko, from the graphics repository on
pgFoundry.
Added icons to bread crumb trail and tabs.
Send encrypted passwords over the wire wherever possible.
Alter sequence, nextval and setval (Guillaume)
Auto-select 'WITHOUT OIDS' if 'default_with_oids' setting is false
(Guillaume)
Autovacuum configuration support (Robert Treat)
Basic ROLE support (Chris Kings-Lynne, Javier Carlos)
Add support for SSL connections (Eric Kinolik)
Display content of pg_locks view (Javier Carlos)
Add labels for checkboxes/radio buttons for improved usability (Guillaume)
Display Prepared Transactions (Javier Carlos)
Re-enable table browsing from tree icons (ioguix)
Add Support For IN/OUT Parameters (John Jawed)
Add column level information into the tree browser (ioguix)
Promote column level interaction into its own page (ioguix)
Add automatic lookup of foreign key values in insert/update fields (John
Jawed)
Add ability to create/drop/alter custom aggregates (Javier Carlos)
Add enable/disable trigger (John Jawed)
* Add global comments for databases and tablespaces
phpPgAdmin. Version 4.1 adds many new features, bug fixes and
updated translations over the previous version.
Download
To download right now, visit:
[http://phppgadmin.sourceforge.net/?page=download http://phppgadmin.sourceforge.net/?page=download]
Demo
To give the fully-functional demo a try, visit:
[http://phppgadmin.kattare.com/phppgadmin4/ http://phppgadmin.kattare.com/phppgadmin4/]
New Features
New icons by Niko
pgFoundry.
Send encrypted passwords over the wire wherever possible.
Alter sequence, nextval and setval (Guillaume)
Auto-select 'WITHOUT OIDS' if 'default_with_oids' setting is false
(Guillaume)
Autovacuum configuration support (Robert Treat)
Basic ROLE support (Chris Kings-Lynne, Javier Carlos)
Add support for SSL connections (Eric Kinolik)
Display content of pg_locks view (Javier Carlos)
Add labels for checkboxes/radio buttons for improved usability (Guillaume)
Display Prepared Transactions (Javier Carlos)
Re-enable table browsing from tree icons (ioguix)
Add Support For IN/OUT Parameters (John Jawed)
Add column level information into the tree browser (ioguix)
Promote column level interaction into its own page (ioguix)
Add automatic lookup of foreign key values in insert/update fields (John
Jawed)
Add ability to create/drop/alter custom aggregates (Javier Carlos)
Add enable/disable trigger (John Jawed)
* Add global comments for databases and tablespaces
Friday, January 5. 2007
2006 Year In Review
I've been trying to get this post out for the last few days without success, but I figure I better get it out now before anythng too exciting happens for 2007. The idea behind the post was to gather a list of items that I saw as significant occurences in my life for 2006; it's not a complete list neccessarily, but pretty good look at things. To that end:
30
In January I turned 30. Really this isn't a big deal to me, but in general society thinks it is important, so it's probably worth noting.
The Book
February saw the release of [http://www.amazon.com/gp/product/1590595475?tag2=zillablog-20 Begining PHP and PostgreSQL 8], a book I co-authored with [http://www.wjgilmore.com/ Jason Gilmore]. Writing a novel is something everyone says they want to do in thier life, and for me this was certainly the way I wanted to go about marking off that todo item on my life list.
pgsummit
Early July saw the 10 year Anniversary, which included my first trip back to Toronto in more than 10 years to attend the [http://trends.newsforge.com/article.pl?sid=06/07/10/1723251&from=rss postgresql developers summit]. The highlight was of course getting to meet a whole bunch of people I'd none online for years.
spi participation
Shortly after the annivesary I was elected as the spi board observer for the postgresql project. To date we haven't done alot with our SPI membership, but I think it has brought PostgreSQL some positive exposure within the FLOSS community, and has given us some structure to move forward on several advocacy efforts.
oscon
Rounding out July was another trip to Portland. This wasn't my first oscon, but presenting on Ruby rather than PostgreSQL gave it a whole new spin, plus having Dave Thomas, among others, sitting in the back of the presentation was certainly a bonus.
Dylan starts school
My 5 year old started kindergarden, and after a year of pre-school (kudos to vpk) that was fairly rocky, kindergarden was even worse. Had things stayed as they were I don't know how things would have turned out, but fortunatly life was about to change for the better.
OmniTi
In September I agreed to pack my bags and move to Maryland to work at OmniTi. One of the big factors in coming was the chance to work with some really smart people on a regular basis, but I was pleasently surprised to see the caliber of talent extend beyond the "name" employees out to the whole staff. Plus there's the odd similarity to how I got hired by OmniTi and how I got married which I get to sit back and think about.
PHP/DB|Works
Technically I went to php/db|works before I started working at OmniTi, but it was after my last day at WebMD. International travel tip #1: Never tell the customs agent you're unemployed when they ask you what your job is. In any case, I again got to visit Toronto and met a whole bunch more people whom I had always wanted to meet, I got to speak on plphp, and was all around impressed with the conference crew; I'll have to do another php conference before long.
google soc summit
In October I went to Mountain View for the Google Summer of Code Mentor Summit on behalf of the PostgreSQL project. Again I met lots of interesting people (see a theme here?) and swapped a lot of good ideas which I hope to help put into action at the next Summer of Code. Also of note it was my first time at Google, a place I strongly recommend any tech developer check out should they get the opportunity.
worked the booth at LISA
Though I had been to several conferences this year, I hadn't done much booth duty for some time, but since LISA was local I thought it wasa good opportunity to pitch in some help (and meet some new folks, but you're sick of that line by now). I enjoyed the conference, but probably more memorable was the subway system and my walk through some back alleys to the out of the way parking lot I ended up in in Silver Springs...
ppa 4.1 beta
So normally a beta release would not be a significant mile stone, but with Chris leaving the project (and leaving me in charge) while I was in the midst of an interstate move, we passed the one year mark between releases and I really wanted to get that thing out so people could see there was some life in the project. I made it just under the gun, and I'm happy to say since the beta we've gotten some bug reports and some nice cleanup work being done which helps make it all worthwhile; now we just need to get those translations updated.
So that about rounds out 2006; looking back no wonder I felt so compressed for time. And what about 2007? I'm on the hook to help out with pgcon and I've been thinking about working on another book project, but otherwise I've no concrete plans, which is probably OK, since I didn't have any at the start of 2006 either.
In January I turned 30. Really this isn't a big deal to me, but in general society thinks it is important, so it's probably worth noting.
February saw the release of [http://www.amazon.com/gp/product/1590595475?tag2=zillablog-20 Begining PHP and PostgreSQL 8], a book I co-authored with [http://www.wjgilmore.com/ Jason Gilmore]. Writing a novel is something everyone says they want to do in thier life, and for me this was certainly the way I wanted to go about marking off that todo item on my life list.
Early July saw the 10 year Anniversary, which included my first trip back to Toronto in more than 10 years to attend the [http://trends.newsforge.com/article.pl?sid=06/07/10/1723251&from=rss postgresql developers summit]. The highlight was of course getting to meet a whole bunch of people I'd none online for years.
Shortly after the annivesary I was elected as the spi board observer for the postgresql project. To date we haven't done alot with our SPI membership, but I think it has brought PostgreSQL some positive exposure within the FLOSS community, and has given us some structure to move forward on several advocacy efforts.
Rounding out July was another trip to Portland. This wasn't my first oscon, but presenting on Ruby rather than PostgreSQL gave it a whole new spin, plus having Dave Thomas, among others, sitting in the back of the presentation was certainly a bonus.
My 5 year old started kindergarden, and after a year of pre-school (kudos to vpk) that was fairly rocky, kindergarden was even worse. Had things stayed as they were I don't know how things would have turned out, but fortunatly life was about to change for the better.
In September I agreed to pack my bags and move to Maryland to work at OmniTi. One of the big factors in coming was the chance to work with some really smart people on a regular basis, but I was pleasently surprised to see the caliber of talent extend beyond the "name" employees out to the whole staff. Plus there's the odd similarity to how I got hired by OmniTi and how I got married which I get to sit back and think about.
Technically I went to php/db|works before I started working at OmniTi, but it was after my last day at WebMD. International travel tip #1: Never tell the customs agent you're unemployed when they ask you what your job is. In any case, I again got to visit Toronto and met a whole bunch more people whom I had always wanted to meet, I got to speak on plphp, and was all around impressed with the conference crew; I'll have to do another php conference before long.
In October I went to Mountain View for the Google Summer of Code Mentor Summit on behalf of the PostgreSQL project. Again I met lots of interesting people (see a theme here?) and swapped a lot of good ideas which I hope to help put into action at the next Summer of Code. Also of note it was my first time at Google, a place I strongly recommend any tech developer check out should they get the opportunity.
Though I had been to several conferences this year, I hadn't done much booth duty for some time, but since LISA was local I thought it wasa good opportunity to pitch in some help (and meet some new folks, but you're sick of that line by now). I enjoyed the conference, but probably more memorable was the subway system and my walk through some back alleys to the out of the way parking lot I ended up in in Silver Springs...
So normally a beta release would not be a significant mile stone, but with Chris leaving the project (and leaving me in charge) while I was in the midst of an interstate move, we passed the one year mark between releases and I really wanted to get that thing out so people could see there was some life in the project. I made it just under the gun, and I'm happy to say since the beta we've gotten some bug reports and some nice cleanup work being done which helps make it all worthwhile; now we just need to get those translations updated.
So that about rounds out 2006; looking back no wonder I felt so compressed for time. And what about 2007? I'm on the hook to help out with pgcon and I've been thinking about working on another book project, but otherwise I've no concrete plans, which is probably OK, since I didn't have any at the start of 2006 either.
Friday, October 13. 2006
Heading to Google SoC mentor Summit Today
This evening I'll be flying out to California for Google's [http://code.google.com/soc/ Summer of Code] Mentor Summit on be-half of the PostgreSQL project. The Summit is an [http://en.wikipedia.org/wiki/Unconference unconference] designed around discussing ways to increase partiticpation, improve the processes, and generally just ways to make the program better. Also there will be some discussion on getting more mentors involved and also keeping students involved after the program ends, two things I am curious to see other's ideas on.
From my experience I thought [http://code.google.com/soc/pgsql/about.html PostgreSQL's SoC projects] all went pretty well. While not everything went into core, all of the mentor surveys indicated that they thought the program was successful. Actually one problem specific to our project was the feature freeze date issue, where 8.2's feature freeze date was before the end of the SoC program, and core decided against pushing it back. Because of this, 3 of the projects ended up with code that the mentors felt will probably be included in 8.3, but didn't make the cut for 8.2. (The [http://code.google.com/soc/pgsql/appinfo.html?csaid=F94A1818F46F66FD xlog viewer], XML work, and the Hashing DISTINCT Clause implementation). On the other end were 3 projects that did make it into core, though 1 of those was actually a list of improvements for PhpPgAdmin, so it didn't have to worry about feature freeze issues. ([http://code.google.com/soc/pgsql/appinfo.html?csaid=DB096D908B948D89 phpPgAdmin improvements], [http://code.google.com/soc/pgsql/appinfo.html?csaid=4E856BAC67297450 enhanced aggregate upport], and ECPG cleanup). The last project ([http://code.google.com/soc/pgsql/appinfo.html?csaid=34B13296DE039A78 Full Disjunctions]) ended with a slightly different fate... upon submittal for inclusion into core, it was decided that the implementation would be too different as a core feature, and so the project now lives on [http://pgfoundry.org/projects/fulldisjunction/ PgFoundry]. It did have a lot of supporters though, enough so that it will probably be mentioned in the upcoming 8.2 press release.
Unfortunately my stay will be short, I'm flying back Saturday night right after the conference, so I won't get a chance to visit any of the [http://pugs.postgresql.org/sfpug/ SoCal gang], but I think it will be nice to get together with other SoC folks and hopefully I'll pick up some tips to help make the program stronger for the project next year.
From my experience I thought [http://code.google.com/soc/pgsql/about.html PostgreSQL's SoC projects] all went pretty well. While not everything went into core, all of the mentor surveys indicated that they thought the program was successful. Actually one problem specific to our project was the feature freeze date issue, where 8.2's feature freeze date was before the end of the SoC program, and core decided against pushing it back. Because of this, 3 of the projects ended up with code that the mentors felt will probably be included in 8.3, but didn't make the cut for 8.2. (The [http://code.google.com/soc/pgsql/appinfo.html?csaid=F94A1818F46F66FD xlog viewer], XML work, and the Hashing DISTINCT Clause implementation). On the other end were 3 projects that did make it into core, though 1 of those was actually a list of improvements for PhpPgAdmin, so it didn't have to worry about feature freeze issues. ([http://code.google.com/soc/pgsql/appinfo.html?csaid=DB096D908B948D89 phpPgAdmin improvements], [http://code.google.com/soc/pgsql/appinfo.html?csaid=4E856BAC67297450 enhanced aggregate upport], and ECPG cleanup). The last project ([http://code.google.com/soc/pgsql/appinfo.html?csaid=34B13296DE039A78 Full Disjunctions]) ended with a slightly different fate... upon submittal for inclusion into core, it was decided that the implementation would be too different as a core feature, and so the project now lives on [http://pgfoundry.org/projects/fulldisjunction/ PgFoundry]. It did have a lot of supporters though, enough so that it will probably be mentioned in the upcoming 8.2 press release.
Unfortunately my stay will be short, I'm flying back Saturday night right after the conference, so I won't get a chance to visit any of the [http://pugs.postgresql.org/sfpug/ SoCal gang], but I think it will be nice to get together with other SoC folks and hopefully I'll pick up some tips to help make the program stronger for the project next year.
Tuesday, August 29. 2006
Google SoC coming to a close
I just finished up my mentor evaluation for the [http://code.google.com/soc/pgsql/about.html google summer of code program]. The project I worked on was the addition of several new features into phppgadmin by way of the postgresql project. Features we ended up adding included the following:
Add Check and foreign key constraints addition to the add/alter column pages.
User-defined size field disabled for data types with pre-defined sizes on add/alter column pages.
Autocomplete feature on foreign key values for update/insert row pages.
Add support for IN, OUT, and INOUT arguments to functions
Add support for ENABLE/DISABLE TRIGGER on tables (introduced in 8.1).
Move argument list for functions into it's own section and add support for
IN, OUT, INOUT and their respective types.
From my end of things, I really enjoyed the whole process, and would gladly sign up for this program next year. My student also said he enjoyed the process and felt very welcome inside the community as well. I also think from [http://phppgadmin.sourceforge.net/ the project's] stand-point it gave us a boost to have regular code submissions coming in during the summer. Right now we have 3 outstanding patches (iirc) that we need to do something about, but after that we can probably go ahead and make a new release for phpPgAdmin, hopefully all in the next month or so.
Add Check and foreign key constraints addition to the add/alter column pages.
User-defined size field disabled for data types with pre-defined sizes on add/alter column pages.
Autocomplete feature on foreign key values for update/insert row pages.
Add support for IN, OUT, and INOUT arguments to functions
Add support for ENABLE/DISABLE TRIGGER on tables (introduced in 8.1).
Move argument list for functions into it's own section and add support for
IN, OUT, INOUT and their respective types.
From my end of things, I really enjoyed the whole process, and would gladly sign up for this program next year. My student also said he enjoyed the process and felt very welcome inside the community as well. I also think from [http://phppgadmin.sourceforge.net/ the project's] stand-point it gave us a boost to have regular code submissions coming in during the summer. Right now we have 3 outstanding patches (iirc) that we need to do something about, but after that we can probably go ahead and make a new release for phpPgAdmin, hopefully all in the next month or so.
Tuesday, August 8. 2006
So what have I been up to?
So, in any given week I'm sure to be involved in at least a half a dozen things, but normally I still try to find time to work in some blogging. Since I've been a little quiet in that area, I thought I'd give a quick run-down on what I've been up to he last week or so.
The main thing that has been keeping me busy is working on [http://phppgadmin.sourceforge.net/ phpPgAdmin]. Mostly this has been in the form a patch reviews, both for the [http://code.google.com/soc/pgsql/appinfo.html?csaid=DB096D908B948D89 Google SoC] work going on and from other developers on the project. This past week fleshed out the column level interaction and table browsing that had been added into the tree earlier, and also added some ajaxy style tech to do foreign key look-ups when manipulating data. With more patches on deck, this next release of ppa is really shaping up to be pretty nice.
Another thing I've been spending time on is working on postgresql foundation business. As you may or may not have heard, the postgresql project has [http://www.spi-inc.org/projects/postgresql teamed up with SPI] to help manage the fund raising and advocacy portions of the project. In conjuction with that, I've been elected as the SPI board observer, so I'll sit in on SPI meetings to keep a watchful eye over things. [[image /xzilla/templates/default/img/emoticons/smile.png alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" /]] The first SPI meeting was last tuesday, where the [http://www.spi-inc.org/corporate/board new board members] were sworn in. Luckily it took like 5 minutes... if only all of the future meetings would go that smooth. On the postgresql side, we've been trying to hash out some procedural issue so we can really get things moving. Other items soon to be hashed out: getting new members, opening up our process abit more, and maybe we'll even revisit the gpg key issue [[image /xzilla/templates/default/img/emoticons/wink.png alt=";-)" style="display: inline; vertical-align: bottom;" class="emoticon" /]]
I've also done a couple of web site updates: cleaning up after Pervasive's recent announcement, but also adding some information on Skype and Sun into the site. We've also added a new featured user, the [http://www.nplindia.ernet.in/ Indian National Physical Labratory]. What is the NPL? From Ashish Ranjan, a scientist at the lab: "Apart from research in sciences, it also sets physical standards for India, and is one of the few designated labs of world whose atomic clock time is averaged to get the average World time at high precision." And about PostgreSQL? "We use PostgreSQL in a *big way*. Our projects which need databases essentially use Postgres. Currently we are even evaluating pgcluster for high availability purposes."
Well, those are the big things. I've been working on a couple of articles this past week, but I'll wait for some links to appear before going too much farther with those. I've also started a couple of blog posts I need to finish up, you'll probably see those next week. Oh yeah, forgot I've also been tinkering around with the blog software we use for the planet postgresql blogs, fixing one broken module and preping a couple of others (we run with security set pretty tight on the planetpg box, so things tend to be a little more manual). Guess I'll talk more about that once I complete those projects too... gotta keep busy.
The main thing that has been keeping me busy is working on [http://phppgadmin.sourceforge.net/ phpPgAdmin]. Mostly this has been in the form a patch reviews, both for the [http://code.google.com/soc/pgsql/appinfo.html?csaid=DB096D908B948D89 Google SoC] work going on and from other developers on the project. This past week fleshed out the column level interaction and table browsing that had been added into the tree earlier, and also added some ajaxy style tech to do foreign key look-ups when manipulating data. With more patches on deck, this next release of ppa is really shaping up to be pretty nice.
Another thing I've been spending time on is working on postgresql foundation business. As you may or may not have heard, the postgresql project has [http://www.spi-inc.org/projects/postgresql teamed up with SPI] to help manage the fund raising and advocacy portions of the project. In conjuction with that, I've been elected as the SPI board observer, so I'll sit in on SPI meetings to keep a watchful eye over things. [[image /xzilla/templates/default/img/emoticons/smile.png alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" /]] The first SPI meeting was last tuesday, where the [http://www.spi-inc.org/corporate/board new board members] were sworn in. Luckily it took like 5 minutes... if only all of the future meetings would go that smooth. On the postgresql side, we've been trying to hash out some procedural issue so we can really get things moving. Other items soon to be hashed out: getting new members, opening up our process abit more, and maybe we'll even revisit the gpg key issue [[image /xzilla/templates/default/img/emoticons/wink.png alt=";-)" style="display: inline; vertical-align: bottom;" class="emoticon" /]]
I've also done a couple of web site updates: cleaning up after Pervasive's recent announcement, but also adding some information on Skype and Sun into the site. We've also added a new featured user, the [http://www.nplindia.ernet.in/ Indian National Physical Labratory]. What is the NPL? From Ashish Ranjan, a scientist at the lab: "Apart from research in sciences, it also sets physical standards for India, and is one of the few designated labs of world whose atomic clock time is averaged to get the average World time at high precision." And about PostgreSQL? "We use PostgreSQL in a *big way*. Our projects which need databases essentially use Postgres. Currently we are even evaluating pgcluster for high availability purposes."
Well, those are the big things. I've been working on a couple of articles this past week, but I'll wait for some links to appear before going too much farther with those. I've also started a couple of blog posts I need to finish up, you'll probably see those next week. Oh yeah, forgot I've also been tinkering around with the blog software we use for the planet postgresql blogs, fixing one broken module and preping a couple of others (we run with security set pretty tight on the planetpg box, so things tend to be a little more manual). Guess I'll talk more about that once I complete those projects too... gotta keep busy.
Friday, December 16. 2005
Shout out to ChrisKL
Just wanted to give a heads up regarding one of [http://people.planetpostgresql.org/chriskl/ Christopher Kings-Lynne]'s newest ventures, the [http://pgfoundry.org/projects/mysqlcompat MySQL compatability project]. At less than a month old, it's already garnered its first news headline, via [http://software.newsforge.com/software/05/12/15/1611251.shtml?tid=72 an article on Newsforge]. It discusses Chris's angle on the purpose of the project, why he got involved, and what it means for application developers. Since I've known Chris to be a stud for years having worked with him on the [http://phppgadmin.sourceforge.net/?page=about phpPgAdmin] project, I have to say I am glad to see him doing well.
Saturday, August 20. 2005
PhpPgAdmin 3.5.5 Released
We've released PhpPgAdmin 3.5.5 which includes the following fixes:
Fix for PHP 4.4.0's new strict references
Small improvement to Opera browser detection in the tree
Fix listing of opaque functions in 7.2
Fix listing of opclasses and functions pre 7.3
You can download it at our project site on sourceforge, [http://phppgadmin.sourceforge.net/ http://phppgadmin.sourceforge.net/]
You can download it at our project site on sourceforge, [http://phppgadmin.sourceforge.net/ http://phppgadmin.sourceforge.net/]
« previous page
(Page 2 of 3, totaling 15 entries)
» next page
Quicksearch
This is the weblog of Robert Treat. I lead the Database Operations Group at OmniTI, where we work on some of todays largest database challenges.
bio | writings
Hire me! Need help with your database? We are available for large scale or short term engagements.
Hire you! If you have experience with Postgres, MySQL, or Oracle, we are looking for people to join our team.
bio | writings
Hire me! Need help with your database? We are available for large scale or short term engagements.
Hire you! If you have experience with Postgres, MySQL, or Oracle, we are looking for people to join our team.
| 
| 
| 
| 
| 
Syndicate This Blog
Powered by
You were saying?
Thu, 31.12.2009 14:06
yum install php-pgsql; should work on most distros that use yum.
Sun, 27.12.2009 23:24
What command did you mean when you wrote: "Step one was inst alling PostgreSQL support into PHP, which was a simple [...]
Mon, 09.11.2009 12:26
I did field a couple of "why s hould I use Postgres instead o f MySQL?" questions, but they were in a different form [...]