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.34
BF: If you were a database, I would join with you.
Me: Left or right?
(there are no words)15
Too much stupid today..
Client: "Our server is almost full, fix it"
Me: "Okay, you can upgrade the VM, or I can see if theres anything that can be cleaned up?"
C: "Clean it up"
Me: *Finds 5 extra MySQL DB's that amount to 50-60GB in total*
Me: "Well I can remove some of your extra databases, and some of the local backups, as they're also backed up offsite. They're currently unused and dated back to the beginning of 2017, everything is out of date anyways."
Me: "Okay, is there a reason?"
Me: "Okay, so we'll upgrade the VM?"
Me: "I'm sorry, but those are really your two options"
C: "Just fix it"
What in the ducking fuck !@#$#%?
If you're so fuggin smart, then why do they pay me?
I'm clearly stupid and unable to read your mind.21
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
When you were growing up to be a developer and your mom brags about what a genius you were and has literally no idea what she was bragging about...
Funny story my step dad was bragging about me hacking Google to a group of his guys a few months ago (mind you I'm 21, he's a roofing contractor) and he calls me over and is like "yo, Jimmy. Tell them how you hacked google. (Obviously I never "hacked google", whatever that means) and this guy he's talking to say:
"Oh shit. You can do that shazz".
For my own amusement I replied:
"Yeah I hacked google last week. I HTML'd into their json databases to pull out an ASP in order to bash attack on their .Net services using only CSS"
Of course the man's only response at this point was to ask me how much it would cost me to build him a site...12
People complaining "oh I always have trouble figuring out if the clock goes forwards or backwards in October"
Bitch please, I'm dealing with 12 databases, with SQL dates as local timezone timestamps, and an influxDB in UTC. I'm dealing with a backend server configured in CEST and a middleware layer configured in Pacific time, and a hundred functions which try to keep everything straight because no one dares to migrate it all to UTC at this point.
In the whole argument about DST you hear about sleep psychology, electricity bills and farmers.
But what about me, the poor database administrator? What about all these ugly legacy systems, what about all the UX designers trying to fix time input pickers?
I spend 2 months a year in agony having nightmares of rips and folds in the flow of time. DAYLIGHT SAVING DOESN'T FUCKING MAKE SENSE HOW CAN TIME EXIST TWICE?19
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
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
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
*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.3
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
Classmate: "Databases are not Important"
me: "They are"
Classmate: *fails test*
Classmate: *becomes a dropout*
me: "I told you"10
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
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
A few years ago:
In the process of transferring MySQL data to a new disk, I accidentally rm'ed the actual MySQL directory, instead of the symlink that I had previously set up for it.
My guts felt like dropping through to the floor.
In a panic, I asked my colleague: "What did those databases contain?"
C: "Raw data of load tests that were made last week."
Me: "Oh.. does that mean that they aren't needed anymore?"
C: "They already got the results, but might need to refer to the raw data later... why?"
Me: "Uh, I accidentally deleted all the MySQL files... I'm in Big Trouble, aren't I?"
C: "Hmm... with any luck, they might forget that the data even exists. I got your back on this one, just in case."
Luck was indeed on my side, as nobody ever asked about the data again.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?!
Way back when, someone named a critical table in our schema as plural, not singular. So it's a Dogs table not a Dog table. No other table is like that. In any case that forced our Hibernate entities to also be plural.
Dogs dogs = new Dogs() ;
List<Dogs> dogss = blahblah
You get it. And yes dogss is what collections of Dogs entities are called.
Today I found out why the table is plural. It never dawned on me before, but the name of the table is Orders. The name of the table is Orders, you see, because Order is a reserved word in SQL. So clearly, there is no way to name your table that.10
10 years ago, I found a vulnerability in the connection between an insurer I was working for, and the network of databases of municipalities. I was only a hacker in so far as kids who watched Hak5 are considered hackers, so I always carried this laptop with a fake access point, package sniffer, wep crack, sslstrip, etc with me.
The vulnerabilities allowed me to register a new identity, for which I requested a passport.
Walking up to the town hall desk with two passports with different names, both mine, was pretty cool.
I did not do anything malicious, and was hired to fix the issues (wep encryption on insurers trusted wifi, and municipality postgres gave write access to all third parties)
For a few days I was the coolest kid in school though!2
"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
My friend and boss，told me he would teach me code 2 years in a half ago.
I can know create my own module with webpack， have my automated doc， use react， redux， he taught me linux， git，unit testing， databases，docker， and so on...
Im not an expert in any of it butbi know what they are for and can play with them more or less comfortably.
The best advice he ever gave me was:
“coding is not about coding. We are like the greath painters of history. They were great at painting but even more at creating. If you have no creativity， you can paint as well as you want， its worthless.”2
Gf: "Why are you such a typist"
Me: "I promise not to buy more keyboards with blue switches..."
Gf: "No, I mean like being racist or sexist, but you discriminate types"
Gf: "You are always bitching about how awful date/time types are, with timezones, leap seconds and daylight savings"
Me: Face turns pale, thousand yard stare, vietnam-flashback to when I was writing a calendar scheduling/meeting/matching tool which used 3 databases, with timestamps in different formats, and web frontends for people in offices around the world.
Me, with a soft broken voice: "So?"
Gf: "You've been working on that palette tool this week, and you keep talking about how interesting all these colorspaces, white balances and conversion formulas are"
Fuck relationships, the only relationship I can have and maintain is with my Linux or in my databases.3
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
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
I really hate it when people immediately say "Yeah I don't get this stuff" even before taking a moment to even try to understand it. Mostly when talking about computers and coding
This even happens with the most simple thing I show. I sent someone a picture of a registration page I made, and I said: "This is where you create an account". He replies: "Yeah I don't get this stuff". I thought to myself: fuck, what is going on with this world if they dont even understand what a registration page is?
Another time I told my mom that data on databases is stored in tables just because I thought she was interested, and she said: "Yeah I don't get this stuff". COME ON EVERYBODY KNOWS WHAT A TABLE IS.
Just stop saying you don't get it before I finished, just because its about code and programming, its fucking annoying and it makes me lose faith in humanity9
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
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
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
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 😊"
Today, social media databases around the world will be forced to accept billions of shitty firework photos.1
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 mind9
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
If I have to draw out a normalized database on paper one more time I think I might split myself into multiple indexes3
A few years back I worked at a company as their front-end web developer with one other guy who was their "back-end" developer. PHP and MySQL specifically. He was eventually fired and I took over both development roles. When I got around to seeing his source code and the way he had created the databases, I immediately saw why he was fired. This guy did not understand the concept of loops. Instead of separating out tags and categories with a split / loop, he set up database tables for EVERY. SINGLE. TAG.
i.e. tag_1, tag_2, tag_3, etc. And then to top ot off, instead of looping through the tables, he set up huge conditioks for EVER.LY. SINGLE. TAG.
i.e. if(tag_1) else(tag_2) else(tag_3) etc.
That fucking guy...6
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 😀6
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
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
"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
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
I just found out at my company it is policy to perform random drug and alcohol testing of all employees. I guess this makes some sense for other parts of the business where people use heavy machinery, etc. but they also test office workers.
I don't take drugs and I never drink during the day but I don't want to be tested. I am a professional person and I am trusted with development of our software and valuable internal and client databases so why cant they trust me with this? There are many developers who produce poor quality work even without any drugs, etc. Surely the quality of my work is enough.
Apparently here in Australia if I am asked to take a piss test and refuse they have the right to sack me. If they ask me I think I might resign.31
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
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?5
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!8
Anyone else tell their apps and databases to "behave" and "no acting up", the day before they go on vacation for a week?3
Mother fucking SQL, fuck mathematicians, fuck every thing!
Enter SQL, there you need to put `SUBSTRING(input, 1, 1)` because fuck every one! Fucking math guys who developed relational algebra on which (most) databases are based on (I love you for it, but come on you fuckers!), Decided that the first character should be at position 1...
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
An update without "where" clause, over a billing program DB.
SQL Server, production server, auto commits (SSMS) and no backups.
My first mistake with databases.
I got the task to set up an NAS, because "server has too high maintenance costs".
I built two databases for this company and the big boss loved my work. (spoiler:not because my work was outstanding but because I, as a student, am cheap and willing to learn).
And now? Reality hit me for good. I looked for a enterprise worthy NAS solution, sent them the details, they bought it and now it's 00:00 in Germany and I'm sitting in the empty hall, trying to configure the storage to work like they want it. On a friday. Alone. As the only member of the IT-team. With way to much responsibility.
So... Yea, fuck you for good. I hope your backup gets an disk error at the same moment i quit. (but first gimme mah monney)3
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
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
I love seeing my dev databases filled with people named "ajciebsoah" with emails of "firstname.lastname@example.org"1
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
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.
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
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
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
First year: intro to programming, basic data structures and algos, parallel programming, databases and a project to finish it. Homework should be kept track of via some version control. Should also be some calculus and linear algebra.
Introduce more complex subjects such as programming paradigms, compilers and language theory, low level programming + logic design + basic processor design, logic for system verification, statistics and graph theory. Should also be a project with a company.
Advanced algos, datastructures and algorithm analysis. Intro to Computer and data security. Optional courses in graphics programming, machine learning, compilers and automata, embedded systems etc. ends with a big project that goes in depth into a CS subject, not a regular software project in java basically.4
Woooooo! Someone ran a cleanup script that deleted all the RPM package our dev Oracle databases use. Glad I'm not that person.
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
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
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
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.
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
Front-end dev trying to dictate back-end tech.
We are gonna start split stack (front / back ) development with the following projects and this stupid fucker who knows jackshit about backend , servers, etc... , is more versed in front end stuff and said herself that she knows nothing about databases told me this:
"No way we are gonna use Java."
I politely said:
"We are gonna analyze the projects requirements and see what technologies best fit the scenario"
Me inside my head:
So one of my clients got their wordpress site hacked and basically just redirects to scam links and well.. I looked at in the server file manager and their are like three directories with this wordpress site (not clones but the same?) one in the root, a version in a folder called old and another in temp.. with 3 separate wp databases.. DNS entries had malware redirects, the wp-content folder was writable to the public and contained a temp folder with tons of encoded malware and ip links to malicious sites.. there was encoded malware in index.php, has like 20+ plugins, oh and the theme uses a dynamic web builder so the code is basically unreadable in source and scattered.. and the redirects seem to happen randomly or at least on a new session or something. Oh.. and did I mention there are no backups? 😃2
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. 😡😡
This was a while back. I was hosting a site at a hosting company's 'vps'. I had 1gig for the mysql databases. Problem is, for some reason the server didnt let me have more than 300mbs including everything (there were some videos on the site). I contacted them and they only replied that its ok on their end. Okay, makes sense. So i opened ssh and started looking for the problem. After a bit, i figured out that my site is hosted on a 1tb drive and i could see all the other partitions. Meaning they just slapped a bunch of users data on the same drive. So i wrote an assembly program to offset the mysql files by ~500 mbs. Turns out that put me in an unoccupied 100gb partition and the site was still working properly. So i offset everything to there and i had a 100gb vps for like $5.2
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
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. :(
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
Getting real tired of having to reteach the basics of relational databases to the same 2 people. You were brought in as the expert in databases and SQL Server, I shouldn’t have to teach you about effing primary keys, secondary keys, many-to-many relationships, and how to join the damn tables in a basic query. Your 5 years of experience are obviously a waste if all you did was select * from bullshit. This is the 2nd week and 22nd you’ve asked the same damn questions. Get your crap together and study your ass off if you don’t know. Google the error messages if you don’t remember how to solve it before coming to me with the same question a 23rd and 24th time. I’m not going to get any work done if all you do is ninja up behind me with your laptop in tow and just spout off the question that could be done over IM or a quick duckduckgo/google search. Headphones in = do not disturb ya rude mother duckers 🦆.4
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
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?
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
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
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
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
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“.
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.
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
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
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
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
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 😂
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
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
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
In my previous work, my boss my horrendous. He didn't know anything about programming, databases or scripts. He often had ridiculous requests that we (two developers trainee) had to refrain.
But he wasn't the one who pissed me off the most.
My colleague, who was supposed to have had the same cursus as me, was as skilled as someone without any knowledge. He spent one year to make a database for a new site, with one table per product type and sub-type, per company and per slider. Today there are 93 tables in a database made for a presentation website. When I proposed to see his work, he refused, saying he knew what he was doing.
Now he's still there, I switched job, but I know he'll get the same diploma as me for this shitty pile of fuming crap, and it pisses me off beyond imagination.
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
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
A few years ago I had a Minecraft server and wanted to create my own plugins for it. I failed, but never stopped trying.
Did an internship at a software development company and got an Arduino as a gift; I was hooked - controlling stuff and seeing that stuff happens because of my code? Count me in!
Took classes in school that teach me coding and databases. I also taught myself a bit of C#, Java, C++ and PHP.
5 years and 3 internships later, I'm finally starting my paid training for the job as a programmer next year at the company that gave me the Arduino.
Gaming is what got me into coding, and I couldn't be happier. :)
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
When the DEV and STAGE databases are down... Yay early happy hour 😝. Too bad for the database guys tho.
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
*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.*
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.
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
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
Everytime you tell yourself "This time I'm going to make them stop putting the cart before the horse again!!! No more forced shit implementations!!! NO MORE ! I'm strong!!"
The last hour in the next week:
- Selinux: off
- Firewall: Any-Any
- Application data: Everything installed on OS disc.
- Documentation: At best, someone remembers the server supposed-to-be dns record
- Service Accounts: Your domain admin account and sysadmin for databases.
- Patching: DON'T EVER THINK ABOUT IT..AND NO REBOOTING! I have set very important runtime variables.
- Backup: Maybe someone else will set this up.
- Monitoring: Not needed since clients will create tickets if system fails.
- Production Status: vague at best. Sort of silently transitioned to production.
- Handover status: Probably, but I quit before the project closed.
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
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
The company I work for uses Coldfusion which is a dead technology in my opinion. I was tasked with using a data grid for our data from our mssql databases. This data grid I was trying out uses ajax to make a call to the server and expects the data transfered back in Json format. well coldfusion sucks balls because it's serializeJson function returns a outdated JSON structure and I can't use it. So obviously this datagrid throws errors and when I try looking up coldfusion solutions online or scope out stack overflow, the posts are dated like 6 years back because no one fucking uses CF anymore. My boss loves to jerk to it, it seems because he refuses to change languages cause its all they have ever used. -_- this is 2016 bitch lol6
I love working on legacy products. You just need a good shower and possibly a therapist after.
- Sensitive data sent over the internet encrypted with DES (not even 3DES). Guess it doesn't matter that the key (singular, for the last decade) is basically 0123456789ABCDEF.
- Client databases with open default port, admin/admin superuser.
- Critical applications (potential for substantial property damage, maybe loss of life) with a single point of failure and without backup.
Suggestions, to slow down a bit with sales, so we have time to rewrite this steaming pile of crap are met with the excuse: be more pragmatist, this is standard industry practice.
Some of this shit can be fixed on my own time if my conscience nags too much, but others would require significant investment of time from multiple developers, which would slow down new business.
Guess the pay is ok, so that's something...
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...
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
After like 15 odd years using MySQL I'm about to delve into the world of document orientated databases ... Wish me luck :)5
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
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
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
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
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
I ended up in a job in which I'm the sole developer (state education databases). Good, well paying job. No complaints there, but I haven't been part of a Dev team since my college days almost 15 years ago. I keep up my skills in personal projects.
I use git, like most developers these days, to track my code and move it between my desktop and laptop. However, while I have a GitHub account, I tend to be very"shy" with my code. I usually won't start putting the repository online until the application I'm working on has its intended cute functionality at least... Functional.
That said, I've read articles that suggest developers should almost start their project repositories online right from the start.
My question is... Are there any others like me, holding back their code until it's functional, or do most of you code completely in public (for open source projects, anyway)?3
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
Couple of SQL databases walked into a "noSQL" bar.
But after some time they walk out...
As they couldn't find a Table... :)
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
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
So i ordered myself a web server and am trying to get access to phpmyadmin.
I got generated username and password for the phpmyadmin login.
So i created mysql databases and database users, outside the interface, but that's fucking it, i need to create tables as well, can't do that without the interface, cuz NO ACCESS!
Fucking piece of shit service provider, they had one thing to do and they can't even fucking do it right. How dare they call themselves web hosts at all...
It's probably a badly configured config file but i can't access the file myself to start sorting this shit out, so i got to wait at least 12 hours till work hours to be able to contact with them and sort this shit out.1
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 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
Why is it that in my IT class, peoplle think it is a great idea to say they know how to use mySQL to create databases and then end up destroying the CentOS VPS they had installed for them... like if you really are that retarded, use Microsoft Access, or better yet, LEARN FUCKING MYSQL BEFORE USING IT3
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
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
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.
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
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
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
I've been reticent to chime in on this weeks group rant, feels too personal...but it is what is is.
Most emotional was losing a dev to cancer, and an analyst to an allergy, and an engineer to an accident...ugh.
Most intense was probably losing servers and hard drives without recovery, not being able to get databases back online because they went down so bad, websites being down, not meeting some quarterly goal, shit not building, email campaigns that go sideways...fuck...anything involving reactionary leadership...unrealistic expectations.
But all that shit, while seemingly important or "stressful", pales in comparison to someone you fought with in the trenches not being there anymore.
restore -if friends
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
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.
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.8
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
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
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
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
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
So thanks for whoever pointed out my mistake with the “!” operator.
I tried to be devcool but i failed ;) but im allgood now!
Getting to the topic:
After scanning people's opinion here i have decided to learn C.
I have done js react and html css for the last year and have an okay grasp on it but i want to learn more.
-memory and ressources
Im a noob ant ive only scratched the surface. Im gonna be soon working on databases and backend java to master the functioning of a backoffice with its API and the handling of form and crud automisation (i probably am not using all the right words. I am learning and being told what to do).
Am i helping myself with C and if so any tutorial advice or good teaching resource that could be advised to me.
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...
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.
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
Why not : How school make you love/hate a specific domain in Computers in general ? Like Databases, Model Driven Development, simple coding, whatever3
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.
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.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.
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
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
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
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.
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
The best moments are when you've been struggling with an implementation for a few days, and then things start to work. I had this happen last week. I have a Windows desktop app processing product dimensional data from multiple warehouses, then sending that data across the country and transposing into a data lake, joining several databases, and sending detailed reports. It was a struggle from start to finish, with lots of permissions issues, use cases to consider, and data accuracy. Finally, I break through and when I step back, I get to see this well-oiled machine of conjoined ideas run through to its eloquent, seemingly fleeting, conclusion. That feeling you get that makes you throw your hands in the air for a job well done! It's very exciting.
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
2 weeks ago I ask my coworker, who btw hates me and try to sabotage me every time he can, for a login for our brand new dev-system (webserver + dbserver).
I needed 8 days until he told me "no, work on the test envoiriment".
I escalated it to my boss, but he told me "no time, do as he says"...
So 3 days ago our bosses boss boss came to me and told us to do this very very important things - or we all will be in HUGE trouble and someone gets fired.
So I do it, I work as hard as I can, finished yesterday.
Today my coworker decides to play with the testsystem, because it is a testsystem, and boooom - accidentally kills a few databases and stuff for this very importent thing. Non recoverable.
And that is, guys, why you never work on testsystems.
He will get fired friday.
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?10
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
Inconsistent, legacy access databases might just be a tad worse than excel sheets.
Not sure if to end myself or the author...1
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..
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
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:
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.
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
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
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
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
*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.
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
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.
How about incompetent management? Company absolutely murders any possible increase in productivity. Laptop provided? Slow as balls. Takes minutes to log in. I get a Mac for mobile development and that's OK. SSD and adequate memory but I'm primarily a .NET Dev. Can't get on the network with a virtual machine. They won't I stall even a managed image. So can't use databases because they're all AD authenticated. Got a virtual desktop environment and that sucks worse in performance than the laptop. Add the Assault on local administration rights and the monitoring software that constantly thrashers any memory and hard drive usage and im about to quit over all this... All this decided by a non developer and not asked for our opinions. Yay large Enterprises
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?
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
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
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!!!!
Definition of database table in my DBMS book :
Table is a rectangular array 😩😂😂😂
I am like why am I even studying this subject1
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
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
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
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.
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
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
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 !
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.
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
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
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'm studying computer engineering. This semester I've got the module "Database I". Its aim is to give an introduction into SQL statements stuff; good for me because I don't know that much about databases yet.
Just wondering why tf do we have to start with MS Access? I feel like being in a Microsoft Word course.4
What is up with the 2000++ tables databases? I am supposed to build a DW from those, but that just seems impossible...2
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.
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
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
Fellow Spanish-speaking developer:
Don't forget the WHERE in the DELETE statement.
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
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
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
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
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 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.
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.
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
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 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
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
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
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.
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?
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
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
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
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.
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
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
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
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
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.
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
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
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.
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.
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.
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
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
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
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!
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
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
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?
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.