|
Rawrbomb posted:PHP isn't compiled, unless you're using hip-hop, and even then its kind of weird. Ah, ouch. Forgot about scripting (as I am wont to do).
|
# ? Jun 2, 2014 20:12 |
|
|
# ? Jun 5, 2024 06:11 |
|
Che Delilas posted:Ah, ouch. Forgot about scripting (as I am wont to do). One level more of fun, depending on how badly you've botched your php/MySQL, you can even do some really fun stuff based on the way PHP handles serialize.
|
# ? Jun 2, 2014 20:16 |
|
Caconym posted:DROP TABLE commonly won't work if there are active connections to the database (at least in SQL Server), use TRUNCATE TABLE instead. That'll preserve the schema, and 'just' delete all the rows in it. Heh, you think MySQL is a real DB with stuff like ACID compliance on default settings.
|
# ? Jun 2, 2014 20:24 |
|
That would still be slightly overkill today, and would've murdered servers 15 years ago when MySQL together with PHP pretty much started the web 2.0 revolution. Nobody really needs watertight atomization for running blogs and forums. Now of course, the people who learned databases in highschool while hacking their PHPBB installation then insisted MySQL was the bestest thing ever for coding their startup ecommerce and CRM software can get hosed.
|
# ? Jun 2, 2014 21:09 |
|
peak debt posted:That would still be slightly overkill today, and would've murdered servers 15 years ago when MySQL together with PHP pretty much started the web 2.0 revolution. Nobody really needs watertight atomization for running blogs and forums. Now of course, the people who learned databases in highschool while hacking their PHPBB installation then insisted MySQL was the bestest thing ever for coding their startup ecommerce and CRM software can get hosed. You can do this perfectly fine while being ACID and having non-retarded behaviour, even with MySQL, you just have to turn on use strict and configure other make-poo poo-not-retarded features. Or you can use postgres (which is ACID-compliant out of the box and is actually hard to make data-unsafe) but tweak the 32MB RAM settings it has stock on most distributions (which is also kinda retarded). Postgres is actually ridiculously good at being "NoSQL" document storage and/or KV store. I believe reddit ran pg as a KV cache by just telling it to store poo poo in memory and, in their use case, outperformed the alternatives they tested. PG is also faster at being mongo than mongo (for JSON), while being much more robust.
|
# ? Jun 2, 2014 22:02 |
|
deimos posted:Postgres is actually ridiculously good at being "NoSQL" document storage and/or KV store. I believe reddit ran pg as a KV cache by just telling it to store poo poo in memory and, in their use case, outperformed the alternatives they tested. PG is also faster at being mongo than mongo (for JSON), while being much more robust. Can you provide any substantiating articles about this? I just started a job at a Trendy New Startup and they're trying to use Trendy loving Stupid Databases written in Erlang or some poo poo rather than a simple RDBMS, so it would be funny to give them this and watch them sputter.
|
# ? Jun 3, 2014 03:13 |
|
Urit posted:Can you provide any substantiating articles about this? I just started a job at a Trendy New Startup and they're trying to use Trendy loving Stupid Databases written in Erlang or some poo poo rather than a simple RDBMS, so it would be funny to give them this and watch them sputter. General rule: don't judge anything a shop does until you've been there for at least two months, because you have no idea why they do it that way. Don't be "that guy" who thinks he knows it all and why they're doing it wrong in a brand new environment.
|
# ? Jun 3, 2014 03:32 |
Oh hey, they ID'd the guy behind Cryptolocker! ... and I'm willing to bet that thanks to the current state of relations between Russia and the US/EU, they'll do pretty much nothing to arrest him. http://www.theguardian.com/technology/2014/jun/02/cryptolocker-virus-nca-malware-protection
|
|
# ? Jun 3, 2014 13:45 |
|
peak debt posted:That would still be slightly overkill today, and would've murdered servers 15 years ago when MySQL together with PHP pretty much started the web 2.0 revolution. Nobody really needs watertight atomization for running blogs and forums. Now of course, the people who learned databases in highschool while hacking their PHPBB installation then insisted MySQL was the bestest thing ever for coding their startup ecommerce and CRM software can get hosed.
|
# ? Jun 3, 2014 14:07 |
|
This website can help
|
# ? Jun 3, 2014 14:42 |
|
They all seem like they have poo poo to be talked about. The mysql stuff I see being complained about seems like bad error handling on the programmers part.
|
# ? Jun 3, 2014 14:48 |
|
So an e-mail recipient on a different domain is getting all of his e-mails rerouted from @company.com to @yahoo.com. How weird. I saw an e-mail sent to one quoted in a response from the other, so I think the description of the issue is accurate. Users were thinking we would set up some kind of bizarro Exchange rule to do this, but I would think that if I received that request from an outside recipient, I would advise them to have the forwarding configured on their company's server instead. Had them send him a message via a personal gmail account to see if the issue is universal...
|
# ? Jun 3, 2014 15:15 |
|
I am not a DBA, but I have supported applications that used mysql as a backend. My experience is that mysql tends to be baby's first database, because hey, it's free! The stuff I supported were all custom apps built for the company I worked for at the time. The external developer was under time and cost constraints to deliver a solution, so of course they went with the cheapest thing possible. Given that the app did snmp polling and put the data into mysql, and then made it available via the web, it wasn't the worst choice, but it did not scale to polling a million devices every 10 minutes.
|
# ? Jun 3, 2014 15:18 |
|
A phone interview came in: Wasn't sure about it way up until the end, it felt like I was doing most of the talking. Put the phone down expecting them to tell me to bugger off. Nope, they want to meet me in person and told me that the positions worth more than what I wanted, so even if they lowball me i'd be happy. The place i'll be going requires me to have a security pass as well as being escorted everywhere, plus they'll need my ID and a picture of me. So yeah, possible
|
# ? Jun 3, 2014 15:19 |
|
It's truly the Spring of Jobs on SA SH/SC
|
# ? Jun 3, 2014 15:22 |
|
dogstile posted:A phone interview came in: Is this like private corporation secure area or government secure area? SCIFs are terrible to work in.
|
# ? Jun 3, 2014 15:25 |
|
QuiteEasilyDone posted:It's truly the Spring of Jobs on SA SH/SC It's a good year to be a goon! Content: This was from yesterday, but an IM came in. Manager: I need you to deal with this ticket, Sev 1. Client is down completely. They cant connect to our cloud servers! Me:Send it over. I read the ticket. Ticket description is basically "Client tried to connect to RDS, failed. Client tried second time, failed. Client tried third time. Connected. Issue has occurred before and client wants to know whats happening." Me: Hey Manager, this isn't a Sev 1 issue. Manager: What are you talking about they are down! Me: No they aren't, it says right in the ticket they are connecting and want to know why they keep getting knocked off our cloud server Manager: Oh.. It does. I didn't actually read the ticket past the first line.
|
# ? Jun 3, 2014 15:29 |
|
Cojawfee posted:Is this like private corporation secure area or government secure area? SCIFs are terrible to work in. Government secure area. Can't be worse than where I work now. Are SCIF's awful in the UK too?
|
# ? Jun 3, 2014 15:35 |
|
Oh, you're in the UK? In the US it's terrible if you're IT. Especially when someone overclassifies something and I have to take a ticket to another building.
|
# ? Jun 3, 2014 15:54 |
|
evol262 posted:They won't. Even if the native json type is faster and hstore might be, postgres is not a drop-in replacement for autosharding distributed nosql datastores. Sometimes not a replacement at all. This, a thousand times this, no DB is a panacea, that being said, no one should be using mongo, it has almost literally no valid use case. Postgres-XC is a neat project to bring sharding/distribution to pg but I've never used it. If you're using Riak you're using one of the really really well done models for distribution and concurrency, if well programmed it's one of the few data stores that can handle network partitioning very very well when using CRDT. If you can get over the cheesy graphics and image macros this is a series of blog posts of someone that ran simulations of networking failures on different distributed databases. Start here.
|
# ? Jun 3, 2014 15:56 |
|
Jesus Christ. There's obscure vulnerabilities, and then there's writing PHP / sql without sanitizing your loving user inputs.Rawrbomb posted:I mean, there are like 8 ways to Sunday to clean user input in php/MySQL stuff.
|
# ? Jun 3, 2014 16:18 |
|
blackswordca posted:
The latest innovation in ticketing is cut-through assigning. Your boss is just an innovator trying maximize support throughput.
|
# ? Jun 3, 2014 16:32 |
|
So if you put two addresses(or more) into a mail contact in Exchange, whichever one is set as the Reply address is apparently where all e-mail addressed to ANY address in the list will end up. Derp, that took me a while to track down.
|
# ? Jun 3, 2014 16:47 |
|
blackswordca posted:Manager: Oh.. It does. I didn't actually read the ticket past the first line. He's paid to lead, not read. Good managers go with their gut without letting inconvenient facts get in the way.
|
# ? Jun 3, 2014 17:15 |
|
KoRMaK posted:Can someone enlighten me as to why mysql is the worst of all the databases? MySQL is basically just database fan fiction. Really BAD database fan fiction. It does a lot of things on the frontend that look databasey, but on the back end, its all hacks and poop.
|
# ? Jun 3, 2014 17:26 |
|
nitrogen posted:MySQL is basically just database fan fiction. Really BAD database fan fiction. I ticket came in... It's all hacks and poop
|
# ? Jun 3, 2014 17:47 |
|
Not really knowing poo poo about databases, when people use Excel as one that's worse than MySQL right? Or is MySQL that bad.
|
# ? Jun 3, 2014 18:10 |
|
At least MySQL is in theory a multiuser datastore, so yes it's still lightyears better than Excel or Access.
|
# ? Jun 3, 2014 18:12 |
Gunjin posted:Not really knowing poo poo about databases, when people use Excel as one that's worse than MySQL right? Or is MySQL that bad. MySQL is leaps and bounds above people who use Excel or Access as databases. It's got quirks, but at least it's actually a database!
|
|
# ? Jun 3, 2014 18:16 |
1 month ago: Older guy wants to get a new computer. We set it up for him. 2 weeks ago: Dude comes back, computer's jacked up to hell with every piece of bloated ad-vomiting malware you can name. We clean it, make sure his AV programs are up and running and that it's clean and isn't rooted, and send him back out. Today: Dude comes back, computer's even more heavily infected than the last time. How? Is this guy looking at german dungeon porn 24/7 or something? I have a netbook in for a virus removal as well which belonged to a hispanic guy who barely spoke english and it took it five years to reach that stage. How did this guy do it twice in one month? I'd be actually angry and not merely baffled if it wasn't for me being able to squeeze another couple hundred dollars every time he brings this thing in, but still.
|
|
# ? Jun 3, 2014 18:16 |
|
President Ark posted:I'd be actually angry and not merely baffled if it wasn't for me being able to squeeze another couple hundred dollars every time he brings this thing in, but still. Same here -- a local business owner has been calling me up every 3-6 weeks like clockwork from the time he ordered his new desktop. He recognizes that he's visiting "sites he shouldn't be" but thinks it's a problem with the machine itself. He's gone so far as to call Dell and complain that they need to send him a replacement. Guy is on a whole different level, but hey he's a paying client so ...
|
# ? Jun 3, 2014 19:00 |
|
All the malware programs are best friends now and will bring everyone to the party as soon as you get snap.do. Check out the install dates of all of the poo poo on these machines, bet it's all the same day
|
# ? Jun 3, 2014 19:09 |
|
President Ark posted:How did this guy do it twice in one month? He's installing something he knows he shouldn't, and that starts inviting along all its friends. Before he brings it to you, I bet he's uninstalling that application, because he's embarrassed about it. You should check the event log for installer activity in the days after you last returned it to him, to see if you can find what he is installing. Also, if he has family/friends that is using it, well....
|
# ? Jun 3, 2014 19:33 |
|
So our phone system was hacked last week and some international calls were made from our numbers. Now the fault lies in that 10 years ago when they purchased the system it was never set up correctly so a forward was set from one of our voicemail systems and abused. Our ISP caught the outbound calls and within 1 hour of the first one they were blocked. Seems to me like a reasonable response time for this. My boss is now angry with me because I won't call the ISP and argue with them about the bill. She's currently on the phone with them threatening to leave for another ISP so it get's credited back. Even though this is our loving fault 100%. Any other provider would have just let the calls come through and charged us thousands or more. The best part is I'm not even on the phone account so what the gently caress am I supposed to do? poo poo drives me insane some days. This is also the same person who spent $500 on a TV that we mounted on the wall (twice in 2 different locations, including having techs come in to rewire a building after having them pre-wire it a month before) only for it to stay turned off for the last 6 months.
|
# ? Jun 3, 2014 19:43 |
|
That's what I like about Gandi's "no bullshit" policy - if they gently caress up they will hold their hands up and admit it. If you gently caress up and try to blame them they will tell you where to go.
|
# ? Jun 3, 2014 19:46 |
|
The absolute best part is I can guarantee we will not get a better price anywhere else we go. Plus the cut over would be loving atrocious and involve me spending many hours outside of my regular work schedule cutting it over. Phone ports never go easily.
|
# ? Jun 3, 2014 19:48 |
|
m.hache posted:Phone ports never go easily. Thanks for reminding me. We're planning to move off these ancient Nortel Norstar PBXs to something a little more modern (they seem bent on Lync and won't look at anything else) and not from a company that went belly up in the 90s. I'm absolutely dreading that transition since I'm the only one that knows anything about PBXs and I've only used FreePBX at a hobby level.
|
# ? Jun 3, 2014 20:06 |
|
Say you don't know anything about PBXes and get someone in who does then. I'm all for trying new things to learn but if you get lumped with it because the don't want to pay a consultant and then get to take poo poo because it went wrong then that's not a very fair deal.
|
# ? Jun 3, 2014 20:07 |
|
Caged posted:Say you don't know anything about PBXes and get someone in who does then. I'm all for trying new things to learn but if you get lumped with it because the don't want to pay a consultant and then get to take poo poo because it went wrong then that's not a very fair deal. Oh, I have. Several times even. They told me to fire up a VM and learn about Lync Server because we're a non-profit that doesn't like to spend money. They seem to think that this a reasonable solution to me having a panic attack about this.
|
# ? Jun 3, 2014 20:22 |
|
|
# ? Jun 5, 2024 06:11 |
|
If they want you to learn then dig out a classroom course they can send you on to learn about Lync. Otherwise just throw it in, gently caress it up totally, clock out and go home. Make sure you keep all your emails.
|
# ? Jun 3, 2014 20:24 |