{"info":{"_postman_id":"4553abc9-0adf-4ab5-9c66-ba441e45eaf7","name":"URL Shortner With DB Sharding","description":"

This collection is for exploring working POC of Database Sharding to create very basic url shortner.

\n

Github.

\n

https://github.com/Rahulbeniwal26119/url-shortner-with-db-sharding

\n

To verify the changes.

\n
\n

❯ docker exec -it pgshard1 psql -U postgres
psql (16.2 (Debian 16.2-1.pgdg120+2))
Type \"help\" for help.

\n
\n
\n

postgres=# select * from url_table;
id | url | url_id
----+-----------------------------+------------
1 | http://customsite.com/1235/ | 22e2d50e42
2 | http://customsite.com/1235/ | 22e2d50e42
3 | http://customsite.com/1235/ | 22e2d50e42
4 | http://customsite.com/1235/ | 22e2d50e42
5 | http://customsite.com/1235/ | 22e2d50e42
6 | http://customsite.com/1235/ | 22e2d50e42
7 | http://customsite.com/1235/ | 22e2d50e42
8 | http://customsite.com/1235/ | 22e2d50e42
9 | http://customsite.com/1235/ | 22e2d50e42
10 | http://customsite.com/1231/ | ce3575956d
(10 rows)

\n
\n
\n

❯ docker exec -it pgshard2 psql -U postgres
psql (16.2 (Debian 16.2-1.pgdg120+2))
Type \"help\" for help.

\n
\n
\n

postgres=# select * from url_table;
id | url | url_id
----+-----------------------------+------------
1 | http://customsite.com/1239/ | 883a78ef0a
(1 row)

\n
\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"13312008","collectionId":"4553abc9-0adf-4ab5-9c66-ba441e45eaf7","publishedId":"2sA3e5f8yx","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2024-07-14T04:00:32.000Z"},"item":[{"name":"Create URL","id":"70758ed4-5b92-4f4e-9568-fe003d30056d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"url\": \"http://customsite.com/1231/\"\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/url","urlObject":{"protocol":"http","port":"8000","path":["url"],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[{"id":"951f8a17-70ea-4536-98ec-b7436b918e48","name":"Success","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"url\": \"http://customsite.com/1239/\"\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/url"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"date","value":"Sun, 14 Jul 2024 03:40:24 GMT"},{"key":"server","value":"uvicorn"},{"key":"content-length","value":"78"},{"key":"content-type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n \"shard\": \"pgshard2\",\n \"url_id\": \"883a78ef0a\",\n \"url\": \"http://customsite.com/1239/\"\n}"},{"id":"dc23ea0b-8e94-4a01-90a6-111b45b9cff7","name":"Success","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"url\": \"http://customsite.com/1231/\"\n}","options":{"raw":{"language":"json"}}},"url":"http://127.0.0.1:8000/url"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"date","value":"Sun, 14 Jul 2024 03:43:25 GMT"},{"key":"server","value":"uvicorn"},{"key":"content-length","value":"78"},{"key":"content-type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n \"shard\": \"pgshard1\",\n \"url_id\": \"ce3575956d\",\n \"url\": \"http://customsite.com/1231/\"\n}"}],"_postman_id":"70758ed4-5b92-4f4e-9568-fe003d30056d"},{"name":"GET","id":"b7822028-bf21-4cbd-9c0e-36f69f401c8e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://127.0.0.1:8000/url/22e2d50e42","urlObject":{"protocol":"http","port":"8000","path":["url","22e2d50e42"],"host":["127","0","0","1"],"query":[],"variable":[]}},"response":[{"id":"58e4a6d1-6996-4b12-8c37-589725ef5e88","name":"Success","originalRequest":{"method":"GET","header":[],"url":"http://127.0.0.1:8000/url/883a78ef0a"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"date","value":"Sun, 14 Jul 2024 03:40:36 GMT"},{"key":"server","value":"uvicorn"},{"key":"content-length","value":"78"},{"key":"content-type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n \"shard\": \"pgshard2\",\n \"url_id\": \"883a78ef0a\",\n \"url\": \"http://customsite.com/1239/\"\n}"},{"id":"796fecd7-66bc-4897-a8c0-f1a09d7abd02","name":"Success","originalRequest":{"method":"GET","header":[],"url":"http://127.0.0.1:8000/url/ce3575956d"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"date","value":"Sun, 14 Jul 2024 03:44:29 GMT"},{"key":"server","value":"uvicorn"},{"key":"content-length","value":"78"},{"key":"content-type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n \"shard\": \"pgshard1\",\n \"url_id\": \"ce3575956d\",\n \"url\": \"http://customsite.com/1231/\"\n}"}],"_postman_id":"b7822028-bf21-4cbd-9c0e-36f69f401c8e"}]}