Pencarian

Rss Posts

 

 

 

Berita pada kategori ‘Sindikasi’

Wajah Baru Ubuntu

Mar 11, 2010

Ubuntu berganti wajah ? ya mulai release berikutnya yaitu Ubuntu 10.04 code name Lucid Linx, ada sedikit perubahan pada ubuntu, khusus nya bagian artwork nya, mulai dari Logo Ubuntu, Logo Komunitas, Tema, Boot Splash, Sampai Template website Ubuntu.com pun ikut berubah

Berikut ini tampilan beberapa screenshoot yang di dapat dari berbagai sumber prikitiwww…

Logo Baru Ubuntu

Logo-Logo Komunitas

read more

Catatan Proses Restore Mailbox Zimbra

Mar 11, 2010

Beberapa waktu yang lalu, Dudi Gurnadi-sosok yang saya hormati karena kecerdasan dan apresiasinya, meski saya belum pernah bertemu muka-membuatkan sebuah script sederhana untuk backup Zimbra mailbox secara live. Script ini sangat bermanfaat untuk melakukan proses backup mailbox Zimbra tanpa harus melakukan stop dan start service Zimbra.
Pada artikelnya disampaikan bahwa proses restore bisa dilakukan melalui menu [...]

Manajemen Paket dengan YUM

Mar 11, 2010

Mendengar kata YUM mungkin sedikit asing bagi pengguna Linux Debian Base, seperti ubuntu dan semua turunannya. YUM (Yellowdog Updater Modifier) adalah paket manajemen open source berbasis command line yang menghandle file-file RPM, biasanya secara default terinstall pada distro-distro redhat base, seperti CentOS, Fedora dan kawan-kawannya :D .

Penggunaan yum sebenarnya tidak jauh berbeda dengan apt-get pada sistem debian base berikut contoh-contoh command dalam penggunaan yum.

read more

Willy Sudiarto Raharjo: Security Update: Pidgin

Mar 11, 2010

Pidgin is finally upgraded on the last update and this time, it is considered a security fix as it fixed several critical vulnerabilities, as described in the Changelog of Pidgin Project.

Ok guys, grab it while it’s hot Yahoo

Performance tuning a server in less than three minutes while being slashdotted – Mark Dennehy

Mar 10, 2010

Burning ComputerTuning a webserver in three minutes while it’s being slashdotted.

ConFoo – PHP in the Enterprise – Paul Reinheimer

Mar 10, 2010


I just finished my PHP in the Enterprise talk at
ConFoo, Slides are available here: PHP in the Enterprise – ConFoo March 2010

Mobile World Congress 2010 – Mark Dennehy

Mar 02, 2010

Two years ago while I was working at dotMobi, I was one of the programmers working on the DeviceAtlas project, which launched at Mobile World Congress 2008. At the time, it was the largest launch I?d been involved in and it was quite a ride towards the end ? when you?re launching to 60,000 people [...]

Developing scalable PHP applications using MongoDB – PHP Classes

Mar 01, 2010

By Cesar D. Rodas
Nowadays there is a new kind of databases that is getting very popular, specially for Web development, including the PHP world, which are the NoSQL databases.

This article focus specifically on MongoDB, despite there are several other NoSQL database implementations.

on NULL and NOT IN

Feb 27, 2010

I#8217;ve been trying to think of something #8220;big#8221; to write about for so long, I haven#8217;t written anything.? So I#8217;ll write about something #8220;small#8221; that I found out the other day.
It turns out, #8216;NOT IN#8217; and #8216;NULL#8217; can have an odd (to me) effect.
Say you are doing something like
SELECT a FROM table1
WHERE a NOT IN
(SELECT a FROM table2);
If there are any NULLs in the table2#8217;s a column, you will never get any results from this query.
Here#8217;s an example:
#8211; first, here are the two tables I used:
mysqlgt; select * from test1;
+#8212;#8212;+
| a??? |
+#8212;#8212;+
|??? 1 |
|??? 2 |
|??? 3 |
|??? 4 |
|??? 5 |
|??? 6 |
+#8212;#8212;+
6 rows in set (0.02 sec)
mysqlgt; select * from test2;
+#8212;#8212;+
| a??? |
+#8212;#8212;+
|??? 1 |
|??? 2 |
|??? 3 |
| NULL |
+#8212;#8212;+
4 rows in set (0.00 sec)
mysqlgt; select a from test1 where a not in (select a from test2);
Empty set (0.02 sec)
#8211; personally, I expected to get 4,5,6.? For that, you can do the following:
mysqlgt; select a from test1 where a not in (select a from test2 where a is NOT NULL);
+#8212;#8212;+
| a??? |
+#8212;#8212;+
|??? 4 |
|??? 5 |
|??? 6 |
+#8212;#8212;+
3 rows in set (0.00 sec)
Why is this?? It is actually to follow the SQL standards on NULL.? As mentioned at http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html ,
#8220;To comply with the SQL standard, IN returns NULL not only if the expression on the left hand side is NULL, but also if no match is found in the list and one of the expressions in the list is NULL.#8221;
Just as #8220;1=NULL#8221; is undefined rather than false, and #8220;1lt;gt;NULL#8221; is too, #8220;1 in (null)#8221; is also undefined (or null), and #8220;1 NOT IN (null) is null#8221;.
mysqlgt; select 1 in (null);
+#8212;#8212;#8212;#8212;-+
| 1 in (null) |
+#8212;#8212;#8212;#8212;-+
|??????? NULL |
+#8212;#8212;#8212;#8212;-+
1 row in set (0.00 sec)
mysqlgt; select 1 not in (null);
+#8212;#8212;#8212;#8212;#8212;#8211;+
| 1 not in (null) |
+#8212;#8212;#8212;#8212;#8212;#8211;+
|??????????? NULL |
+#8212;#8212;#8212;#8212;#8212;#8211;+
1 row in set (0.00 sec)
To simplify the examples with tables above, we can do the following, and see similar results.
mysqlgt; select 1 not in (2);
+#8212;#8212;#8212;#8212;#8211;+
| 1 not in (2) |
+#8212;#8212;#8212;#8212;#8211;+
| 1??????????? |
+#8212;#8212;#8212;#8212;#8211;+
1 row in set (0.00 sec)
mysqlgt; select 1 not in (2,null);
+#8212;#8212;#8212;#8212;#8212;#8212;-+
| 1 not in (2,null) |
+#8212;#8212;#8212;#8212;#8212;#8212;-+
| NULL????????????? |
+#8212;#8212;#8212;#8212;#8212;#8212;-+
1 row in set (0.00 sec)
Personally, once I read the reasoning, it made sense to me, but initially I was surprised.? I thought I#8217;d write about it, because it is common to do a #8220;SELECT #8230; WHERE NOT IN (SELECT #8230;)#8221;, as in the example above with table1 and table2, and the results might not be what you expect if you have any NULLs in your table.

BuddyPress for One (and All!)

Feb 26, 2010

Back in April of last year, Matt posted here on the dev blog about the release of BuddyPress 1.0, a plugin that adds a social networking layer to an installation of WordPress MU. Many people were excited about the idea, but were unable to experiment with BuddyPress because they ran single installations of WordPress rather [...]