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
The information you have given about the database is very important information.
Thank you for sharing your information.
LikeLike