💡 Providing SQL files

[mrrfly]

Halo,

Sebelumnya terimakasih telah membuat projek yang sangat bagus seperti ini, sangat berguna sekali diprojekan saya.

Tapi disisi lain, menurut saya ada yang kurang diprojek ini, yaitu file SQL untuk programmer yang masih berkutat dibidang RDBMS seperti saya ini.

Dengan tersedianya file SQL, programmer tidak perlu repot-repot lagi untuk mengubah dari CSV ke SQL atau melakukan pembuatan table wilayah lalu import csvnya.

Apa mas @fityannugroho berkenan kalau saya open PR untuk menambahkan file SQL tersebut?

Terimakasih ☕️

[fityannugroho]

My goal in creating this package is to present data in a universal file format with minimal size (e.g. CSV) without relying on a single database type, either relational or non-relational (see Motivation).

For ease of use, this package provides an API to convert the data from CSV into JavaScript objects (see Methods). So you don't need to convert them manually if you're working on a Node.js project (that using Node.js package manager like npm, yarn, or pnpm).

I have provided some examples of how to use idn-area-data with several databases (see the examples folder).

Unless you're working on a project that doesn't use Node.js or uses another programming language, then you'll need to download the data from data folder and convert it manually, or do it programmatically using CSV parser (for example: How to parse CSV file in PHP).

[mrrfly]

Thank you so much for your hard work in creating this package! Your goal to present data in a universal file format with minimal size is really cool, especially for developers who care about efficiency and flexibility in database usage.

I truly appreciate the API provided to convert data from CSV to JavaScript objects. It will definitely be very helpful in my Node.js projects, especially with package managers like npm, yarn, or pnpm.

I will use the examples you've provided as valuable references for my future projects, particularly in integrating data with various database types. I'm also very interested in collaborating or contributing to the development of this package if there's an opportunity.

Thanks again for your amazing contribution in enriching the developer community. I hope this package continues to grow and bring significant benefits to many people. Keep up the great work! 🍻🍻🍻