Posts by Maniero • 444,682 points
6,921 posts
-
10
votes1
answer100
viewsA: Amount of index influence on performance?
1 - Create multiple indexes, taking into account the Where (E.condicao = '1') AND (E.situacao != 'desativado')... I put in the Github for future reference. Does it influence performance? (Beyond…
-
3
votes1
answer75
viewsA: Wrong Linq expression when avoiding repetitions on a List
The code is confused and seems to have conceptual errors, but I believe you want this: set { player = value.Where(x => !player.Any(y => x.NickName.Contains(y.NickName))).ToList(); } I put in…
-
8
votes1
answer177
viewsA: What is Type Annotation?
What is Type Annotation? Technically it is every syntax that a given value or variable or other location where there may be a value has its type explicitly defined. The term is mostly used in…
-
7
votes1
answer109
viewsA: Is it feasible to migrate from long to Guid?
Are you sure that the long will burst? There are 18 quintillions, if you only store it and nothing else will be hundreds of exabytes occupied, or millions of Hdds of the largest that exists only for…
-
3
votes4
answers1004
viewsA: What are the batch commands/variables. Example [%username% or %groupname%]
It is not possible, because in the same way that in a code anyone can create variable, then even more so, then there are unlimited variables depending on what you are using. The batch is just an…
-
3
votes1
answer84
viewsA: Return malloc to pointer does not stay between functions
Exactly, you went through b as a pointer, only b is already a pointer, so you are passing the value of b of main() for the parameter b function. You can manipulate the contents of this pointer, but…
-
2
votes1
answer54
viewsA: Performance between index() and hashmap . get()
the get() of the map has complexity O(1) and the indexOf() of array has O(n) complexity, so you can’t even compare, so much the difference in performance, and switch to the array It will get a lot…
-
4
votes1
answer58
viewsA: Why does the conversion take place in the wrong way?
First, the data you are using is descriptive, that is, it is a text and should not convert to number under any circumstances, it is not a number, only coincidentally the text only has numerical…
-
2
votes1
answer92
viewsA: List as function input
Well, this code doesn’t seem to make much sense, but I imagine this is what you want: def media(x, y, z): return (x + y + z) // 3 lista = [7, 8, 9] media(*lista) Note that this particular example…
-
8
votes1
answer119
viewsA: How does PHP arrays work internally?
PHP has something called array associative and internally is some form of hashtable even, therefore it can have sparse keys, of different types of data and has complexity O(1) for almost all basic…
-
1
votes3
answers77
viewsA: Use of type="password" changes layout
The simple use of this control does not alter style, but as it is a different control from others input It may be that your style is not configured properly to handle this, the styling may not be…
-
1
votes1
answer72
viewsA: How do I get variable values out of a function?
I don’t guarantee that the code is correct, but I solved the problem by returning the value I needed. There were other problems. Note that you don’t even need a variable for what you were wanting to…
-
0
votes1
answer2108
viewsA: Notice: A non well Formed Numeric value encountered
When you’re doing $salario->salario = 2000 . "<br/>" is converting all the value into string and it is being stored in the variable. As there is a concatenation it will turn "2000…
-
5
votes1
answer75
viewsA: Does it matter to delete and create new lines or update old ones?
Of course it makes a difference, one thing is one thing, another thing is something else. Know that from the internal point of view Postgresql already creates a new line and creates another whenever…
-
5
votes2
answers204
viewsA: Is there any way to nest one for N times?
Yes, and no. It depends on what you want to do. If each level has its own characteristics, it has practically no way. It would have, but it takes so much work that doing it manually is easier and…
-
3
votes2
answers1446
views -
5
votes1
answer64
viewsA: Difference of use of immutable object in method argument or outside it
The difference is only that one you do not see and the other you see, nothing else. The difference is the method println(). nothing happens Wrong premise. at this time a Contradicts the premise. The…
-
2
votes1
answer1326
viewsA: Concatenate a string with number in Typescript
Unlike Javascript which has weak typing, Typescript does not allow automatic coercion of types that may bring problems in some circumstances, so the only way to handle values of different types is…
-
2
votes1
answer462
viewsA: "unsigned int" and "int," what’s the fastest?
It depends on the platform, but is generally the same. Use the unmarked types is more complicated than it seems and you should only use it if you really need it and understand all the implications,…
-
4
votes1
answer1214
viewsA: Is VBA object oriented?
VBA is actually the Visual Basic language and uses version 6, whose last release came out 20 years ago. VB is object oriented? They say yes (there are those who question), and indeed much of what is…
-
9
votes2
answers528
viewsA: Standard Builder design, why should I use it?
How would be the best way to apply this pattern? In general such questions are open and often directed by opinions. But I would say that it applies better by following a reliable source (already…
-
1
votes1
answer2833
viewsA: Conditional class relationship diagram
It has no problem to relate to more than one table at the same time, although in this case it is not at the same time, because it is conditional or relates to one or the other. Data structure is not…
-
2
votes2
answers803
views -
2
votes2
answers60
viewsA: Do I need to omit the word "window" when calling a function of the global object?
This is not good practice. Readable code is subjective, and will only be good for others if you are doing what they expect. So no one can say whether to omit or not, depending on what the team has…
-
2
votes1
answer43
viewsA: Alternatives to using transactions on Myisam
Not by a long shot. You can make a complex mechanism in the application to try to simulate this, but it’s extremely difficult to do it right, it takes a lot of work, you’ll have a huge loss of…
-
8
votes1
answer368
viewsA: What is abstraction and how does it influence the creation of functions?
First let’s take a look at the answer that defines What is an abstraction?. Much of the question is already answered there. What in fact would be this abstraction and how can I apply it? The summary…
-
5
votes2
answers1584
viewsA: What are http-equiv="Pragma" and http-equiv="Cache-Control" goals for?
Every time we see pragma in technical things it means that there will be something that is dependent on implementation, ie, each implementor of the specified technology can use that as you want and…
-
6
votes1
answer319
viewsA: Remove element from the list in C#
The method RemoveAll() exists to pass a condition so will remove all elements that meets a certain condition, is not to erase all of truth. He’s actually pretty inefficient, but if that’s what you…
-
6
votes3
answers144
viewsA: Is there any way to pass the parameters to a constant function?
It has some forms, but it doesn’t seem to be quite what you want. I am assuming that you can and will change the function to work with a different parameter than you currently accept, even if it is…
-
10
votes2
answers828
viewsA: Parametric polymorphism and overload in Java and C++
The right one is the same. 1 - What is the difference between parametric polymorphism and overload polymorphism?) Behold Overload method is polymorphism?. And + 3 overloads - What would that be?. I…
-
2
votes2
answers175
viewsA: Setters in an array
I started answering and am posting initially not to miss the long answer, but I realized that the question is in unanswered condition, I will delete if it is not possible to keep. Do not consider…
-
18
votes2
answers124
viewsA: How to read the Git help manual?
Everything between brackets is optional (remember that the brackets themselves are not part of the syntax, it only exists to indicate this in the documentation), you use only if it makes sense for…
-
4
votes2
answers104
viewsA: I want to understand how the instance variable and the local variable of the parameters works
The terms are misused in the question. There is the instance variable, the class variable, and the local variable, in addition to the parameter which is actually a local variable which is…
-
2
votes1
answer361
viewsA: Use of routes at the frontend or backend
False dichotomy, because routing in one or the other exists to route what is in that layer, the fact that it has used in one layer does not make it unnecessary to use in another, of course, as long…
-
8
votes1
answer146
viewsA: What is the purpose of the keyword "export"?
What is the purpose of the keyword export? Knows public of other languages? That’s basically it. For some reason Javascript chose to use this, and Typescript adopted it, before JS made it official,…
-
4
votes1
answer511
viewsA: Array[] in database, how to create and manipulate?
Only in Postgresql (among the best known) you can do this and even then you will go through some adaptation before recording or retrieving information. In any other database you will have to create…
-
4
votes2
answers63
viewsA: Random numbers appear later in sorting algorithm
There are several problems in the code. The main thing is that it is giving a scanf() in item 10 of array, which is not even an element that exists inside it, and picks up junk in memory. It goes…
-
8
votes1
answer347
viewsA: Using "bytes" and "bits"
A bit (Binary Digit) is the smallest unit we can find in the abstraction of computation. Computers work with pulses (all of which have been in real use since the end of World War II are electric)…
-
8
votes2
answers210
viewsA: Improve function performance that determines whether it is palindromic
Not only is this code not idiomatic C# (it seems to be written in another language), it does a lot of needless things, including memory allocation. The main change is not to allocate a new object…
-
10
votes3
answers229
viewsA: Why is an anonymous function seen as an object in PHP?
Introducing It is discretionary of each language to define how to organize its entire structure, that is, each one does as it thinks works best for it. It would be possible for all data to have only…
-
22
votes1
answer415
viewsA: Does it still make sense to use the Desktop Metaphor?
I don’t have a lot of groundwork because this kind of thing doesn’t have a lot of grounded theory. UX is a lot of observation and experience, using the acquired knowledge base to make decisions. And…
-
7
votes1
answer90
viewsA: How do I know my function is breaking SOLID POO?
Studying a lot, but a lot. This is the "trick". These things are taken as cake recipes by many and just follow that everything will be fine, but it’s not like that. People do it wrong all the time…
-
7
votes1
answer70
viewsA: I’m getting None in output
Has a print()within the input() and it doesn’t make sense. So it works normal: l = [1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89] num = int(input("Choose a number: ")) new_list = [] for i in l: if i <…
-
6
votes2
answers224
viewsA: Delete string until it reaches the character and ":"
In your code there is no reason why you remove anything, nor is it possible in standard C# code. You take another part of the code. You can take it from the current position until the end. But do…
-
10
votes1
answer382
viewsQ: What is and what is a Bloom Filter for?
I was reading an answer here at Sopt (yes, it’s funny) and I saw about Bloom Filter, I wanted more information about him. Besides what it is and what it’s for, where I can use in practice?…
-
1
votes1
answer40
viewsA: Recursive binary search, but this error appears:"expected Primary-Expression before 'int'"
When you will call a function you cannot declare the variables there as you do with the parameters. Do: BuscaBinariaR(vetor, 0, 9, x); I put in the Github for future reference. He looks like he has…
-
30
votes3
answers1494
viewsA: Why is Python so current?
I noticed that the world’s leading sites (Google, Facebook, Youtube) False premise. Can use punctually for some script or some code that the responsible team thought it should use, but they are not…
-
8
votes3
answers150
viewsA: Two equal programs providing different outputs
Because the codes aren’t the same, they’re very different. In your code you’re adding a with b, only just before you said that a is the same value as b, so in practice you’re always adding up b,…
-
3
votes2
answers552
viewsA: Changing character values in C
It has to do with the fact that the ASCII table goes up to 127 (not 125). When you exceed this value you start printing the values of the extended tables. In fact the problem seems to be even more…
-
3
votes2
answers108
viewsA: Does the use of the "alias-assignment" '->' operation interfere with the performance of the application?
Only one correction: in the descending languages of dBase II :) xbase calls. Clipper is already descending. Originally dBase II had a very simplified language with syntax that reminded a little…