Re: [GENERAL] Too far out of the mainstream
On Sat, Sep 1, 2012 at 5:25 AM, Andy Yoder ayo...@airfacts.com wrote: Hello all, I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the concern our client's IT group has about our use of PostgreSQL in our shop. The group in question supports multiple different databases, including Oracle, MySQL, SQLServer, DB2, and even some non-relational databases (think Cobol and file-based storage), each type with a variety of applications and support needs. We are in the running for getting a large contract from them and need to address their question: What makes PostgreSQL no more risky than any other database? Thanks in advance for your input. Andy Yoder Hi all, I really don't want to waste your time too much on this - so please ignore if so - but I have been watching this group for many years. There are more than 26K emails in my inbox! You never hear from me because really I'm more a Java guy (PG hides behind Hibernate here) - and in the end PG just works perfectly forever on any dodgy customer PC we install on. So on this esteemed group I'm no more than a novice, although I would claim much dev and management experience. FWIW, my comments on this thread are as follows ... - The issue is one of mind share - MySQL has it, PG deserves it. - PG desperately needs to have amunition available for this OP - PG already convinces highly astute people who have time, knowledge, and inclination - PG misses too many people in influencial positions who don't have the above This mainly calls for ... (1) to have a visible community (2) to have endorsements (3) to be seen regularly So what to do? ... - Every PG conference (or gathering, expo trade show etc) should be expected to submit photos and a brief story of what went on. Who (half famous or important) was there, what was discussed, issues of the day etc. - Rock stars within or close enough to PG should be asked to write endorsements. CEOs, CIOs, gun devs, consultants. - Key PG people should be rostered to contribute one or two articles per year to mags, sites, etc - All the above should be posted on the website under the banner Community or something. - Anything more than 12-18 months old is trashed. I'm trying to think of things that take 1-4 hours here and there. Yip - I know I'm allocating work around where I have no right to do so, but I think that these soft issues are as important as ACID and replication. Anyway - nuff said - I'll return to my OutOfMemory exception. At least I know the data is safe. Cheers, -Damian
Re: [GENERAL] recommended schema diff tools?
On Fri, Apr 13, 2012 at 12:57 AM, Welty, Richard rwe...@ltionline.comwrote: ** can anyone recommend an open source tool for diffing schemas? (it should go without saying that i'm looking for ddl to update production and QA DBs from development DBs, but i'll say it, just in case.) thanks, richard Richard, A java command line tool that we have used for years is AGPDIFF - http://apgdiff.startnet.biz/ Usage is something like this ... c: java -jar apgdiff.jar --ignore-start-with pg_old.sql pg_new.sql diff.sql It is PostgreSQL specific. Takes two SQL files and produces the diff.sql, that we use as the basis of our production upgrade artifacts. A very useful and basic tool.. HTH -Damian
Re: [GENERAL] pl/java status
On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce pie...@hogranch.com wrote: Joshua D. Drake wrote: Mostly, I think you will find that the back end developers aren't fond of Java and thus, it doesn't get much love. There is a reason that plPerl is king in this community (and I don't even like Perl). Java2perl anyone ? http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6 (99% joking) And if you think positively a 14hour TZ difference is really only 10 if you go the other way. Cheers, -Damian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] The future of Solaris?
On Thu, Dec 11, 2008 at 6:00 AM, Liraz Siri [EMAIL PROTECTED] wrote: Guy Rouillier wrote: Liraz Siri wrote: Solaris is awesome (dtrace rocks!), but I still prefer Debian/Linux for the same reasons I prefer PostgreSQL over MySQL - its lack of dependence on any single company. OpenSolaris? I think it takes more than a license to make a true community opensource project. You need significant buy-in from a large consortium of diverse interests. Sun dominates Solaris/OpenSolaris development and IMHO it is unlikely Solaris would survive as a viable long term option if Sun dropped support for it. Solaris has a single point of failure. Linux may still be behind Solaris in a few areas but I'll wager Linux will catch up and make Solaris completely, utterly obsolete in the not too distant future. Sun opened up Solaris too late. It has no future outside of tiny specialized niches and legacy installations. But thats just my opinion. I could be wrong. Cheers, Liraz I understand and accept that this is just your opinion, but its sheer dripping passion tends to highlight its lack objectivity! and make Solaris completely, utterly obsolete in the not too distant future. For what it's worth .. 1. Solaris and Linux are both fine pieces of technology 2. In the most general sense, I suspect Solaris (in general) will survive longer than your next Ubuntu instance, so you would be safe using Solaris instead of Ubuntu. 3. Sun is struggling, but it is made up of profitable and unprofitable areas. The Solaris and Server areas would seem to be relatively profitable, so even if Sun as a whole failed, the profitable areas would likely march on into the future. 4. As anyone with a little life experience could tell you, things don't just disappear. That is true in computer or other areas of life. Cobal aint going away. Baddies aint going away. Religion aint going away. There are plenty of Solaris fan boys to keep Solaris going. Even if all your friends tell you it is bad and as god as dead. 5. Ubutu is generally an excellent choice for a desktop, and Solaris is generally an excellent choice as a server. Did I tell you I currently use MS-Windows exclusively! Not because of the technology, but just because all my customers do. All the best -Damian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL and Java on WindowsXP
On Mon, Mar 31, 2008 at 8:12 AM, Vismaster46 [EMAIL PROTECTED] wrote: I need to install on my local Windows XP machine PostgreSQL to test The trouble is that I cannot connect to PostgreSQL via Java application, because the connection fails every time...what's the problem? Sorry, but you have not provided any clues! - What connection is failing? Any error messages / stack traces available? - Can you connect to the DB via (say) pgAdminIII ??? - How have you set it all up??? -How is it set up when not on XP??? (I guess it works there?) We use PG / Java / XP every day and it works like a charm. We use Hibernate. I have not installed PL/Java package cause my Postgre installer disabled this option...it is the matter??? No - nothing to do with it. Cheer, -Damian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general