In this fourth post (parts one, two and three are found here) on the State of the Computer Book Market, we will look at programming languages and drill in a little on each language area.
Overall the market for programming languages was down 5.9% in 2008 when compared with 2007. There were 1,849,974 units sold in 2007 versus 1,740,808 units sold in 2008, which is a decrease of 109,166 units. So the unhealthy 8% loss in the Overall Computer Book Market was not completely fueled by …
[Read more]
The Community Team has decided on a unique way of getting to the
Users Conference this year. We're going to precede the Users
Conference with a special University Tour.
I will be leaving for the Users Conference from Montreal on March
25th and travelling to San Francisco by environmentally friendly
ground transport: Amtrak, VIA Rail, Greyhound and the like. Along
the way I will be hitting as many college campuses, user meetups,
user events, customers as I possibly can. The focus is students
but certainly there is time to hit other things as well. Giuseppe
has dubbed it "Dups on Rails" (he sent me the image below by the
way).
In California, between April 13-17, two teams of two will then
travel to campuses. Giuseppe Maxia and Sheeri K. Cabral …
Last time I demonstrated a case where stored procedures are slow when they have to do computationally expensive work. The more interesting, to me at least, question is how slow is SQL? The answer to that is far more complex.
For example, this simple SQL takes 2.2 seconds to run on MySQL. This is a painfully faster than the 696 seconds it took a stored procedure to produce similar results.
select customerName, count(*)
from Salet s
join customer c on s.customerId = c.customerId
group by customerName
As demonstrated in the previous article, the equivalent C# code took 1.4 seconds to produce the same results. Some may find it surprising that it take less time to ship 1 million rows out of the database and then summarize it in code than it does for MySQL to summarize the same data in the database.
In this simple case the performance difference …
[Read more]
Elance Cites Surging Demand for MySQL Experts
is an interesting article for several reasons. For many years
advocating Open Source products was seen in many circles of
management as akin to promotion of some sort of social anarchy.
But now they see the cost savings, the performance gains, and the
flexibility that a product like MySQL can provide.
Check out the jobs Elance has for MySQL talent.
DFW MySQL Users!
Monday night at seven will be the next meeting of North Texas
MySQL Meetup. This meeting will not be MySQL-centric but will
discuss creating Facebooks apps and using the …
In 1809, a hero in America's Revolutionary War, General John Stark, was forced to decline an invitation to a military reunion due to ill health. He sent a toast to be read in his absence that began, "Live Free or Die." That phrase is now the official motto of the American state of New Hampshire (where Stark lived), known for a fierce sense of independence (and no income taxes).
Hold that thought for a moment.
Today, we're announcing the single biggest and most important OEM/distribution agreement Sun's ever signed for the open source Solaris operating system - through which we'll be joining forces with the world's largest supplier of high volume servers, Hewlett Packard. As a result of the deal, Solaris gains tier 1 status, …
[Read more]It has been over a year since the last OurSQL podcast. First, I want to thank everyone who has written in to tell me how much they loved the OurSQL podcast, and how they want it back. Plans are in the works for that, mostly I got busy writing a book on MySQL geared towards folks who are new to MySQL, but not necessarily new to databases. The book is coming out in May and can be pre-ordered at http://tinyurl.com/mysqlbook.
But enough about the past…..In this first Drizzle podcast, Jay Pipes and I talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint.
The podcast can be downloaded (5.76 Mb as an mp3 file) or played right through your browser at http://technocation.org/content/drizzle-podcast-%25231. The show notes are also on …
[Read more]In this first Drizzle Podcast, Sheeri K. Cabral and Jay Pipes talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint.
As Gary already pointed out, the replication behavior when mixing non-transactional and transactional tables have changed between 5.1.30 and 5.1.31. Why did it change? Well, for starters, it actually never worked and the existing behavior was fooling people that it actually worked.
There are several bugs reported on mixing transactional and non-transactional tables in statements and in transactions. For the two latest examples, see BUG#28976 and BUG#40116.
To explain the situation, I will first start with some background...
The binary log
For this discussion, we call a statement that manipulates transactional tables only a transactional statement and call …
[Read more]See also: MySQL Bug 43151
The MySQL Manual proudly states that you don’t get implicit default values if strict mode.
mysql> set sql_mode='STRICT_ALL_TABLES';
Query OK, 0 rows affected (0.00 sec)
mysql> create table t1 (a int, b int, c int, d int, e int, f int, g int, h int,i int,
primary key (a,b,c,d,e,f,g,i,h)) engine=MyISAM;
Query OK, 0 rows affected (0.03 sec)
mysql> show create table t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`a` int(11) NOT NULL default '0',
`b` int(11) NOT NULL default '0',
`c` int(11) NOT NULL default '0',
`d` int(11) NOT NULL default '0',
`e` int(11) NOT NULL default '0',
`f` int(11) NOT NULL default '0',
`g` int(11) NOT NULL default '0',
`h` int(11) NOT NULL …[Read more]