Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
Get a devDuck
Rubber duck debugging has never been so cute! Get your favorite coding language devDuckBuy Now
Search - "databases"
This is what our university recommends as reading material for databases. I'm still in denial that this exists.32
BF: If you were a database, I would join with you.
Me: Left or right?
(there are no words)15
Senior frontend Dev at my company: "microservices best thing ever"
Also him: "Relational databases gonna die"
Also him (talking to the DB team): "You're gonna dissapear, Mongo is the future"
Me: "Eh... Dude, Mongo is still a database.."
Fun fact: Michael Widenius named "MySQL" after his daughter My. When MySQL was acquired by sun, he decided to start a new open source database, "MariaDB", named after his second daughter Maria.
This guy is (partially) responsible for two of the largest databasesystems in the world.
Imagine his daughters apply for a database engineering job one day. During application process: "One of the largest databases in the world was named after me..." 😂20
Way to many...
- Passwords stored in plain text on the year 2014
- Not supporting HTTPS because to expensive
- Hidden admin URLS
- Databases available all over the internet
- Client Side validation
When you see a web service API accepting a SQL query in one of its JSON fields and the evil starts growing within you..
DROP ALL DATABASES
Just because you can!4
The first time I decided to hack around a bit:D
One of my teachers made a quiz software, which is only used by him(his lectures are about databases), and it is highly unsecure. When I heard that it is written in C# I decided to look in it's source code. The biggest problem I ran into: this program is only available on the computers in his classroom, and he monitors the computers display. However, I successfully put it into my pendrive without getting caught.
So when I got home, I just had to use a .NET decompiler(in this case: dotPeek) to get the fully functional source code. The basic function of the program was to download a quiz from his database server, and when it was finished, grade it client-side. Than, I realized how bad it was: It contains the number of questions, the number of correct and incorrect answers.
I've just made a modified .exe, which contained really little modification(like correctAnswers=maxQuestions, incorrectAnswers=0). Everything looks the same, you just have to click over it, and everytime it will return with 100%.
And the bonus: The program connects to the database as a user with root access, and without password. I was able to log in, download(dropping was available too, but didn't try) databases(with all the answers) and so on.
Never had to use it though, it was just a sort-of experience gaining.:)5
I'm a fucking finance girl. FINANCE. GIRL. Why the fuck am I spending all morning importing databases??
I'll tell you why.. "you are married to a dev. You must have picked something up." Fuck this. Fuck fuck fuck fuck. (no it's not working for the fuck of it, and whoever wrote this program deserves to be hanged by his balls from a tree)24
So I gave this guy access to a database and phpMyAdmin and then I get this:
Him: hello??? i cant make databases i have no privilages
Me: Use tables instead of databases...
Him: I need to make databases
Him: 1. my votes plugin 2. my ftop plugin 3. my forums 4. my new forums 5. my new forums (he runs a minecraft server fml)
Me: You don't need databases for all of those, you can use tables, that's a massive waste
Him: idc i would rather have databases
Classmate: "Databases are not Important"
me: "They are"
Classmate: *fails test*
Classmate: *becomes a dropout*
me: "I told you"10
*all kinda db shizzle at work but finally done and going home. Can't see anything related to databases for the next few hours*
*gets in car and closes eyes for 5 minutes* (I'm not the driver)
*opens eyes only to look right into the center of a license plate: xx-DB-xx*
I think the universe hates me or something.2
Had to do a course on database design a couple of years ago. One exercise was about SQL queries and a bit of theory of databases.
On the night of the submission I got so drunk that I had to use both hands to control the mouse and instead of my solution I uploaded the exercise description.5
I waited until yesterday evening to watch the livestream capture from our creators.
Was expecting something like them being bought by MS or Google or whatever due to how good this awesome network is doing/growing.
As so, i was mentally preparing for a goodbye (the second this data gets into the hands of a data hogging company I'm fucking out (as in, the one who owns the databases)) and then I started watching the livestream.
"aaand here it issssss!!"
Well that was one hell of a relief!14
I'm working on my own code editor with 'multiplayer', option to draw stuff, option to design algorithm schemes, option to browse SQLite databases and most importantly - I've based entire interface on HTML/CSS/JS and entire backend on C# and PHP, so it works both online (via browser) and offline (via program).
Tell me whatchu think, it's still work in progress.
(I've removed the name of it so when I share this project with my future employer, he doesn't connect the dots)17
How do people just go about deleting databases when they don't mean to?
"Ah, a database!"
*Flaps hands at the keyboard until something happens*
"Oops, I deleted the database :/"
(*Posts a rant about accidentally deleting the database on devRant*)
Fuck yes for data hoarding! Wanted to start on a project again but thought I lost everything.
Code is sill in git, (took me a while to find but whatever) database is still on my own laptop (due to ex/importing my entire local host as for databases every time I do a new installation).
Let’s get this fucker going again 😎4
We had issues with lack of disk space on our production SQL server. Another developer decided to delete the databases he thought weren't in use to clear some space.
Ever think about checking first?!
"Read-only Friday" rule: On Fridays, you don't deploy new versions, don't merge code into production, don't update databases, and a lot of others "DON'Ts"4
Fuck relationships, the only relationship I can have and maintain is with my Linux or in my databases.3
Actual quote of our database professor in third semester: "Databases are a lot like sausage making. Once you know how it's made you don't want it anymore".10
Got a call while on vacations, the main server is down.
*holy shit* I thought.
As I opened my MacBook, the phone kept ringing and slack was going crazy.
“What should I do? Where is the problem?”, the voices in my head said..
I opened the terminal and tried to get a ssh connection.
Sweat was dropping down from my forehead.
“Connected” the terminal said.
“Fuck yeah, the server is up, only the app is not responding”, I thought and opened the log files.
Suddenly, “STOP” I shout at the log files that were appended way too fast.
Then I saw it.
I added an index to the modification date column,“ kill -9“ed the process, started again and went back to vacation mode 🙂
And of course I was the office hero for a while💪
For the smart asses, I’m aware that it’s a bad idea to -9 the app process in prod, but it was so overloaded that i was not able to kill it any other way. And we needed that server up again.4
When your raspberry pi is bombarded with /phpmyadmin URL attempts in all its forms and possible paths and versions 😅
Like seriously? Who in there right mind uses phpmyadmin AND has it accessible to the public.
- there's no databases on this Rpi but you keep looking.11
A client was talking to me all day asking about my "hacking" experience.
I taught he was going to ask for a pen test for his trampoline website. At the end of the day, he revealed he wanted me to hack the "competition's databases" so he can promote his "very unique trampoline accessory".
Guess what happened? Nothing, cause fuck legal trouble!7
Client reads about MomgoDB ransomware attacks online.
Him: I heard that the MongoDB is not secure, we should use something else in our system.
Me: Those databases got attacked because security features were turned off. If you want you can have an external security team to test the system when it's done.
Him: I don't wana take any risk, so I we should use something else.
We have been working on this system for almost a year and the final stage was supposed to be delivered in a month.
He wants me to replace it with MySQL11
*Opens a pack of tablets (8000) and start to prep them.*
WHAT THE ACTUAL FUCK.
SAME MAC ADDRESS.
Okay, that's just an er-
NOPE, ANOTHER ONE. HOLY SHIT. OKAY IT'S GETTING WORSE.
Is it my db?
The db is just fine.
*Painfully getting in contact with the reseller*
Me: grumbles grumbles Mac Address grumbles
Reseller: Uh.. What?
It would be okay if we weren't using Mac Addresses as primary key in our databases.
They gave us some weird-looking software to "re-write mac addresses". It's working.
Something tells me that ipv6 is not for tomorrow.7
Him: Relation databases are stupid; SQL injections, complex relationships, redundant syntax and so much more!
Me: so what should we use instead? Mongo, redis, some other fancy new db?
Him: no, I have this class in Java, it loads all the data into memory and handles transfers with http.
Me: ...... Bye!5
Welcome to the company I work at since 2 months, where we:
- do not have secure FTP
- do not have version control for 50% of our projects
- still use classic ASP for major projects
- give our public_html folder chmod 777
- do not have testing databases, only production ones
There's probably a lot more, but this is the first that came to my mind10
Today, social media databases around the world will be forced to accept billions of shitty firework photos.1
Colleague: "I'm gonna update some tables and stored procedures later"
*phone rings two hours later*
Colleague: "Hi! Just wanted to tell you I accidently dropped all our production databases. Have fun recovering them 😊"
If I have to draw out a normalized database on paper one more time I think I might split myself into multiple indexes3
When debugging and testing programs with huge databases, i acidentally start breaking Records in this company.
Had my biggest curl command with 5000 UUIDs (which just made my terminal crash, never happened before), my longest curl request (over an hour) and now Github ... what were your most ridiculous proportions in coding?7
At college (UK) and taking a general IT course (databases, programming, networking) a friend suggested "We should make our own network protocol." (The only language we had covered at the time was Visual Basic)4
Database tip of the day:
Spent hours on Amazon's DynamoDB and ultimately found it couldn't do what I wanted, not without a complicated workaround.
Switched to Mongo and had it working in literally under 5 minutes.
Hooray for Mongo 😀5
I quit my job at a startup because the business guys did not respect my advices in business strategy.
just saw the job post for my position where they write:
"experience with MySQL databases (for example redis and git)"
Now I know that I was wrong. These guys seems to have informations that I do not have 😎2
When ur gangsta af and dev at the same time 😎
P.D. I didn’t do it, I took the image from internet 😅1
My manager is a "you don't know shit" kinda dude.
This one time while guiding us on how to operate on databases which existed and somehow, he deleted the whole database.
Ofcourse, to save his ass at once he claimed "This is why I was telling you all this, see!? The whole database got deleted"
And yes, we had a backup of that database. And yes we weren't able to control our laughter too.
You should have seen his face.3
"WTF? These records should have been inserted into the table!"
...Hours of checking code, trying to figure out how this is possible, can't find a way to have this scenario happen...
...Add additional debug and troubleshooting code, add more verbose logging, redeploy to all the containers, reset all the tables, many apologies to the boss for the delay....
...Co-worker comes in: "oh, hey, sorry, accidently deleted some stuff from the database last night before i left."1
Lol... So I was a intern at a IT Recruitment Start Up as a IT Guy (the irony). I was given a task to upload all his clients into a database from xing. It was a fucking copy paste job... So I told him this sucks... You will not believe what he said next... "you will learn how databases work with this" WHAT THE FUCK DUDE YOURE SUCH A DENSE MOTHERFUCKER. HOW WILL ANYBODY LEARN HOW DATABASES WORK WITH COPY PASTE... YOU RETARD.3
Pressing that “deploy to production” button when it usually consists of multiple projects and databases updating at once.
Maybe I should look at separating them one year.
So one rant reminded me of a situation I whent through like 10 years ago...
I'm not a dev but I do small programs from time to time...
One time I was hired to pass a phone book list from paper to a ms Access 97 database...
On my old laptop I could only add 3 to 5 records cause MS access doesn't clean after itself and would crash...
So I made an app (in vb6) , to easily make records, was fast, light and well tabbed.
But now I needed a form to edit the last record when I made a mistake...
Then I wanted a form to check all the records I made.
Well that gave me an idea and presented the software to the client... A cheesy price was agreed for my first freelance sell...
After a month making it perfect and knowing the problems the client would had I made a admin form to merge all the databases and check for each record if it would exist.... I knew the client would have problems to merge hundreds of databases....
When it was done... The client told me he didn't need the software anymore.... So I gave it to a friend to use as an client dabatase software... It was perfect for him.
One month later the client called me because he couldn't merge the databases...
I told him I was already working in a company. That my software was ready to solve his problem, but I got mad and deleted everything...
He had to pay almost 20 times more for a software company to make the same software but worst... Mine would merge and check all the databases in a folder... Their's had to pick one by one and didn't check for duplicates... So he had to pay even more for another program to delete duplicates...
That's why I didn't follow programming as a freelance... Lots of regrets today...
Could be working at home, instead had a burn out this week cause of overwork...
Sorry for the long rant.2
Anyone else tell their apps and databases to "behave" and "no acting up", the day before they go on vacation for a week?3
Why do I have no problems writing code and designing databases, but draw a complete blank when trying to come up with a good database username for the code to use?4
Got asked into a meeting to give my opinions on the security about software that might be used to implement a web app.
After 20 minutes of listening to bullshit that wasn't even my concern they got into databases and I was constantly talked down, by people who know shit about tech, about the professional use of PostgreSQL and they only did shut the fuck up when I compared their "important business" to Facebook using MySQL.
Come on... Stop talking down about shit you know nothing about.3
Im going to my first IT conference!
By looking at the plan i already regret not getting the "Buzzword bingo"...
Machine learning? Check
Internet of things? Check!
Chatbot/Virual Assistant? CHECK!7
Had a meeting with a web development firm with 10+ developers on staff to discuss ways we could help them improve efficiency and they said "we don't have anyone who knows SQL or databases"...
How do you even find 10 developers who "don't know databases"?11
when your boss can't distinguish back end from front end web dev
I admit the lines are blurred, but the guy whose background is pure front end probably shouldn't be designing databases, and I'd rather not spend my days trying to make videos autoplay on mobile on the company website7
This is a short tale that can be summed up as "oh fuck meee".
After finishing an API the night before I settled in for a day of bug fixes and tidy ups. Until slack went off.
The front end dev was getting an error, a code breaking error. After doing the standard process of request checking i went okay must be me. I find the script that is has the error and the line that it is failing at.
Que 2 hours of the full cycle of anger, sadness, pleading, and finally acepting that it had finally happened I had gone insane. The code was to documentation best practise correct and it still had the same error.
I the cheaked the DB on a whim and I found that my code was not wrong and it was doing exactly what I wanted the data however had a single record that was old and the schema had change juuussstt enoigh to break everything at that record. One 3 secound deletion later code ran perfectly.2
My favorite OpenSource project is Julia (www.julialang.org). As a physicist, I could never really befriend myself with OOP. With Julia I can write beautiful Code, which I also understand (with full UTF-8 support).
In Python you write pseudo code in Julia you write math.
In Addition, there is an optional package on Github for every fuck which can be handled by the integrated package manager (like using QML, Distributions, Databases, HTTP Server, and so on...)4
Last year I was nominated for a reward by some tech internship 'charity' who helped me get my university placement.
It was about having made the most contribution and personal progress. I spent the whole year working solo projects and building small web applications and websites for customers having never written a line of even html before I started.
The girl that won did so because she wrote a couple python scripts to query mysql databases and put it on a table and spent an entire year learning how to do this. Confusingly the judges also told me that programming wouldn't be too hard because it's just copy pasting anyway.2
I love seeing my dev databases filled with people named "ajciebsoah" with emails of "firstname.lastname@example.org"1
MySQL databases beginning with "test" in the name gives even people without login full access to its tables.
Somebody deleted all tables so we had to get a backup from out hoster.
PM emails me a zip file with the message "Can you give the attached a look and get it to work. See email below that there are some items missing to make it run."
Items missing : 3 custom libraries, 2 sql databases, 3 custom sql tables, and oh yeah the license to the program it runs on.1
Using Oracle 10g for our distributed databases practical lab session, and typed many SQL queries in one sheet.
Suddenly this guy came and told shortcut 'ctrl + r' to quickly run selected query.
And the page fucking reloaded and boom, all queries were gone! His evil laugh was more disturbing. 😡😡
Supervisor has me making a web app in this badass new stack called the LAP (linux, apache, php) stack because he would he would like the app to be "simple". He's spot on though.. having a three letter acronym saves so much time.... and then we don't need to worry about a database... or querying.... or efficiency.... or even the web app itself because clearly he expects the fucking code gods to come down and turn this piece of shit web app into a fucking masterpiece if he thinks this shit can be done based on a hacked together file management system. Please save me code gods4
I bought my first VPS today. After years of hosting my email, websites, databases and backups services on my own physical servers both home and in real serverrooms.
Strange feeling, but it feels like something heavy was lifted from myself, I do not need to buy hardware if something fails.13
I goofed up and forgot the WHERE clause in my UPDATE query. Accidentally all of production possibly updated because we don't do test databases. I think it didn't actually go through because I cancelled it but now I need to restore a backup and compare data. Which means explaining this to the co-owner who can help me with a restore. I'm mortified, more so because it was a stupid thing to do to begin with.4
While working on generic enterprise code: querying databases, calling third-party APIs and just passing data around, I'm thinking: "PLEASE LET ME DO SOME THINKING, LET ME WORK ON SOME HARD ALGORITHM OR SOMETHING!"
When finally working on 'some hard algorithm or something', I'm thinking: "ARGH! MY HEAD ACHES! GIVE ME RELEASE! LET ME WORK ON SOME MINDLESS ENTERPRISE CODE!"1
Woooooo! Someone ran a cleanup script that deleted all the RPM package our dev Oracle databases use. Glad I'm not that person.
So I'm not sure I understand this question fully, if it is meant only through code, than I guess none or those people I got to know while I was doing my algorithms and data structures project last semester where we were helping each other with our code
If it's meant generally through code related activities then I gained lots of friends in uni in classes and here on devRant of course and actually yesterday I got to talk unexpectedly about coding and programming languages on an event with a guy who actually studied financial maths in Vienna but now works as a tester and works with databases, that was nice6
My worst dev experience was my first software as freelance...
1 month codding
When delivering the app the client didnt want it anymore...
Two years latter the client calls me because he had a problem... Merging hundreds of access 97 databases... Exactly what my software did (besides editing, filters and remove duplicates)
Told him I got mad, deleted the source code and was already working on a company...
He had to pay for a software company to do the same 10 times the cost4
So I started a 80hour intership today at our Department of Education and this is how it went...
Boss : Design a database to show all applicants that applied for jobs at schools.
*I start thinking which tables and columns I'm going to use and start designing the database, writes out all the tables on paper*
Me : Is there a pc I should work on or should I use my laptop? And which database engine do you use?
B : No you can use your laptop. And btw we use MS Access
*Thinking wtf kind of business even governmental uses Access for their databases. But anyway, start creating the databases and relationships when my boss walks in*
B : No, what are you doing?
M : Im creating the database you asked for.
B : No, you design it on paper. Draw all the tables, draw the report and the form then you come show it to me, if I decide its good enough you can come in tomorrow and start creating it.
*Wtf kind of place is this, are you mentally retarded? You have a IT staff of 3 people, in which only the actual fulltime intern is a qualified IT professional, but when me or him tries to do some actual work, you give us shit about doing what was asked from us*5
When you go at your first IT internship and you realize that a SQL database could be way bigger that anything you could had imagined.
Then I showed the schema to one of my database engineer friend and he laughed at me. :(
Ok. FUCK MySQL Workbench.
Most of our products built on MySQL and we just had enough of the tools that we are using for our mysql databases...
We decided to make our own tool :)
If it goes well, we plan to open source it. Would you guys be interested in it?
We planned the following features:
1. Schema editing
2. Schema versioning
3. Update/downgrade script generation to move easily between schema versions
4. Manual/auto sync
5. Might include our own replication solution too...
What do you think?10
Is anyone looking for a Ruby Developer with 2 years of experience with Ruby, 2 years with pure SQL databases and half year with React?
In our databases lesson, we are going to use Microsoft SQL Server throughout the year.
This shit's setup fails at random, doesn't even start (empty error box??????) on some machines, and when it, uh, works, kinda, it's a convoluted mess.
I'm getting convinced that some areas are not teachable. You have to learn it by yourself. Databases (sql), for instance, the teacher never manages to get the class attention. Even I that consider myself a very interested guy can't handle 2 hours of his explanations. I tried to think in a better way he could teach the content but don't really think there is one ..Do you guys faced issues like that in school?3
almost a year ago, i have no idea of what i was doing at work cause everything was new: coding languages, databases, clients, co-workers, etc. i had 0 experience and i am back here again on devRant after 3836382 years and i am proud to say i've learnt so much and have been promoted to Project Manager. im happy asf and i am now ready for another round of dev rants!14
Dear past me,
never ever offer a customer to rename their databases during migration.
Renaming databases in mysql is evil and will cost you more time than you think,
sincerely, my present me.
Ugh, stupid triggers and procedures >_>1
I feel ridiculous. While learning SQL databases I ran a query that was supposed to fill up the database with test data for me to play with. The actual result?
8 GB and 330,000+ rows.
Keep in mind this database is on a remote server, so trying to delete it times out after thirty minutes. I’m submitting a ticket right now.6
there it is, couting with: 2 instantes of VisualStudio, 3 of chrome, 1 of firefox, 1 of gvim, 1 of notepad.exe, 1 of Spotify and 2 real notepads in the desk.
2 projects, 4 databases and 1 deadline tomorrow 😂.
man, the 2 monitor setup really helps, when you can, go get one for yourself.3
A friend of a friend showed me a leaked password database encrypted with md5 and started cracking it with hashcat, welp with the wordlist and rules setyp for the program it is scary how bad passwords people have, and really devs of these databases, md5 is dead ffs change sha 1 preferably sha 2568
I'm doing databases in school now, but I couldn't wait to make one/learn basic SQL, so I made a database of the devices on the home network!
Shown here is the DB and an SQL query that was basically corrected by the program ;-;7
Any good resources for sql?
Im getting heavy into databases. Im a noob but i need to reach top level quickly.
Im gonna buy 1 oelr 2 books. Im leaning towards oreillys “learning sql“.
Never have I been so satisfied as I am right now after having implemented a login and user account system with the ability to update user preferences with databases n' shit in PHP after only knowing PHP for a day.
Speaking of all that, do you guys know of any good place to make sure all my stuff is secure? No SQL injections n' the like.4
Everything will be about the same, but faster. Quantum computing will allow brick-shitting speeds of data processing, Nvidia will at some point develop a quantum GPU and call it Fuckall architecture or something that will allow to simulate all the atomic-level physics of a whole car (and stuff), 1Tb network speeds will be common, websites and databases work in a blink of an eye.
Also someone will find a spectre/meltdown-level vulnerability in quantum CPUs and everyone will get f-d in the a. Again. Almost.14
I worked for a company that was in entertainment news. Specifically rock music.
On the terrible night of the Battaclan (spelling?) terror attacks in Paris. Few years ago our site was one of the first to run the story (the main attack happened at a rock concert). Anyway the tech debt that we’d been complaining about for months reared it’s head. The site got so much traffic that it was just fucked all night. Literally couldn’t get the databases back up for about 7 straight hours.
Rant about IT teacher
(This happened a few months ago)
I go to highschool and in ninth grade you learn about Excel and databases in general. In the first half of the year we learned how to use excel and in the second part of the year we learned about SQL databases.
So we learned SQL and how to set up a database using LibreOffice Base. At the end of the year we had to do one final project which was setting up a database and writing some queries.
We had to do it in groups of two and we had to choose for what we wanted to make a database.
We had like 5 minutes time to discuss it in the groups and me and my friend decided to do something like GitHub, so a database with tables for all the users, repositories, etc.
Then we had to tell our teacher what we wanted to do. Others made databases for hospitals, shops, netflix, app stores. The teacher asked the other groups, they told him what they wanted to do and he wrote it down. Here is how it went down with my group:
Teacher: So what do you want to do?
Me: A database for something like GitHub
Teacher: For what?
Me (very slowly): G I T H U B
Teacher: what is github?
(I was very surprised that he didn't know GitHub)
Me: well, you can upload files and work on them together with other people. There are also things like branches...
Teacher: Ah ok, so a cloud service
(I was done and wanted to end the conversation)
Me: Yes... it's a cloud service...
(Me in my mind: why do i have to be here)
We named our project 'GitGud', a little bit passiv aggresive.
Yeah so apparently my IT teacher doesn't know GitHub, however he installed Ubuntu on some of the school computers so I guess that's nice
We got an A so that's good.15
So how the fuck am I meant to get any work done with no admin access to my machine, no access to the databases I need to work with, firewall rules stopping me from doing anything from AWS so I can’t get to my data? Deadline in about a week... fuck that noise!5
Course title: Advanced Database Management
-Create a database with SQL.
-Describe data normalization of database information.
-Describe distributed database management system.
-Design databases based on Entity Relationship modeling.
-Discuss connecting to databases with server-side scripts.
-Discuss database administration and security.
-Discuss database systems
Like. Come. On.7
IT'S CAPS RANT TIME!
MYSQL ERRORS ARE SO USELESS! AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHH
I JUST WANT TO ADD A FOREIGN KEY BUT 'Cannot add foreign key constraint' KEEPS COMING UP, AND THE STACK OVERFLOW ANSWERS INDICATE THAT IT COULD BE -LITERALLY- ANYTHING!
THIS IS OF COURSE, AFTER PHPMYADMIN GIVES ITS OWN ERRORS FOR TRYING TO USE THE DESIGNER TO ADD THE RELATION. IT ONLY WANTS UNIQUE FOREIGN KEYS, DESPITE ONE OF THE MAIN USES OF FOREIGN KEYS BEING MANY-TO-MANY AND ONE-TO-MANY RELATIONS!3
Ok... I hate databases... ( subject )
I can’t understand a single thing 😭😭😭
What the hell is view and conflict serializability!!!
Tomorrow is my exam... 😭😭😭😭
If someone can tell, it’ll b extremely helpful 😨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.2
it turns out we probably caused the downtime ourselves. I didn't know dropping 170 databases and deleting 80 entire projects at once could do that"
Gave me a hearty chuckle. Especially as the client adamantly refused to have SSDs installed for the DB to run on top.
Just imagining the poor read-write heads jerking back and forth in vain attempts to find all the data to delete... So yes, dropping 170 databases at once does in fact take a database server down to its knees, as deleting is all the drives will be doing for a while.
At least it wasn't my or my colleague's mistake this time.6
I just officially graduated from a web dev program and it feels...
Learned ES6, React, Webpack, service workers, offline databases, accessibility, (...bla bla bla)
And my knowledge with data structures and algorithms isn't even that great yet.
I look at the stuff I still don't know and wonder if I'll ever be comfortable with my level of expertise.15
The way I was told to write unit tests was particularly terrible.
No mocking of objects or dependencies so the tests ran the actual code in full including updating databases and files. Then at the end of each test there was code to restore all changes back to before the test.
Each test ended up being over 100 lines. Madness.1
*Spends the day writing script to back up production nosql databases before applying sweeping schema changes.*
*Accidentally runs the script to apply sweeping changes instead of backup.*
So.. name one fucken case where your database is not a computer backed thing.
Just asking because.. why the fuck? I don't think your database server supports input of fucking math symbols? JUST USE HUMAN LANGUAGE, AS YOU HAVE TO DO ANYWAY!
It's stupid how everything needs to be expressed mathematically ffs. Not that it's hard to understand - it's just more complex than of a very simple wording.6
So I started my 3rd year on Sunday, and this semester we're going to learn SQL and PL/SQL, as well as C#, HTML, JQuery, AngularJS and a few more cool things, with a LOT of CS crap. And the best thing is - everything is taught as part of a whole! Databases, computer communication, complexity, program architecture... Feels like they all go in one giant swoosh with a common baseline of building network- and web-related programs, and I like it a lot. They even talk to us like we're big kids now.
This semester smells really good right now.4
When the DEV and STAGE databases are down... Yay early happy hour 😝. Too bad for the database guys tho.
I have spent 2 hours fighting with another dev once about mysqli vs pdo and how mysqli is probably worse than pdo, turns out the only difference is that pdo supports more databases, where as mysqli only supports mysql, else their spec is basically the same. 😰2
Rant at myself for being a moron.
Manually tried moving some InnoDB stuff around on a local server and corrupted a load of databases, with no backups since June 28th. Spent all day yesterday trying to recover with no luck 😑
Lesson learned: need to backup databases more regularly. Any good tools?3
Deleted 5 databases out of which 3 of them contains important data. A team is working on a big feature from months on those databases. All of the data is gone.10
Sometimes, during bug chasing, I think about how great investigators we developers would be. Crimes resolved in hot-fix time? No problem!
Seriously, I feel like Sherlock while investigate a bug that's about what's in the databases and how it changed by which user.2
But i have studied databases for a few weeks and i have been thrown into the backend.
Java - spring boot - myBatis - postgreSQL.
Its a big change to my react world.
And its fucking amazing.
Auto tuning for Azure SQL databases is cool but :
DON’T allow it to automatically drop indexes ! (My bad, I should’ve tested that before)
It dropped one of the most used indexes in the DB. Yep, just like that. 150+ timeout exceptions and customers going crazy4
I learned basic, Visual Basic and java in high school, then one year of college studying c++. I really hate c++ and swore I would never become a programmer. After that one year of college, I spent two years out of the country with no computer usage at all. Then 4 years working at a grocery store.
Then my friend told me about an opening at his work place for a java programmer. This was 7 years since doing java and 6 years since I had programmed anything at all. But I applied and interviewed. When asked about databases, I said “I know a little Microsoft Access.” Had no idea what relational databases were, never heard of php, but by some miracle they hired me anyways. Still working for them 6 years later, now an experienced java, php, MySQL, front end developer.
Still have no idea why they saw fit to hire me.5
Well it's a bit long but worth reading, two crazy stories in one rant:
So there are 2 things to consider as being my first job. If entrepreneurship counts, when I was 16 my developer friend and I created a small local music magazine website. We had 2 editors and 12 writers, all music enthusiasts of more or less our age. We used a CMS to let them add the content. We used a non-profit organization mentorship and got us a mentor which already had his exit, and was close to his next one. The guy was purely a genius, he taught us all about business plans, advertising, SEO, no-pay model for the young journalists (we promised to give formal journalist certificates and salary when the site grows up)
We hired a designer, we hired a flash expert to make some advertising campaigns and started filling the site with content.
Due to our programming enthusiasm we added to the raw CMS some really cool automation: We scanned our country's radio charts each week using a cron job and the charts' RSS, made a bot to search the songs on youtube and posted the first search result as an embedded video using some reg-exps. This was one of the most fun coding times I've had. Doing these crazy stuff with none to little prior knowledge really proved me I can do anything with the power of will.
Then my partner travelled to work in an internship in the Netherlands and I was too lazy to continue it on my own and it closed, not so surprisingly for a 16 years old slacker boy.
Then the mentor offered my real first job. He had a huge forum (14GB of historical SQL) but it was dying, the CMS version was very old and he wanted me to upgrade it to the latest. It didn't seem hard at first, because there were very clear instructions in the CMS website on how to do that. However, the automation upgrade scripts didn't work well because the forum owners added some raw code (not MVC plugins but bad undocumented code) and some columns to the SQL tables. I didn't give up and decided to migrate between the versions without the scripts. I opened a new CMS and started learning by heart all of the database columns so I can make a script to migrate between the versions. The first tests ran forever because processing 14GB of data on a single home computer is not a task meant to be done. I didn't give up. I made an old forum and compared the table structures and code with my mentor's. I think I didn't exhaustively finish this solution, the task was too big on my shoulders and eventually I gave up. I still owe thanks for that mentor for teaching me how to bare with seemingly (and practically) impossible tasks, for learning not to fear from being a leader and an entrepreneur and also for paying me in time even though I didn't deliver anything 😂
At what point can I claim to not be a script kiddie anymore?
Like, I've built compilers, and interpreters for an excel-like syntax, I refactored a pdf-parsing library from the ground up. I managed databases and wrote protocols for communicating with hardware.
But most of my experience is with python / nodejs / golang. It is only recently that I started playing with C and rust for actual efficient system code.8
Today I found out we have 5 different Customer databases, one for each product area. We don't have access to more than 2 of them, while corp. it central has full access, but we have to beg and pay to see our own customers....
Now i'm tasked with integrating all these into a Customer db. and the way i get access is cobolt made, fixed length csv files and it's different for each db.
I get some error when deleting an azure service so I put a support ticket asking for help. Just as I am about to close my computer for the day I receive an email saying:
"Product team will disable the account xxxxx from backend".
The xxxxx is our subscription number. The subscription that hosts not only that service but also production servers and databases, storage accounts containing backups, etc.
I replied to the email so hopefully disaster is avoided otherwise tomorrow wont be a happy day.6
So it's Friday afternoon just before a bank holiday weekend here I'm the UK, perfect time for our production database to go TITSUP (total inability to support usual performance), life sucks then you die folks....2
std::string rant = new Rant();
That moment you're working on old code you wrote 6 months, have no clue wtf is going on in it, (Because no comments), but you use the program everyday and found this big that prevents you adding new stuff to a crappy custom database file (I didn't even use Json or anything normal, I used my own file format which sucked). I now need to probably change the writing/reading of db file.
Wish me luck...
I've been assigned lots of database work the last couple of weeks. Managing old databases are what make or break people surely.
The customers have this proprietary mess of a Visual FoxPro database manager.
I spent the entire day navigating what I should and shouldn't export for them (as they're fortunately trying to rid themselves of the service)
When I was supposed to do the export, the proprietary hardware only allowed exports of 25 rows at a time with the free version this big company is using... I ehr... I just regret not converting it into SQL to begin with.2
Any recommendations for a decent free web host service?
I'm using plain html with no databases.
My current host seems to be having issues with ftp.8
How about a Git for Databases?
Do your changes, delete things, create things, and then when you are sure push these changes to your server.
If you did something wrong like accidentally delete fucking everything, just revert and everything is like before again.
Also you can view history and blame people for doing something wrong.
Tell me what you think about this. Not clue how you could implement this tho... Also I have enough to do already so feel free to take this idea!11
Someone at work deleted my test environment's databases.
What. The. Fuck.
If its not yours, don't fucking touch it.2
I think that was that automated greenhouse thingy.
This is basically a Raspberry Pi with sensors, a fan and a water pump controlling the air circulation and watering of the greenhouse. The data from the sensors gets stored in a database and you can check the temperature & humidity history on a shitty web interface.
This was one of my very first projects and I'm really proud of finishing it although it's really not perfect. When I started it I had never worked with
2) sensors on the raspi
before and somehow managed to get it working.4
After like 15 odd years using MySQL I'm about to delve into the world of document orientated databases ... Wish me luck :)5
I wonder, are some apps on purpose made to be small size, but then later when you open them force you to download the actual data made with converting people that are low on space or dont want heavy apps to actual download numbers? since if they now after discovering that, delete the app - they already have boosted the downloads
I can understand pulling offline databases or game updates from own servers to get the newest data, but sometimes you come across apps that have no need in any of those and could just e.g. package the audio which will never be updated5
Couple of SQL databases walked into a "noSQL" bar.
But after some time they walk out...
As they couldn't find a Table... :)
There are two types of unicorn coders. There is the first type, they are talented guys who just can’t stick to only one area — they will be bored. So they learn frontend, backend, databases, visual design, maybe even math, finding beauty in everything. These are your bros.
And then there is the second type. They come to your company just to fuck everything up. It’s mediocre design skills and awful coding practices followed by huge ego. They’ll fuck your project up with workarounds and hacks.
Don’t be like the latter. Read books and always be where there are guys way more skilled than you.1
is there a opensource tool to collect all the existing databases in a big company to one platform/cockpit? In order to make them queryble via graphQL? aka. [Company.api]4
Dev-tip of the day:
Always make sure that your database table fields are long enough to hold the entire third-party API client reference ID, so that the last three characters won’t be cut off..
I’ve been “crying” here while debugging for the last hour because my API function and everything else worked, but the result wasn’t showing up in the third-party application (their API returned a 200), but when I tested it with their API sandbox application, it did show up..1
The mobile application my company is developing is beginning to fail in a prod environment because the third party tool we purchased to sync our 3 databases in the background isn't working as expected, so I have been assigned the task of rewriting the entire application. I chose to do it in react-native/redux which I have never heard of until two weeks ago, and I have never enjoyed programming so much in my life. Shit just clicks and works the first time more often than not. Android Studio had me banging my head against my desk daily. Kudos to these technologies 👌1
Some articles on hackernoon involve setting up multiple fault tolerant databases
Others are about "temporary hacking using just your browser"
This is why I don't trust RSS feeds.4
So my Database professor decided that we should design a database with like 4 tables and hundreds of records and we had to write like 100 queries to produce a specific output from the tables we designed. All in less than a week. This is the first time I'm learning about databases, mind you.5
so in my city there's an opportunity for some
tech university students to attend extra programming classes for a year (12 hours/week). they'll teach many things: (advanced) data structures, databases, oses, computer networks, compilers, making games, data analytics etc. is it worth attending or i should just write down those topics in a to-do list and learn them by myself? i've never attended such courses so i don't know if they are useful or not. thanks for taking the time to read this :)6
My original project has morphed and twisted to become this monster where I’ll need to learn PHP, databases, and somehow get a desktop C# app to read the remote database and execute tasks based upon times in the database. God help me.4
Okay so this question is directed towards anyone with SQL experience. Is MySQL bad to start and bad for beginners? It seems intimidating if Im being honest. and Im confused on how to set everything up and get started and working with SQL and Databases in general15
We're trying to use Oracle databases in Visual Studio. They won't install the Oracle developer tools on my system. Life has lost all meaning. I'm floating in an endless void where the only sensations are confusion and the vague sense that someone is stepping on my stomach4
Has anyone here used MongoDB for relational databases? I am trying to use MySQL with Node but I feel like the whole thing is a mess. There are some ORMs like Knex or Sequelize for MySQL but they are pretty crap. I am thinking if I should just move onto MongoDB instead of MySQL, at the same time I feel a little dirty to store relational data in a document store :(18
Do any of you use graph databases. If so what? I am not able to understand where they really fit in.6
Excel literally has internal support for treating other excel workbooks as SQL databases, encouraging end-users to do that instead of using MS Access properly, and *it doesn't even work*.6
Trying to implement a dynamic data masking solution for our databases, to filter out sensitive data.
This seems like a problem which should've been solved decades ago. But it isn't. All DDMs, proxies, seeders, maskers... they all suck balls.
Which makes me wonder, how many devs walk around with MacBooks with half a million credit card numbers on them...
So, I just recieved a welcome email from bit.ac, with my email and a random generated password. The fact is that, I have never registered on this website. Did someone just registered with my email? Or maybe it's a new marketing strategy, to collect emails from another databases and send them emails, "reminding" them their email and a random generated password, so that who recieve the email, to be confused and to access the website to see what is all about,resulting that the company gets more traffic & eventually new possible customers?7
I will have you know that being part of the mobile solutions team is pretty sweet when you have nothing to do but keep a few databases clean and up to date, test which iPad is best suited for the sales people and buy 20 cases to test them for sturdiness.
Seriously without dumb idiots arguing about roaming costs and demanding help with the most basic shit this would be heaven.
I mean it's apple but still having every color of the 9.7 iPad and of the 12,9 pro stacked up on your desk is pretty cool.
Question for devs who work with databases. Do you constantly get tasks that involve joining data not on keys? Data from Exel files, other servers, etc where you have to try to match things on dates, amounts and other normal data.5
On the MSc I was participating in, there is a teacher that has a lesson about Databases.
The MSc was not only for experience computer science students. We were informed that the first semester would be as an introduction to all.
So, Databases. No introduction at all. Just read the powerpoint and the pdf he had just translated (or not, because some were just from the internet), just refers to how they are structured briefly. He showed everything about Databases without the students that didn't know much to be involved (we didn't get to our lab for some reason) and then there was his assignment.
His assignment was written as it would be from a customer that knows shit about Databases (sorry but I had to rant). We sat down student's that knew already Databases and some of us worked as database engineers. We agreed on some steps that after read the next chapter of the assignment we reconfigured them. And so on, until we had nothing and we were back at the beginning.
Needless to say, I did not lose my Christmas holidays for him. It took me 2 days after to build a database that was not a full solution but a part (I wad noy sure, the assignment was ambiguous). I passed the lesson with the minimum passable grade.
So, I wrote a nice email to the MSc teacher that had to organize it (or something like that). I did not swear at all. I was professional and wrote what I encountered and what it should have been. The Databases teacher had always that smirk and face that he was THE boss and had no respect for his own lesson. But I didn't mention it. The organizing teacher shared the email with the databases teacher.
And the time came that we had another lesson (web development, it was awful under him) with the databases teacher. And he had the wonderful idea to read the email out loud in front if everyone. He did noy mention my name. I raised my hand and told my colleagues it was me. Then I asked him in front of them, if he was contented with the results (only a few passed the databases lesson and max grade was the smallest passable), first he avoided the question. I asked again. And he said yes. We all looked at each other and somehow knew. No one spoke and I didn't push because I didn't want to take the web lesson's hours for this. It was just hopeless.
From there on, the teachers said we were their best class ever but the most complaining one. They didn't even bother to analyze the "complaints".
So, there you go. One of the lot of those teachers.1
New to databases - How is it that Oracle has been around for so long, yet have terrible documentation? Their support forums consists of condescending developers who never actually answer the questions and the forums’ format is just so bad.10
I remember back then when we were building an E-commerce website. To maintain good performance the boss insisted using flat table. This was also applied to other projects like GPS. That was already 2013 when NoSQL databases like MongoDB was around already. His concern is he didn't like to risk on new technologies and it would cost money for training instead of using the existing "MySQL" and Microsoft SQL Server.
Everything I learned from that guy was just poop.
DBeaver is probably the best, most underrated UI for interacting with relational databases, that's free and universal.
It's just sad that I had to try out literally everything else, which is total crap in comparison, before I stumbled upon DBeaver.1
Yesterday, friend asked me to help her with some homework that used Microsoft Access. Reluctantly, I agreed. Upon seeing her textbook, I realized why on earth she's using Access. It's a Shelly Cashman Series textbook, a brand I hate with an utter passion for many reasons. Her book was an updated version of the one I used for "Introduction to Computers" at my first school 3 years ago, in which I learned how to use Win7, Word, PowerPoint, Excel, and Access. Nothing, in Access or that book, has changed since then.
Additionally, mom is planning on going back to college hopefully this summer, the same one I first went to. She too will have to take the Intro to Computers class, and the next semester (which may be fall if she gets summer classes), she'll have a whole class that solely uses Access for everything.
My friends and especially family should be glad I've worked with databases and Access before and can explain everything...2
Delete data because it's corrupt. Angry call from support that their data is gone but they've managed to recovered it. Try to explain why it was removed only to get told they need that data. Fine whatever but if I see any more bug reports about that unit I'm not solving them because it's the data not the code. This is why I wish they'd test on their own databases, which they have, but somehow don't use.
Why not : How school make you love/hate a specific domain in Computers in general ? Like Databases, Model Driven Development, simple coding, whatever3
So we are migrating between different hosts so I write a nice script to move two pieces of encrypted data between the two, one over ssh, the other over https to two separate end points. One boss says can’t do that as it is insecure because they come from the same script!
Another boss objected that I wrote a script to dump databases in bash rather than like his in PHP even all his PHP does is run the same bash commands, I just took out the middleman and made it faster.
Been working on this project for the last 9 months, it's 1000 times bigger than the original spec, but the worst part of the whole experience is the god damn Microsoft Access database and migrating data from it.
Wanky encoding, references that aren't actually linked up, ID's that aren't unique, meaningless columns and table names.
Pushed me to the edge.
Why does MySQL call databases schemes? Makes absolutely no sense.
Schema is the metadata around your tables or documents. What is Json Schema? Metadata around a json object.
MySQL, databases contain data. Schemes do not! Bad DB technology. Bad...3
I’m a full-stack Dev, but my job description restricts me to backend - app logic and databases - but the frontend Dev makes crappy markup templates and I have to keep closing unclosed tags and replacing ID css selectors with classes.7
I just accidentally installed mariadb and completely fucked mysql. Probably by now I've deleted my databases, but luckily nothing very important.
Time to get round to setting some proper backup system I suppose.3
I've been given a huge stack of paper, some users stories and loose specs. Was tasked with engineering the specific requirements, then the models and finally the database. Then I need to build an API on top of that.
Stuff I'll use is Go and Postgresql. Small issue is, I've never done DBs, so I've no idea what to do or where to start.
Does anyone have any resources to help kick-start myself in this field? I've been reading on SQL, but that doesn't really tell me anything about data structures and how to transform those user stories into product requirements.6
Working on an application - everywhere an enum should be is a database table instead.
Me: What happens when someone changes "rejected" to "approved" in your status table?
Me: What happens when you re-seed your database and the indexes for your types are different?
All problems, with no time or scope to fix!
USE A FUCKING ENUM9
Testing an application we were going to partner with. My colleague and I where able from the login screen to drop all databases including the system ones and use xp command to send email and access the server.1
Is it worth it to make a UI in c? (console application)
Note: That is our school assgignment due next month,
make an interactive app using databases in c that runs in console
ex) theater seat reservation system4
Some friends of mine were working on doing neural network image processing and wanted to build a social network for it. I got to play with graph databases, mobile app development, and neural nets. Unfortunately, project never took off, but it was fun nevertheless.
is pre-debugging a good thing?
I have a habit of implementing a project(for e.g. a mobile app) like this: See the project, break the tasks to be done into small parts(Like UI layouts- setting, listeners to implement , graphics involved, background threads required, databases necessary, etc.)and then code each of them step by step , while simultaneously testing their working (For all possible test cases I could think of ) side - by side. this results in my project getting developed in far more time than other people, but I always have something good and working all times to show to my bosses.But I really feel stupid when I spend 2 hours handling the animations and ui while I have yet to look into databases and other more important stuff
I guess that's a habit from my good old python days(its IDLE was a playstation for me) but I wish to know better approaches,if any?4
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
Colleague: I'll write a stored procedure that does fully qualified database table path names to access data from the other databases and then do business logic with all of it in the same proc.
Me: That will be 600 lashings.4
Fuck you, webdev.
I had to explain to a new web developer about an Oracle database and Toad. Anyone remember Toad? I still remember not too long ago, developers knew the basics of relational databases and available client tools.
I have this database systems professor who cannot for the life of her teach this class. She goes on random tangents about anything and everything. She asks weird trick questions and gets mad when we don't get them right. She is just very unorganized in general. Her lectures just feel like one long run on sentence. So I guess to make a long story short, anybody have any good resources when it comes to learning about databases?9
IT teachers here at my school giving us 20 different and completely unsuitable for Access databases businesses, as subjects for indeed Access databases. And then be like "Create documentations for that"
And they actually mean by that is
So I clicked here then there and then I selected and pressed the C symbol key while holding the Control key on the keyboard input device connected on my computer, which happens to be plugged into the wall outlet..
As a full-stack developer this is just so cringy I'm speechless..
After 4 1/2 hours of testing I have redeployed my postgresql database from Windows to Debian Server. I can now access my database and deploy webapps from any computer, anywhere, anytime.
It's 2:30 AM in the morning. I am exhausted but fulfilled.1
Which database program do you use? MySQL, MongoDB etc.
I'm using MySQL at the moment, but a lot of jobs requires MongoDB. Does anyone know why?
Though I can't get it to work on my dedicated server, giving up for now...13
I'm studying Databases and I'm getting confused about Foreign Key.
A Foreign Key made reference to Primary Key of another table. But what's the point? Can't I simply use a value and select requested data where TableA value is equal to TableB value?
Sorry if I didn't explain it well, I'm so confused lmao7
Can someone explain to me what is meant by, "full stack," nowadays? I see posts by people saying they're, "full stack," but don't know anything about Linux, networking, databases, or daemon configs.
How can you possibly call yourself a full stack engineer if you don't know anything about infrastructure?11
Thinking about dropping Google cloud console and Google domains and just go back to namecheap, just pay the $80 a year to have them host it and not have to worry about the server's and databases personally...
Anyone else got good recommendations other than namecheap?6
So... I might have to build a survey and analysis tool to be used online nation wide (the final client is the government).
The bad news, it's probably going live in a week.
Even though 90% I wrote and tested in the last 3 years (matrixes,formulas,dB, Interface elements ) from previous runs, I have to handle fronted, databases, math, testing and design.
Over a daily changing methodology and session workflow (by my direct client).
No sleep for the next few days 😭6
Inconsistent, legacy access databases might just be a tad worse than excel sheets.
Not sure if to end myself or the author...1
Just spent all morning adding my own user account to my local MongoDB because some network security guy found I was running an unprotected server on my PC....
I tried all the admin roles to get full access across all databases I have but none worked....
Until I see one at the bottom of the official documentation:
Why Dart was designed with idiocy:
1) naming conventions are idiotic
Most other languages are smart enough to not throw errors when the variable name matches its type. And lots of others, for any lexemme - only 1 naming kind is allowed.
Fine. Oh wait, there's that thing called existing databases and GraphQL & other APIs, should they all adapt to this? No, because 2) is the bonus
2) String keys in objects. Unless it's a class with boilerplate, you write them as strings and access them as strings.
So here's the solution when you want to integrate Dart with existing services: write a lot of JSONSerializable decorators to fit with dart's pissy naming requirements.3
Recently, I launched a website to practice and perfect a lightweight Larval CMS that is forcing me to learn Databases and good sanitization practices.
Trolling Zuckerberg's Facebook for Images to make potential MeMes, I can't help but notice he has quite a ridiculous and unrealistic amount of instances in which he seems to be talking to military and government officials.
Figured I'd use the old humor as a weapon to shed light upon this.
Been ripping the hairs from my skull the entire week trying design some new databases and some SQL to pull the correct data from them.
Litterally 5 minutes before i log out for the weekend I run my test cases and everything works! Amazing start on the weekend :D3
*looking over an Excel sheet*
Me: now there are 2 rows that represent the same data, with the same description
Them: I'll just 0 out the one, and we'll ignore it.
Me: I'm never letting you near any of my databases.
I always feared databases, but Django makes it so comprehensible. I only have to define relationships, and everything else is taken care of under the hood. Love it!11
In my current company I am trying to introduce functional/api testing with database, and I am kind of hit the wall. So company and their product was around for a very long time, the size of skeleton mysql database (without or only necessary data) is over 300mb. It takes up to 5 minutes to import it.
Now idea initially was, that when developer runs tests, database is automatically imported (with unique name), migrations are ran, tests are ran, and then in the end database is dropped. Obviously this approach is counter productive, especially for TDD, if something changes, you need to wait 5 minutes to import database alone.
It’s also worth mentioning, that most developers work in single server, and also share mysql server (which is shared by everyone in company), so we would like to prevent junk databases (that are created during testing) and save some space, this why we wanted automatically import and drop db each time.
Also tests are ran in transactions, so in theory same database should be reusable (unless tested code already uses transaction, then it’s fucked up...).
I thought about separating import and drop functionality into custom commands, then developer could import and drop db on demand (and it would make sense). Then also have a cron script which would clean up those databases every night. It seems like the best solution at this moment.
Anyway, I have some time until our architect is back in office and we can discuss it, so I figured, I will ask fellow devranters, do you have any recommendations? How do you manage your functional tests and databases?2
My laptop was at 500% of course usage and ram... Wtf...
Had to stay till 1am because I was debugging a microservice system with 15 services, 3 databases and a full mail server. Freaking integration tests took all night to build and run. Don't have a remote server to run this on because the guy is sick. Arghhhhhh8
Looking for a Framework or language that has:
- multi-platform (Windows + Android minimum)
- Easy to design GUI
- Can use file databases like SQLite
- Can use serial, BT, Wi-Fi to send-receive data.
I already used Python + Kivy but I think there must be easier frameworks for this...22
So the curriculum director is sad that she can't query lecture objectives that nobody ever entered out of our homegrown database, so she's insisting on buying an expensive off the shelf system, I guess expecting these data to magically be available once it's in place.
This also means I'll have to rewrite the API I've been developing for the past year that powers most of the curriculum resources.
Why can't everyone just know how databases work?2
Why is it so difficult to tell the people to not use the same passwords everywhere? I thought of a service which searches all leaked databases and predicts a password based on that as a warning for the user... Having the program told you that your password the user is likely to enter would be XY, because the adobe OR MySpace OR Dropbox passwords for the email OR username entered was that password could be a bit more aggressive but useful to let the users at least think of secure passwords.1
I've been in technology since 2007, programming and databases since 2008. Each new company/position/department/role is a new challenge that I couldn't have attempted without doing the one before it. It takes time and energy to hone your art and skill.
Emailing clients their website, databases and domain codes. Tell them to move it to another server in two weeks because this one is phased out.
What is up with the 2000++ tables databases? I am supposed to build a DW from those, but that just seems impossible...2
So, I have a pretty decent understanding of big complete languages like Java, I build android applications following several design patterns, solid principles, building big stuff with databases and servers and libraries interconnected with gradle, tracking everything with git, using tdd and functional programming capabilities blablabla ... And I still have trouble making sense of a FREAKING STUPID SHELL SCRIPT I MEAN WHO CAME UP WITH THAT SINTAX I HATE IT SO MUCH OMG I CAN'T EVEN
But for real everytime I need to read a '.sh' I literally wanna throw my computer away and die. Am I alone?
getting over studyong databases so returned to my roots of repairing power tools for a break did anyone else come from a very diffrent career route before starting software engineering5
I have been sitting idle for so long I completely forgot what it feels like to dive nose first into something new7
what books, resources would you recommend for improving software design philosophy as well as computer science and database design ?11
Databases and LDAP down since 1 1/2 days...so embarrassing...am i really working in an it company???
luckily there are options beside work...hello amazon, spotify, devrant...:D
if we got Server/DB issues it always takes about at least half a day to fix it! *facepalm*1
Working with nested arrays in MongoDb!! Who would have thought it would be such a pain to update data in nested arrays in a database! So frustrated!!!!
We had a course on GUI and Databases as part of my bachelor's degree. It was a basic introductory course (I am a mechanical engineer) where we were expected to design some tables and build a simple front end in VB6.
But the instructor was so bad that he hardly taught any VB code at all. And as far as theory on databases was concerned, about 80 percent of the lectures involved some generic introductory statements followed by an explanation of the terms DDL, DML and DCL. I do not remember him writing even a single SQL query to explain to us how it's done.
I had a fun one for one of myself but then I heard a "technical architect" at my company used the same login and password for a project's production and development databases.
I then had to deal with the crisis of a new dev on that project blowing the entire production database to smithereens because of said decision.
Why employers strongly believe Front-End and Back-End are synonyms of Full-Stack?
They are requiring Front devs to have knowledge and experience with relational databases and Back devs to be experts in HTML and CSS, sometimes graphic design stuff too.
For God's sake just hire a Full-stack Dev3
Definition of database table in my DBMS book :
Table is a rectangular array 😩😂😂😂
I am like why am I even studying this subject1
Start with simple projects then keep improving it until you reach the depth level that you want.
I used to learn a new language/technology every month, I did that all this year until now, I learned 3 new languages, 2 new databases, 1 new paradigm, so many frameworks and methodologies and design patterns applying in real world projects !
When you make an account again, because the site in question fucked up all their users accounts when moving databases, and after 5 tries for a new password, because they seem to contain too complicated characters, they send you your password in clear text. My goodness..1
2 o clock (night) and i need to hand in a deliverable tomorrow, all small extras are implemented only the main feature not. I was so focused on perfecting everything i forgot functionality. At least it looks fantastic
I'm completly hating having to work with databases at college.
I have to use my department's Oracle server to which I must connect using a VPN that fails constantly and I must use SQL Developer that hangs every single time I want to do more than a single Select with it.
Maybe next year I finish this course unit.5
MySQL Workbench 32-bit requires Visual C++ 2013, but all I can find is VS 2015 and later. So you need to have a 64 bit computer now to develop on mySQL databases? Well that SUCKS! A lot of devs work on commodity hardware, i.e. somewhat dated, 32-bit computers. Most devs that I know, including myself, are not interested in the latest, flashiest, most expensive hardware.19
I start website with Databases, it work well but I want to upgrade with new feature.
Some features could be better in an other site.
So I build another website with many features and think about new widget and concept.
I start another one again and again and again...
Does I am the only one to do that?
Another haveibeenpowned news story, why can't people set a password on their mongodb instance? Is it that hard or different from other databases?3
I run two servers, one that runs WordPress multisite and one that runs a vpn. As a self taught sysadmin I learn best through projects. I’m also interested in databases and backends for iOS (swift) apps. Do you have any suggestions for what I should make my servers do next? Thank you.2
Using DB triggers is something bad? I have started using NoSLQ databases (CouchDB and MongoDB) and I can't find anything intuitive or native to the BD.
The worse is that I have googled it and I rarely find people asking for triggers in NoSQL databases.
What am I missing? My concepts about RDBMS blind me about NoSQL?7
Why is the syntax of SQL INSERT so completely different to the syntax of UPDATE?
...proceeds to rewrite multiple 60 column inserts into updates...2
I'm starting a little side project (a web app for finding/booking musicians) and have to decide which language to use for the backend. I have broad experience with Java and C#, but it would also be nice to learn something new (Kotlin? Go? Rust?)
Additionally, what's your recommendation for databases? (SQL vs. NoSQL vs. ...)
For the frontend, I'd like to use typescript, webpack and Vue.js.
Any thoughts? ;)8
Me, an apprentice, got to contribute towards a project for the business.
I only have access to the git of that particular project, no access to the other projects, databases or sourcecodes.
Thing is, we basically have to redo an old programm to access and work with the database, so having access to the sourcecode of that or access to the database would be very very helpful.
I have to guess the attributenames of the tables and what the code looked like that assembled all the data together for the overview.
I feel incredibly unprepared for this.
I may be a bit tired, but why am I failing to find something that will aid me in getting to grips with working with databases?
I'm not completely useless. I know how a reasonably good database is put together. Problem is that it's all theory and no practise.
I've had a play with MySQL in a terminal. I understand how to create databases, tables and insert data.
What I really want is an efficient workflow where I can quickly put a database together and iterate through a few design or structure changes and then immediately make use of the data from within either a desktop or web app, depending on what I need to achieve.
I've always skirted around the idea of using databases purely because of the long hours I know I need to put in to be able to get good with them. Now I have the motivation, but the information is proving difficult to find.7
I'm going to ask a silly question... When I was introduced to databases, I was shown using Access. The interface Access used seemed to me to be fairly intuitive.
When I was introduced to MySQL, I guessed there would be some tool or other that would allow a similar design and manipulation of a database using a GUI.
MySQL Workbench didn't seem to be great for the task.
What is the 'proper' method used by actual DB devs?2
Why do some firms think you can skimp on hardware for devs. I am expected to do full stack windows Dev on a 3 year old dual core Dell with style 16gb of ram. Asked for a replacement you need management approval for anything better than a 128 ssd and 8gb of ram. Some of our databases are > 100gb.3
It pisses me off. When i have to use older technology or software because new technology or databases or operating system will less community support if they have that, then they'll say it's not battle tested and the best one is "its difficult to find people who know this technology" *slowclaps*
In the end you end up using almost the same thing that everyone else uses.
Fellow Spanish-speaking developer:
Don't forget the WHERE in the DELETE statement.
MySQL by far. It was my first DB experience and I have since used it in countless LAMP web apps. Even with modern document databases MySQL is the first solution that comes to mind
I took over an application that consisted of 4 MSSQL (2005 at the time) databases, hundreds of tables, thousands of stored procedures, maybe a 1/4 of them actual still being used, external links to more than 20 other databases (MSSQL, Oracle and DB2) which all ran from a single "master" stored proc that was kicked off nightly by scheduled job.
The existing documentation consisted of a single word document, about three pages long, describing how to set up the application... on the Sql Server 6 server it had been originally created on two generations ago.
When your boss sees that you’re trying to recover a client’s employee dumb mistake on a database (he basically overwrote new data with old data) and calls his boss to tell him to correct the problem itself instead of making me lose my time finding when he screw up (he wasn’t able to tell when he did this, and I was recovering databases to find the point of idiocy) , plus charging him with for the time I lost.
I suddenly love my boss.2
wow, its 4 am, nd i have been working with complex sqlite databases in my apps for near an year now.
And today at 12pm is my database paper and i don't know shit about the theory and technical terms in this xD
That moment when you get started as a junior frontend and end up having to design a couple databases. I dont know shit about that. 😱 also in between I happen to become sort of unofficial IT staff in this music school. I'm confused. Not a proper rant, but just wtf? At least I'm getting money... someday. Maybe. 😲
At least I'll have my voice and piano lessons covered. 🌟2
Databases are some of the small things in life that both make sense and don't at the same time
One of those things is why are there like 40 config files for MySQL and only the one named 50-servers.conf in a hidden directory actually contains what I need?8
So, question time to see if I'm being noob or not... Context: I have 3 services, that link to 3 databses, ducks live on DB 1, but can have a grape assigned to them in DB 2, and also have a lemonade in DB 3, which saves more details on their dietary preferences than DB 1 and 2.
Scenario 1: To show that the green grape is linked to Mr. Quacks MeUp in DB2, is there any real difference between linking the grape in a link Table (grapeDuckLink) to the guid of mister Quacks (found on DB1) , or
Scenario 2: should I have an additional table that houses all the Guids of the ducks that have access to DB2 and an ID assigned to that guid and link that ID in the grapeDuckLink table?
Clarity, I am fighting for scenario 1 as scenario 2 feels unnecessarily complex... Am I being a noob for thinking that or am I on the right track?4
had a uni exam in databases (just closely didn't make it😒)
it didn't even have sql in it!?
questions about ER diagrams and draw a diagram, functional dependencies with given dependencies, find candidate key and what not, work on a b-tree (miserably failed😣), datalog (who the fuck cares about datalog? the least expected topic) and transaction management/serializability
whose idea was it to not include sql?? isn't it one the fundamental parts of relational databases?4
Best eays to improve database performance?
I have a huge database table with a lot of data, 10+columns and around 5-6million rows and growing. We are thinking about optimisation methods, the data will be frequently accessed, but not in the same ways. even though caching is helping, some initial requests take 6-20secs. What are good ways to improve a relational db performance? The data is date and item based, every item can have some data back from 2016 or older and up to 1000 related rows in each day. Every day new data would be added. Right now working with php.9
I hate pl-sql and data warehousing. For this project we're extracting from source tables using a generic method equal for every student, changing the data and then copying to a table for analytics.
Everyone's project is fine. Mine occupies 90mb and exceeds the quota already. Delivery due in 2 days... So much for that cs grad. FML.
I have been setting up my private cloud the past weeks. And now I am thinking about backup machanisms.
I have already planned redundant storage, and I have hardware available for an additional (on-site) backup.
I am looking to create a weekly backup of several MySQL databases and a large collection of files.
Could any of you recommend a system or method and maybe describe the reasoning behind it?4
I'm just starting with the Hibernate, and I am finding it tough to differentiate it from JPA.
eg. hibernate suggests to use JPA criteria queries instead of hibernate criteria queries. So my doubt is what does it mean? Isn't JPA just a specification? How come it has implementations for criteria queries?1
Hello everyone, i'd like to know which databade do you all use and what will be a good database for a beginner?7
The feeling when someone decided that it was a good idea to give all databases the same name across environments. So you have to:
drop database prod
On your MySQL prompt to restore the test environment from the latest mysqldump.
Never thought naming could be so hard...2
What do you think about blockchain ?, do you think that this technology will change our world for better one or not?
Anyone of you started a project using blockchain technology?2
Absolutely frustrated with some people's inability to make the information in their databases consistent. Had a request to make a report based on some criteria, and couldn't find the information from tables that seemed to have most of the information. Some information was correct based on what was on the website, some was not. What the fuck.1
Client: I need to organize this data in my database, just let me create any folder, and folders inside folders. I mean, it is a database so you can create folders right?
Me: I'll see what I can do
Inner me: NO, F U, that's not easy, that's not how databases work, WTH is wrong with you4
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
In the last days, my developer was working with different kinds of databases.
He uses a database, named TimeScale DB (Timescale). This is the plugin of a famous SQL database PostgreSQL.
He imports the same data in PostgreSQL and timescale DB.
Size in Timescale DB is = 24KB
Size in Simple PostgreSQL = 166MB
This is the record of 1000000 rows, 12 columns.
Data fetching is the same on both databases, But if we fetch time-based data, (e.g 2 days, 24 hours, From Date to Date) we have a 50% to 200% difference depending on the query. python3 & elixir is also working fine with DB.
Results are also nearly the same with InfluxDB.
For a specific use-case, we have software that is handling Simple and time-series data at the same time. If anyone wants to suggest something new, Also tell us.
What would you guys use to backup multiple mysql databases incrementally without root access. I've been just exporting the db through PMA but I'm switching everything to a version controlled system and would like to do the same for our databases.
Oh yeah and the reason I don't have root is we have cloud hosting which doesn't provide root access. I can't even run Yum.
Got offered a new job with a 50% pay increase after 3 interviews, which only one of them was more technical, and it didn't involve any leet code or anything.
My friends coworker tried applying and failed
multiple times previously, so I'm feeling wayyy under qualified because my OOP knowledge sucks, I'm a self taught developer. They asked me more about engineering web solutions - how I would handle a lot of traffic , how I've designed a system where it holds a lot of requests, what do I know about databases, what engines I used and why. I'm very scared to accept, and I like my current company. What do?7
Hi, guys. I'm looking to get into Android development (Xamarin) and to build some simple apps first.
What I have in mind is something trivia-like, with a hosted database (can't find any free & reliable public APIs).
Do you know of any free downloadable databases on the topics of:
http://www.usabledatabases.com/ seemed promising, but it's not free (or I couldn't find any free DBs, as they don't have a price filter).
Thanks in advance!
For persistence, either credentials or data, is there any best practice that prefer DATABASES over FILES? Files such as JSON or txt or whatever...
Do dbs offer better perfomance or security?💾6
Does ayone knows of a
+ Open Source
Data test generator tool?
I'm on my first work with a development that will go to production, and I'd like to test performance, UI and all of that with random generated data. I know about dbSchema but it's trial pulls me back
A friend of mine asked me to create a Discord Bot for him with randomly generated jokes / puns. The coding process might be easy, I know how to make bots, it'll just be the "random puns" that'll bother me. How could I make that?
I thought about having two "databases" where the bot could randomly pick a "start" and an "end" for the jokes. It will surely generate bullshit but that could be fun.
Anyone here knows of any joke that could be cut in half? Google's propositions aren't funny at all and I'm not funny at all.6
I'm rewriting an entire activity of a messaging app. I'm suffering a lot.
ListViews, Databases, Sending/Receiving from server...
And no, I can't reuse code. The original activity is from a decompiled APK, so it's smali code.
People love to talk crap about MongoDB but it's not horrible for getting in to NoSql databases. Is it good for extremely important production apps? No, but nobody is saying it is.
I’m a mobile app developer, I want to learn something so that I can develop backends.... databases, rest apis, admin panels etc. I know basics of php, meanstack and django. What should I choose...4
Started at the age of 6 by doing simple calculator on zx-spectrum. Tho that's just a joke, not a professional experience. Somewhat serious project was started with PHP, without even knowing the language/theory/databases.... After that years have passed and now I can call myself: professional self-taught programmer.
So apparently people use IDA over Ghidra still.
Either they're paying thousands a year for the privelege or they've got a cracked version. Either way, you're getting shafted. (Pirated IDA databases can't be loaded in legit copies, so forget community sharing without exporting shit, and IDA is confused by jumps in anything half the time. Pirated IDA also often has issues with plugins and mods and such.
Why are you people like this?4
How is it that years of development are not enough for NewRelic to add native support of mssql metrics in their unholy newrelic nodejs agent.????!?!?11!
On the other hand "important" databases like PostgreSQL are having native support.
Excuse me... WTF!!!!2
C# question. Most tutorials show code first to create the database. I see how this works when there is one app and one database but I am used to databases being used by multiple apps and reports. I can't convince people that having an app be an app and also design the code is a problem except for the most simple environment. I must be wrong so someone please explain.5
Am I the only one who's hands start shaking when about to send "CHANGE MASTER TO" on a dev server?
Happened to me yesterday, replication got stuck after corrupting a relay log file when the database segfaulted under my hands.
I could check and recheck the positions I was about to reset it to a bilion times and I was still nervous!
Looking for iOS and Android app developers to join startup in Rutherford, NJ area. Must be able to show portfolio of apps and have some published. Must be able to pull and compare data with sensitive databases (social security number, passport, birth certificate, etc) to verify user. You will be compensated hourly. Must sign NDA.
So, this backend dev, thinks because I am doing frontend work I have no knowledge on backend stuff.
I ask him for a backend feature to match my front end feature. He says that that will take about 4 weeks and therefore cannot be included in this scope. I ask why because its something really easy. He says he'd have explained but I cannot get it.
So I ask him why they have their tables structured that way (I went in and checked ). I then went ahead and schooled the guy on SQL, normalizing databases and other stuff.
Put some respect on frontend devs. some of us are fullstack
Hello fellow germans devranters! I study Applied Computer Science (dual) in a big telecommunication company at the moment. But I found out that almost every IT related things (programming, configuring servers, databases whatever) are outsourced, we only work on project plans, project specifications or such things. But that is something I don't want to do my whole life. Are there still some big companys in germany where these IT related things are still made here?