‘We plan to expand open source team by more than 50%; also open to freshers’

‘We plan to expand open source team by more than 50%; also open to freshers’: "Gokul Muralidharan, open source specialist, Aspire Systems talks about the company’s journey on the open source road and the promise this speed lane holds for FOSS/Linux experts"

View all

Get your own

Produce and Consume Linked Data with Drupal!

Check out this SlideShare Presentation:

Produce and Consume Linked Data with Drupal!

View more presentations from scorlosquet.

What is RDFa?

Check out this SlideShare Presentation, it explains the RDFa in a very nice manner.

What is RDFa?

View more presentations from JISC Netskills.

FAST FACTS ABOUT COFFEE

FAST FACTS ABOUT COFFEE...



Love Thy Coffee.... :)

A Look at Motorola Droid

Motorola Droid seems to get a buzz around on its arrival into the mobile market...

What is it that makes us think it’s a great gizmo and will it overtake the I phone.

Let’s see some quick fact sheet on the Droid.

• Android™ 2.0
• CDMA CDMA 1X 800/1900, EVDO rev. A
• SLIDER
• Wifi
• GPS
• 5 MP camera
• Email sync
• MSOffice and PDF viewers.
• Close integration with Google apps.

The overall composition looks very appealing who likes google products with motorola hardware, clearly has a list of much needed features like Wifi and GPS and email sync to office and certainly available unlocked so that I could switch over to any service provider.

I certainly appreciate that Motorola made it available as unlocked though exclusive offers are given by Verizon.

I like it hoping the price would come down much further to get my own Driod…

This site has an good comparison have a look http://www.infoworld.com/d/mobilize/mobile-deathmatch-motorola-droid-vs-iphone-side-side-875&current=2&last=1#

Advantage PostgreSQL XML power

All of us know the greatness of the opensource database PostgreSQL, which is shortly called as PGSQL. This article outrights the power of XML functions usage available in the postgreSQL database.

Lets take a small sample.

Create a small table

CREATE TABLE "user_add"

(

id serial NOT NULL,

"name" character(100) NOT NULL,

address character varying(100),

phone character varying (12),

city character varying(20),

CONSTRAINT id PRIMARY KEY (id)

)

now let insert some sample records for our further actions

INSERT INTO "user_add"("name", address, phone,city)

VALUES ( 'John', '10, East st,Chennai', '111-111-111','Texas');

INSERT INTO "user_add"("name", address, phone)

VALUES ( 'Peter', '11, West st,Chennai', '222-222-222','Texas');

INSERT INTO "user_add"("name", address, phone)

VALUES ( 'Mike', '12, North st,Chennai', '333-333-333','Newyork');

now if you do a select of the table as select * from user_add;

1 | John | 10, East st,Chennai | 111-111-111 | Texas

2 | Peter | 11, West st,Chennai | 222-222-222 | Texas

3 | Mike | 12, North st,Chennai | 333-333-333 | Newyork

now I plan to give these data for an web service request or an ajax request for a request of user by city.

Generally we will be getting this data and then will be formulating that as xml format, which generally is a very consuming and exhausting process, PostgreSQL provides a simplistic way to achive this using its power full xml functions

here is a query

SELECT xmlelement (name city,

xmlattributes(city as "city" ),

xmlagg(xmlelement(name user,

xmlattributes(name as name),

(xmlelement(name address,address)),

(xmlelement(name phone,phone))

)

)

)

as xml from user_add where city = 'Texas' group by city;

you should get the xml

So just inaf to be passed on directly. Sounds amazing....