I have noticed significant reduction in time while compressing files larger than 1GB.
If you are looking to Bulk Insert while using PDO and want to use bound parameters (to prevent SQL injection), please have a look at this solution here: http://stackoverflow.com/questions/4629022/how-to-insert-an-array-into-a-single-mysql-prepared-statement-w-php-and-pdo
Quite simple and does the job.
I developed a website that you can browse to get the top News Stories from India. Here is the description that I added when I submitted the app to Apple:
The site offers you top news stories from a variety of News Sources from India covering topics such as General News, Sports, Cinema, Finance and Technology.
1. Ability to vote for a particular news article:
If you like a particular news item, you can approve of it by clicking on the up arrow next to he article and that would be counted as a vote for the article.
2. Top Stories
Interested in knowing which articles in a particular category are popular (lots of votes)? Then look at the Top Stories section and you will find it there.
The site is free to use and was mainly constructed because I was not really impressed with the other apps/sites offering this kind of service and decided to design my own site for personal use. Now I am opening it up for everyone who feels the same about the lack of decent Indian News site for IPhone users.
The site can be accessed here: http://trk7.com/mob/
My Social Search Engine:SansJ has had some updates to it’s interface recently. Most notable is the use of CSS based Buttons instead of standard HTML buttons. Thanks to some excellent free web 2.0-ish icons available here, I have been able to create some good-looking CSS buttons.The new menubar at the top has been created with help from here; which is a wonderful site to learn about HTML <li> and also look at some implementations (mainly CSS based menus).
I wa surprised to find that IE does not support :hover for anything other than <a> and was happy to use the workaround available here.
Another weird problem that I encountered with IE (versions 6 & 7).IE doesn’t seem to display text that had the color defined as ‘grey’, but, when I used the HEX value for color grey the text actually was visible. It is a bit difficult for me to put up with these issues as at home (where I mostly code), I use a mac and do not have IE (running windows a Guest OS, is something I wouldn’t want to do again), so I discover these quirks with IE when I get to work and then try to FTP to my site and try to edit files, and is getting quite painful as I am usually busy at work.
More updates, soon.I am hoping to complete some ideas that I would want to implement before I leave to NZ for a 4 day vacation.In preparation to the trip (apart from the shopping), I have decided to get rid of the tummy that could get out of control and found some help here.
My search site can be accessed at SansJ.com.I have also created a what-is-SansJ-kinda page here: SansJ Wiki. I intend to write about SansJ and the latest development happening at SansJ in that part of the site.
Also, was successfully able to implement a SansJ search plugin for Firefox 2.0 and IE7(haven’t tested in IE7 as yet).If you would like to create a opensearch plugin, please do visit this site:
Creating_OpenSearch_plugins_for_Firefox and if you are looking for a online opensearch plugin creator check this out: http://keijisaito.info/ready2search/e/.
Further info on SansJ, you can spread the word about SansJ to your friends by going here: http://sansj.com/refer.php , much appreciated if you manage to do that! Also check this interview that appeared on Wired with Eric Schmidt here: http://www.wired.com/techbiz/people/news/2007/04/mag_schmidt_trans .He talks about how Search is the main focus for Google and how every other product of Google revolves around search. A very insightful article and a very insightful person!
and had been reading Jonathan Franzen’s – How to be alone (after 2 years of reading it for the first time), I am blown over by the guys linguistic capabilities and also the way he so well puts into words the logic/rationality behind it.
That’s it for now!
Check the wiki at http://sansj.com/wiki.
This is interesting, History of people, History of time (briefly) and now history of websites. An interesting piece of History.
Check out http://feeds.feedburner.com/macmerc?m=683.