₦airaland Forum

bassdow:
I love it when I ses women in these field.

You seem to know whAt you are doing (that's if you didn't do Copy & Paste).

Women are not so much in tech, thats true. But I feel the comment about copying and pasting is very inappropriate...

DanielTheGeek:
Even YouTube was shitty at some point, it started out with PHP and now runs on Python, Java and Go with BigTable and MariaDB as databases of choice.


Note: YouTube's switch over from PHP doesn't mean a YouTube kinda site can't survive on PHP. There's HHVM, and stats show that Facebook is nearing YouTube on video uploads and playbacks.

Wow. Didn't know Youtube, started out with PHP. I wonder why they switched. Language inconsistency maybe.

Well, it seems the OP has learnt enough to last him a year. If there are any specifics, please ask, I'd be more than glad to give my input.

DanielTheGeek:
Nope, think of your user base..
Nice write up, I only disagree with the listing of MyIsam/InnoDB as database types, those are database engines not types.

Welcome to Nairaland @bearnana

I think I mentioned that MyIsam/InnoDB are database engine types.
If you don't consider your codebase I wonder how developers would work on it to manage better performance.

Thanks for the welcome.

Do you want to block the computer's access to your database or you want to block the user after three failed attempts??

If you want to block the computer:
1: Get the ip of the system
2: Store the ip in an ip table
3: The ip table should have a row for number of access time
4: Increment the number of access time if the the computer enters a wrong detail
5: If the number of access time is more than 3 do something.
(I don't see why you would want to do this)

If you want to block the user, I am assuming that the username is correct but the password is wrong
1: The user table should have a row for number of access time
2: Increment the number of access time if the the computer enters a wrong detail
3: If the number of access time is more than 3 do something.
(I don't also see why you'd do this because any body could have anybody's username and try to enter it three times)

I don't think scalability of applications is much about performance.

Its more about how to manage, if a lot of hands were to get on deck.

To explain my point I'd share a personal experience since you are talking PHP:
I worked on an application where the devs who handled the code before used procedural and the client wanted to build a Software Department to manage the application. It was difficult to understand the application and the variable types the devs before had done. So we were tasked to build the application from ground up in a very short space of time.

Some rules I have learnt in my short time on this coded planet.

1: Your application won't scale if it wasn't designed to scale. i.e. Don't use procedural if your application would one day have a very large number of users and would have a software department.

2: Simple Architecture is good if you are starting i.e Try to optimize your code base for speed (this is different fro performance; your code performs and your code performs fast are two different things. Every codebase is designed to perform, not all codebase is designed to perform fast...)

3: Think about database type. Since you mentioned LAMPP, I am assuming that you are using MYSQL for backend. It may not be as important as the first two rules when starting out but you would have to consider database engine type ISAM, MyISAM, InnoDB.

These are the ones I can think off the top of my head. The other ones are when you have reached about 500k users. You might want to think of load balancers and redundant firewalls, maybe more webservers for performance. By then you would also have to factor splitting your database read and writes. Before you get to this stage, there should be enough money to hire me to help you out...

But first off, if you are thinking of scaling at this early stage, THINK OF YOUR CODEBASE!!!

Whats wrong with people and learning how to code "the fast way" You CANNOT learn programming in 6 days!!! Its practically impossible. Even if you were a savant, you would have to implement what you have learnt and there is a huge mountain of logic that you would have to conquer.

My apologies to the OP if 'I have spoil market'...