Webware for Python

> From: Tavis Rudd [mailto:tavis@...]
> I would strongly recommend PostgreSQL over MySQL.
> Here's an excellent comparison of the two:
> http://phpbuilder.com/columns/tim20001112.php3

Good news!

PostgreSQL 7.1, released a month ago, adds support for views and SQL92
join syntax!  Now I can port my MS SQL Server database over and most
of my SQL should work without modification :)

RE: [Webware-discuss] The Ideal Webware Platform From: Chuck Esterbrook <echuck@mi...> - 2001-05-17 15:55 At 10:56 AM 5/17/2001 -0400, Jeff Johnson wrote: >PostgreSQL 7.1, released a month ago, adds support for views and SQL92 >join syntax! Now I can port my MS SQL Server database over and most >of my SQL should work without modification :) Does it support "drop database if exists Foo;" and other uses of "if exists" or "if not exists". Does it support "use" as in "use Foo;"? Reason I ask is that when attempting to port from MySQL to PostgreSQL, I ran into these missing features and while they can certainly be worked around, porting (and SQL in general) is more convenient with them. -Chuck

RE: [Webware-discuss] The Ideal Webware Platform From: Jeff Johnson <jeff@je...> - 2001-05-17 17:25 > Does it support "drop database if exists Foo;" and other uses of "if > exists" or "if not exists". I can't find any support for "exists" which might be an issue for me. Some of our select queries use "exists" and ran much faster than with other ways of doing the same thing. > > Does it support "use" as in "use Foo;"? > I don't see it anywhere.. I've never had to use it but maybe I'll wish I had it later.

1 message has been excluded from this view by a project administrator.