On Fri, Feb 27, 2009 at 7:32 PM, Ashley Sheridan <a...@ashleysheridan.co.uk> wrote: > On Fri, 2009-02-27 at 16:41 -0600, Boyd, Todd M. wrote: >> > -----Original Message----- >> > From: Andrew Ballard [mailto:aball...@gmail.com] >> > Sent: Friday, February 27, 2009 3:26 PM >> > To: Bastien Koert >> > Cc: Shawn McKenzie; php-general@lists.php.net >> > Subject: Re: [PHP] Re: How important is your Express or Web Edition >> > database? Please weigh in-- >> > >> > On Fri, Feb 27, 2009 at 4:21 PM, Bastien Koert <phps...@gmail.com> >> > wrote: >> > > On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie >> > <nos...@mckenzies.net>wrote: >> > > >> > >> Stan Stadelman wrote: >> > >> > Hello All: >> > >> > >> > >> > I'm trying to see how Web Edition databases are being used in your >> > >> company >> > >> > for PHP-driven web-apps. Our strategy team thought that free and >> > >> community >> > >> > editions would be dominant, but we interviewed Zend Framework >> > developers >> > >> > using Oracle, IBM, Microsoft, MySQL, PostgreSQL, and it looks >> > >> > like--surprise--that each vendors' market share is about the same >> > as in >> > >> the >> > >> > broad commercial market. >> > >> > >> > >> > We think this means that you--the PHP developer community--aren't >> > >> actually >> > >> > using the lightweight Web/Express Edition for your corporate web- >> > app >> > >> > deployment, and instead are building out on the licenses for >> > databases >> > >> your >> > >> > company is already running. >> > >> > >> > >> > Is the Express/Community/Web Edition important for you at work? Is >> > it a >> > >> > critical sandboxing step for you? Do you run it live for internal >> > >> > applications? >> > >> > >> > >> > Answering these 10 multiple choice questions--should take about 90 >> > >> > seconds--will help us understand what databases you need in your >> > >> > professional life, and how to deliver them to you. >> > >> > >> > >> > Happy cooking, and thanks! >> > >> > >> > >> > >> > http://www.surveymonkey.com/s.aspx?sm=Jro0rkoIGJKuQNpfWZV_2bBQ_3d_3d >> > >> > >> > >> >> > >> What exactly are, Express or Web Edition databases? >> > >> >> > >> -- >> > >> Thanks! >> > >> -Shawn >> > >> http://www.spidean.com >> > >> >> > >> >> > > Just another marketing tool to sell a limited toolset db to punters >> > who like >> > > marketing hype >> > > >> > > >> > > -- >> > > >> > > Bastien >> > >> > I thought they were free. Limited, but free. (reduced functionality or >> > limited number of connections compared to the commercial versions of >> > the products) I've not heard of "Web Edition", but I have heard of >> > both SQL Server and Oracle Express. I haven't used them, but I guess >> > the idea I have in mind is of products that are supposed to be just >> > good enough to use in either embedded apps or else to entice >> > developers into wanting the full version for server apps. >> >> I use SQLExpress (SQL Server Express) all the time at work for prototyping >> and such... although, I have to say--if my company hadn't installed it on my >> machine to begin with, and they weren't running SQL Server 2005 on the >> production servers, I would rather just use a private MySQL installation for >> prototyping and then push to a MySQL production server. Alas... >> >> >> // Todd > For me it's MySQL all the way. My company is too cheap to pay for later > versions of MS SQL Server, so the versions we have there are *very* > limited in features (for example, no limit function!) MySQL also seems a > lot faster for me too. I regularly deal with large databases (think > millions of records) and MSSQL is a real bottleneck here, whereas MySQL > seems fine (althogh, it is running on Linux, which frees up more > resources for actually getting stuff done!) > > Oh, funny thing. I filled in the questionnaire above, and when it got to > the final 'thanks' page, I clicked the button, and it bombed out to a > completely blank page. Doesn't bode too well for a company attempting to > sell a product for use in enterprise situations! > > > Ash > www.ashleysheridan.co.uk >
It all depends on what you need. I know from your previous posts that you're not very well disposed to SQL Server, but I've used it quite a bit now for the last 8 years and haven't really had any problems with performance. I'll grant that it doesn't have the LIMIT clause (Is it part of the actual ANSI SQL spec, or is it something handy that MySQL added to their product?) The newer versions offer a row number function that can be used to provide the the same functionality, but I'll admit it is not nearly as simple as being able to say LIMIT 25, 50. While I like MySQL, it has its oddities as well. I've run into situations where I had to add ORDER BY clauses to UPDATE statements (I'm not sure that's really valid SQL either) because it updated the rows sequentially and validated a unique index after each row rather than after all the rows were processed. I wish it would support CHECK constraints. And as convenient as I've found the SET and ENUM datatypes in simple databases, I'm coming to the notion that they are not a good idea in most situations. And while the availability of different engines has benefits, it can also cause issues. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
