Sri Lankan Postal Code Database – SQLite

Postal Codes of Sri Lanka in a SQLite Database

This was actually a byproduct of one of my projects in university. However I did a thorough search on internet to find one complete database. It was kind of difficult, most of them were not complete or does not fit to my project requirements. Therefore I went further and designed my own version of postal codes database.

Word about SQLite : 

SQLite is an another form of SQL just like any other MySQL,MSSQL,Oracle etc. but the difference is quite noticeable. If you look at the list of SQL varieties above they all have one common feature, i.e all of them requires a dedicated SQL server to process queries, communicate with the database. This is where SQLite draws line.

SQLite does NOT need a server!

Therefore you can use SQLite to design stand-alone applications which are truly stand-alone. (This was one of my project requirements at that time.) 

Get it from GitHub : Postal Codes – Sri Lanka

Here is the database file : Sri Lankan Postal Codes Database – SQLite

Database Specifications:

Tables : postal_codes, towns, Dis.

postal_codes table contains : 1830 Records! & PostalCodes, PlaceName, State columns.

towns table contains : 4980 Records! & Province, NameofTown columns.

Dis table contains : 60 Records & Name,Province, District columns.

Just thought of sharing my work so that someone else can streamline their projects. Please do contact me if you need any help with SQLite or the database.

PS : If anyone is wondering how to open, create, modify SQLite databases, then there are plenty of free solutions available. For starters visit this link : SQLite Browser