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!

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

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://

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.