Tag: PostgreSQL


Introduction To CKAN – Open Data Portal Platform

Please note that below blogpost is based on my personal experience while developing data.gov.lk which is the Sri Lanka’s Open Data Portal.

CKAN. In their words “the world’s leading open-source data portal platform”. Since you know about open data and how to use it let’s get right into CKAN. Oh oh! You don’t know about open data. Don’t worry! I got you covered. Read this blog post and you will get to know every thing you need to know about open data. Yeah trust me! Everything.

What’s CKAN?

As they say,

CKAN is a powerful data management system that makes data accessible – by providing tools to streamline publishing, sharing, finding and using data. CKAN is aimed at data publishers (national and regional governments, companies and organizations) wanting to make their data open and available.

Basically it’s a open source tool which allows you to manage your open data. It’s written in Python & uses Postgres as the database. If you are a MySQL fanboy and don’t know about Postgres don’t forget to read this blog post. It will give you a good idea about Postgres. Will divine into to CKAN’s features, so that you will know how powerful and feature-rich CKAN is. Brace yourself, here we go.

– Read More –

Let’s explore PostgreSQL DBMS

Why PostgreSQL?

The purpose of this article is to give you an idea about PostgreSQL. Most probably this will be an introduction for you. I will be providing a lot of links through out the article. Make sure to check those out .

Let me start like this. I have been a MySQL fan for a long time & I got a chance to work with PostgreSQL. Then I realised  the value of PostgreSQL. Let me tell you little story. This might hurt but let’s face the truth.

Do you know that MySQL is owned by Oracle. As you know MySQL is licensed under FOSS(Free and open-source software) License. Do you really think that Oracle will let their FOSS product(MySQL) beat their commercial product(Oracle Database). I think I made my point here. Don’t get me wrong, I’m not saying that MySQL is bad. It’s an awesome DBMS. That’s for sure. Also PostgreSQL is called the FOSS version of Oracle because it’s that much feature-rich.

– Read More –