{"id":48194799,"title":"Show HN: Connparse, a tool to parse DSNs, URLs, file paths, and cloud storage","points":3,"user":"modelorona","time":1779205255,"time_ago":"5 hours ago","type":"link","content":"

Hello!

This is a tool I created on the side that is able to parse connection strings for various data sources including SQL, NoSQL, files, cloud storage (s3, etc), and more.

I created it because I wanted to add automatic parsing for WhoDB (day job) so that users do not have to type in each detail individually when they add a new data source.

The parser currently supports SQL, NoSQL, file-based, and cloud storage connection strings (Postgres, MySQL, MongoDB, Redis, S3, SQLite, and more).

Each datasource is defined via YAML:

- required fields

- optional fields

- credential handling

- query params

- validation rules

Usage is simple:

const result = parse('postgres://user:pass@localhost:5432/app?sslmode=require');

and the result:

{\n "scheme": "postgres",\n "type": "database",\n "authority": {\n "host": "localhost",\n "port": 5432\n },\n "resource": {\n "type": "database",\n "name": "app"\n },\n "path": "",\n "query": {\n "sslmode": "require"\n },\n "fragment": null,\n "credentials": {\n "username": "user",\n "password": "pass"\n },\n "options": {},\n "raw": "postgres://user:pass@localhost:5432/app?sslmode=require",\n "safe": "postgres://user:**@localhost:5432/app?sslmode=require"\n}

which can they be used directly in the application.","url":"https://github.com/clidey/connparse","domain":"github.com","comments":[],"comments_count":0}