Super Tool: (Probably) the best SQLite Editor/IDE for web development and production use

| No Comments »

I really love SQLite. It’s lightweight and got a really small footprint. I use it as my database initially when i’m creating web applications(I then move to mySQL during production), the only issue I have is the lack of IDE for working with it. Of course there’s SQLite Administrator, i’m just not into the idea of installing a software especially with SQLite being small(I prefer not to cramp up as much software possible in my Windows).

This is where sqlite-manager comes along. It’s a 100kb plugin for Firefox(which also means cross compatibility with other OS), it’s a great complement to SQLite’s lightweight and small footprint. If you need to work with the database, you simply fire up sqlite-manager from the Tools menu.

That’s It!


How to Fix: I’m unable or can’t copy, move or delete files in MAC because of insufficient privileges or permissions

| No Comments »

Problem: My Mac OSX is complaining that the files im about to copy or move doesn’t have sufficient privileges or permissions!

Solution: Simply use the CHMOD trick here to recursively set all your files and directories permissions. After these are set, you will now be able to copy, move or delete these files.

You need to have administrative privileges for the following to work.

1. Open Terminal by typing Terminal in your spotlight(click the magnifying glass on the top right or press CMD+Spacebar on your keyboard). You can also open terminal from your Applications folder. 2. Type cd <Type the directory you want to give yourself permissions to here...>  3. Type the following commands(enter your password when it asks): sudo find . -type d -exec chmod 755 {} \; sudo find . -type f -exec chmod 644 {} \;

That’s it! You can now backup, copy, move or delete these files.


Unix Super Tip: How to CHMOD all your files recursively

| No Comments »

Problem: How do I set permissions to my files and/or directories without manually setting them up individually?

Note: You may need administrator privileges for these to work, if that’s the case simply add a sudo before typing the commands below.

If you want to chmod all your directories:

find . -type d -exec chmod 755 {} \;

and for files:

find . -type f -exec chmod 644 {} \;

That’s it!


How to: Count your regex pattern matches in python

| No Comments »

Problem: I need to display the number of times my regex has matched.

Solution: No Problem! Use the len (abbrev. for length) function:

import re >>> regex = re.compile(r”your pattern here…*”) >>> match = regex.findall(“the contents…”) >>> len(match) 10

That’s It!

On a side note, you can also use len to count the number of characters in a string.

>>> text = “All your base…” >>> len(text) 16

Unix Super Tip: Easy Access to your files and directories by creating symbolic links(shortcuts)

| No Comments »

The directory structure of Mac and Linux(both are UNIX) tends to get really _really_ long. But don’t worry, by using the ln -s, or Symbolic Link command in the terminal(unix shell), creating “shortcuts” to your folders or files is now a breeze.

ln -s   Here’s an example: ln -s /Library/Python/2.5/ /shortcuts/PYTHON  

The effect: cd /shortcuts/PYTHON is now the same as cd /Library/Python/2.5/, removing a shortcut is similar to removing a file: rm /shortcuts/PYTHONthat’s it!


How to: Fix Adium can’t connect to Yahoo Messenger

| 21 Comments »

Help: Adium can’t connect or is unable to connect to Yahoo! even after restarting the application or the whole OS.

__UPDATE__(6/24/09), Important!

Adium’s latest update includes a fix for this bug so please do download the update and after installation please make sure your connection’s login server is back to the default: scs.msg.yahoo.com, and ports: 5050, that should fix it.

Here’s a quick fix to this problem

  1. Disconnect(or Cancel) if your account is currently connecting.
  2. Change your connection’s login server from scs.msg.yahoo.com to 66.163.181.106, leave port 5050 unchanged. (You can do this by going to File -> (Select your Yahoo! Account) -> Edit Account, you can also do this in the File -> Preferences -> Accounts -> Edit
  3. Try Connecting Again.

That’s It! The steps above should be done to _each_ of your yahoo accounts.

__UPDATE__: This solution works for Pidgin as well so you may want to share this with your pidgin buddies who are experiencing the same problem.

Ciick here to share this solution with others who are experiencing the same problem!


Opera’s New Technology, Opera Unite, opens endless possibilities

| No Comments »
With all the sad stories of attempts in changing how the web works, it’s a good thing Opera did something that works very well even in a premature state(still in beta as I type)

Watch the following video to get the hands up of things: httpv://www.youtube.com/watch?v=D5hr-6cw4M8

Think of Opera Unite as creating your own server without any hassle at all! The browser itself serves as your gateway with communicating to the outside world (this is through the use of P2P technology), if you want to share your files, stream your music from anywhere, chat with friends(or anyone) everything is done with 0 configuration. You simply install the Opera 10 Browser (here), that’s it! it’s already preinstalled, click on the door with an arrow icon found on the brower’s corner (top left) and click on the propeller-like icon (hover on it and you’ll see Opera Unite), a list of available services (Media, File Sharing, Photo Sharing, Lounge and possibly more in the future) will show up. Double click on the service you want to run then login(registration is also hassle free) and that’s all there is to it! You will be given a url that you can share to friends or use for yourself so you can be connected to your files at all times! You can make your service available to everyone, limited(this is the default, a password is displayed that you can share to your those who you want access to your services to), or Private(for yourself only)

So that’s it!, once you have your services turned on, simply give your url to your friends. Remember to give them the password to your services that has Limited access’ passwords as well(each service has their own password, setting them up yourself is much preferred of course!)

Oh and did I mention that your friends don’t need to have Opera installed to access your services? Firefox, Chrome, Safari and other next generation browsers works fine! You only need Opera 10 if you want to run your service.

I’m using Opera Unite to:

  • Chat with Fellow Developers
  • Stream my music from anywhere
  • Share my photos with my friends and family

With more services to follow, Opera Unite will always be in one of my “must-have” software installed in my computer.

With all the joys and positivities surrounding the new technology, there are still some quirks that needs to be patched up(namely the webservice server isn’t living up to what all web developers are expecting) but to be fair Opera 10 is still in it’s beta stages so with all the good things it have right now, we are bound to see more surprises soon.

Kudos Opera! You have won yourself a fan.


How to: Fix “BOOTMGR IS COMPRESSED” error

| 84 Comments »

Problem: So I’ve decided to turn off compression(My Computer -> Select a Drive -> Right Click “Properties”) to speed up my computer. Compression saves disk space but it seems to slow down my computer whenever it’s accessing massive amount of files.

I was prompted to restart my PC so I did, I was then greeted by an error that says:

BOOTMGR IS COMPRESSED

Press Ctrl+Alt+Delete to Restart

SOLUTION(s):

There are 4 (possible) fix for this problem.

Option #1: Boot from your Windows Vista DVD and select Repair your Computer -> Startup Repair.
Option #2: Boot from your Windows Vista DVD and select Repair your Computer -> Command Prompt, execute the following commands: bootrec /fixboot bootrec /fixmbr Reboot.
Option #3: At the prompt to select your OS installation, click the button that says ‘Load Drivers’. This should bring up a explorer-style drive browser.Then just right-click on the drive you tried to compress, and deselect ‘Compress this Drive’, which should still be ticked on. Hit apply, and apply to subfolders/files. Reboot.
Option #4: Boot from your Windows Vista DVD and select Repair your Computer -> Command Prompt, in the command prompt, execute the following commands by typing them and pressing enter for each line: c: expand bootmgr temp attrib bootmgr -s -r -h del bootmgr ren temp bootmgr attrib bootmgr -a +s +r +h Reboot.(If the 2nd line fail, go back to 1st line and replace C with the drive letter of where your windows is installed.)

That’s it! Hope that helped you out.