Merging features in PostgreSQL
Joining lots of small polygons to form larger polygon using PostGIS?
This question is about the net speed.  I'm from China, and I find that opening pages on Stack Overflow is very fast, normally within a range of 1 to 4 seconds. This speed is very good for a website outside China; it's even faster than some native websites.  Not every website outside China has such good speed, so I am wondering why and how Stack Overflow manages to be so quick. How to reset or recover admin account password for MySQL? I have a MySQL database that I "inherited" and I was not given the admin credentials.  I do however have access to the box that it runs on.  Is there a way to either recover the admin credentials or create new ones? I want to set a folder such that anything created within it (directories, files) inherit default permissions and group.    Lets call the group "media".  And also, the folders/files created within the directory should have g+rw automatically. Is there a public API for Stack Overflow? How can one prove the statement $$\lim_{x\to 0}\frac{\sin x}x=1$$ without using the Taylor series of $\sin$, $\cos$ and $\tan$? Best would be a geometrical solution.  This is homework. In my math class, we are about to prove that $\sin$ is continuous. We found out, that proving the above statement is enough for proving the continuity of $\sin$, but I can't find out how. Any help is appreciated. Using mask as a garbage matte to hide an object I'm trying to use a mask to hide a part of a render layer, so that when the render layer is shown over a movie, some parts in the movie will appear to be in front of the render layer.  For example, assume I want to add a box to this image, so that it would look like it's behind the person:    I created the following simple object:    If I render the object, it looks great - the object is solid, everything else is transparent (I didn't use any 'sky'):     Now I create a mask to describe the standing person (or at least the part that would otherwise be covered by the box):    What I want now is to create a "hole" in the rendered box, so that when I use Alpha-over, the box look as if it's behind the person, but I can't find an easy way to do that. My first guess was to use 'Set alpha' to apply the mask (inverted) as an alpha for the rendered layer, but this doesn't look good:    The mask did create a "hole" where it should, but now all the other pixels are not transparent. How can I "retain" the transparent pixels while setting more pixels to be transparent based on the mask (use it as a matte)?  Note: I can do this with (I'm ashamed to say) some math work on the alpha channel, but it just doesn't seem right:    Thanks, and sorry for the [oh so] long question. The bounty I offered on  is now in its grace period and the information box tells me:     you must award this bounty as soon as possible   But there are no answers - what do I do? When doing an apt-get update/upgrade I see that warning  W: Conflicting distribution: https://downloads.plex.tv/repo/deb public InRelease (expected public but got )   I was upgrading to Ubuntu Zesty 17.04 before and do not know how to fix the above. Already have seen ? but there are no suggested fixes for that.  Maybe one of you can give some hints? Thanks! I'm having some trouble understanding cosets.  If I understand it correctly, cosets form a partition. So, if I have $|G:H| = 2$, then $G = H \cup xH$. Right?  In an exercise, I'm asked the following:  "For $G$ group and $H \le G$ such that $|G:H| = 2$, prove that $x^2 \in H$ for any $x \in G$"  If $x \in H$, then $x^2 \in H$ because $H$ is a group. But, if $x \notin H$, then $x \in gH$ for any $g \in G$, right? Then $x^2$ = $(gh)^2$ but I can't see why this is in $H$.  Can you give me some hint? Thanks for stopping by. When is unbalanced data really a problem in Machine Learning? We already had multiple questions about unbalanced data when using , , ,  and a number of other similar questions, what makes it a very popular topic! Unfortunately, each of the questions seems to be algorithm-specific and I didn't find any general guidelines for dealing with unbalanced data.  Quoting , dealing with unbalanced data     (...) heavily depends on the learning method. Most general purpose   approaches have one (or several) ways to deal with this.   But when exactly should we worry about unbalanced data? Which algorithms are mostly affected by it and which are able to deal with it? Which algorithms would need us to balance the data? I am aware that discussing each of the algorithms would be impossible on Q&amp;A site like this, I am rather looking for a general guidelines on when it could be a problem. Is it possible to raise stats? How can I determine the list of files in a directory from inside my C or C++ code?  I'm not allowed to execute the ls command and parse the results from within my program. The set that only contains itself Current code is:  \begin{enumerate}[label=LEVEL \arabic{*},leftmargin=*]     \item Description of Level 1 \quad L1 \\ \emph{more text}     \item Description of Level 2 \quad L2 \\ \emph{more text}  \end{enumerate}   but the \quad does not align L1 and L2 uniformly vertically. I want to replace \quad with a tab but the tabbing environment does not allow mixing with an enumerate! How to filter string for unwanted characters using regex? Is there a word for someone who won't think critically? Is there a word for someone who won't think through issues and instead comes to others hoping that they will think for them and solve problems for them?  A word that is more specific to a lack of critical thinking skills than "lazy"? ${\rm Aut}(G)$ is cyclic $\implies G$ is abelian I would appreciate if you could please express your opinion about my proof. I'm not yet very good with automorphisms, so I'm trying to make sure my proofs are OK. Proof: Since ${\rm Aut}(G)$ is cyclic, ${\rm Aut}(G)$ is abelian. Thus for any elements $\phi, \psi \in{\rm Aut}(G)$ and some elements $g_i \in G$, $\phi\psi(g_1g_2)=\phi\psi(g_1)\phi\psi(g_2)=g_3g_4=\phi\psi(g_2)\phi\psi(g_1)=\phi\psi(g_2g_1)=g_4g_3$. Hence, $g_3g_4=g_4g_3\implies G$ is abelian. The proof seems to be quite straightforward, but I'd rather ask for advice. I have some questions about a suspended user's earning and activity.   Can suspended users get reputation back after the suspension period? If a user is suspended for 7 days and he/she earns reputation during this period. Then will it be calculated after completing suspension period? If a suspended user has awarded a bounty to other user and the awarded bounty marked as illegal. Then will that bounty rolled back to their account?  Can suspended users get any alert from comments or chat room using @username method? Can suspended users post comments on his/her question/answer? If another user replies or ask a question on suspended user's post. Then, can a suspended user give response back? Why are the Ringwraiths fearful of coming into contact with water? At least twice in The Lord of the Rings: The Fellowship of the Ring, Ringwraiths cower away from bodies of water.  The second time (the ford of Bruinen) can be explained away by their fear of some Elvish magical trap through the enchantment of the water; but what about the first time, at the ferry? One of the Nazgûl could have easily made the jump onto the barge and quickly dispatched those pesky Hobbitsses. How do I get the deformed coordinate of a vertex with Python? How might someone find the deformed coordinate via Python or otherwise when using a subdivision modifier with the 'show on cage' option?  For example, a subdivided cube with cage enabled and a vertex selected shows the location of the vertex at 1,1,1 but when manually placing the cursor near on the surface it is closer to .5,.5,.5  I know the vertex location needs to be at its non-deformed location for subdivision to even work but would like to get more accurate point locations at the surface without having to apply to mesh.