Maps API

I would like to create a custom map and put pins programmatically on locations based on data from our database. Is there some open source api which allows me to do this or should I use gmaps?