What is difference between functionality of laravel throttle and captcha?

https://laravelvoyager.com/

😒
do you usen’t social media ever ?

following id means people that i follow
follower id means people that follow me

i found solution for solve this proplem

Are you live in Iran

first i get array of users id that follow me

$follower_id = array();
foreach ($followers as $follower) {
$follower_id[] = $follower->id;

}

then i used a single line to get paginated posts

$posts =Post::whereIn(‘user_id’, $follower_id)->paginate(10);

yes

Too

do you usen’t ?! is this a brand new language ?

vividly :)))))))

What

he didn’t understand what i want man

no body can understand you with this awful language dude , you need a good english course 🙂 and a good laravel course too

this crucially exploits the fact of using English for dummies, per se

hum that makes sense

but I did understand him and I’m not English native…

Imagine someone has 10k followers, this code would be pretty heavy for DB. I’d avoid using count like this but use belongsToMany to get users following the current user and then use Eager Loading to load all the posts

first i was try for eager loading
but it returns all posts from followers
🙄

you can select only N posts for each user

$limit = 10;
$user->with([‘followers.posts’ => function($query) use($limit) {
$query->limit($limit);
}]);
If that is what you need

i gonna get paginated posts

and eager loading doesn’t provide this goal

Did you try use QueryBuilder + join?

no i just tested eloquent

can you write a example please ?

User::getQuery()->join(‘followers’, ‘users.id’, ‘=’, ‘followers.user_id’)
->join(‘users as followee’, ‘follower.followee_id’, ‘=’, ‘followee.id’)
->join(‘posts’, ‘post.user_id’, ‘=’, ‘followee.id’)
->paginate(10)
Smth like this, I believe

has it better performance vs my code ?

It forms one request and filters all data on the DB in single query, so it should has better perfomance (+ you could speed it up with indexes)

join table isn’t heavy load?

select (…) where id in ( /* over100500 IDs*/) is much worse

you could fill your database with a lot of posts and use
Db::listen(function($query) {
dump($query->sql, $query->bindings, $query->time);
});
to check which query takes more time to execute

thank you so much alex
for sharing your experience

always welcome)
Btw, that is a good practicle to EXPLAIN queries, you could see how it exactly executes the queries

recently i used elastic search
for a big project

if mysql doesn’t provide good performance i should use it

Does anyone know what’s the problem here?💔

This is a query exception, you are trying to insert the same record on a column which has the unique constraint, handle the exception with a try catch also validate the inputs using Validator facade in laravel.

the error is “table is read only”, not like “unique constraint”

Btw, this is a “google me” problem:
https://stackoverflow.com/questions/9575914/table-is-read-only

Gmt

you are right!, i saw it wrong

I suggest you to go with QueryBuilder as it has good performance then Eloquent. But if you want clean code then Eloquent is best.

Hello guys
what is difference between functionality of laravel throttle and captcha? doesn’t both do the same thing?

You can use something like this:

$user->with([‘followers.posts’ => function($query) {
$query->paginate();
}]);

In simple words, Throttle is for limiting the request and captcha is for validating the request.

You can say that both have similar purpose, to protect your app from DDOS attack. But captcha prevent before making requests and throttle after making request.

tnx

Throttle could be also used for API requests, captcha cannot.

+1

Anyone have project for freelancing?

ext-json is missing in composer.json less… (Ctrl+F1)
Inspection info:
Reports usages of classes/functions/constants from php extensions which are not specified in composer.json