Adedemola π» Web Developer
@demoladevop
Followers
26
Following
2K
Media
18
Statuses
633
πΌ Need a fast, scalable web experience? Letβs build one that looks great, loads fast & drives results π Book a free consult β https://t.co/NmBBJvxGCr
Lagos Nigeria
Joined May 2025
I build polished, responsive full-stack web apps β from landing pages to SaaS dashboards. π§ UI, backend, performance & scalability β all in one service π¬ Available for freelance collaborations & projects β DM me π See work & book β https://t.co/Z2fxURXXOb
1
0
5
Homepage and auth screens are now designed. Focusing on layout, structure, and clarity before wiring up any logic. If you have an eye for UX or UI flow, Iβd appreciate feedback on the design. #buildinpublic #nextjs #nestjs
Update on this: @turborepo is finally sorted β nestjs + prisma on the backend, and Iβm moving the frontend to @nextjs with @tan_stack router. Huge thanks to the @prisma team for the guidance while wiring things up. Now I can focus on the booking flow UI. #buildinpublic
1
1
1
They said itβs affordable ooπ« π«
The cure for sickle cell disorder is now available at sickle cell foundation Nigeria, LUTH. π₯Ί
31
1K
2K
The cure for sickle cell disorder is now available at sickle cell foundation Nigeria, LUTH. π₯Ί Please retweet for others to see
484
22K
30K
Update on this: @turborepo is finally sorted β nestjs + prisma on the backend, and Iβm moving the frontend to @nextjs with @tan_stack router. Huge thanks to the @prisma team for the guidance while wiring things up. Now I can focus on the booking flow UI. #buildinpublic
Time to upgrade this. Turning the @nestframework booking app into a full turborepo project with a tanstack start frontend. Shared models, types and a cleaner base for automated booking systems. Demo on the way. #buildinpublic
0
1
2
Time to upgrade this. Turning the @nestframework booking app into a full turborepo project with a tanstack start frontend. Shared models, types and a cleaner base for automated booking systems. Demo on the way. #buildinpublic
Iβve been building a full Booking Management System API over the last few days, and itβs finally in a solid place to share. Built with @nestframework + @prisma (migrated to 7) Putting it out here for feedback, collaboration, ideas & gigs ππ½ #backenddeveloper #OpenSource
0
1
4
Wrapping up my invoice automation system with @fastapi: JWT + argon2 auth, full SQLAlchemy models, invoices/clients/payments, schema-driven APIs, and Celery+Redis workers for email queues, payment logs, and recurring billing. Built for reliable, automation-heavy workflows.
Quiet update, Client + Invoice CRUD done: β Create clients with unique email enforcement + soft deletes β Full invoice creation: line items, auto-numbering, due-date calc β Single endpoint returns everything a real dashboard would need (client + invoices + items +
1
1
2
Quiet update, Client + Invoice CRUD done: β Create clients with unique email enforcement + soft deletes β Full invoice creation: line items, auto-numbering, due-date calc β Single endpoint returns everything a real dashboard would need (client + invoices + items +
Building an invoice management automation system with @FastAPI Core pieces implemented: β’ JWT auth with argon2 hashing β’ SQLAlchemy models + Alembic migrations β’ Typed request/response schemas β’ Env-based config + versioned routing Up next: CRUD for clients and invoices.
1
0
1
Building an invoice management automation system with @FastAPI Core pieces implemented: β’ JWT auth with argon2 hashing β’ SQLAlchemy models + Alembic migrations β’ Typed request/response schemas β’ Env-based config + versioned routing Up next: CRUD for clients and invoices.
0
1
4
51 bookmarks. You'll are stingy with retweets. I see why people gate keep now.
We made our first sale through a recommendation from ChatGPT π I broke down how you can instantly add your website to ChatGPT, Claude, Perplexity, and every major AI assistant. Most people donβt know this, but LLMs now read your site the same way Google reads your sitemap
6
4
21
(Key Takeaway)Defense in depth: 1οΈβ£ Use parameterized queries (PRIMARY defense) 2οΈβ£ Validate input with class-validator 3οΈβ£ Whitelist dynamic values (sorting, columns) 4οΈβ£ Use least-privilege database accounts
0
0
1
(Why It Matters)Real impact of SQL injection attacks: Bypass authentication (login without passwords) Steal entire databases (credit cards, user data) Modify or delete records Drop entire tables Use ORMs like Prisma/TypeORM that parameterize queries automatically.
1
0
1
(The Solution)The fix: PARAMETERIZED QUERIES β Never do this: query = `SELECT * FROM users WHERE email = '${userInput}'` β
Do this instead: SELECT * FROM users WHERE email = ? -- Pass [userInput] as parameter separately User input is treated as DATA, not executable CODE.
1
0
0
(The Problem)SQL injection happens when attackers insert malicious SQL code through user inputs. Example: Enter " OR "1"="1" -- as username Your query becomes: WHERE username = "" OR "1"="1" -- Since "1"="1" is always TRUE, they bypass login without a password.
1
0
0
Just completed the SQL Injection module on @freeCodeCamp SQL injection = attackers insert malicious SQL through user inputs. Example attack: Username: " OR "1"="1" -- WHERE clause becomes always TRUE β instant bypass π± How to fix this? π
1
0
2
Finally touched BCNF β making sure any attribute that determines another is a superkey. Itβs stricter, but seeing how it kills those sneaky anomalies is worth it.
0
0
1
Transitive dependency example next: order_id | customer_id | customer_city | city_postal_code | ... City + postal code depend on customer info, not directly on the order. Split into orders, customers, and cities (3NF). Makes updates predictable.
1
0
1
Then hit partial dependencies: Had an orders table: order_id | item_id | order_date | quantity | order_shipping_city Shipping city depends only on order_id (part of a composite key), not the full key β broke it into order_header + order_items (2NF). Way less duplication.
1
0
0
Example I worked through: I took a students table that had things like phone_numbers = "0801,0902" in one cell. Normalized it into a students table + a phone_numbers table so each value stays atomic (1NF).
1
0
0
Quick update on my @freeCodeCamp relational DB track β spent today digging into normalization and finally seeing why it matters once you start modeling real data.
1
0
6