Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Get a devDuck
Rubber duck debugging has never been so cute! Get your favorite coding language devDuck
Buy Now
-
Hey everyone!
devRant will be going down on Friday, July 7th around 10:30pm EDT so we can do some database maintenance and restructuring of our cluster. It hopefully won't be down for more than about 30 minutes or so, and during that time you should see our "down for maintenance" message.
If you usually use devRant while you're on the toilet (we know many do!), we apologize and suggest you try to schedule around this!
Please let me know if you have any questions and apologies for the inconvenience.44 -
Brain: hey kiddo, want to stay home and work on your side project today? I'm feeling good.
Me: fuck yeah finally!
*call in sick.
*open laptop. Tabs and editors already waiting.
*play music, no sound.
*system is all laggy.
*fuck, restart.
*
*Installing windows updates...
*leaves for work.18 -
I am currently working for a client who have all their data in Google Sheets and Drive. I had to write code to fetch that data and it's painful to query that data.
I can definitely relate with this.
PS: Their last year revenue was over US$2 Bn and one of their sibling company is among Top IT companies in the country.
9 -
You know you've had to deal with a tough database problem at work when you start seeing SQL in your own kitchen... (It says SOL meaning salt)
P.s. I sure hope this is how these memes work, because I want my avatar
16 -
My internship at startup:
Dream: Lots of coding
Reality: Maintaining Excel sheets for API functions.😑14 -
Reviewing coworker's code:
Me: I see you're doing a convoluted sort for every element twice to get your two lists in sync... 😐
CoWorker: Yeah. *straight face, no regrets* That's the only way to do this.
Me:... Uh... No? You can just manage one list with a simple struct and then use the the standard sort.
Coworker: Yeah sure I know. But it'll take time. We don't have time.
Me: *aghast* This is embarrassingly bad code!
Coworker: Don't worry, later on I'll use a hashmap for it. But this needs to be pushed now.
Me: *to myself, no you don't need a hashmap*
Okay, you do you but I can't back you on this. It isn't going to take a lot of time to correct it.
Next day.
Coworker: Hey can you review my code again?
Me: You've made the changes already? *in a bored tone, knowing that they wouldn't have changed shit*
Coworker: No this is a different file. Our manager agrees that we can worry about performance later.
Me: Sure. *😀🔨🔨*
Few weeks pass by:
QA: The operation takes absurdly long time to complete even with the smallest data. Ten minutes for X is unacceptable.
Me: Who would've known? ☺️25 -
Seniors: Welcome to the team. Feel free to ask anything if you need help. There is no such thing as stupid questions.
New Dev: Sure. Thanks.
*a few minutes later*
New Dev: How to comment a code?
Seniors: Google it....and please don't ask stupid questions.11 -
Me: *reinstalling windows10 using the recovery disk.
"Your partitions will be reformatted if needed... warnings this, that... Continue?"
Me: do it already!
"Recovering... 1%..."
.
.
"Recovering... 1%..."
.
.
"Sorry cannot recover. We didn't change anything."
Me: *reboot
.
.
.
.
"No bootable drive found"
YOU MOTHERFUCKING LIAR! *throws away the thumb drive with the laptop attached out of spite27 -
Discovered one of the worst db designs ever:
- A cust is inserted in a table.
- The insert trigger is fired, calling a stored proc
- The stored proc being called creates a dynamic sql that builds a create table statement for 8 different tables. These tables will be postfixed with the newly-created cust id and is executed.
When querying info for a cust, a stored proc is used that accepts an id value would be appended to another dynamic sql that creates a select statement across all 8 tables for one customer.
Shoot me now.10 -
We have this weird db naming convention requirement by the client all table names should be of 4 letters. And guess what somebody thought of naming a table 'ANUS'8
-
Avicii died. 😞😢
At just 28.
He got me through some tough and grueling times. I still use his tunes while coding. I'm still shocked that he left so early. But he made it count. He might've lived short but he lived large.
I'll miss him. I'm sad that he left so early. But his work will live on. I hope to become as good at programming computers as he was at using them to make music. His music was perfection. RIP.13 -
Went out with friends last night to celebrate a birthday, on our way back with the train we are asked for our tickets. We had bought a group ticket (for 30€/5 Persons) and showed it to the ticket checker. It was 6:20 am at that point and we were all tired and just wanted to go home, but apparently the ticket was only valid to 6 am (it does not say that anywhere on the ticket and it is called a "9-o'clock day ticket"). That asshole seriously made a record about all of us and took 60€ from everyone of the 5 of us.
The Deutsche Bahn company is the only rail company in my region, there is nothing that could compete with them, so they just shit on their customers. And now they want to privatize the highways too? Stop making public traffic something to pay for! There is no competition if there is only one traffic company with the only highways or train-web in a specific region.7 -
Dev: Hay dude , look this page is broken, how long has it been like this.
Me: No? 🤔, Weren't you working on the Database for this yesterday?
Dev: I didn't change anything yet...
Me: Okay, let's do a git bisect and see where this came from.
...After going back in history and checking out like 3 commits.
Dev: It's fine I'll just search for it
Me: 😕, that's what we are doing the bisect for?
Dev: But we've already looked at so many!?
...After some time of convincing, finds good commit, does the bisect and finds offending piece of code. The database details changed.
Me: okay so while it's still pointing to the old database it's working but switch it to the latest one and it breaks. You sure you didn't change anything?
Dev: I didn't do anything.
Me: okay well it seems to me like it must be a database issue, let me know what you find.
10min later...
Dev: Hay dude, soo I found it, I accidentally renamed a table
In my mind: 😲😲😲
I hate working at a company with bad practices like saving database config into git and not making a copy of the database when you intend to work on it, and not edit the f'ing live instance! Not even close to the luxury of migrations.1 -
I HATE TESTING DB MIGRATIONS! SHIT TAKES BLOODY FOREVER!
This one takes 20 freaking minutes each attempt, and I need to run it. yet again.
$@%&!12 -
Marketing : Do you think we can implement this feature in a system?
Dev : Hmm....*checking specs*...This will...
Marketing : *interrupts* we have already signed a contract with a client.
Dev : ugh......7 -
So, a friend of mine started working on an internship in which he was supossed to manage a DB. He was given an Excel file. 🙈Wtf4
-
Spent a month working on a website that relied on crawled data
Got the memory leaks and usage down from 700mb to ~150mb
CPU usage from ~100% to <5%
Shrink-wrapped the DB requirements based on data
Created self-supporting services and what not
When everything FINALLY worked good enough for me to look at it and go "damn, this actually worked"
the whole monitoring sys got dyed in red :v
A quick look up and my crawlers exhausted my godaddy's per-user db limits.
Kill me.
Just fuckin kill me.7 -
So last semester, my college made a class compulsory to attend.
We were taught, "How to install MongoDB on Windows"...
With screenshots, not even live installation.
I wanted to die.. So much.. 😖4 -
20 minutes trying to convince my boss (lead dev) that dynamically create tables on DB based on file name to store uploaded json content isn't a good design approach and he is still convinced that 500 lines will really impact performance that much on one table and that this is the best design...
Based on this approach, he wants to create another table with the user who last modified and the "fk" (not sure if he even knows what this is cause none of the fks here point to anything...) would be the table name... now I know where those hideous tables we have here come from...
Don't know if I laugh or cry...3 -
I am sooooo very happy & grateful that my coworker wrote down this comment.. I'd have been lost without it! :/
-
Trying to discover why the DB listener wasn't being called in my app for like 30min. Many log messages, no exceptions or errors, DB rules revised, DB content revised, changed constructors, simplified code and nothing worked... problem: the phone's wifi was disconnected.2
-
HOLY FUCK (!dev) SOMEONE KILL THE MANAGEMENT OF DEUTSCHE BAHN ALREADY
Seriously where can I complain? delays on every single train i was on since weeks. and always because of some stupid shit like "we need to let another train pass by". wtf you didnt know that earlier?15 -
I got a bug report with a typo in it. The subject read "...action X takes long time thank expected."
The thank is supposed to be "than".
I chuckled and immediately created a snapshot that shows the result of the action and the success message says, "Action successful, thank you for your patience."
I shared it with my team but no one even acknowledged it. 😞3 -
People with "I am a senior, only I have to be right" mindset are really fustrating to work it.
It is not that hard to accept the truth. No one can be right all the time and no one gonna look down on you for that. You don't have to shove off-topic stuffs down the other people's throat when you realize you might be wrong.4 -
I just had the most surreal email discussion I think I've ever had...
I spent over two hours going back-and-forth over email with an enterprise DBA, trying to convince them I needed a primary key for a table. They created the table without a primary key (or any unique constraints... or indexes... but that's another discussion). I asked them to add one. Then had to justify why.
If you ever find yourself justifying why you need a primary key on a table in an RDBMS, that's the day you find yourself asking "is this real life?"
I want the last two hours of my life back. And a handful of Advil.1 -
Every time I have to recall how to LaTeX, it's a huge pain in the ass. It's like learning to code in Greek (I don't know Greek). Happens every single time (it can be months before I need to use it again).
However.
Every time I finish my creation, I fall in love with LaTeX all over again.5 -
Slapping idiots around.
This needs to be a trend.
---
Actual rant :
I'm sitting in this idiot haven completing my mandatory hours doing nothing. Earlier I would spend this time learning stuff but I'm too fed up to do anything. This place is driving me mad and just today I had to suffer through more madness that is blocking me from resolving a bug.(I don't have the license to run the product I'm supposed to be fixing)
The number of inept idiots is too damn high. I try not to be bothered but I can only try so much.4 -
Junior: I fixed the slow backup system in db server
me: what?
Junior: yes, I remove some weird database from the backup
me: prodcardholderslatinamerica db?
Junior: yes, that weird db!
:-/1 -
Really now?
AWS, #1 cloud provider with their #1 cloud database DynamoDB, all shiny, highly dynamic NoSQL, your data schema could change any second...
then DynamoDB errors out when one of your values is an empty string? {"foo":""} is impossible to store?
Like nobody ever saw or used empty strings a a value or what? There are tons of upvotes to fix this.
I just have to imagine the Product owner standing there: "No,no,no. They are just using it wrong if their data has empty strings as value. Won't fix!"4 -
Please use normalization. Don't store more than is intended in one field and use special characters to separate things. It would make future developers job easy.
7 -
I am pretty sure by now that this project is trying to screw me over. on the test server I had errors I didn't have on docker, and on live I have errors I didn't have on test OR docker. Because why the heck apparently not. Sidenote: utf-8 is NOT suited for inserting text with emojis into a DB.1
-
'Hey I found a bug in your code, it's probably a typo, see here.'
Me: Oh right, yeah. How stupid of me. Thanks, I'll push it.
'It's okay. You can push it or I can do it too after you push the changes we just discussed. I actually simplified one of your methods.'
Me: You, what... ?
(You crammed multiple lines in a single line with your stupid as fuck, rigid constructs, removing my error handling, loosely coupled service, in the name of simplification?)
' Yeah it's just four lines in a single function now, no need to call the function again and again.'
Me: (No... Just no. This totally undos whatever little I could do to avoid supporting your idiotic object in the first place.)
Oh... okay, we'll see. I'll let you know.
What life.
Life in a company full of ignorant, inflated egos is no joke.
Details:
I created a service that reads a configuration file and returns the configuration. This person needs five entries for his app logic. He collected them in a object. Quite alright. Except that the class prototype is shitty. I, like a normal person, made my service return a value based on input. I was asked to incorporate this awful object so that I can return the five entries together, which is awful because the service is not supposed to know about how the entries are clubbed. It should most certainly not know about the data members of the object!4 -
When i started my work I encoubtered this db(one of 4): more than 20 tables, some with 200 columns literally... EVERYTHING is a varchar 😓.
I'm slowly designing some normalized tables with real fk on new features and projects and people are like: how the fuck did you implement this feature so fast? the other guy spent 3 months designing this form (and I'm just speechless):
The form was some sort of crazyness shit passing input names as "name-of-property" and a file only to check if(name="string") then store a number value to an array and save it as a "number" (actually varchar) on the db. literally more than 50 if statements to do this.
Everything on a single table that made no sense at all.
Just wtf... At least my boss let me start if from scratch cause he we were always having panick attacks every time he needed to do something with it. 😂😂6 -
Is there automation tool for postgres or mysql to fire a query? I got a db that will reset the row column value after 1 month of the created date
Edit: I know this is not SO
Not clearing the rows, just resetting the value of some rows if the criteria is met13 -
Family expectations from an engineer in India:
Go fix the ceiling fan, it's very slow these days.
😖1 -
Gahhhh!
Just inherited a HR backend written in Laravel. However, ALL database interaction is done using DB::raw() i.e.
$results = DB::select( DB::raw("SELECT * FROM tbl WHERE col = '$fromThe QueryStringLOl'") );
No models at all :(
FML.3 -
What the fuck is wrong with Google?!!
Trying to log into Gmail.
Forgot password.
Gmail: To reset, code from authenticator app is required.
Me: Super. Good thing I set it up.
Enters code.
Gmail: Recovery email.
Me : Uh... Forgot that too.
Gmail: Some email address to communicate.
Me: Super!
Enters some other email address.
Receives mail with a link.
Me: Finally!
Opens link
Gmail: "When did you create your account?"
Me: Uh... If I had that kind of memory, we wouldn't be dancing right now.
.
.
.
Gmail: Sorry we couldn't verify you.
WHAT THE FUCK, GOOGLE?!
What sort of sadist play is this?!
Dropped them a mail to get access back. Got a link in the auto reply that explains how to repeat the above process. WTF?!
What the actual fuck?!14 -
Sport Festival today
I'm in the IT course and responsible for injecting data into DBs.
I asked some 11-graders if they would pay for better values ;D1 -
In my work we have this big client who is really concerned about security.
We can't even access the DB from our machine, so they gave us some shitty, heavy as hell, laptops. It's ok, i don't like the ideia but ok.
But in this laptop have a super fucked up windows 7 that have almost everything blocked, we can't even install the fucking sdk(java) to work without asking the company's "IT guy".
On top of that, to access the DB from outside this client we need a VPN, it's ok, I understand, but the fucking VPN drop connection every 5 fucking minutes.
Yesterday I spent fucking 6 hours to run 2 ten minutes queries that we needed to make a report for this fuckers.
I sit in front of a big window, I really felt the will to throw their laptop right through it.3 -
DevSup channel:
Someone: FYI, Db is down(ticket link)
Otherone: Can anyone help me connecting
with db? I am having issues.
I am so happy I am leaving this place in 2 months.... 😂😂1 -
!dev
Snow is fun and festive when you aren't sitting in a train stuck due to the weather. Growl :/
9 -
Me chatting with a bandmate who is also a developer:
Me: do you have any experience in Db?
Him: Dropbox? Databases?
Me: Sorry enharmonic confusion. I meant C#
P.S. yes, sometimes I find my comments so funny that I make new joke posts about them.3 -
the web developer equivalent of waiting for code to compile is waiting for your local test DB to be populated with recent data from the production DB2
-
Student Account Password at the university. No changes the default. It's their DOB and first two letters of the name.
Injection steps:
Open Database ( I am the Placement Representative )
Copy DOB
Paste
Add the first two alphabet
Unlocked3 -
So, I feel a sleep at my desk for about 15 minutes. Only to awaken with drool down my shirt. I then proceeded, while half sleep, to delete 58 rows from the DB...O.o
Hahahahaha good thing it was only on my machine. -
How many of you wear shades at work?
I started doing it after I faced some problems due to the extremely bright lights. It's such a complicated problem that no one in the management or admin team can do anything about it. 🙄15 -
How surprising is it when a person designs code in a very clear and impressive structure and just when you think about asking them for guidance, they reveal themselves to be complete turds?
I've been working with this person's "infra" code, at work. I've rewritten some classes to use their infra. I had a vague idea of how the classes work. I had no idea of how their code works. Expectedly, there were some issues but now only minor ones remain.
I asked them for a description of what I'm supposed to do for the few bugs I'm facing. They replied in such a condescending tone, it made me want to punch them through the screen.
Almost a month later, we're still going back and forth with emails. I've been swallowing it and responding calmly. I never got direct answers. Always deflections to irrelevant things or veiled insults. I took it because they did correct one silly error of mine that actually my code reviewer should've caught. (What's worse is that it got introduced by me just before my review and commit.)
But does that give them the right to insult me in front of the whole team including my project manager? I got a reply today from them with everyone of note in cc implying very clearly that I have not done any work. They highlighted a line from my code with some todo tag (that was not meant for them) to make their invalid point. A line that's unrelated to the bug I asked them about. This is after I proved them wrong when they insisted that I had done something wrong about a feature related to the bug.
If you don't understand what I asked for fucking ask me to ask again. But do not fucking try establish yourself on higher ground by pointing out irrelevant things in my code.
I was shocked and enraged that they'd do such a thing. I double checked everything like a mad man. Despite knowing that the fix has to come from them, I was instantly transported to the noob stage, grasping at straws. I wanted to send a really scathing reply right away but my manager asked me to wait.
My mind is now a see saw shifting between a panicked noob questioning every fucking thing I ever did in my nada life and a hungry enraged monster looking to maul that fucking shithead for burning me like that.1 -
Accidentally using a MySQL update and not specifying the where....yeah needless to say every single dB record got updated to trash data and the DB wasn't backed up....I was a brand new developer so....4
-
When you have a Database Theory final exam in 2 hours and you're cramming a 1/4 of the module. #uni #student
-
I've never really had a project "blow up", however one that I'm quite proud of is fairly popular (almost 500 monthly downloads if NPM's (limited) stats are to be believed.
It's a connector for Redis for Node, which uses ES6 Proxys in order to make basic interactions with objects in the db easier.
It's actually based off of an existing project that does the same sort of thing, but I noticed a couple of things that it did that I found a bit annoying.
1. When creating new nested objects, it didnt create a tree, meaning you had to do that manually.
2. It stored everything in a single hash, which does makes it easier to interface with, but it's a bit weird for people who didn't expect it to work that way.
3. It supports array methods with getting objects, but they don't mutate the array in the database, which was one of the main reasons I decided to make my own thing.
It took a while to get it working properly, mostly due to getting some weird ass errors, but in the end I finally got it working as I wanted.
I never really expected a lot of attention for it, but it makes itnjust that little bit sweeter to know that other people use it. And even if no one else uses it, it makes life just a bit easier for myself. -
Export data from a database that you've not modeled is a problem (sometimes), I just realized that this DB has two tables to storage cities, the main difference is the id, the other fields are the same in both tables, I hate that kind of people....
-
My journey into learning Docker, chapter {chapter++}:
Today I learned that when you use a database image in your docker-compose file, and you want to rebuild the whole thing for reasons (say, a big update), then if you change your credentials ("root" to "a_lambda_user" or change the db's password) for more security, and you rebuild and up the whole thing... It won't work. You'll get "access denied".
Because the database (at least mysql and mariadb) will persist somewhere, so you need to run "docker rm -v" even though you didn't use any volumes.
I love loosing my fucking time.4 -
A client hired someone to work on a new feature while we were working on something else. The new guy makes huge commits that we don't have the time to read, really.
I merged and deployed my work only to find that the whole database was wiped. Apparently, the new guy pushed some code that reset the database.
I Spent the rest of the day looking through backups trying to restore the database.2 -
When you replace a read from db to a read from file from db without testing and when you test it works
4 -
I've now spent 6 hours trying to find a way to do something similar, as you can do in Neo4j, where you find relations up to depth 5, in PostgreSQL.
The issue is, I have to tables. One with persons, another one with relations (incoming ID and outgoing ID) to have a many to many relationship.
I'm at the point where I just don't care getting it to work. In Neo4j it's a fucking one liner, so why the fuck am I getting assigned to do this in PostgreSQL?
To prove a point? Well fuck you, I'm done with this shit.5 -
Customer: "There are only 'X' values in COLUMN_D, your - report - import is wrong!"
Me: select count(*) from table_a where column_d is not in ('X') -> returns more than a thousand... Yeah please only scroll within a couple hundreds of records in your shitty sql client gui without making queries. Fuckhead. -
I was given 6 whole months to rewrite some old monolithic web app exactly 5 months ago today. Now I have to show my boss the progress I've made. How do I explain him that I wasted my time in this order:
1.- heavy procrastination
2.- try new frameworks to work with, pick one, start writing the app, regret and start over again using a different framework.
3.- devrant
4.- existencial crisis and self doubt.
Now all I have are a bunch of incomplete buggy modules and a mental breakdown.8 -
Setupwars. Show off your epic coding zone setup.
Your biggest oh fuck moment as developer. "I dropped the prod DB"1 -
I met my crush last day, she is a junior from the same college, everything was fine until when she wanted to find a recharge shop to recharge her phone. I opened PayTm(One of the Mobile Wallet here in India) and said I'm doing it.
Her reaction : What ? How ? You can do recharge right away from your phone ! wow !
I lost my interest on her :(
She is BTech Final Year Student
Tragedies2 -
We've got a big legacy app which we have to rewrite. The current client applications are only working on XP(!). We have to move the clients to the browser so we can finally get rid of all XP vm-s. The db schema is complex but still 1000+ stored procedures and functions and about a hundred tables with 13 years of data.
So I ask the guy responsible for maintaining the DB code. (he is ~25 years older than me)
me - Where is the source of the database. Which project?
he - Where would it be? It's in the db.
me - So we've got a huge db without VCS, upgrade/downgrade scripts, etc?
he - Yes. I don't get why young developers always want to use shiny new tech like git just because it is cool. It has nothing that an external usb backup drive can't do.
me - VCS has been around since the early 1980's...
he - If you really want, you can put it under git or whatever, so you can sleep better, but I still think it is stupid and a waste of time.
I get that it's hard to keep up, but getting personal...1 -
Guys, a company's HR mailed me for a position that requires strong experience of ">3 years in Python with C or C++".
Does it mean Python and C/C++?
Or do they need someone who is using C/C++ to write Python?
I have some experience with adding Python support to C++ code. Does it count? 😁8 -
name your db nodes after GoT characters, to remind yourself you shouldn't give a shit when they die.
-
I discover last week Eloquent ORM.
A php database abstraction layer.
How to make things quickly! Great tools!6 -
When you realise a so-called app developer has used nvarchar columns to store every single date record, in every DB table of your platform.
Using d/m/Y format.
Without leading zeros.
And, in just a few tables, m/d/Y.
*sigh*2 -
There is a parody of "Cheap Thrill's" by Mongo DB.
Yes Mongo DB ,it was for thier product promotion(Mongo DB Atlas)!
BTW it's one of the best DB I have ever used, it binds well with NodeJs
Here is it:
I know its way old ,but just want to share
https://youtu.be/0vPt7GI-2kc -
Been at it inconsistently for two weeks and a few days now. Hitting approx 30 wpm with dvorak! Starting to slowly integrate it into my daily work. I'm on my way to becoming ambitextrous. 😎11
-
wtf boss!!!! Is it so hard to understand that having one column per year is a horrible bad practice?9
-
My life was troublesome today, had to help a non programmer to run jar files.
The jar executed well from command line in Windows 10 but didn't work on double click.
Did all the tricks, registry edits, cmd commands and at last I found a miracle tool called Jarfix.
Just double click and all okay.
The root cause of the problem was 7zip.
This bug is reported in the Oracle bug reporting and they have closed it as " Will not fix" low-priority report.2 -
This company have a group of three DB in their product. One DB consist of 130 tables, and they DO NOT HAVE ERD.
Better start one.....while I'm bored and do no have task yet.
~pokerface :|1 -
Anyone else annoyed by their scumbag brain that is hard to please but gets content easily?
Or is it just me?2 -
Asked us to build a car and later complain because it cannot fly.
And then, expect us to turn into a plane in 3days? -
Here is a little Story/Joke:
Once I was doing some work on our sql database and I showed my boss the query I wrote and he then told me that it is way to broad. It does the trick but it searches much more. So he showed me the right query and told me that a database is like a extremely easy to trigger person. So we want to ask only as little as possible to not get the database pissed. Since he told me that, it is now stuck in my brain and I will never forget to optimise my queries :D2 -
Occasionally, some guys send badly written SQL to the database and drained most of the resources, then complain the db and apps using the db are not working.
-
That feeling when you debug the Users table in sql, which has a Password field encrypted with hash, but most of the demo users use the same Adminadmin password, so you recognize the other users password because you rembered the hash1
-
get to the office at 5:45AM to do a migration because the client doesnt want to automate it.. but pays extra for the inconvenience...
-
You had that moment when you agree with someone and given a ++ because it takes less space in DB than comment?
-
My office WiFi is freaking fast upto 25mbps, should I download Torrents using it. Is there a possibility that corporate networks are under more surveillance ?7
-
I've been programming a simple DB engine all day. As my commit describes, i cant tell how it went...
-
The other day I fucked up. I coded a safety measure that saves a file on crash, to keep data safe.
I added two lines of code before loading the file, and they crashed. There goes all my data.
(At least got to fix that bug) -
So we finished our requirement ( barely) for a new client. Next is data modelling and system design.
We started with data modelling. Unfortunately the lead developer does not know the difference between database and data modelling.
me: hey bro, we'll do the database and stuff later, now let's focus on data modelling.
him: (acting like he knows) yeah I have developed a sample design for the "data model".
me: no this is database design.
him: what's the difference?
me: dude, they're totally different. Okay, simple explanation data model is what you want to store, whereas DB design is how you store it.
him: So, if I am not wrong, it's implied that you know what to store if you are talking about how to store it.
me: but you don't know what it is you want to store yet. And one of them precedes the other.
him: Okay, let's start with DB design.
me: What?????? you want to build a house without a plan??? That's it for me I am done !!!
I left the project yesterday, later I heard that, the team members are coders, who think that developing a software is all about coding and fixing errors. -
Today is very special day. Our whole PHP app has connection problems with DB. After 6 hours of desperation still nothing...6
-
I'm currently working on a new (for me) legacy database that store percentile numbers in a varchar column . Seriously who the fuck had the that brilliant idea!!!4
-
any thought about the best way to start a solo project? I think going for the db schema first is easier, curious to see your opinion 😁6
-
I know it's old but it happened again and I had to waste a few minutes because I couldn't disable the bloody task this time.
But using psexec tools worked.
Guess micro and soft describes their ux team.
Look at the balls on their micro cocks. "Heads up". How dare you scare me like that on *my* fucking machine that I paid for, god dammit.
"We're going to make Windows better...". Can it suck my dick after updating? Because I'd like to choke the retard genes out of it.
The only thing that comes close to it is the fucking swiping keyboard that I'm using to type this rant.
-
Still waiting for that confirmation email. Multiple resends and still nothing. My inbox has nothing from devrant. Now I can't ++. I want to ++. Seems like I can't have anything I want at all.
.
.
.
.
That's old. I deleted and created my account again but the rant was still saved so I thought why not start with it.10 -
Weekly drama call 1.
(the number reflects the devrant broadcast count not the actual count).
We work with a remote team and the project manager there just loves to talk. It started as something adorable(?) but it's just plain annoying now. He keeps on talking and talking and talking. We just muted him, had a good laugh and missed nothing. Nobody has any idea when he'll stop.
:/
.
.2 -
Buy dell, hp, lenovo and any other craptop company out there and fire all the numbnuts working there so that they slowly die of unemployment in the fucking gutters where their useless asses rightly belong. Oh and castrate them too so that they don't reproduce.
I'm considering going full Lannister on them but that might be too harsh.5 -
Come on, WordPress! Why are you such an asshole? I just want to migrate and move on with my life.
Is it because I started with Joomla? Is it because I cheated you with Flask?
Can you please, please be nice to the same db you made? Am I asking to much for?1 -
Spent 4 hours working with a buddy before realizing our failing code stemmed back to using sqlite3 Npm package, which is asynchronous. Switched to better-sqlite3, a synchronous sqlite package, and alls good.
What's the purpose of an async DB anyway? Seemed like it made storing and retrieving data a huge hassle. -
My one of my favorite open source project was Re-think DB!
It was highly light weight real-time DB.
One fine day, I read a blog by the CEO / founder, telling we are under loss since there is no financial support! and we are closing it, by just keeping the website and docs of prev version alive!
I was heartbroken , for days!
This takes the top place for favourite oss project
Btw
It has high no. of stars in github than Mongo db, reddis, etc..3 -
Rejected for the job . Out in technical round, though i gave all the correct answers.
Me: seating outside with a down face.🦁
HR: what happened? you seems to bit low .
Me: sir ,got rejected in technical round.🐷
HR: work on mistakes.
Me: yeah sir🦊
Inner me: tell me the mistakes fucker...
Why ? Why? Why?
Dealing with rejection for no reason 🐀17 -
protected $db;
$this->db = new PDO($tooLazy, $toDeclare, $everything);
public function getCoffee() {
$getCoffee = $this->db->prepare('SELECT * FROM Coffee');
$getCoffee->execute();
$result = $getCoffee->fetchAll();
return $result;
} -
So what is the best free Mongo DB client for Mac? What are you using aside from the command line?
I prefer good ui and features. Thanks! 👍5 -
Sure, clear the DB every day... Makes testing so much easier zomgs!
Its a database not a dailybase 😂🤔 -
Finally I have something decent for my résumé.
I was going through some LaTeX hell before someone started a cv tools discussion. It was good to learn that json cv is a thing. But it was too late for me. LaTeX posed a challenge and I was bored. It became personal.
After a lot of kicking around and landing on XeLaTeX, I finally have a decent layout. I had to compromise a tiny bit but that's on me for having little content.
(I wanted a graphic résumé but I'll need to do more to sufficiently fill a page. Besides I'd need to design icons and shit for it.)
Now it's done and my job hunt can start!3 -
Try inserting today's date in access db using sql ( 01/03/2017 in dd/MM/yyyy format). Open db and check what has inserted instead.1
-
Last rant update:
I won't have to take a leave after all and won't have to force myself to a wasted day full of useless awkward interactions or roaming around in a park.
Phew! -
Best: rediscovering auto hotkey. It's weird how much it pleases me. 😳
Worst: Oh so many. I've tried to overcome these with varying success rates but there's one that is still a big pain: job.1 -
I am wondering what secure app do you guys use for texting/voice/video.
I know Signal but I am looking for something that uses a username like devrant instead of a phone number.6 -
What Database client do you use? I'm currently using Sequel Pro. Right now I'm comparing TablePlus and DataGrip.
DataGrip - not user friendly and complicated to use but powerful
TablePlus5 -
It's too late for this but I just realized it so I'm sharing it anyway.
How do I get through tough dev days?
Depending on how tough it is going :
House music
Soundtracks for focus
Soundtracks for action (any Assassins here?)
AC soundtrack with chocolate.6 -
Pretty recent one. I found that I can use Perl to edit files using a single cmd line (with regex search and replace). Loved it.
-
A dedicated team has built an "infrastructure" for creating UI for c++ developers in the company. What looks like a poor attempt at recreating what Microsoft did with XAML at first glance, it actually is a horrible exercise in force feeding people the stinking pile of shit that their code is.
The idea is to make it easy to create UI for developers who aren't used to front end development. They should just need to declare the layout. Very noble.
But.
If you want to do anything more than show a checkbox or a radio button, if you dare to define relationships between the UI controls or worse, if you get ambitious with creating a simple UI that uses a lot of similar controls and similar relationships with dynamic content... be prepared to eat your own barf from eating too much of their shit.
Not only do you now need to write front end code (including JS among others), you need to do it with limited or poor support and you have to make sure that it sits well with the house of moist, crumbly cards the team proudly created. Or resort to some very stupid and performance costing "bypasses" that further cripple your application code. Usually you have to do both of these things.
To think that scores of other teams have welcomed this amazing enhancement with full support without any resistance. It's sickening.
I waste too much of energy (and good jokes!) with these people.4 -
ICT class.
Class title: Excel as DB
It was about filters and sorting.
The closest thing to a db was that I found an INDEX function while I was bored... -
Do you have a db specialist in teams? I often see frontend & backend ranting but no db Devs. Isn't that role so crucial as one lost index can cause massive performance drops?5
-
Worked until now on my private mac and used pymssql and freetds to connect and work with a MSSQL DB and Python
Two days ago I switched to an Ubuntu Machine and I couldn't get it to work.
As it turns out Ubuntu was not able to solve the DNS Name into an IP Address.
FML - 2 days wasted2 -
Totally fuck Prestashop! They can't even make DB properly. Now it is not possible to alter table, because they fucked up 1 default value. GJ, I hope it won't broke if I fix this...
-
Been told ill be worming with Oracle DB'S today, as someone who's never touched on Oracle stuff before. Any advice?4
-
Responding to a numb sales guys joke with "do you know the best about UDP jokes? - I don't care if you don't get it! " ...turnin around left the hallway... Unbeatable
-
Saturday morning 9:30. Alright, let's crack this case. Automated PG backups of DB in a docker swarm attempt 5.
-
Today we trunkated a table with 15 milion keywords for our search engine. It did feel very scary... With @Jappe and @hahaha1234
-
What do you think of the Database design of Drupal/WordPress? They use 2 tables for 85% of the data!! Product, pages, whatever are all stored in the same 2 tables. Does that work out better than having each content type in separate tables?
I'm thinking of making an ERP. Would that table structure work there?2 -
When the DBA restores the live db to staging and all your connections fail on passwords. Every fucking day!1
-
Recently I had a task from my university to build some DB with forms using MS Access.
Despite of me constantly thinking that I wold accomplish this using Python+SQLite+Some GUI much faster, I've completed.
And I've got only one question left: why the hell proprietary product with giant company behind has such a terrible UX?
It' really painful to use. -
By implementing proper eager loading in Eloquent, based on a sample request, I reduced it from 850 DB queries down to just 14 DB queries. So that's an increase in 98% performance?
-
mysqldump db > db.sql
yum install mariadb
*config*
mysql -u username --password pass db < db.sql
Why do I control mariadb with the mysql word? I installed it, I want to use it....2 -
Haaaa this moment you understand that, not only there is some old Java running INSIDE the oracle DB but also that it calls the app, that query the db, that run some more java, that call the app, etc.
-
3 database-admins are walking into a bar. Shortly the leave without ordering or even sit down for one sinple reason: they couldn't find a table.1
-
I have a choice to either take a leave without me wanting to or to go waste my day with the people in a theme park that I already don't much like.
All because someone wants their picnic figures to look good.3 -
Dvorak users, how do you manage your shortcuts, like in vim?
I can't quit it anymore! 😜
I am too scared to remap everything.7 -
always the same, while im in a part of the system, i notice an optimization that can speed up a major query which has to join a table which is about 4gb or something ridiculous. i make ammendments using partitions because they're in the defined on that table. test. everything cool. only to be told that theres no job to clear out old partitions so i end up reverting everything i've been doing which basically makes my day's total output == bollock-all. WHY DO WE PUT HALF BUILT SHIT INTO PRODUCTION!!!???2
-
So I'm here after a long break coz my life is shit all over again, and only devRant allows me to rant officially.
I was selected by a recruiter visiting our college in very early days of the campus placements, September last year,
Problem 1:
I wasn't allowed to sit in any of the other recruitment drives by the college, even when I didn't really like the job profile I was in
Problem 2:
The company is taking 12 tests and wants me to work on 3 Projects of bootstrap, rails, and react each, before they give me joining.
Here I am working like an asshole with all frustrations after my college got over to finish the tasks without a penny.
This frustration is only causing more and more delay in my work. -
stdclass arrays of php are a good solution to work with data from the database but sometimes they can be a pain in the ass...8
-
Update to my last rant:
I wrote a reply to the person. Not scathing (as I'd have liked it to be) but firm and in a no nonsense way. My manager supported me. My project manager talked with the person to in order to convey what the issue is and to undo any misunderstandings due to written communication (we have different native languages).
I have not received a reply but my project manager told me that they are analyzing the problem now. I was also told that they are not a bad person. ^^
I think I'd like to believe that. We all make mistakes after all. -
Sometimes the implementation of setting a pw is really wow... yesterday I create a new db in my 1and1 hosting package. I generate a strong pw with a length of 20 and try to set it. It took me 1h to find out that 1and1 only accept 9 signs and I ranted after that because nobody says that they will just cut the inserted pw and set it with no warning or hint that I maybe should chose a shorter one...2
-
Our DB teacher always told us about God (Codd) doin some Join(t)s. He spoke very slowly. Must have been kinda disturbing for normal people...
-
I have for a very long time wondered about, what do people do when using git and databases? If I locally add new columns to the db, how in the world would you easily make the change in production?
Do I really have to manually do it or take the time to make scripts for it?3 -
Dont be that guy, ok. Just clean up your shit and don't let shit go through you.
I will git blame you. I will judge you.
#leaveitbetterthanyoufoundit
2 -
Hey guys, I have a question.
If you ever had to deal with parity (Ethereum node software) and ever ran archive node, you perfectly know how long this bastard synchronizes. For our server it took almost month. Well, today or yesterday parity decided to spontaniously blow up (or crash) corruptiong database manifest file which greatly undercut us.
Anyone knows any viable way to rebuild manifest file withoud doing full sync from a scratfch?
If anyone has any suggestions other than what 95% of internet say "well, delete your database and sync from scratch" Im happy to test if it will solve our burning burning issue.
I am sure there is some way to rebuild database, especially where it's manifest file that's corrupt (Ive checked it, for wtf reason parity decided to truncate the file when it crashed).
Database backend is written in rust, and is called rocks db.
EDIT: if helps, its archive fat database (fat db means it should be easier to recover?)4 -
C++ is the worst thing ever happened to the developer community.
Doesn't have a stand of its own. Always changing. -
When someone edits old liquibase files so the db doesn't get updated and everything needs to be done by hand.
What's the point of liquibase then -
If you are into Postgres and don't know this guy than I don't know what to say...
I wonder if he's on devRant
2 -
Wonder how many companies out there uses Google Spreadsheet as a DB for customer projects.
Company I work in is one of them :(2 -
DB migrations give the chills.
This one went well. It worked as expected but that "uneasy" feeling lingers... -
How is your experience with upgrading from Debian 8 to Debian 9? Want to update my homeserver but I really don't want to screw it up. Especially with the switch from MySQL to MariaDB1
-
Like 3 days looking for graphenedb connection with golang..
just did..
im so happy :'D
guys lets party!! -
I would like to use an graph database for a new application. Do you have any recommendations? How is Apache Tinkerpop?4
-
Want to rename stuuby db to something else. Any suggestion?
Stubby db is a npm package which helps to stub HTTP(s) calls. Many people are confused with DB word and overlook it. 😢1 -
Since HR does job postings on StackOverflow I'm aware that they have a landing page. ...did not expect that. 😀😀
-
The Asus in photo is an old 2008 model (PRO52RL) that I bought last year just for the DB exam.
We have to create a localhost server with Apache and create a database with Postgressql, we used the LAMP solution in the end and yes we discovered the existing of WAMP, but hey ! on Linux look COOLER 😂😎👌
I love and hate him, even The Binding of Isaac make him under a strong pressure 😞 but hey ! for coding with out testing or debugging is perfect 😉 or even for kill a person (it's really heavy )
-
Things I say at work:
"...and the words 'ghetto' and 'database architecture' don't ever belong in the same sentence."
Top Tags
Weekly Rant
View