rsvb

Experience

7,220

5 Best Reply Awards

  • Member Since 3 Months Ago
  • 34 Lessons Completed
  • 1 Favorite

21st May, 2018

rsvb left a reply on Enterprise Applications • 1 day ago

You will need a lot of server capacity and peak load handling.

Defining Peak Load and Peak Capacity

Peak load refers to the maximum number of concurrent users and requests per minute that you expect the system to support, based on the pattern of activity that typically exists on your system. You may want your system to support a certain number of requests with a certain response time per request. This doesn't mean that your system can in fact handle this load: it might be able to handle the number of users, but only by processing their requests at a slower rate. If you decide you want your system to handle the maximum number of concurrent users that typically access the system and submit requests, you may have to add server resources to achieve the desired response time. You may, instead, decide to use another design point, steady state load, which is explained on page 61. Whether you choose peak load or steady state load as your system capacity design point depends on several factors, including acceptable response time, all of which are described later in this chapter.

Peak capacity refers to the maximum number of concurrent users that the system can realistically sustain before requests per minute start to decline and response time starts to increase. Peak capacity may be more or less than peak load, and knowing the difference is critical to planning your system. You may find out at first that your system cannot handle the peak load. However, if you use peak load as a design point, you can do things to adjust aspects of your system and bring peak capacity to a level that is acceptable for your enterprise.

18th May, 2018

rsvb left a reply on 1366 Incorrect String Value, On CSV Import To MySQL DB • 4 days ago

Perhaps you use a php str function, you should use mb_str.

http://php.net/manual/en/ref.mbstring.php

rsvb left a reply on 1366 Incorrect String Value, On CSV Import To MySQL DB • 4 days ago

Can you save é in the table column? If yes the column is okay, if no you should change the column collation.

15th May, 2018

rsvb left a reply on Socialite Hitting 404 Page • 1 week ago

Route::get('login/{social/callback}', 'Auth\[email protected]') ->where('social','twitter|facebook|linkedin|google|github');

should be

Route::get('login/{social}/callback', 'Auth\[email protected]')
            ->where('social','twitter|facebook|linkedin|google|github');

rsvb left a reply on Install Maatwebsite/excel Package Without Composer • 1 week ago

Best practice is :

  1. backup webserver .
  2. download laravel from webserver.
  3. run composer local.
  4. upload laravel to webserver.

10th May, 2018

rsvb left a reply on Running Scheduler Another Way Other Than Cron? • 1 week ago

I delete the mail in mail folder.

8th May, 2018

rsvb left a reply on Laravel Socialite - Facebook - User Access Token Changes • 2 weeks ago

This means that every 90 days you must send a person through the Facebook Login process, and the person must agree to specific data permissions by tapping the “continue” button.

7th May, 2018

rsvb left a reply on Default DB: MySQL - Need To Sync With SQL Server • 2 weeks ago

I make 1 stored procedure in mysql, very easy. It is best to do the action as close as it can be, in the database itself.

6th May, 2018

rsvb left a reply on Web Development Became Too Complex • 2 weeks ago

Web development is way way way way etc. too too too complicated.

1 very positive point : one app serves all.

5th May, 2018

rsvb started a new conversation First Things First Lol • 2 weeks ago

First of all, you need to know how to search the Internet, which most of askers obviously have no idea how to do. Knowing where to look for answers is the first skill you need as any kind of developer, front-end, back-end, mobile, sysadmin, whatever.

rsvb left a reply on RAW Queries And SQL Injection • 2 weeks ago

You should to see :

AND data.id = "218 OR 1 = 1" so no injection but a search string.

4th May, 2018

rsvb left a reply on RAW Queries And SQL Injection • 2 weeks ago

The important thing here is that the parameter values are combined with the compiled statement, not an SQL string. SQL injection works by tricking the script into including malicious strings when it creates SQL to send to the database. So by sending the actual SQL separately from the parameters, you limit the risk of ending up with something you didn't intend. Any parameters you send when using a prepared statement will just be treated as strings (although the database engine may do some optimization so parameters may end up as numbers too, of course). In the example above, if the $name variable contains 'Sarah'; DELETE FROM employees the result would simply be a search for the string "'Sarah'; DELETE FROM employees", and you will not end up with an empty table.

Very simple.

3rd May, 2018

rsvb left a reply on Authentication Scaffolding • 2 weeks ago

Username / password is not very secure. For really secure you should add a 3rd check.

rsvb left a reply on Updating 150,000 Records Is Timing Out - Can't Find A Solution • 2 weeks ago

UPDATE cart JOIN (SELECT @no := 1000) r SET Number=@no:=@no+1;

rsvb left a reply on Updating 150,000 Records Is Timing Out - Can't Find A Solution • 2 weeks ago

set_time_limit(0); 0 = unlimited

rsvb left a reply on A Medium Size Website With Laravel Vue • 2 weeks ago

Never use tools the client wants, the client is complete ignorant about computer software.

rsvb left a reply on Adding New Fields To User For Registration • 2 weeks ago

In the database there should be a default value if the column can not be empty.

2nd May, 2018

rsvb left a reply on What Framework / Template For A Webapp With Idea To Convert To Native App? • 2 weeks ago

Most popular front-end frameworks used for developing generic designs that facilitate rapid prototyping these days are Bootstrap, Skeleton, and Foundation. Among the three, Bootstrap handles the lion’s share leaving Skeleton, and Foundation somewhat a mile distance

1st May, 2018

rsvb left a reply on Hosting On Shared Server Best Practice • 3 weeks ago

Now another thing, in case you do not have local, is the default install 100% right on a webhost?

rsvb left a reply on Hosting On Shared Server Best Practice • 3 weeks ago

Why should the webhost setup be different from the local setup? They should be the same in my opinion. Then this question would be history lol.

30th April, 2018

rsvb left a reply on Hosting On Shared Server Best Practice • 3 weeks ago

The easiest way for me is 1:1 webserver : localserver.

rsvb left a reply on Laravel Socialite Not Completely Destroying Session • 3 weeks ago

You should login into another facebook account on your device.

26th April, 2018

rsvb left a reply on Auth::attempt() Not Working When Connecting In Laravel With Facebook • 3 weeks ago

You must login user

auth()->login($user, true)

24th April, 2018

rsvb left a reply on How To Send Mail Using Gmail Account • 4 weeks ago

It can be done, but it is a big hassle. I could not find 1 pages with clear instructions.

23rd April, 2018

rsvb left a reply on Eloquent Typecasting To Nvarchar(4000) • 4 weeks ago

A php string should match the mssql column type, i think nvarchar is the correct type, but now it will not use the varchar index.

rsvb left a reply on Auth Login With Custom Fields • 4 weeks ago

You do not need a password when you use facebook as authentication.

rsvb left a reply on Development Setup • 4 weeks ago

I develop on the webhost. One flaw, I must upgrade local ( with composer ).

22nd April, 2018

rsvb left a reply on Is One User Table Enough? • 1 month ago

I added colums in user table.

Auth::user()->addedcolumn gives the value.

21st April, 2018

rsvb left a reply on How To Use Laravel Passport For Web Authentication? • 1 month ago

The Auth facade has the user properties. Only authenticated users should be capable of getting the application pages.

19th April, 2018

rsvb left a reply on Create A Job To Run Every Second • 1 month ago

while (true) { process the rows }

will never stop, set_time_limit(3600) will stop after 1 hour, so you need to start the cronjob every hour and you have a stop.

18th April, 2018

rsvb left a reply on Create A Job To Run Every Second • 1 month ago

What it has to do with job running?? You must proces unprocessed rows, continuously.

14th April, 2018

rsvb left a reply on Many Routes In Web.php • 1 month ago

It would be nicer to put all config params in a database, but I like databases and do not like all that distinct config files.

13th April, 2018

rsvb left a reply on Coverting MS Access Queries To Laravel Query Builder • 1 month ago

DB::select

9th April, 2018

rsvb left a reply on Where To Go ? Laravel Or .NET Core 2 • 1 month ago

Biggest problem for companies with php is that you can not get a php certificate.

counterpart of this https://www.microsoft.com/en-us/learning/mcsd-certification.aspx does not exist by my knowledge.

4th April, 2018

rsvb left a reply on Is There Any Usefull Official Documentation (with Proper Explanation) About The .env Parameters? • 1 month ago

There are 5 app params and 6 db params. the db params are the same as always, so what should be documented?

rsvb left a reply on Sum Of Total Row Data In Database Table • 1 month ago

You must make an attribute in the model which is the sum of the columns.

public function getTotalAttribute()

return this->class_000 + this->class_100 + etc.

3rd April, 2018

rsvb left a reply on How To Use Always Encryption In Laravel With Sql Server • 1 month ago

ColumnEncryption = Enabled, don't know if this will fix, maybe.

2nd April, 2018

rsvb left a reply on Is It Good To Learn Laravel 5.1 As A Beginner? • 1 month ago

5.1 is 2 1/2 years ago, that is a long time in web terms.

1st April, 2018

rsvb left a reply on Laravel Composite Index Issue • 1 month ago

In mysql you can create an index and specify the length, so you keep the info in the column, but truncate it in the index.

27th March, 2018

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format • 1 month ago

Yes, i can update the query in mysql with no problems.

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format • 1 month ago

Eloquent gave me more misery, I'll stop with it completely.

Not suitable for professional development.

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format • 1 month ago

As you can not read null is correct as value for an integer. It should not give an error, and it happend before, so this is interesting.

rsvb left a reply on SQLSTATE[22007]: Invalid Datetime Format • 1 month ago

"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'NULL' for column 'tb' at row 1 (SQL: update ac set tb = NULL

NULL is correct for the database, but not for Eloquent. Not nice.

25th March, 2018

rsvb left a reply on UpdateOrCreate Duplicates? • 1 month ago

I would not use it.

I use mysql INSERT .... ON DUPLICATE KEY UPDATE

21st March, 2018

rsvb left a reply on Store Data Until The Submit Button Is Pressed As Temporary • 2 months ago

I'm used to a pile of a mess when it goes about internet and js and data jajaja.

rsvb left a reply on Store Data Until The Submit Button Is Pressed As Temporary • 2 months ago

To store in database you need jquery.

rsvb left a reply on Store Data Until The Submit Button Is Pressed As Temporary • 2 months ago

when you type in name, you go to next field address, so you leave field name. then you can save field name in the database, and you must do it after every field. You do not save the form fields on click submit, but after leave field.

<script>
function myFunction() {
    var x = document.getElementById("fname");
    x.value = x.value.toUpperCase();
}
</script>
</head>
<body>

Enter your name: <input type="text" id="fname" onblur="myFunction()">

<p>When you leave the input field, a function is triggered which transforms the input text to upper case.</p>

rsvb left a reply on Input Facebook Data (Gender, Birthdate, Address And Bio) Into Database With Laravel Socialite • 2 months ago

You have only the FB authentication. Now you need to make FB API calls.

Edit Your Profile
Update

Want to change your profile photo? We pull from gravatar.com.