So once a week I pull roughly 250,000 RSS feeds in a single
snapshot. Its not consistent and only represents what a slice of
blogosphere has published at any given time. I've polled websites
for years, and more recently URLs/RSS. An article on Business 2.0
got me interested in breaking up the entries by individual word.
I was curious to just see how often some words were being
mentioned. The Business 2.0 article was on who and what you
should not being putting your attention into. It had the
"Slashdot is out, and Digg" is in comment.
While I think Digg is a great site, I just do not buy the work
Jeremy pointed out on Slashdot vs Digg. Digg may be growing, but
I believe that its relevancy is not as high as Slashdot's. I also
think that do to the nature of it being an open site with no
editorial, eventually it will water down its own effect by being
to broad.
The numbers:
mysql> select word_id, word, …
MySQL AB, the developer of the worldâ??s most popular open source database, today announced its participation in the Microsoft Visual Studio Industry Partner (VSIP) program as an Alliance-level partner. With over 240 members, Microsoftâ??s VSIP program gives partners the tools and resources they need to successfully integrate their tools, components and services into the Visual Studio 2005 development environment.
C.J. Blathers about recent major changes in his life.
https://colliertech.com/~cjcollier/confidential/sateOfTheCJ20060625.ogg
https://colliertech.com/~cjcollier/confidential/sateOfTheCJ20060625.mp3
Mail me for credentials.
Jason Maynard of Credit Suisse First Boston, enfant terrible of the software analyst community (well, if you're a proprietary vendor, anyway), is at it again. He's got a great "Mavericks vs. Microsoft" series going, with a June 23, 2006 report coming from a call with Marten Mickos, CEO of MySQL. He makes some interesting points, including:
-
Currently a private company, MySQL is...the world's most popular open source database with more than 8 million active installations.
-
The primary revenue stream for the company comes from the conversion of free downloads of its database product into support contracts. So far, the conversion rate to paying customers runs about 1 for every 1,000 downloads. MySQL’s database has been downloaded close to 100M …
Today we put the finishing touches on another article for the
Developer's Zone page. This one centered on how to implement
foreign keys via triggers into MySQL. This is important when your
application requires referential integrity and the storage engine
you'd like to use, as in the case of MyISAM or more specifically
NDB (Cluster), does not support this functionality
natively.
In the article we cover:
- Restricting INSERTS
- Restricting UPDATES and DELETES
- Cascading UPDATES and DELETES
Some of the advantages of foreign key enforcement include:
- Assuming the proper design of the relationships, foreign key constraints make it more difficult for a programmer to introduce an inconsistency into the database.
- Centralizing the checking of these constraints by the database server makes it unnecessary to perform these checks on the application side. This …
Sometime it is needed to handle a lot of rows on client side.
Usual way is send query via mysql_query and than
handle the result in loop mysql_fetch_array
(here I use PHP functions but they are common or similar for all
APIs, including C).
Consider table:
PLAIN TEXT SQL:
- CREATE TABLE `longf` (
- `f1` int(11) NOT NULL AUTO_INCREMENT,
- `f2` date DEFAULT NULL,
- `f3` date DEFAULT NULL,
- `f4` varchar(14) DEFAULT NULL,
- `f5` varchar(6) DEFAULT NULL,
- `f6` date DEFAULT NULL,
- `f7` smallint(6) DEFAULT NULL,
- `f8` smallint(6) DEFAULT NULL,
- `f9` varchar(13) DEFAULT NULL,
- `f10` varchar(39) DEFAULT NULL,
- `f11` int(11) DEFAULT NULL,
- `f12` float DEFAULT …
From Monday to Wednesday we at eZ systems AS had our internal developers
conference in Skien, Norway.
Since I joined eZ systems only recently, this was the opportunity
for me to get to know all employees that gathered from all over
the world. Most of the Tuesday was reserved for a "Crew Day" with
some "team-building" which took place in a forest nearby.
On Thursday and Friday the eZ publish conference
2006 took place.
During the conference I met with …
From Monday to Wednesday we at eZ Systems AS had our internal
developers conference in Skien, Norway.
Since I joined eZ systems only recently, this was the opportunity
for me to get to know all employees that gathered from all over
the world. Most of the Tuesday was reserved for a "Crew Day" with
some "team-building" which took place in a forest nearby.
On Thursday and Friday the eZ publish conference
2006 took place.
During the conference I met with Sébastien Hordeaux of WaterProof SARL,
the …
After seeing Frank’s script in “Finding out how far behind are slaves” I figured I would post some nagios plugins I wrote a while ago, that we use at our company. They’re already up at http://www.nagiosexchange.org/, the 3rd party repository for nagios plugins.
So I figured I’d point you to:
Replication Lag Time
and
InnoDB Free Space
I’ll note that backups from a slave server can cause replication lag time to fall behind, for 2 reasons — …
[Read more]BusinessWeek has been covering the rise of open source and Web 2.0 companies for a while. In a special series of articles, they show how Web 2.0 is going to change the landscape of not only consumer software, but also enterprise software. Not surprisingly most of these web 2.0 companies are powered by open source software. Whether it's the large public companies like Google, NetFlix or Yahoo or startups like JigSaw, Soonr, SixApart, SlashDot, Second Life, FaceBook, Flickr, Meetup, Technorati, Wikia or Craigslist, they are all built on a scale-out architecture with MySQL. Open source scale out is the architecture for the modern enterprise. And its not because open source is cheaper. Open source gives startups and large companies the freedom they need to scale as their business grows.
The next …
[Read more]