Posted
28 days
ago
by
ts77
During the last couple of days I did some experiments with IPv6 connectivity / applications / configuration.
For nearly two years I already got two sixxs.net tunnels. One for a server and one for my home connectivity.
I never got aiccu working on Mac OSX so the home tunnel was down most of the time.
Finally it got [...]
Posted
2 months
ago
by
ts77
Merely as a note to myself I just looked around the Gentoo bugtracker to learn about the current state of MySQL in Gentoo.
So far I found two related bugs:
About 5.0.x
http://bugs.gentoo.org/show_bug.cgi?id=279493
What I learned from
... [More]
this bug:
Recent dev-db/mysql versions contain most of the percona patchsets already (neat!). Dunno about xtradb so far.
Latest in tree is 5.0.84 which [...] [Less]
Posted
2 months
ago
by
ts77
Long time no post but thats some stuff lingering in my head for a while looking at the mysql ecosystem lately.
For a long time I had to stay with MySQL-4.0 (sick I know) but there’s a lot of software to adapt to the new version(s) but lately I’m pushing it more and more into mysql [...]
Posted
about 1 year
ago
by
brianlmoon
Well, I blogged about Wordcraft the other day. I have just been running live on the software for 4 days now. Well, that post had no URI associated with it. It took me two days to figure this out. Oops. Welcome to eating
... [More]
my own dog food. So, running this live with actual users (and a host of bot spam attempts) I am learning a lot and making a lot of commits. So, I may very well roll once or twice a week for the first few weeks.
So, with that, I have packaged 0.5. There are 15 changes in this package. Some features, but mostly bug fixes. So, if you could use a simple blog, give it a try and help me debug it. If you do, please use the Google Code issue tracker. Maybe I can figure out how to have those things emailed to me. [Less]
Posted
about 1 year
ago
by
brianlmoon
So, a while back, not sure when, I was listening to the P3 Podcast
and Paul mentioned his dislike for Wordpress. He said he wished there
was a simple blogging application. I am probably misquoting him
horribly. It was an
... [More]
idea that I had been tinkering with. So, I
started on Wordcraft in my spare time. Like super spare time. That
time between the kids going to bed and me falling asleep. So, it took
a while to get it to a usable state.
Up until now, I have used Wordpress.com for my blogging. It works
quite well. You can get started quite quickly and it does what most
people need. My wife uses Blogger for our family blog. It is, IMO,
not as nice as Wordpress.com in some ways. But, it does allow you to
edit your styles (for free) and such which is nice.
So, why would I want to reinvent the wheel? I am a control freak
and rarely run other people's code. I know, it is a character flaw. I
am working on it. So, what did I come up with?
I had some goals when I started on this.
Keep it simple.
Focus on what I am good at doing.
Keeping it simple
I use MySQL. I didn't try to make it work with every possible
database. In fact, it only uses the mysqli PHP extenstion. The few
objects (CAPTCHA) are all PHP 5 objects. I don't plan to worry about
PHP 4. The templates don't use a template language. They use plain
old PHP. The are scoped to protect template authors from global
scope. There are only 6 files required to make a new template. There
are just 589 lines of code in the forward facing scripts. The admin
has 2,446.
What am I good at doing?
I write PHP/MySQL code that has to work fast for a living. It is
what I get paid to do. I am not a designer. I am not a spam catching
wizard. I don't write cool javascript widgets. So, I focused on the
PHP/MySQL parts of the code. For templates, I used designs that are
released under the Creative Commons license. I use Akismet and the
CAPTCHA libraries from Phorum for spam catching. I used the YUI Rich
Editor for the admin where I needed a WYSIWYG widget. I even link to
the YUI sources that are hosted by Yahoo. No sense taking on that
bandwidth or storage.
So, what does it do you ask? Well, here are some of the features:
WYSIWYG editing via YUI.
Comments with optional CAPTCHA and/or Akismet.
Custom pages can be created.
Tagging of posts
Custom publish dates
Automatic Pingback support
Friendly URL support with mod_rewrite
5 Templates in first release. Easy to build more.
Email notifications to authors
There are some things missing of course. Internationalization of
both the admin and templates is a big one. There is no current search
engine for blog posts. There is no "blog roll" type of feature. There
is no date based archive. And I am sure there is more missing. And I
am sure there are bugs.
But, if you would like to try out yet another PHP application, I welcome you to give it a try. The code is hosted at Google Code. It is a BSD licensed application. [Less]
Posted
about 1 year
ago
by
brianlmoon
So, a while back, not sure when, I was listening to the P3 Podcast
and Paul mentioned his dislike for Wordpress. He said he wished there
was a simple blogging application. I am probably misquoting him
horribly. It was an
... [More]
idea that I had been tinkering with. So, I
started on Wordcraft in my spare time. Like super spare time. That
time between the kids going to bed and me falling asleep. So, it took
a while to get it to a usable state.
Up until now, I have used Wordpress.com for my blogging. It works
quite well. You can get started quite quickly and it does what most
people need. My wife uses Blogger for our family blog. It is, IMO,
not as nice as Wordpress.com in some ways. But, it does allow you to
edit your styles (for free) and such which is nice.
So, why would I want to reinvent the wheel? I am a control freak
and rarely run other people's code. I know, it is a character flaw. I
am working on it. So, what did I come up with?
I had some goals when I started on this.
Keep it simple.
Focus on what I am good at doing.
Keeping it simple
I use MySQL. I didn't try to make it work with every possible
database. In fact, it only uses the mysqli PHP extenstion. The few
objects (CAPTCHA) are all PHP 5 objects. I don't plan to worry about
PHP 4. The templates don't use a template language. They use plain
old PHP. The are scoped to protect template authors from global
scope. There are only 6 files required to make a new template. There
are just 589 lines of code in the forward facing scripts. The admin
has 2,446.
What am I good at doing?
I write PHP/MySQL code that has to work fast for a living. It is
what I get paid to do. I am not a designer. I am not a spam catching
wizard. I don't write cool javascript widgets. So, I focused on the
PHP/MySQL parts of the code. For templates, I used designs that are
released under the Creative Commons license. I use Akismet and the
CAPTCHA libraries from Phorum for spam catching. I used the YUI Rich
Editor for the admin where I needed a WYSIWYG widget. I even link to
the YUI sources that are hosted by Yahoo. No sense taking on that
bandwidth or storage.
So, what does it do you ask? Well, here are some of the features:
WYSIWYG editing via YUI.
Comments with optional CAPTCHA and/or Akismet.
Custom pages can be created.
Tagging of posts
Custom publish dates
Automatic Pingback support
Friendly URL support with mod_rewrite
5 Templates in first release. Easy to build more.
Email notifications to authors
There are some things missing of course. Internationalization of
both the admin and templates is a big one. There is no current search
engine for blog posts. There is no "blog roll" type of feature. There
is no date based archive. And I am sure there is more missing. And I
am sure there are bugs.
But, if you would like to try out yet another PHP application, I welcome you to give it a try. The code is hosted at Google Code. It is a BSD licensed application. [Less]
Posted
about 1 year
ago
by
brianlmoon
Just got home finally from PHP Appalachia. I enjoyed meeting all the great people.
I presented about what I learned and how we deal with importing large amounts of CSV data into MySQL. I threw my idea onto the wiki at the last minute
... [More]
, made the slides while everyone ate breakfast and I had planned on researching it all (been a few years since I wrote it), but we had no reliable internet. Some claims I made and their corrections.
I said our largest file is about 1.8 million lines. WRONG. Actually it is about 4.6 million. I was correct however that it does finish importing and indexing in about 5 minutes.
I claimed I LOAD DATA INFILE to MyISAM first and then "insert into ... select from" into an InnoDB table for speed reasons. WRONG. In fact, I do that because I need to merge fields from the file sometimes into one field in the databaes. I could not find a way to do that with LOAD DATA INFILE. As to speed. I can't say either way as I have no solid data. Sounds like a good test. MyISAM probably still wins on a LOAD DATA INFILE into a blank, fresh table based on my experience.
Total rows currently indexed is 7.2 million. I did not make a claim, but I thought I would just mention that. I wanted to include that, but did not have Internet. (Damn you Hughes) [Less]
Posted
about 1 year
ago
by
brianlmoon
I spoke at the MySQL Conference and Expo this year about the architecture we have here at dealnews.com. After my talk, Jimmy Guerrero of Sun/MySQL invited me to give a webinar on how dealnews uses memcached. That is taking place next week
... [More]
, Thursday, October 09, 2008. It is a free webinar. We have used memcached in a variety of ways as we have grown. So, I will be talking about how dealnews used memcached in the past and present.
For more information, visit the MySQL web site. [Less]
Posted
about 1 year
ago
by
brianlmoon
Man, what did I do before strtotime(). Oh, I know, I had a 482 line function to parse date formats and return timestamps. And I still could not do really cool stuff. Like tonight I needed to figure out when Thanksgiving was in the US. I knew
... [More]
it was the 4th Thursday in November. So, I started with some math stuff and checking what day of the week Nov. 1 would fall on. All that was making my head hurt. So, I just tried this for fun.
strtotime("thursday, november ".date("Y")." 3 weeks")
That gives me Thanksgiving. Awesome. It is cool for other stuff too. At its very basic, it can take a MySQL datetime field and turn it into a timestamp. Very handy for date calculations. It also understands RFC 2822 and ISO 8601 date formats. These are common in HTTP headers and some XML documents like RSS and Atom feeds. Also, PHP can output those two standard formats with the date() function. So, this makes them a good standards compliant way to pass full, timezone specific dates around. [Less]
Posted
about 1 year
ago
by
brianlmoon
So, Google Chrome is out. If you don't know, it's Google's new browser. I downloaded it on my Windows XP machine and tried it out. I found this curious thing in the options.
So, I thought, I will click "Learn more" to see what they are
... [More]
watching. I get this.
So, I unchecked the box. Let's hope the premature launch is the reason there is no more information out there.
UPDATE: The page comes up now and says:
Information that's sent to Google includes crash reports and statistics on how often you use Google Chrome features. When you choose to accept a suggested query or URL in the address bar, the text you typed and the corresponding suggestion is sent to Google. Google Chrome doesn't send other personal information, such as name, email address, or Google Account information.
So, if you use their suggestions, they know it. And it tracks what features you use. Hmm, I think I will disable. [Less]
