I bought a shiny new iPod touch, and after unlocking it to install custom applications, I soon filled the 300Mb applications partition. If you need more than 300Mb for apps (which you more than likely will if you install more than a couple), you can create a sym link to the music partition.
- SSH into your iPod using a client such as Putty with the iPod's IP address, user: root, password: alpine.
- Move the applications folder to /private/var/Applications by typing mv /Applications /private/var/Applications
- Change directory to / by typing cd /
- Create a link to the new applications directory: ln -s /private/var/Applications Applications
- Now when you list the directory using ls -la, you should see something like lrwxr-xr-x 1 root admin 25 Oct 12 22:31 Applications -> /private/var/Applications
- Reboot your iPhone and fill up yet more space with useless applications!
[Via: MacRumours]
I've been working on adding support for Microsoft SQL Server to iZeit, and there are a few things I've noticed. Firstly, whereas you can addin multiple rows in MySQL or Postgres by using
INSERT INTO tablename (field1,field2,field3) VALUES (r1c1, r1c2, r1c3), (r2c1,r2c2,r2c3)
MSSQL fails and throws an error. Instead, you have to use UNION ALL, which I always thought was more resource intensive.
INSERT INTO tablename (field1,field2,field3) SELECT (r1c1, r1c2, r1c3) UNION ALL SELECT (r2c1,r2c2,r2c3)
The second major annoyance is that MSSQL doesn't like ORDER BY clauses with text fields. Understandably you can't sort a field containing an image, but why can't it sort a text field alphabetically? One thing I still haven't found a workaround for is the LIMIT and OFFSET clauses, which MSSQL doesn't support.
Britons are now sending more then 4 billion texts weekly. That's more than were sent in the whole of 1999 and 25% more than one year ago. In September, 4.8 billion texts were sent, about 4,000 per second!
That’s some furious texting. People would be better off with Blackberrys though…
Read More [BBC News]
