A lot of people may ask them­selves when devel­op­ing data­bases when to use the UNSIGNED keyword.

So what’s the dif­fer­ence between a “signed” integer and an “unsigned” integer?

An “unsigned” integer can not be neg­at­ive but the upside is that you can have a big­ger range of pos­it­ive numbers.

I think the fol­low­ing types explain themselves:

Tiny­int -> Signed range -> –128 to 127
Tiny­int -> Unsigned range -> 0 to 255

Medi­umint -> Signed range -> –8388608 to 8388607.
Medi­umint -> Unsigned range -> 0 to 16777215

Bigint -> Signed range -> –9223372036854775808 to 9223372036854775807
Bigint -> Unsigned range -> 0 to 18446744073709551615

That’s should explain it. Short but inform­at­ive… hopefully!

The other day I star­ted work­ing on a Twit­ter pro­ject and what I need to do is to scan Twit­ters pub­lic timeline and get a cer­tain amount of tweets from a cer­tain user. On top of that it needs to be filtered by hashtags.

After brows­ing the net for a little while I found a fant­astic class on script­play­ground.

I imple­men­ted it in my pro­ject and it worked like a charm.… until I wanted to fil­ter out ReTweets. I simply couldn’t find any addi­tional para­meter for the Twit­ter Search API that could do that for me. I mean I tried to put –RT and all that sort of stuff into the search-call but it simply didn’t work out for me.

Maybe I did some­thing wrong. If so, I would highly appre­ci­ate a com­ment that will widen my horizon!

So I decided to extend the class myself and provide it for any­one who might find it useful.

Read more…

… is the name of the new daily magazine I cre­ated on paper.li. It’s all about Adobe Flash — Flex — Cata­lyst and Android punch lines! So stay tuned and subscribe!

Daily A[n]d[roid]obe.

I was just brows­ing for the latest ver­sion of Tor­toise SVN when I stumbled upon this neat little tool which imple­ments a fea­ture into your Win­dows 7 OS that will be avail­able in Win­dows 8 (or what ever they are gonna call it).

It changes your win­dows aero color depend­ing on the over­all col­our of your wall­pa­per. Check it out, it works like a charm!

Here it is… my new design with a cus­tom header that I cre­ated last night.
The design was ori­gin­ally cre­ated by patembe.
You can throw the social net­work icons around and be amazed by the phys­ics. If you double-click the items you will be redir­ec­ted to my pro­file page of the cor­res­pond­ing social network.

Enjoy and leave me a com­ment if you like it…

After search­ing the inter­net for some­thing trivial like the sort­ing a mul­ti­di­men­sional array I found the fol­low­ing solution.

Read more…

You are here because as a Word­Press plu­gin developer you are exper­i­en­cing the fol­low­ing error:

The plu­gin gen­er­ated 8 char­ac­ters of unex­pec­ted out­put
dur­ing activ­a­tion. If you notice “head­ers already sent” mes­sages,
prob­lems with syn­dic­a­tion feeds or other issues, try deac­tiv­at­ing or
remov­ing this plugin.

I solved the issue by doing the following…

Read more…

Hi every­one,

I developed this web applic­a­tion for a cli­ent of mine. It was run­ning fine on a server but now they want an off­line for present­a­tion pur­poses.
So they asked me to do some changes (load local pic­tures etc…) and deploy an off­line version.

So while doing that I dis­covered the fol­low­ing error:

Flash Secur­ity Error — fpdownload.adobe.com

This error occurs when I tried to open the HTML file that embeds the SWF in my browser.

Read more…

I am just play­ing around with Twitter’s PHP Lib­rary twit­ter­libphp and cre­ated this little application.

You can see the res­ults here.

Read more…