AboutI am a web developer based out of Waterloo Iowa. I do consulting as well.
Joined devRant on 12/2/2016
Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
Making an ad for web design.
Give me your puns to design something around so it isn't boring...
I have 15k in unpaid invoices. 5k of which is over a year old. Everyone has contracts. Considering getting a job and just giving up the biz.6
I had spent the last year working on a online store power by woocommerce with over 100k products from various suppliers. This online store utilized a custom API that would take the various formats that suppliers offer their inventory in and made them consistent. Now everything was going swimmingly initially, but then I began adding more and more products using a plug-in called WP all import. I reached around 100k products and the site would take up to an entire minute to load sometimes timing out. I got desperate so I installed several caching plugins, but to no avail this did not help me. The site was originally only supposed to take three to four months but ended up taking an entire year. Then, just yesterday I found out what went wrong and why this woocommerce website with all of these optimizations was still taking anywhere from 60 to 90 seconds to load, or just timing out entirely. I had initially thought that I needed a beefier server so I moved it to a high CPU digitalocean VM. While this did help a little bit, the site was still very slow and now I had very high CPU usage RAM usage and high disk IO. I was seriously stumped the Apache process was using a high amount of CPU and IO along with MYSQL as well. It wasn't until I started digging deeper into the database that I actually found out what the issue was. As I was loading the site I would run 'show process list' in the SQL terminal, I began to notice a very significant load time for one of the tables, so I went to go and check it out. What I did was I ran a select all query on that particular table just to see how full it was and SQL returned a error saying that I had exceeded the maximum packet size. So I was like okay what the fuck...
So I exited my SQL and re-entered it this time with a higher packet size. I ran a query that would count how many rows were in this particular table and the number came out to being in the millions. I was surprised, and what's worse is that this table belong to a plugin that I had attempted to use early in the development process to cache the site. The plugin was deactivated but apparently it had left PHP files within the wp content directory outside of the actual plugin directory, so it's still executing scripts even though the plugin itself was disabled. Basically every time I would change anything on the site, it would recache the whole thing, and it didn't delete any old records. So 100k+ products caching on saves with no garbage collection... You do the math, it's gonna be a heavy ass database. Not only that but it was serialized data, so when it did pull this metric shit ton of spaghetti from the database, PHP then had to deserialize it. Hence the high ass CPU load. I had caching enabled on the MySQL end of things so that ate the ram. I was really desperate to get this thing running.
Honest to God the main reason why this website took so long was because the load times made it miserable to work on. I just thought that the hardware that I had the site on was inadequate. I had initially started the development on a small Linux VM which apparently wasn't enough, which is why I moved it to digitalocean which also seemed to not be enough, so from there I moved to a dedicated server which still didn't seem to be enough. I was probably a few more 60-second wait times or timeouts from recommending a server cluster to my client who I know would not be willing to purchase it. The client who I promised this site to have completed in 3 months and has waited a year. Seriously, I would tell people the struggles that I would go through with this particular site and they would just tell me to just drop the site; just take the money, just take the loss. I refused to, this was really the only thing that was kicking my ass. I present myself as this high-and-mighty developer like I'm just really good at what I do but then I have this WordPress site that's just beating the shit out of me for a year. It was a very big learning experience and it was also very humbling as well, it made me realize that I really don't know as much as I think I might. It was evidence that there is still so much more to learn out there, I did learn a lot from that experience especially about optimizing websites the different types of methods to do that particular lonely on the server side and I'll be able to utilize this knowledge in the future.
I guess the moral of the story is, never really give up. Ultimately things might get so bad that you're running on hopes and dreams. Those experiences are generally the most humbling. Now I can finally present the site that I am basically a year late on to the client who will be so happy that I did not give up on the project entirely. I'll have experienced this feeling of pure euphoria, and help the small business significantly grow their revenue. Helping others is very fulfilling for me, even at my own expense.
Anyways, gonna stop ranting. Running out of characters. If you're still here... Ty for reading :')8
For the love of God stop having your fucking secretary make the design decisions. "Make the logo bigger"
The header looks like shit if it takes up 1/4 of the screen Karen 😡😡8
I can't be the only one who gets this:
- Visual Studio frequently crashing. Particularly when working with databases
- Slowness when working within the database designer (after every change!)
- Random "errors". Literally could change nothing in a working program and then it will be throw an error.
My experience with VS and ASP.NET has been very frustrating.1
You guys ever get "Project Zoned"?
When you've been consulting with a client for the past few weeks and then in the end they say "I've decided I'm not going to move forward because it's better for me, blah blah blah. But if I did you'd be the person to do it."
But you spent all that time trying to close the project that seemed so attainable at the time, thinking about the money you could be making. Then you get hit with that shit stick.
So like a couple days ago I was trying to clear the Var directory of my Symfony project.
rm ./* -R
Linux: are you sure you want to delete write protected blah blah blah?
Me:AHA! SO ITS A PERMISSIONS ISSUE
sudo rm ./* -R
Quickly realized I was no longer in my project directory.
Took a fat L. Had to reinstall.2
I took a pinball game I found on GitHub, forked it and added graphics along with modified the physics a bit.
I have a customer who repairs pinball machines.
I'm gonna sneak this into his site free of charge just cause it would be badass.1
At one point in my career I tried to do a payment plan for the websites I built for some reason (I guess to make it more affordable for people???).
Out of the 3 people I onboarded 1 of them actually finished paying for everything.
The other 2 didn't make it half way through.
Their invoices are overdue collecting interest to this day. Websites are shutdown.3
Anyone elses file names sound more and more frustrating as a client continues to request tiny changes? Like it goes from
*mistypes "organization" once in doctrine while generating entity*
*Have to mistype it everywhere because I already made the entity*
The worst kind of problem you can have while coding is an inconsistent or intermittent bug... For code you didn't originally write...1
Has anyone ever looked over the code that they wrote like two years ago and just felt embarrassed of how bad it is?10
Client: hey are you home yet.
Me: no. I won't be for another hour.
Client: so who's logged into your PlayStation account?
My thoughts on Windows:
Xp: fairly decently stable
Vista: OK wtf
7: what vista should have been. (The best one imo)
8.1: an attempt to fix trash
10: slightly less trash with more stupidifying4
A client of mine wanted me to use a specific picture as a background image on one of his graphics. This is how the conversation went:
C: Can you use this as the background?
Me: Where did you get this image exactly?
C: I got it off Google Images.
Me: you can't do that, you need licensing for the image
C: Well I just licensed it. Screw them.
Me: ...That's not how that works..6