banner
LightNews
architxkumar.bsky.social
Archit Kumar
@architxkumar.bsky.social
12 followers 20 following 20 posts
22 | 📝 Documenting my journey transitioning from 🎓 Undergrad CSE student to 👨‍💻 SDE #Flutter #Golang https://github.com/architxkumar
github.com
Posts Media Videos Starter Packs
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 15h
Created the ⛃ database schema for my backend "Expense Tracker API" project. Would love to have your feedback!
#Golang #Postgres #database
Database entity relationship diagram showing six interconnected tables: USERS (top) with fields including user_id, username, email, password_hash, first_name, last_name, and profile_picture; ACCOUNTS (left) containing account_id, user_id, name, balance, currency, type, logo, created_at, and updated_at; TRANSACTIONS (bottom left) with transaction_id, account_id, amount, type, date, description, category_id, user_id, created_at, and updated_at; CATEGORIES (right) showing category_id, name, profile_picture, user_id; TAGS (bottom right) with tag_id, name, user_id; and TRANSACTION_TAGS (bottom center) as a junction table containing transaction_id and tag_id. The tables are connected by relationship lines showing foreign key associations, with USERS at the center connecting to ACCOUNTS and CATEGORIES, ACCOUNTS linking to TRANSACTIONS, TRANSACTIONS connecting to both CATEGORIES and TRANSACTION_TAGS, and TAGS linking to TRANSACTION_TAGS. Primary keys are marked with 'PK' and foreign keys with 'FK'
1
Reposted by Archit Kumar
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 3d
Today, taking inspiration from play.google.com/store/apps/d....
I decided to reverse-engineer the database design and improve upon it in Postgres. Here is a snippet of the work in progress.
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 3d
Today, taking inspiration from play.google.com/store/apps/d....
I decided to reverse-engineer the database design and improve upon it in Postgres. Here is a snippet of the work in progress.
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 4d
I just started using linter rules in #flutter like "always_use_package_imports" and "directives_ordering" . The sheer number of recommended linters on dart.dev/tools/linter... seemed overwhelming. Are there some essential linters worth using?
Linter rules
Details about the Dart linter and its style rules you can choose.
dart.dev
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 5d
Just kick-started working on a fresh new project from
@roadmapsh.bsky.social
by jumping straight to the🗄️database data modelling.
2 1 2
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 5d
Looks great! I have to admit it looks like loading spinner in a space game.
1 1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 5d
I couldn't agree more with that! I still feel that a lot of classes rely on rote learning which needs to change.
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 7d
I bet you asked, "Is Jordan Schlansky real? Who writes his stuff?"
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 7d
I just learned that Golang has merely 25 keywords, as opposed to C++'s 95 keywords (which, although no one uses all at once), but still, I think it's enough to highlight the language's emphasis on simplicity.

#golang
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 10d
Thanks a lot!
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 10d
Is there any specific design philosphy behind this?
2
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 10d
I have a question about unit testing around databases in #golang. In the lib/pq's documentation, it states that I need to have a live PostgreSQL server to test it out. However, in unit testing, shouldn't the external dependencies be mocked?
github.com/lib/pq/blob/...
github.com
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 17d
Even after 7 years, it's a blast to watch #TheBoringFlutterShow.
It's amazing to see the effort @redbrogdon.dev, Philip, and the rest of the Flutter team have put into each episode.

P.S. Also, I am curious why it has stopped airing?

#Flutter
1 2
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 18d
Just wrapped up a fun Flutter web app - Oscar the Grouch's Resume 🗑️

It was a fun way to understand Flutter's MediaQuery, responsive padding, and snappy CI/CD to GitHub pages
via GitHub Action.

🌐Check it out at: architxkumar.github.io/oscar-the-gr...

#flutter #OscarTheGrouch #BuildInPublic
1 3
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 18d
Happy to be here.
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 21d
One question bugs me that if nginx too can also cache responses and gin/fiber can too. Which one should I consider?
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 21d
Right now the focus is on iOS and Android. I haven't given wasm a shot. What's your advice for wasm?
1 1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 21d
I am finding it challenging and fun at the same time. Fun in the sense that it rally avoids the OOP hell and challenging in the sense that most Baas don't really support golang serverless function except for google cloud which makes things a bit harder.
1 1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 21d
Do you use redis for caching?
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 21d
Hey Dima,
It's nice to meet you. Looking forward to learn from you.
1
architxkumar.bsky.social
Archit Kumar @architxkumar.bsky.social · 21d
Hey Everyone,
I am new here on Bluesky. I am currently building apps with @flutter.dev and @golang.org. It will be great to connect with fellow developers
#flutter #golang
4 2 18