PgEast CFP closes in (3) Days
Hey, MySQLers if you are looking to present at PgEast, now would be a great time to get your talk in. Yes it is a PostgreSQL conference, but we like to learn from each other, do we not? I would be all over seeing talk titled: What I wish PostgreSQL could do, from a MySQL users perspective! https://www.postgresqlconference.org/talk_types JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
PgEast CFP (second call) (anybody up for comparative papers?)
January 13, 2010 PostgreSQL Conference East, The PostgreSQL Conference for Decision Makers, End Users and Developers, is being held at the Radisson Plaza, Warwick Hotel in Philadelphia on March 25th through 28th. This is the second call for papers for this conference. You can review the skeletal agenda here: http://www.postgresqlconference.org/2010/east/agenda You can review content from the recent West conference here: http://www.postgresqlconference.org/2009/west/ You can submit your talk here: http://www.postgresqlconference.org/talksubmission Time line: December 14th: Talk submission opens January 30th: Talk submission closes February 15th: Speaker notification This year we will be continuing our trend of covering the entire PostgreSQL ecosystem. We would like to see talks and tutorials on the following topics: * General PostgreSQL: * Administration * Performance * High Availability * Migration * GIS * Integration * Solutions and White Papers * The Stack: * Python/Django/Pylons/TurboGears/Custom * Perl5/Catalyst/Bricolage * Ruby/Rails * Java (PLJava would be great)/Groovy/Grails * Operating System optimization (Linux/FBSD/Solaris/Windows) * Solutions and White Papers Submit Session: http://www.postgresqlconference.org/talksubmission Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Fri, 2009-04-24 at 10:42 -0700, David Sparks wrote: -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Your FUD would be better posted on a Postres list with all the onging discussions on how Mysql doesn't support foreign keys, transactions, etc. There is no FUD here. The question was asked, I supplied my thoughts. Further I never suggested any of the things you are stating. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Fri, 2009-04-24 at 18:15 +, Glyn Astill wrote: Begone Postgres troll! Oh the hostility of a scorned mysql user. Joshua has posted no more FUD than you mysql chaps have done yourselvs over the past few days. You were worried about the future and he's posted a few ideas of how you can prepare. That said I do agree he's jumped in at the right time to do a bit of Postgres pushin' and pimpin' :-) You have to take your opportunities when you can :) Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Fri, 2009-04-24 at 12:15 -0700, David Sparks wrote: Glyn Astill wrote: Begone Postgres troll! Oh the hostility of a scorned mysql user. Joshua has posted no more FUD than you mysql chaps have done yourselvs over the past few days. You were worried about the future and he's posted a few ideas of how you can prepare. No he didn't. He posted doom and gloom: Boy you really just can't handle someone not agreeing with you can you? It will be a supported but second class citizen from Oracle. Yes, and I stand by that. Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. All you have to do is look at the SEC filings and the pricing sheet. maintain it long enough to allow MySQL to kill itself. Which I do still believe will happen. I would expect that MySQL in two years likely won't exist except on the most tertiary level. How we take one piece of the whole puzzle to make our point in the fruitless effort to discredit those who are clearly more well thought out than you. My whole point was: I would expect that MySQL in two years likely won't exist except on the most tertiary level. Most new projects will be developed in either PostgreSQL, Interbase or one of the forks (MariaDB, Drizzle). Considering my discussion with Monty this weekend, I would exert that the above is even more true. MariaDB is set to be a meritocracy based, true community (something the current MySQL is not). I expect that it will return to a quality form of development of release when ready not when the marketing droids force you to. I have a strong faith (even if I am not technically interested) in the direction Monty is going with MariaDB. I expect to see great things. One more time: begone Postgres troll! Based on your definition of troll, I would say that I am more a MariaDB troll. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Fri, 2009-04-24 at 08:44 +0200, Martijn Tonies wrote: Well, MySQL is open source, right? And the source is available? I'm sure a team of devs will come to the rescue. Really? What would make a group of developers wanting to develop a -database engine- for free? Some party needs to step up and pay those people, else you're beloved product will go no-where. SQL Lite and PostgreSQL were both originally developed for free. Yes much of PostgreSQL is sponsored by people who now get paid to work on the product but that isn't 100% the case and it took a long way to get there. That being said, this is a good point. A team of developers are likely not to pick up MySQL unless they get paid. There are too many as good or better options that are also open source. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
On Fri, 2009-04-24 at 10:56 -0400, Martin Gainty wrote: IF MySQL returns to opensource..(presumably under Monty's benevolent leadership) then packages that utilise MySQL could be for paying clients only from your perspective what is the future of MySQL? Interesting question. I think MySQL will live on in various incarnations but I do think its glory days are over. It will be a supported but second class citizen from Oracle. I was at Innotech yesterday speaking on the open source panel (http://vimeo.com/4307197) and one of the participants stated that they were nervous about the fact that MySQL had been bought twice in the last two years. I did mention that I didn't think MySQL was going away and that Oracle is a smart company and there is a lot of mind share with MySQL. However, Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. It is estimated that MySQL AB was only doing 50M a year when they were bought by Sun. 50M a year is petty cash for Oracle. So Oracle has two choices, completely change MySQL to make it more profitable and thus alienate its main user base (small websites) or maintain it long enough to allow MySQL to kill itself. MySQL is already killing itself through the various forks that have permeated through the last 9 months. Another issue I see is the potential for mass migration from MySQL by non web applications. Yes there are a lot of them. Why? Because one way Oracle can make money from MySQL is to continue to charge for linked software against MySQL. If you are building a web app as long as your web language is open source, you are good with the GPL. However if you are building a monolithic app in say C++ you have a serious problem because the nature of the GPL guarantees that your C++ app will have to be open source. As much as a lot of us are pro Open Source the majority (by far) of the world still isn't. MySQL does have a strong following in the appliance state in this way. I would expect that MySQL in two years likely won't exist except on the most tertiary level. Most new projects will be developed in either PostgreSQL, Interbase or one of the forks (MariaDB, Drizzle). Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Thu, 2009-04-23 at 08:25 +, Glyn Astill wrote: --- On Wed, 22/4/09, Joshua D. Drake j...@commandprompt.com wrote: what are we gonna run as RDBMS ? How about PostgreSQL? I second that. You should all have a play with the 8.4 beta I actually think a lot of primarily MySQL people are missing a lot of great stuff in PostgreSQL. Of course I am biased but when I look at the complaints about PostgreSQL they are largely based on years old information that is out of date. Alternately it is people who really don't know anything about databases but understand how to use MySQL. That is obviously a compelling argument. If I know how to use something and it does what I need, why change? The only counter argument I can provide to you is that there is a good chance you don't know what you are missing. Give it a shot. There are plenty of Pg people that would be happy to help MySQL people make their migration. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote: Hey Gilles, After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? How about PostgreSQL? Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2nd call for papers: PostgreSQL Conference East
PostgreSQL Conference East is being held at historic Drexel University on April 3rd through 5th 2009 . This is the second call for papers. The call for papers ends Feb 23rd and speakers will be notified on the 27th. You may submit your talk here: http://www.postgresqlconference.org . We are looking for a wide range of topics. Can you speak on any of the below topics? What about a different topic? As long as it is centered around Postgre SQL we want to hear about it. Hacker topics: MVCC C Function development Writing Procedural Languages Creating types The planner Optimization tips Explaining the process model DBA topics: Backing up PostgreSQL Understanding and Configuring Autovacuum Normalization Trigger Happy (how to use triggers ;) PITR -- happiness is a shipped transaction log User / Groups / Roles Security End User development: Web Frameworks with PostgreSQL Pylons Grails Rails Cake Turbo Gears Django Solutions: Do you have a successful case study to present? How did you solve a problem with PostgreSQL? Do you have an Open Source product that runs on PostgreSQL? As always we let the presenters drive the feel of the conference. If you have an itch, let's figure out how to scratch it (as long as it is with PostgreSQL). Submit your paper today: http://www.postgresqlconference.org/ -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Looking for MySQL Speakers
Hello, I run PostgreSQL Conference (long announcement below). We are looking for some people to speak on why MySQL at East 09 in Philly. Anybody interested should submit a talk (or better yet Tutorial). Yes this would be a little different for a MySQL person but I believe in reaching out. Specifically I would love to see one or two people be willing to convince PostgreSQL people to switch. Begin long infomercial: PostgreSQL Conference, U.S., East 09 will be held in Philadelphia at historic Drexel University from April 3rd through 5th. The call for papers is now out at: http://www.postgresqlconference.org/2009/east/ . As always we let our submissions define our actual tracks. If you have something you want to talk about it. Submit it. As long as it is about PostgreSQL (or doing something with PostgreSQL) we will consider it. We are seeking creative ideas about things we can do at the conference. At West we had a code sprint. The sprint was very successful as it was about all things postgresql and open source. It wasn't just hacking back end code but people worked on all kinds of things.. Is someone up for running a code sprint? There has also been specific interest in having us add (in addition to our advanced topics) a newbie track. Please do not be afraid to submit a talks on items such as: * Backing up PostgreSQL * Understanding and Configuring Autovacuum * Normalization * Trigger Happy (how to use triggers ;) * PITR -- happiness is a shipped transaction log Other topics we are interested in beyond the standard PostgreSQL architectural fanfare are: * Groovy/Grails * Django * PHP * Postgis * Pylons * SQL Alchemy So don't delay, PostgreSQL Conference, U.S. is the premeire PostgreSQL conference series for the United States PostgreSQL community! Please submit your talk here: http://www.postgresqlconference.org/2009/east/ . Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Looking for someone to give a talk at http://www.pgcon.us/ on MySQL
Hello, I am looking for someone to give a talk on MySQL at the upcoming PostgreSQL Conference in October. Something like Why I chose MySQL over PostgreSQL: A Technical analysis (or similar). Any takers? http://www.pgcon.us/west08/talk_submission/ Sincerely, Joshua D. Drake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?
JW wrote: Hello, We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast server. Specs are: OS: Linux Debian 4.0/Etch RAID 5 on 4x U320 15k rpm drives (uses a perc-raid 3/DC hardware raid controller) 16GB of RAM 4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo it shows up as 8 processors - maybe it's only HT snip This machine is not what is seems to be unfortunately. 1. Dell until their latest series with the Woodcrest based CPUs was a notoriously bad performer period. 2. Raid 5 + Database == run faster over serial cable. Use RAID 1+0. 3. Dell hasn't made a re-branded a decent RAID controller that is anything more than 18 months old. 4. 16GB doesn't help you because you are limited by your 32bitness. Get a real machine with real processors. 5. The CPU is hyper threaded, not dual core. I doubt you would ever get decent performance out of this for any database let alone MySQL. Tell your boss to suck it up, spend 5k. You can get a new, decent Dell for that. Or better yet, a HP. Sincerely, Joshua D. Drake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What MySQL can learn from PostgreSQL
Hello, The talk I gave at MySQCon on this topic is here: http://www.commandprompt.com/blogs/joshua_drake/2008/04/what_mysql_and_really_sun_can_learn_from_postgresql/ It was an interesting experience. Thanks for the help you guys gave me via this list and direct email to accomplish the task. Sincerely, Joshua D. Drake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question about mysql procedures
Hello, Can MySQL functions/stored procedures access database data? Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question about mysql procedures
On Fri, 11 Apr 2008 14:52:30 -0700 Rob Wultsch [EMAIL PROTECTED] wrote: On Fri, Apr 11, 2008 at 2:15 PM, Joshua D. Drake [EMAIL PROTECTED] wrote: Hello, Can MySQL functions/stored procedures access database data? Joshua D. Drake Yes. Is there something in particular you are looking to do? Just gathering information :) Thanks! Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Only 3 weeks left for PostgreSQL conference
Hello, I know this is a *little* off topic but it is about Open Source databases :) There are only three weeks left to register for the PostgreSQL Community Conference: East! The conference is scheduled on March 29th and 30th (a Saturday and Sunday) at the University of Maryland. Come join us as Bruce Momjian and Joshua Drake have a round table open to any PostgreSQL question from the community. If a round table isn't your cup of tea, visit our talks page where you can pick to learn from over 20 experts in the field. http://www.postgresqlconference.org/talks/ To register just point that old fashion web browser over to: http://www.postgresqlconference.org/ All registrations and sponsorships are donations to PostgreSQL via Software in the Public Interest, Inc., a 501(c)3 non-profit corporation. Thanks again to our Community Conference Sponsors: Organizational Sponsor Command Prompt, Inc. http://www.commandprompt.com/ Silver Sponsor EnterpriseDB http://www.enterprisedb.com Talk Sponsors Afilias http://www.afilias.org/ Continuent http://www.continuent.com/ Sun http://www.sun.com/ Truviso http://www.truviso.com/ Xtuple http://www.xtuple.com/ Meal Sponsors OTG http://www.otg-nc.com/ General Sponsor Emma http://www.myemma.com/ Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit signature.asc Description: PGP signature
What does MySQL have that PostgreSQL doesn't?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I am an unabashed PostgreSQL user. However i am giving a talk on MySQL/PostgreSQL shortly. I would like to know from a MySQL user perspective what MySQL has over PostgreSQL, why is it good? Why would use use MySQL versus PostgreSQL? Any particular PostgreSQL Gotcha's or issues that force you to use MySQL? Sincerely, 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) iD8DBQFHjPQQATb/zqfZUUQRAjKWAKCaqdPiiuYsUnYt2CkS9PVLX5YiywCdH081 61Cqr7z3iwIg7t1tmM7FpSk= =UlT3 -END PGP SIGNATURE-