search

dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.3k stars 2.54k forks source link

[FEATURE] PostgreSQL support for country, city, state data with GoLang. #624

Closed caner-cetin closed 7 months ago

caner-cetin commented 1 year ago

Update: this is now a base functionality in main library. yeey.

caner-cetin commented 1 year ago

By the way I dont have the knowledge for creating SQL individually. Script is all and best I can provide.

fabiopicchi commented 8 months ago

The link to the gist is broken. Could you republish it @caner-cetin ?

Thanks a lot for the effort, by the way.

caner-cetin commented 8 months ago

@fabiopicchi read the code before running, I forgot what I did here lol. https://gist.github.com/caner-cetin/db20c431bd6075a49acc4457de0eb6c3

dr5hn commented 8 months ago

@fabiopicchi //cc @caner-cetin No need for this i am merging this PR https://github.com/dr5hn/countries-states-cities-database/pull/739 which will add support for postgresql.

dr5hn commented 7 months ago

Postgre support is now added! Cheers \m/

caner-cetin commented 7 months ago

yeehoo