galgorah
@galgorah
Best posts made by galgorah
-
RE: Vote of No Confidence
I know change is hard, but the nature of forums and discussion on the web has changed. We too must change with the passing of the boards.
Resistance is futile, you will be assimilated....
To be honest though I actually like the feel of the new forums. Its not perfect but it works way better than CS.
-
RE: Vote of No Confidence
He doesn't remember that and will either ignore that you've pointed it out or will deny it.
I think I'm starting to get used to the infinite scrolling thing.
It's kinda Blakey's thing to be the cranky forum muppet. I'm pretty sure if he wrote the code for discourse he'd still be upset.
-
RE: It's Time To Get Over That Stored Procedure Aversion You Have
Resident DBA Chiming in.
Jaime, Its not hard to end up in a circular logic situation with triggers. I've seen it many times with development teams. Now that being said the decision to use or not use them should be an architectural one. In other words the team should have standards around there use. I'm strongly against business logic in them though as you also point out.
As for sprocs, I prefer their use over ad-hoc SQL. It tends to be cleaner. Plus it can be tuned much easier without modifying application code. Plus its one execution plan for the procedure as opposed to one for every variation with ad-hoc. Granted parameter sniffing could be a problem at some point, but that's an easy fix on the DB side.
I work with developers all the time. We sit down and figure out what logic should be where. Its a give and take. "It depends" is kinda a mantra here.
That being said ORMs are ok for rapid prototyping of an app or just small apps in general. But they don't really scale well. So if your app will be high transactional volume and/or heavy load, don't use them.
-
RE: It's Time To Get Over That Stored Procedure Aversion You Have
BTW, I'm DBA-ing a hosted application environment with five thousand users and 10TB of SQL Server data. It's not some dating site, it's the type of application where people go out of business if I screw up. You aren't the only one here with experience.
I have 10TB+ in one table alone on our production SQL Server. We actually have several like that and its growing rapidly. I work in Silicon Valley so yes I see and play with a lot of tech. For us performance is as critical as it gets. So yeah I work for the type of company, with lots and lots of data, you reference.
By the way, I never questioned your experience. We just have different view points on certain things.
As for my earlier comment about modifying application code. I was referring to the queries themselves. Its much easier if its in a procedure. I make my tweak and alter the procedure. Ideally also checking in the procedure update to source control.
A separation of concerns is a good thing. Let the database do what its good at. If most of your concern is about data dependencies or moving said data around, then that likely belongs in the DB. That being said I understand quite well the need for a business logic layer and the benefits it provides. Do your sorts outside of SQL Server. Feel free to manipulate it there. But don't discount stored procedures. They don't as you say create atrocities. In fact I've fixed a lot of issues with performance and maintenance over the years moving sets of queries to procedures.
-
RE: Proving that Android’s, Java’s and Python’s sorting algorithm is broken (and showing how to fix it)
I thought I was special. *sob*
<ins>But</ins> <del>And </del> I <ins>got</ins> <del>didn't even get</del> a
<kbd>HTML Award</kbd>
as a consolation prize... <del><tt>;~(</tt></del> <ins><tt>\o/</tt><ins>Huzzah!
Well I guess in a sort of obtuse way I owe ya. So enjoy!
-
RE: Proving that Android’s, Java’s and Python’s sorting algorithm is broken (and showing how to fix it)
Yeah I missed that. I removed the badge from you and tar.
When @galgorah didn't remember we had a <<!-- -->kbd>HTML award</<!-- -->kbd> badge.
-
RE: It's Time To Get Over That Stored Procedure Aversion You Have
It's easier for you, sure. Then again, our DBAs are just specialized admins (though actually, they're sysadmins, too, so really just general admins). They don't really have anything to do with queries.
Our DB team is a mix. Some folks specialize in the development support side, others focus on the operational side. Everyone on the team does do a bit of the other side. About 30%. Often times DBAs are also expected to be embedded within development teams. You sit with them and attend their meetings, etc. There's a large focus on team work here.
Latest posts made by galgorah
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@Lorne-Kates said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
Presentation is not a DBAs job
Knowing the entire system they are working with is their job. For all intensive porpoises, PHP is coupled with MySQL. If the "superhero experts" who see all, know all, are clairvoyant and work your system end to end don't know the Web, they're fucking useless. They provide, in their own words, "Extraordinary help".
Hey Cybershitter, what sort of hardware should I provision to keep up the load on both Apache and MySQL.
duh idunnoFine. Cumdumpress, what backup schedule will I need to support the comment system in order to provide a reasonable assurance of data continuity?
tee wee {knowing wink} i liek databassUhg. Token Vaguely Colored Girl: You're an "ultra-brain" with knowledge of ALL technology. Am I going to run into bandwidth issues with mobile browsers using webservices?
i can haz database? i solve everything as long as it is database!Goddamn it. Captain Constipated the Confused. You're able to forsee literally all problems before they happen! Tell me what format of data the front-end should take to best scale over the next ten years.
{hurk} my ass is full of cementUseless. Every one of you. Should I even bother with Furry the Perv Pounder?
meow {poops on a server while yiffing a Linux penguin plushie}If you contract them for managed DBA services, they will stop after MySQL. a DBA does not need to understand how the front end work. I'm sorry you feel that way though. RDBMS are massively complicated, When you can explain finer points around concepts like data pages, memory clerks, cpu scheduling, indexes (clustered vs non clustered, spatial), storage optimization, parameter sniffing, etc, then you might begin to start to have a DBAs level of knowledge about RDBMS systems. Once you've got your data out of my system, I don't care how you display it. Saying a DBA should know front end technology is like saying a dentist should be able to perform open heart surgery.
The point is I would not hire this company as front end developers, Maybe though I would consider them for MySQL administration.
The only companies that do things the way you describe are very early stage startups. As soon as a company grows to more than 20 people things start to change and responsibilities divide.
It doesn't make them bad at all. If you want to contract someone or both, then look for a company that does both. The needs of the DB and the app layers are very very different. They both require specialized knowledge.
As for MySQL not being used for anything complicated, I think my Director would disagree, he led the MySQL team at twitter up until recently. I'd also disagree on the grounds that we have several complex systems running on MySQL. And we use it here as one of many systems involved in our various products.
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@Lorne-Kates said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
Presentation is not a DBAs job
Knowing the entire system they are working with is their job. For all intensive porpoises, PHP is coupled with MySQL. If the "superhero experts" who see all, know all, are clairvoyant and work your system end to end don't know the Web, they're fucking useless. They provide, in their own words, "Extraordinary help".
Hey Cybershitter, what sort of hardware should I provision to keep up the load on both Apache and MySQL.
duh idunnoFine. Cumdumpress, what backup schedule will I need to support the comment system in order to provide a reasonable assurance of data continuity?
tee wee {knowing wink} i liek databassUhg. Token Vaguely Colored Girl: You're an "ultra-brain" with knowledge of ALL technology. Am I going to run into bandwidth issues with mobile browsers using webservices?
i can haz database? i solve everything as long as it is database!Goddamn it. Captain Constipated the Confused. You're able to forsee literally all problems before they happen! Tell me what format of data the front-end should take to best scale over the next ten years.
{hurk} my ass is full of cementUseless. Every one of you. Should I even bother with Furry the Perv Pounder?
meow {poops on a server while yiffing a Linux penguin plushie}If you contract them for managed DBA services, they will stop after MySQL. a DBA does not need to understand how the front end work. I'm sorry you feel that way though. RDBMS are massively complicated, When you can explain finer points around concepts like data pages, memory clerks, cpu scheduling, indexes (clustered vs non clustered, spatial), storage optimization, parameter sniffing, etc, then you might begin to start to have a DBAs level of knowledge about RDBMS systems. Once you've got your data out of my system, I don't care how you display it. Saying a DBA should know front end technology is like saying a dentist should be able to perform open heart surgery.
The point is I would not hire this company as front end developers, Maybe though I would consider them for MySQL administration.
The only companies that do things the way you describe are very early stage startups. As soon as a company grows to more than 20 people things start to change and responsibilities divide.
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@Lorne-Kates said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
I would expect a managed DBA services company to outsource their web site development and design to another company instead of doing it themselves.
I would expect a DBA services company to have the slightest fuck on how to present the data they are managing.
Presentation is not a DBAs job. Thats what front end folks are for. DBAs focus on the infrastructure. Would you expect the middle tier guy creating web services to understand the finer points of CSS? I sure wouldn't, it's not their job.
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@Lorne-Kates said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
So I don't see why they would want to hire a front end developer.
Databases aren't the only part of the system.
"Hi, I'm a mechanic. I know transmissions like a motherfucker"
Really? My power steering is on the fritz, the headlights flicker, and I think I've blown my shocks.
"TRANSMISSIONS! I'M A GODDAMN GIANT!"
I wouldn't go to a Transmission specialty shop to get my headlights checked out. Plus headlights are a lot less complicated than a transmission is. Front end development is very complicated as are database platforms. They are both specialties in their own right.
I would expect a managed DBA services company to outsource their web site development and design to another company instead of doing it themselves.
Yep pretty much
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@Lorne-Kates said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@galgorah said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
So I don't see why they would want to hire a front end developer.
Databases aren't the only part of the system.
"Hi, I'm a mechanic. I know transmissions like a motherfucker"
Really? My power steering is on the fritz, the headlights flicker, and I think I've blown my shocks.
"TRANSMISSIONS! I'M A GODDAMN GIANT!"
I wouldn't go to a Transmission specialty shop to get my headlights checked out. Plus headlights are a lot less complicated than a transmission is. Front end development is very complicated as are database platforms. They are both specialties in their own right.
I would expect a managed DBA services company to outsource their web site development and design to another company instead of doing it themselves.
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@Lorne-Kates Chances are that was the marketing department who hired an freelancer to draw the cartoon. Magenic is another company who used a cartoon drawing of super heroes a few years back. I'm guessing they ripped this off of them.
This company seems to specialize in mysql and mongoDB, as remote admins. So I don't see why they would want to hire a front end developer. They wouldn't put that person to use at a client.
-
RE: Database Performance Team: Superheros doing extremely tedious MySQL shit!
@RaceProUK said in Database Performance Team: Superheros doing extremely tedious MySQL shit!:
@fbmac Batman's not doing his own admin; he's too busy being a billionaire playboy or punching bad guys. If you want to find the actual DBA, there's only one candidate surely: Alfred.
I'd actually suggest that Lucious Fox is the real DBA. He seems like he would be really good at automation. A good DBA tries to automate as much as possible.
-
RE: Blakeyrat pointing out NodeBB problems
@boomzilla said in Blakeyrat pointing out NodeBB problems:
@cartman82 Funny you should ask. I was looking through the users page today and noticed that @galgorah had one.
@boomzilla: Yeah actually I didn't realize it was animated. Hang on one sec while I change it... ok done.
-
RE: Recruiting Giants
@Weng Even out here in Silicon Valley, we try to avoid pulling crazy hours. We all have lives and take breaks. Most everyone from the CEO to sysadmin leaves for home by 5:30. Its really only early stage startups out here where you find folks working crazy hours. Unless of course someone chooses to work late. I'm a DBA and on call for one week a month. Its no worse than anywhere else and actually its better than other places I've worked.
-
RE: The Official Status Thread
@Mikael_Svahnberg You just reincarnated into a slightly different timeline is all.