|
One thing that comes up a lot on sites like Stackoverflow and the like is how to backup MySQL databases.The first answer is usually use mysqldump. This is all fine and good, till you start to want to dump multiple databases. You can do this all in one like using the –all-databases option however this makes restoring a single database an issue, since you have to parse out the parts you want which can be a pain.
|
|
When developing a system that people use in their day to day work, I often meet the following requirement: “A user should be able to see all tasks from each functional area on a single screen.” This requirement requires integration with all parts of the system, making it architecturally costly. Luckily, the requirement might often not be needed at all! Everyone will tell you: The most powerful technique for dealing with a large problem is b..
|
|
Usually, when you need to put something down, you just place it on the next table and don't think much about it. After a few days (or weeks/months/years) your appartment looks like shit and you have to clean it up. How do you clean? One thing at a time. So one by one you take each item lying on the floor, on a table, in a shelf and find it a new home. Sometimes you can see a pattern in all your stuff that's lying around and you might find a..
|
|
Usually, when you need to put something down, you just place it on the next table and don't think much about it. After a few days (or weeks/months/years) your appartment looks like shit and you have to clean it up. How do you clean? One thing at a time. So one by one you take each item lying on the floor, on a table, in a shelf and find it a new home. Sometimes you can see a pattern in all your stuff that's lying around and you might find a..
|
|
Im not usually one to promote events and the like unless I feel there is a genuine benefit to be had by attending but this is one stands out. Richard M Stallman, the guru of Free Software is coming Down Under to hold a talk. You can read about him here, Open Source Celebrity to visit Australia You can register for the event at the ACS Website I am certainly planning on attending.
|
|
I learned PHP and built the online website creator N.nu from scratch myself (examples). From the start one of the principal focuses has been to make sure that the system has optimal SEO and it is my intention that N.nu is the online website creator with the best SEO. This blog is of course hosted [...]
|
|
I learned PHP and built the online website creator N.nu from scratch myself (examples). From the start one of the principal focuses has been to make sure that the system has optimal SEO and it is my intention that N.nu is the online website creator with the best SEO. This blog is of course hosted [...]
|
|
I used to think I knew a bit about performance, scalability and how to keep things trucking when you hit large amounts of data. Truth is I know diddly squat on the subject since the most I have ever done is read about how its done. To understand how I came about realising this you need some background. Essentially what I have been working on and hope to launch soon is a highly vertical search engine that websites can employ on their site ..
|
|
For license reasons (god damn GPL), ZFS can’t be integrated into the Linux kernel, but there is a userland fuse version called [ZFS-FUSE](http://zfs- fuse.net/), so I tried to measure the fuse overhead vs others filesystems presents on my server. This tests are not benchmarks, but just show that ZFS-FUSE is fast enough and seems to be stable (at least for my personal server) ZFS with lzjb compression dd if=/dev/zero of=/testzfs/toto bs=2048..
|
|
In a production environment you could hit this one: DatabaseError: Invalid handle! It seems to happen when Oracle is called with OCI interface (cx_Oracle) by multiple threads. Yes using apache with MPM worker or mod_wsgi, will create threads in the same process, by default cx_Oracle is configured to be used without threads cause it will add a mutex and a performance hit. The solution is to pass the threaded parameters to the connection stri..
|
|
I haven’t been feeling very motivated to blog lately – I’ve missed the last two weeks of Iron Blogger, and I’m not totally enthusiastic about any of the items on my “to blog” list. But, I do enjoy blogging when I actually get into posts, and I’d like to keep updating this blog. So, in a bit of a copout, and following in Edward’s footsteps, this is an appeal to all of you: What should I blog about?
|
|
I haven’t been feeling very motivated to blog lately – I’ve missed the last two weeks of Iron Blogger, and I’m not totally enthusiastic about any of the items on my “to blog” list. But, I do enjoy blogging when I actually get into posts, and I’d like to keep updating this blog. So, in a bit of a copout, and following in Edward’s footsteps, this is an appeal to all of you: What should I blog about?
|
|
I thought I would post some examples of websites with bad website search. Rather then pick on some small blogs lets go after the big boys. Starting with eBay. “There was a screenshot of ebay here at one point but now it is lost for all time… sorry” The link to the left is an example of a simple search I performed on eBay for an iPad. The search comes back pretty quickly which is good but has a few issues I will go through now.
|
|
I was reading a blog post today linked from Dzone which alluded to test driven development being a waste of time I am one of those people who has caught the test driven development (TDD) bug and I am a big fan of TDD and unit testing in general. In fact I am the one who posted the first comment on the linked blog and prompted the authors change to it.
|
|
The below is just a few things to keep in mind if you are writing a crawler or considering writing one. The first is to assume that all of the links you have are broken to begin with. When I write this I dont mean assume that the link goes nowhere, but that the URL itself is actually wrong. Even when you seed your own list (like I did) you can still get some bad URL’s in there.
|
|
One of the things that I always have to look up (when doing it manually that is) is how to export specific databases or all of them from MySQL using mysqldump. To avoid having to Google around every time I need the commands I thought I would preserve it here. Export a database from MySQL in one line NB password must follow -p without a space mysqldump -u user -pPASSWORD mydatabase > mydatabase.sql Export all databases from MySQL
|
|
So in keeping with the lean startup style, I needed to work out which version control system and which bug tracker I would use. Internally at work I use subversion and JIRA. Both do the job quite well but I have found some shortcomings with subversion and JIRA is needlessly complicated for a single developer at the moment. So I looked for alturnatives. Version control was easier of the two to pick. I have been toying with GIT for a while ..
|
|
I wanted to learn how to build mobile apps, so last weekend I bought Building iPhone Apps with HTML, CSS, and JavaScript: Making App Store Apps Without Objective-C or Cocoa . I don’t have any problem learning a new language, in fact I really enjoy it, but I was reluctant to to pay serious dollars for a Mac just to learn the skill. The book covers how to build a website that is tailored for the iPhone. It looks and behaves like an iPhone ..
|
|
Well I finally got around to doing what I always said I would. That being launch and online business. Inspired by all of the stories and discussions at news.ycombinator.com and in particular this single post http://news.ycombinator.com/item?id=1560422 I decided to finish off those projects that I have been working on for a while and launch. Naturally following the experience of the greats who have done it themselves, such as Patrick wit..
|
|
I finally finished my first Exadata performance troubleshooting article. This explains one bug I did hit when stress testing an Exadata v2 box, which caused smart scan to go very slow – and how I troubleshooted it: Troubleshooting Exadata v2 Smart Scan Performance Thanks to my secret startup company I’ve been way too busy to write anything serious lately, but apparently staying up until 6am helped this time! :-) Anyway, maybe next w..
|
|
I finally finished my first Exadata performance troubleshooting article. This explains one bug I did hit when stress testing an Exadata v2 box, which caused smart scan to go very slow – and how I troubleshooted it: Troubleshooting Exadata v2 Smart Scan Performance Thanks to my secret startup company I’ve been way too busy to write anything serious lately, but apparently staying up until 6am helped this time! :-) Anyway, maybe next w..
|
|
This video is from an interview I did with James Turner at OSCON in July of 2010. From Slashdot : “Imagine that your data center was in the most geographically remote location in the world. Now imagine that you can only get to it 4 months of the year. Just for fun, add in some of the most extreme weather conditions in the world. That’s the challenge that faces John Jacobsen, one of the people responsible for making sure that the data..
|
|
This video is from an interview I did with James Turner at OSCON in July of 2010. From Slashdot : “Imagine that your data center was in the most geographically remote location in the world. Now imagine that you can only get to it 4 months of the year. Just for fun, add in some of the most extreme weather conditions in the world. That’s the challenge that faces John Jacobsen, one of the people responsible for making sure that the data..
|
|
This video is from an interview I did with James Turner at OSCON in July of 2010. From Slashdot : “Imagine that your data center was in the most geographically remote location in the world. Now imagine that you can only get to it 4 months of the year. Just for fun, add in some of the most extreme weather conditions in the world. That’s the challenge that faces John Jacobsen, one of the people responsible for making sure that the data..
|
|
This video is from an interview I did with James Turner at OSCON in July of 2010. From Slashdot : “Imagine that your data center was in the most geographically remote location in the world. Now imagine that you can only get to it 4 months of the year. Just for fun, add in some of the most extreme weather conditions in the world. That’s the challenge that faces John Jacobsen, one of the people responsible for making sure that the data..
|
|
Smartphones, netbooks and tablet computers are evidence in the evolution of how we interact with the web.
|
|
Amit wrote on the Rootein blog: > What is it with people refusing to take some risks to follow their dreams. Are their dreams not worth it? If not, why do we sulk about them later? Don't we...
|
|
Now you can preview fonts in the Google font directory. This is exactly the kind of thing Google does incredibly well. It also gives you the CSS needed to make the font appear the way it does in th...
|
|
Amit wrote on the Rootein blog: > What is it with people refusing to take some risks to follow their dreams. Are their dreams not worth it? If not, why do we sulk about them later? Don't we...
|
|
Now you can preview fonts in the Google font directory. This is exactly the kind of thing Google does incredibly well. It also gives you the CSS needed to make the font appear the way it does in th...
|
|
Zeitgeist , the desktop activity logging engine is now becoming geo-aware. From Seif Lotfy's blog : It allows you to ask Zeitgeist stuff like “Get me the recent files I edited at university” “Who do I contact most when I am at School?” “Which pictures did I take in Brazil?” “Where was I when an Email came in?” “What files did I open during the conference?” As I've been advocating since 2006 , location is important for making appli..
|
|
I’m pretty sure every developer who has ever worked with a modern database-backed application, particularly a web-app, has a love/hate relationship with their ORM, or object-relational mapper. On the one hand, ORMs are vastly more pleasant to work with than code that constructs raw SQL, even, generally, from a tool that gives you an object model to construct SQL, instead of requiring (Cthulhu help us all) string concatenation or interpolati..
|
|
I’m pretty sure every developer who has ever worked with a modern database-backed application, particularly a web-app, has a love/hate relationship with their ORM, or object-relational mapper. On the one hand, ORMs are vastly more pleasant to work with than code that constructs raw SQL, even, generally, from a tool that gives you an object model to construct SQL, instead of requiring (Cthulhu help us all) string concatenation or interpolati..
|
|
Overview and Requirements So I've volunteered to help Boulder Community Computers set up some automated Ubuntu OS installations over their local area network. Being as this is a large part of what I do professionally, this is something easy for me to do that should help them be more efficient. Their network layout is going to look something like this I think: Internet ^ | Office LAN (private addresses)<-> Various workstations (DHCP fr....
|
In 2010 I generated this hardbound book as a wedding present for my friends Nathan and Pei-San and published it with Intermedia Writing Systems. It used the Open Wound software along with some custom editing tools. The quotes on the inside jacket flap were taken from the generated text and were touchingly specific to their […]
|
|
My friend Glenn invited me to go flying with him the other afternoon. I got some pretty amazing pictures. Check out the spectacular rainbow from the plane!
|
|
When I was growing up I always thought that my life would hit some kind of point where everything will start moving very quickly and that I’d have to keep up with the current before I get swept away. And today I finally feel like I’ve dipped my toe into that point in my life. Our baby girl was born yesterday (a month ahead of schedule) and I’ve been kind of in a rush to get everything put into place.
|
|
The interesting part of this talk is how technology can give us a cognitive surplus, or simply free-time.
|