Ope | Backend First

Flutter Developer | Django Backend
Building. Learning. Improving daily.
Open to collaboration.

[Ope | Backend First @lastissa]

@kapilansh_twt Readability.
I dont want to cause a second headache to myself when i have to debug

[Ope | Backend First @lastissa]

@ashuuu_soft Still finding footings here
Nice to meet you

[Ope | Backend First @lastissa]

@ThorCommerce Thank you.
That is been considered too as before any visitation
Live chat will be on the site where potential renters can converse with owners about availability and hidden clause

[Ope | Backend First @lastissa]

This is exactly the reason why i am building "padiplace".
A house hunting platform where landlord upload house, people can find it, no agent in between wahala.
Government Id verification added to avoid spam.

Still currently in development but i hope to releease it by month-end

[De Liberty @Mikeliberation]

Last year, when I was looking for a house, an agent told me that the inspection fee was ₦20,000.

Because I was in urgent need of a house, I agreed. The agent told me it was a one-time payment.

Two days later, he called and said he had found a house. I went to inspect it to see if I liked it.

After checking everything, the house did not meet my expectations.

I told the agent to find another place, and he said I would have to pay another ₦20,000 inspection fee.

According to him, the ₦20,000 I had already paid would expire once I inspected a house, and I would need to pay another ₦20,000 to inspect a different one.

[Ope | Backend First @lastissa]

+ features
* In app chat
* Rating ; so people can know who they are dealing with at a glance
Even though my main motive for building this is students agency fee for off campus at #unilorin is too high and unregulated, i plan for extend it to normal people usage

[Ope | Backend First @lastissa]

Explain each aspect publicly , what it foes and why decision driving me to choose flow

So help me God

[Ope | Backend First @lastissa]

In software development, There is a clear difference btween building to solve problem and building to understand,
This is sometimes call the learning doom loop and i have been doing more of the later than the former. understanding and using backend concepts like:

-> Pagi...

[Ope | Backend First @lastissa]

Everyday, build an aspect of this project, maybe teacher onboarding, or "who can do this or that", chosing between session(i knew you because you are in my database ) or using statles token ( i dont remember but let me see the band i gave you last time)

[Ope | Backend First @lastissa]

TWO PROPOSED PROJETCS
(2) A full web application to solve the problem of finding hostel for student and also owners to post about their house. My main target being in area where i leave, tanke Ilorin

[Ope | Backend First @lastissa]

TWO PROPOSED PROJETCS
(1) A multi tenant school management system api where multiple school can use the same api concurrently without data mixture, or every knowing they are on the same api

[Ope | Backend First @lastissa]

Today i decided to escape the learning loop doom.
Build to solve problem while also enhancing and solidifying my knowledge

Two proposed projetcs

[Ope | Backend First @lastissa]

Middleware ( a Middle man between the server and incoming request, used to validate or perform some action before the request get to the bussiness logic, think of it like a general bouncer)

[Ope | Backend First @lastissa]

DB limitations ( postgres can allow Unique keys to be null but sql doesn't allow it though both are relational)

I hit this prob when trying to create a field that must be unique but can be null, my development DB was sql and it kept raising error if i try to create a data row

[Ope | Backend First @lastissa]

Rate limiting(used to reduce the amount of request that can be made to an endpoint)

Returns a 429 status code.
Imagine an hacker tryinf mix of password, eventually he might hit the right one but with rate limiting, he will get a short ban.

[Ope | Backend First @lastissa]

-> Caching (a quick short term memory reducing constant database hit)

Best used for a data that does not change frequently, imagining Whatsapp statu hitting the database constantly just to check "is this user online?" For a million user? Another database crime!!

[Ope | Backend First @lastissa]

Role validation ( who are you and what you can do)
This checks for access attached to a user and help filter what user can do or returns a 403 status code if permission is denied.

401 status code if it does not even know who you are at all

[Ope | Backend First @lastissa]

-> Pagination(istead of sending all data at once, send it little by little)
Help solve problem like e commerce feed for product with unlimited products, imagine having to send all the products at once for a project with a million catalog...

[Ope | Backend First @lastissa]

...that will be a database crime, istead the products are send little by little , maybe 20 first snd when user scroll to a certain extent another 20 is fetched, this is how pagination works.

[Ope | Backend First @lastissa]

THE DATA ITSELF, i stil have to run ONE MORE QUERY TO GET THE ACTUAL CONTENT OF THE KEY and for 10 datas, thats 10 extra journey putting me in a worse situation that i initially was.

To fix it, i make use of JOIN

[Ope | Backend First @lastissa]

People do say information is everything but until we actually need them , we just won't know THEY exist.

This bring me to a knowledge i learnt today that i did not kow it existed as a problem

N+1 QUERY PROBLEM

OPEN THREAD

[Ope | Backend First @lastissa]

... Meaning i still have to do one extra journey to get the real data with that key

That journey is called N+1 QUERY

Where i had a problem was TABLE A retunes a list with 10 data each having name, class, user AND SINCE USER IS A KEY NOT...