Re: MySQL vs PostgreSQL
Aaron Roberson wrote: pgAdmin III comes installed out of the box with PostgreSQL and I cannot figure out how to create tables using it either. At least in phpPgAdmin I can write SQL directly to create tables, but phpMyAdmin has UI features for creating tables. I would prefer using phpPgAdmin since I am so familiar with phpMyAdmin. However, if I went to work for a company that used PostgreSQL with anything other than PHP I could bet that they wouldn't use phpPgAdmin. You should give the command line client (psql) a try. A command line client may sound archaic, but it offers some pretty nifty advantages: - you can run it over a remote shell; - it can do anything a GUI can, and some things a GUI can not; - you keep up to date with your SQL; - it is incredibly feature rich (inline help, tab auto-complete, statement history etc.). Especially the tab auto-complete is a great feature. You just type the first few characters, press tab and the client completes it for you. Very similar to how tab auto-complete works in the Windows or Unix command line, it saves you a ton of typing and you don't have to switch between keyboard and mouse all the time as you have to do in a GUI. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
Jochem van Dieten wrote: You should give the command line client (psql) a try. A command line client may sound archaic, but it offers some pretty nifty advantages: and of course it will put hair on your chest. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
You should give the command line client (psql) a try. A command line client may sound archaic, but it offers some pretty nifty advantages: I started learning MySQL with using the command line but then when I went to phpMyAdmin I found it much more efficient (I am not a db adminstrator, so I am not creating, altering and updating databases and tables everyday). That is why I decided to go straight to phpPgAdmin for working with PostgreSQL. I am sure that if you memorized all of the commands for PostgresSQL or MySQL the command line would be fast and more advantageous. However, I am more concerned with memorizing CFML, PHP, ASP, SQL, JavaScript and CSS at the moment. While it may put more hair on my chest as Paul has said, since I am only working with PostgreSQL just to expose myself to it, I am not ready to take on the command line. However, it would make me a better db administrator, but I am not sure if that is required to get a high paying job building ColdFusion apps. Thanks, Aaron ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
Jordan, Thank you for that explanation. I just didn't think to click on schema because I don't really know what a schema is. I guess I need to learn about schema's and all the rest of the complex features available in PostgreSQL and not in MySQL or Access. -Aaron ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
On Wednesday 06 December 2006 16:57, Munson, Jacob wrote: Right, but you can do that anyway, right? There are always contracting companies around that will gladly take your money to fix things for you. True, but most of them will still only support versions X, Y and Z running in the manner A, B or C. Or charge Silly Money(tm). -- Tom Chiverton Helping to autoschediastically foster turn-key appliances This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263510 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
I usually use phpMyAdmin for MySQL administration. This week I installed PostgreSQL and phpPgAdmin. Does anyone know any good resources for learning how to use phpPgAdmin? At present, it seems that the only way to create tables is to write SQL. -Aaron ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
I usually use phpMyAdmin for MySQL administration. This week I installed PostgreSQL and phpPgAdmin. Does anyone know any good resources for learning how to use phpPgAdmin? At present, it seems that the only way to create tables is to write SQL. It has been a while since last time I used PostgreSQL. But this could be worth a try: http://www.pgadmin.org/ Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL vs PostgreSQL
The Light (free) version of EMS SQL manager for Postgre (or mysql) is really pretty good. I have had no issues, and use it quite a bit. http://www.sqlmanager.net/products/postgresql/manager Joshua Cyr Savvy Software 866.870.6358 www.besavvy.com -Original Message- From: Aaron Roberson [mailto:[EMAIL PROTECTED] Sent: Monday, December 11, 2006 1:58 PM To: CF-Talk Subject: Re: MySQL vs PostgreSQL I usually use phpMyAdmin for MySQL administration. This week I installed PostgreSQL and phpPgAdmin. Does anyone know any good resources for learning how to use phpPgAdmin? At present, it seems that the only way to create tables is to write SQL. -Aaron ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
It has been a while since last time I used PostgreSQL. But this could be worth a try: http://www.pgadmin.org/ pgAdmin III comes installed out of the box with PostgreSQL and I cannot figure out how to create tables using it either. At least in phpPgAdmin I can write SQL directly to create tables, but phpMyAdmin has UI features for creating tables. I would prefer using phpPgAdmin since I am so familiar with phpMyAdmin. However, if I went to work for a company that used PostgreSQL with anything other than PHP I could bet that they wouldn't use phpPgAdmin. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
Hi Aaron, We use phpPgAdmin extensively. First, just to cover the bases, you will need to create your database first. Each PostgreSQL installation allows you to create any number of individual databases. After you've got your database created, you can create a table within that database by clicking the + sign next to it. This will open up the schema tree. After the schema tree is open, you should see a public schema. If you are not familiar with schema's, just think of them as databases within a database. That's not technically what they are, but it will give you the basic idea. Click on the + sign next to the default public schema. This should several more options available to you. On my screen, I see tables, views, sequences, functions, and domains. If you've ever used MS SQL Server Enterprise Manager, this should look somewhat familiar to you as the layout is similar. Click on Tables, and the main screen will change to display your current tables. At the bottom of the main screen, if the user your are logged in with has permission, you will see the Create Table link. Hope this helps! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] Aaron Roberson wrote: It has been a while since last time I used PostgreSQL. But this could be worth a try: http://www.pgadmin.org/ pgAdmin III comes installed out of the box with PostgreSQL and I cannot figure out how to create tables using it either. At least in phpPgAdmin I can write SQL directly to create tables, but phpMyAdmin has UI features for creating tables. I would prefer using phpPgAdmin since I am so familiar with phpMyAdmin. However, if I went to work for a company that used PostgreSQL with anything other than PHP I could bet that they wouldn't use phpPgAdmin. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
Munson, Jacob wrote: 'Supported' means when if it falls over in a big steaming mess at 9am on a Monday, I can phone someone else and have them come fix it because they promised it would work. I have never seen a support contract where they promised it would work, only support contracts where they promised they would respond within X hours to try to make it work. Right, but you can do that anyway, right? There are always contracting companies around that will gladly take your money to fix things for you. Sure there are. For instance, we sell that sort of support. But there is a catch: if you don't already have a contract, you don't know the 24/7 phone number. So for new customers it is effectively 'next business day' support and not 'X hour' support. Also, high end support requires access to the source code. Hence this type of support is much more prevalent in the Open Source arena then in the closed source arena. (And that is not just for 'help it crashes' support, when I was working with tweakers.net to tune PostgreSQL for this benchmark I repeatedly checked the source code to make sure we did the right thing.) Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
Right, but you can do that anyway, right? There are always contracting companies around that will gladly take your money to fix things for you. Sure there are. For instance, we sell that sort of support. But there is a catch: if you don't already have a contract, you don't know the 24/7 phone number. So for new customers it is effectively 'next business day' support and not 'X hour' support. When I was trying to convince an boss at an earlier job that we should use Delphi for a programming project instead of VS, he played the 'support' card. To counter that, I did some searching, made some phone calls, and had a list of local companies that could offer Delphi support if needed. If one is too busy to take my money, I'd go to the next, and so on until I had someone on hand. The same thing happened when we had a router go down at that job. I called two companies and left messages. The first one that got back to me got the money. See, I think people are too scared and/or lazy to do it this way, thus they prefer the 'comfort' level an expensive support contract offers. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
When I was trying to convince an boss at an earlier job that we should use Delphi for a programming project instead of VS, he played the 'support' card. To counter that, I did some searching, made some phone calls, and had a list of local companies that could offer Delphi support if needed. If one is too busy to take my money, I'd go to the next, and so on until I had someone on hand... See, I think people are too scared and/or lazy to do it this way, thus they prefer the 'comfort' level an expensive support contract offers. I think that is pretty good advice and I will remember this example in case I get into the same situation or find myself wondering if I should pay extra for an expensive support contract. Thanks, Aaron ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL vs PostgreSQL
So it appears that mySQL is much faster? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:25 PM To: CF-Talk Subject: MySQL vs PostgreSQL I've long recommended PostgreSQL as a very viable and capable enterprise alternative to MS SQL or MySQL. While there's nothing inherently wrong with either of those databases, PostgreSQL has a much more liberal license. You could pack it up, rebrand it, and sell it right along with your own CFML apps. You can't say that for MS SQL or MySQL. With that in mind, I found this independent test of MySQL 5 vs PostgreSQL 8 to be extremely interesting. I know that all benchmarks are relative, and you'll probably experience different results with your own databases, but the results here are so dramatic it's pretty difficult to argue with. Check it out: http://tweakers.net/reviews/657/6 Hopefully some of you find this as interesting as I did. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
On 12/5/06 10:24 PM, Jordan Michaels wrote: http://tweakers.net/reviews/657/6 Am I the only one who reads this to mean that MySQL is faster with lower demand but that PostgreSQL ramps up better with higher usage? I'm glad to see them testing PGSQL 8.2, which was just released yesterday, but I'm surprised they didn't also compare a development release of MySQL? -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
From those graphs, only for low numbers of users. As soon as the number of users becomes significant PostgreSQL blows MySQL away. It's what I'd expect - PostgreSQL is tuned for higher concurrency as it's an Enterprise platform; MySQL isn't (yes, let the flaming begin). On 12/6/06, Andy Matthews [EMAIL PROTECTED] wrote: So it appears that mySQL is much faster? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 9:25 PM To: CF-Talk Subject: MySQL vs PostgreSQL I've long recommended PostgreSQL as a very viable and capable enterprise alternative to MS SQL or MySQL. While there's nothing inherently wrong with either of those databases, PostgreSQL has a much more liberal license. You could pack it up, rebrand it, and sell it right along with your own CFML apps. You can't say that for MS SQL or MySQL. With that in mind, I found this independent test of MySQL 5 vs PostgreSQL 8 to be extremely interesting. I know that all benchmarks are relative, and you'll probably experience different results with your own databases, but the results here are so dramatic it's pretty difficult to argue with. Check it out: http://tweakers.net/reviews/657/6 Hopefully some of you find this as interesting as I did. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL vs PostgreSQL
Gotcha. Thank you for clarifying James. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 06, 2006 8:41 AM To: CF-Talk Subject: Re: MySQL vs PostgreSQL From those graphs, only for low numbers of users. As soon as the number of users becomes significant PostgreSQL blows MySQL away. It's what I'd expect - PostgreSQL is tuned for higher concurrency as it's an Enterprise platform; MySQL isn't (yes, let the flaming begin). On 12/6/06, Andy Matthews [EMAIL PROTECTED] wrote: So it appears that mySQL is much faster? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
Damien McKenna wrote: On 12/5/06 10:24 PM, Jordan Michaels wrote: http://tweakers.net/reviews/657/6 Am I the only one who reads this to mean that MySQL is faster with lower demand but that PostgreSQL ramps up better with higher usage? That is how I read it too. It serves as a great example to show how the setup of a benchmark can influence the results. I'm glad to see them testing PGSQL 8.2, which was just released yesterday, but I'm surprised they didn't also compare a development release of MySQL? Testing took several months (especially of the Sun Niagara), so it is actually a snapshot of PostgreSQL 8.2dev from this summer, i.e. not the version that was released yesterday. A development release of MySQL 5.1.x of about the same time was also tested, but it was unstable and the results were not published. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL vs PostgreSQL
I've long recommended PostgreSQL as a very viable and capable enterprise alternative to MS SQL or MySQL. While there's nothing inherently wrong with either of those databases, PostgreSQL has a much more liberal license. You could pack it up, rebrand it, and sell it right along with your own CFML apps. You can't say that for MS SQL or MySQL. Jordan, How much pain do you have to go through to get PostgreSQL to run on CFMX/BD? Is it easier, the same, or more difficult than MySQL? I don't care if it's 'supported' or not. I think requiring software to be supported is an idea for wimpy CIO/MBA types that don't trust their staff, but that's another topic altogether. :) EMF idahopower.com made the following annotations. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
On Wednesday 06 December 2006 16:03, Munson, Jacob wrote: How much pain do you have to go through to get PostgreSQL to run on CFMX/BD? Is it easier, the same, or more difficult than MySQL? It's *exactly* the same unless you are pushing the edges, or redistributing. supported is an idea for wimpy CIO/MBA types that don't trust their staff, but that's another topic altogether. :) Nah. 'Supported' means when if it falls over in a big steaming mess at 9am on a Monday, I can phone someone else and have them come fix it because they promised it would work. -- Tom Chiverton Helping to globally compete wireless market-growth This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
Munson, Jacob wrote: How much pain do you have to go through to get PostgreSQL to run on CFMX/BD? Is it easier, the same, or more difficult than MySQL? CFMX: same. BD: easier, PostgreSQL is supported out of the box, for MySQL you need to install the driver yourself. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL vs PostgreSQL
supported is an idea for wimpy CIO/MBA types that don't trust their staff, but that's another topic altogether. :) Nah. 'Supported' means when if it falls over in a big steaming mess at 9am on a Monday, I can phone someone else and have them come fix it because they promised it would work. Right, but you can do that anyway, right? There are always contracting companies around that will gladly take your money to fix things for you. My biggest beef is those stupid maintenance contracts CIOs love to dump money in. A huge waste of money, IMO. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL vs PostgreSQL
Munson, Jacob wrote: I've long recommended PostgreSQL as a very viable and capable enterprise alternative to MS SQL or MySQL. While there's nothing inherently wrong with either of those databases, PostgreSQL has a much more liberal license. You could pack it up, rebrand it, and sell it right along with your own CFML apps. You can't say that for MS SQL or MySQL. Jordan, How much pain do you have to go through to get PostgreSQL to run on CFMX/BD? Is it easier, the same, or more difficult than MySQL? I don't care if it's 'supported' or not. I think requiring software to be supported is an idea for wimpy CIO/MBA types that don't trust their staff, but that's another topic altogether. :) CFMX 6 and 7 do not come with PostgreSQL drivers out of the box. You have to take particular steps in order to create your PostgreSQL DNS's: http://www.viviotech.net/docs/postgresql8_cfmx7.pdf or http://www.viviotech.net/docs/postgresql8_cfmx7.odt Adobe might be changing this in CFMX 8 though - which I think would be great. ;) BD, as Jochem already mentioned, already comes with PostgreSQL support out of the box. Just select PostgreSQL from the drop-down list of database types and you're good to go. CFMX 6 and 7 come with MySQL 3 drivers - which will work for later versions of MySQL. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4