Quora uses mysql
Foursquare uses mongodb
Facebook uses mysql
And those are the biggest there is when it comes to database.
I mean if people can build something SO BIG with FREE databases.
Why do anyone need paid dbms?
Not to mention hundreds of other alternatives that I never heard about. If ...
@ypercube How long will you be in town for? We have a fold out bed that you're welcome to crash on for a few days. (+ we live quite close to Heathrow).
I am pretty new to Oracle database, and I am trying to set up a Data guard between two PCs.
First one runs Windows server 2008 R2, and the second is on Fedora.
Since Oracle version is 11gr2, it is, as far as I read, possible.
I followed many tutorials, and reached the step when I need to start t...
I'm not sure anything on MSO has fired me up as much as this stupid idea to ban snark (and the unfortunate, if controversial, traction it's had thus far)
So, the death of WSOIN was intended to help reduce the snarky comment level. I don't see any diminution of the volume of sarcastic comments added to weak questions. I don't write this to reopen the debate.
I used to be a fairly aggressive flagger of snark, but I got the sense (impossible to dete...
I just deleted What Stack Overflow is Not, a collection of various explanations for things that Stack Overflow doesn't do, wasn't meant to do, or shouldn't be used to do. Several people put a fair bit of time and effort into it, so I felt I should take a minute to explain my reasoning...
First I...
@BenBrocka Meta mirrors the real world - a lot of the people with high rep there have much lower rep in sites where questions exist (as opposed to questions about questions) - so excuse me while I don't interrupt my hard volunteer work to go read what the chattering classes have to say.
I'm developing a Facebook application which requires a leaderboard. Scores and time taken to complete the game are recorded and these are organised by score first, then in the case of two identical scores, the time is used. If a user has played multiple times, their best score is used.
The lower...
I have several clients who want to move their existing databases (SQL SERVER) to either the Amazon cloud, or Azure.
These are complicated systems built over several years. My instincts tell me this will be a nightmare. I was hoping there was somebody out there who actually did this and it was NOT a nightmare.
@datagod If it's just Azure infrastructure VMs it's a big difference than if it's on SQL Azure platform. Cloud != Cloud, unfortunately - it's a new twist on the 3-valued logic. Do they just want to host them in a more virtualized infrastructure or change platforms?
Yeah, the "Azure" name spans a variety of different products and terms.
@CadeRoux What's really annoying is when people move from MySQL to Postgres and say "POSTGRES IS INFERIOR - IT CAN'T EVEN DO THIS {{ insert egregious ANSI violation here }} !!!! MYSQL IS WINNAR"
@datagod Not me, my current client is on Oracle and 3rd party cloud is not terribly likely. However, the majority of their environment is now on vmware, so in a way, it's already a private cloud - just with limited blade servers to move the stuff around on and we know who's actually managing it.
@datagod Offloaded an LMS from a local ... ahem ... mysql instance to an AWS instance. It was painless. The codebase was complex, but we treated it as @Phil described. It was essentially a VM hosted somewhere else that I Linux admin'd - we just outsourced the hardware.
@datagod so it once again comes down to semantics. if it's just a straight-up database move to a VM hosted in someone else's data center, then meh. you'll have higher network latency, depending on the client, and you wont really be able to test your performance counters. other than that, should be seamless.
@swasheck There are so many common problems which SQL didn't adequately help to solve more easily than with standard recipes to work around them. One of these is the "GROUP BY/pick one according to these criteria" problem. SQL Server 2012 finally has some of these things like FIRST_VALUE which are actually ANSI SQL:2008. Getting people to think in terms of what you can ask about a set of aggregates in the first place is a problem which will never be solved.
@swasheck Focus is that way as well. It accepts things which it shouldn't and gives results which you can't particularly justify - this grouping issue and also rounding. In some respects CSS/HTML is like that because of implementation vagaries. And I think that is why I dislike working with those platforms.
@swasheck I think it's important for declarative systems to be predictable (do what I say), I know they won't be as deterministic as procedural languages (do how I say), but you have to have something you can rely on. Functional languages (strict, not Javascript) seem to have gotten it right pretty well, but then they aren't really that mainstream.
Sometimes I write my SQL like this for fun: SELECT * FROM tablename PLEASE
@CadeRoux I go to meta frequently, but I almost never answer or comment there (hence my 160rep there). It's because I've read other questions, answers, and the general response that they seem to have. There's just too many groups with the same opinion that make any other suggestions dissapear
They built a product which had value and a noble purpose and in opposition to crappy sites about sexchanges; a big part of the value is created by harnessing addicted users (who think everyone else is wrong on the Internet) with a voting game - but that doesn't make it a democracy. And Meta has just turned into a ruling class.
@Lamak I go there when something doesn't make sense about the way the site is working, to find out that this had been debated over and over and the Meta people had apparently decided on it to work a certain way.
@Lamak I guess activity on the primary sites vs. the meta ... do they show a trend (are rep and meta activity correlated)? are the primary influencers on meta high-rep users?
@Lamak It's like people telling you if you don't like the way a site works, to install a browser extension or greasemonkey - they'll never admit that designing a site takes some amount of directed vision - not voted/committee/democratic vision.
@CadeRoux But I still think that there is some directed vision. Moderators and really high-rep users carry with them the votes of "fan-club" users (I don't know how else to say it)
And there is some sort of "circle-jerk" (again, don't know how else to say it), where all users have the same opinion. Don't get me wrong, a lot of times I also have the same point of view, but still
@Lamak I think a lot flip over to spending more time in meta than asking and answering questions - people get caught up in the social part. Look at this chat room.
@CadeRoux I prefer being in the heap because i learn a lot more and i feel like i can toss things out there and let the experts shoot them down (troy: "CHOOT 'EM!!!") and i know the context of the correction.
@Lamak SO leadership all really seems so anonymous now - like Wikipedia. I expect it's reached a kind of critical mass and is unlikely to evolve as quickly any more.
and then something hit and i became an active visitor
(i'm closing FB)
i just dont feel like i am a worthy contributor - so i generally spend time here because i get to learn from folks like you and aaron and lamak and phil and mark and ...
I am used to Microsoft technologies including SQL Server. Today I ran across a Q&A where the following passage from the MySQL documentation was quoted:
Standard SQL would reject your query because you can not SELECT
non-aggregate fields that are not part of the GROUP BY clause in an
a...
Stealing the share bar used in beta sites, I have userscriptified this:
Add Share buttons to the "link" box
I may add more buttons if I feel bored (I'll need to dig up icons and all, though)
and as Quassnoi's answered, it offers slight improvements in performance and readability - when you know what you are doing ... (which is not usually the case with many MySQL programmers)
@AaronBertrand so the issue with the sock thing is that, for instance, we get a notification when someone starts mass deleting their own content (not comments, posts). So we can investigate and understand why.
They just want a similar notification that an account has been created. If lots of things match up, such as similar email names, similar style of comments/questions, then we can see rather quickly that this is likely a play to bypass
If there are lots of users from a company on the site, odds are pretty good that the users will have all been on about the same time. Rarely does one person make a fool of himself and encourage dozens of others (or even just one more) to sign up while he's being an asshole on the site.
There is room for it to affect "casual account creation during the suspension of another on the same broadcast IP" but it is unlikely and it's not sufficient to warrant not adding this flag.
The flag is merely a tipoff by an automated tool that something has occurred. The flag is not corrective action. The corrective action is a manual process instigated by a moderator, and we always accumulate evidence before we take action.
One thing that JNK and I have talked about is suspensions on Database Administrators. Until we've left comments, and tried to guide the user, we can't suspend them (the tools don't stop us, we stop us). However, when it's evident that they aren't trying, then we stop them.
So @AaronBertrand all they are asking for on meta is a way to automate finding that someone is likely up to no good, as I get notified already when someone starts mass deleting their posts (rage quit?)
@ypercube Errors - again I think you have to default to best practices. Just because experts need to do something occasionally, beginners using it accidentally incorrectly all the time is a greater harm - it encourages poor code making it into production codebases which just happens to work. Of course because it affects the entire session, the setting is not as convenient as it could be for the few times you want to except this.
@jcolebrand I never suggested that I thought any ban would be automatic. I just think it's going to be a lot of work to differentiate between a bunch of legitimate users behind the same IP block and ferret out the asshole. I up-voted the suggestion; my answer was just meant as commentary too long for a comment. Anyway I deleted my answer because it wasn't taken in the right spirit.
@AaronBertrand I know, but I wanted to explain in longer than a few comments why it's not a bad idea to flag them, regardless of the possible side-effects of the posts being flagged and everything be ok.
@CadeRoux: we agree then. The misuses of this are common I think. And they also lead to workarounds that as you say, just happen to work. And one never knows when they'll break.
So, I think that for the first time, I'm being spite downvoted. I got two downvotes at almost the same time on really old answers. Granted, they weren't very good answers, but one of them was the accepted answer and the other is clearly better than the upvoted one. Oh, well, maybe aptem got offended yesterday
I think that you need to modify the function SplitCSVStrings for this to work. Yo should make it so the table that it returns has one extra column indicating the position in the csv. For example, if the parameter is "C++, Java", the result should be:
id val
1 C++
2 Java
If you do that, then ...
I think that what you wanna do is to pivot your table; in that case, if you are using SQL Server 2005, you should try something like this:
SELECT *
FROM (SELECT FeeComponent, Amt FROM Trn_Clear) AS S
PIVOT(SUM(Amt) FOR FeeComponent IN ([A],[B],[C])) AS PT
In this case, I use SUM as your aggreg...
@Lamak Makes no sense - upvoted your answers. That second question needs reformatting and improvement. Both so old there's not much point in fixing them, though.
@CadeRoux Thanks. But, as you said, there really isn't much point on fixing those posts. And, looking at them again, they could be closed as too localized. I think that the part that gets to me is that on one of those posts, there is a non-answer as the most upvoted one
@ypercube Are you able to create fiddles now?. I'm still getting this error: Component [models.Schema_Def] has no acessible Member with name [STRUCTURE_JSON]
but I have recently discovered the reality of their differences, and have been bitten by them
heh
speaking of live support - once I finally get user accounts working, I want to introduce support for sharejs.org so that you could work directly with others on a given fiddle
so rather than having to send links back and forth, you could work out a solution immediately, together
@JakeFeasel I'm torn. Congratulations. I like seeing stuff like this succeed and I want you to be rewarded for your work. But I don't want some ridiculous corporation to come in and buy you out and jack it all up.
Its always so hard for me to explain something clearly in english
@Amrit - You don't seem to understand the problem. If dealId is the primary key, then its easier to explain. If the conditions that you put on your WHERE returns more than one row as a result (let's suppose that it returns 3 rows), then, since you are grouping by the primary key, you will have 3 rows with a count value of 1, instead of 1 row with the count value of 3. And of course, the result that you are getting can't be assigned to a scalar variable. — Lamak7 mins ago
i think that there are a couple of problems: 1) less significantly is that Amrit may also be a non-English speaker, 2) more significantly, Amrit has no idea how to use the GROUP BY clause
@Lamak that was actually me. i thought i was clicking on yours and then went off to edit. i submitted the edit and noticed that i'd upvoted charleh but my grace period had expired. so i upvoted your comment too :S
@JakeFeasel I don't like SE's either - because the other OpenId is kind of obscured in how you are supposed to use it. This one's problem is that you have to click away from the popup to see the remember me, and if you click again on OtherOpenId it blanks out the text box.
@AaronBertrand do you see the "Login" button in the top bar?
@CadeRoux The remember me checkbox is only obscured while the popup is active, and it's only active until you make a selection (right?). So... doesn't seem like a big deal
@CadeRoux with regard to the other open id option - I think it is supposed to blank it out, so that you can type in your own there. How else could / should it work?
@JakeFeasel I guess so - It did this on a blog I commented on today, so I assumed it was a widget. Tabbing out doesn't work, it tabs into the popup, I think. It's not a big deal - just not as clean as it should be (for something people are supposed to plug in to have a nice predictable login which works well for a lot of sites ;-))
@AaronBertrand I'm also using Chrome on OS X. Chrome seems to cache things pretty aggressively. I noticed that when my whole site as offline (thankfully briefly) I still had people showing up in Google Analytics as live hitting the site
I have something like:
SELECT a, b
INTO v_a, v_b
FROM (
SELECT x, y
FROM whatever
UNION
SELECT z, w
FROM something
) AS subquery (a, b)
Which of course doesn't work in Oracle (that syntax - apart from the INTO and the optional AS) would be fine in SQL Server (http://sqlfidd...
@JakeFeasel Browsing on tablets is still a toy to me because I don't have keyboards and mice on any of mine. It's really just using the browser as a rich text reader with limited input. I use it for search, reading, but without a real keyboard (with control keys), typing is tedious.
@JakeFeasel I don't find it any better or worse than Safari on the iPad. On the Mac, I switched to Chrome after Safari seemed to be getting buggier/slower. Firefox is a memory hog on every platform. I was pleasantly surprised when I tried Chrome again how much better it was on the Mac than the first time I tried it. Of course it helped that I had upgraded the mac mini to 8GB RAM. On the quad-core PC, it always screamed.
@JakeFeasel Haven't tried it on the iPhone - have to charge it up, because I moved to Android for daily use, the iOS devices are usually battery drained.
@JakeFeasel That's probably the cleanest thing which would show the intent so if someone comes in they won't clobber the first set - I'd have to make sure I get the data types right - that's something annoying about UNIONs. if the first set gets removed, then it would need to be shifted to the second, etc. I'm concerned about lifecycle of the code
@JakeFeasel The way SQL Server does it is just too damn nice, since the table alias is outside, having column aliases outside makes it all quite modularly clean.
@JakeFeasel I hate the way I've been spoiled with SQL Server
Quora uses mysql
Foursquare uses mongodb
Facebook uses mysql
And those are the biggest there is when it comes to database.
I mean if people can build something SO BIG with FREE databases.
Why do anyone need paid dbms?
Not to mention hundreds of other alternatives that I never heard about. If ...
I am used to Microsoft technologies including SQL Server. Today I ran across a Q&A where the following passage from the MySQL documentation was quoted:
Standard SQL would reject your query because you can not SELECT
non-aggregate fields that are not part of the GROUP BY clause in an
a...
Stealing the share bar used in beta sites, I have userscriptified this:
Add Share buttons to the "link" box
I may add more buttons if I feel bored (I'll need to dig up icons and all, though)
I have something like:
SELECT a, b
INTO v_a, v_b
FROM (
SELECT x, y
FROM whatever
UNION
SELECT z, w
FROM something
) AS subquery (a, b)
Which of course doesn't work in Oracle (that syntax - apart from the INTO and the optional AS) would be fine in SQL Server (http://sqlfidd...
