Exactly where do I go to get this?

As versus what we have now? How many trillions in bailouts (leading to nice fat bonuses for the Wall Street oligarchy) will it take to convince you otherwise?

More powerful government == more opportunities for corruption. Yes, NATURALLY.

Seems to me DART is meant to replace the ubiquitous PHP/Javascript combination. Think about it: quick prototypes with untyped code, moving to static typechecking wherever wanted, Server-side and client-side execution, built-in HTML5 DOM library. Its features may be unexciting, but they could provide an easy escape from PHP/Javascript hell without too much learning curve.

If that is Google's primary target with DART, it may prove to be a very strategic move.

This has always worked out well for me at some level or other. If you make it clear that your reason for leaving is not a negative one (IE. hating your boss/job/whatever) and that you are willing to do whatever you can to help them make the transition, usually employers are quite reasonable about such things. One of my former employers (a branch of a very large company) still contacts me occasionally even 4 years after my departure.

Never burn bridges, but never limit yourself due to feeling sorry for your employer.

That has long been one of my thoughts. For example, PG'OCaml looks very promising.

Having migrated a few applications from MySQL to Postgres, the truth is, it will be painful, but the result is you will be a LOT more confident in the quality and manageability of your data. Start here

PostgreSQL has all the datatypes that MySQL has, and more (see especially the ), and usually with far less limitations. Any character type can be up to 1GB in size if needed, for example.

The biggest sources of pain will likely come from character set handling (some MySQL oddities there) and MySQL's ready acceptance of NULL where it really shouldn't occur. Learn to love grep, sed and the 'iconv' utility.

There are conversion utilities that will get you part of the way there with a DB structure dump, but they will hardly do justice to a complex database. You will have to reengineer your system--in fact you will want to, since PostgreSQL has many capabilities that you cannot take advantage of in MySQL.

Triggers and stored functions are a little less 'wieldy' in Postgres, but far more capable once you get the concepts. For one thing, MySQL re-compiles all stored procedures for every instance of a connection (making SPs in PHP web-based apps almost pointless). One caveat: Postgres does not have 'true' stored procedures in the sense that they cannot span multiple transactions. Thus they are called functions, but aside from the transaction limitation, they are far more capable than MySQL stored procedures. For example, result sets from functions can be treated exactly like result sets from tables, and nested inside other queries and views, even in the FROM clause in ways that MySQL still does not allow. Full referential transparency.

Postgres has many more indexing options than MySQL, which you will want to explore for performance tweaking.

Postgres has the RULE system which allows for query rewriting in much the way that Apache's mod_rewrite allows for URL rewriting. It is a powerful tool, allowing you to potentially get rid of tons of stored procedure code. In some ways it works like an alternate triggering mechanism, but it is very lightweight.

BTW, one way you might consider handling your migration is using PostgreSQL's new foreign data wrapper or SQL/MED functionality, which can allow you to query a MySQL table from within a PostgreSQL DB (read-only for now, but excellent for importing tables interactively)

Bingo. Exactly what I have been saying for years, but... we both know that this sort of idea is far too sensible and boring for the 'concept du jour' programming community.

Why is this modded down? +1 informative, please.

Nowhere in your rambling, incoherent response did you come close to anything that could be considered a rational thought. We are all dumber for having listened to it. I award you no points and may God have mercy on your soul.

Very interesting to note. I had been wondering about that part of the story.

Absolutely!. I am at the last 100 pages right now and it surely does not lose steam. Nor punk. (OK, I'll stop now)