Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
Search - "databases"
This is what our university recommends as reading material for databases. I'm still in denial that this exists.32
Senior frontend Dev at my company: "microservices best thing ever"
Also him: "Relational databases gonna die"
Also him (talking to the DB team): "You're gonna dissapear, Mongo is the future"
Me: "Eh... Dude, Mongo is still a database.."
Fun fact: Michael Widenius named "MySQL" after his daughter My. When MySQL was acquired by sun, he decided to start a new open source database, "MariaDB", named after his second daughter Maria.
This guy is (partially) responsible for two of the largest databasesystems in the world.
Imagine his daughters apply for a database engineering job one day. During application process: "One of the largest databases in the world was named after me..." 😂19
PROBLEM: A tickets' company came to us last autumn. They said they have severe performance problems and asked us to help.
SOLUTION: covid and quarantines. All events have been ceased, noone's buying any tickets any more. Performance problems are no more. FIXED.
PROBLEM: Another company came to us recently. They said they have severe performance problems with their huge databases and asked us to help.
SOLUTION: a few days of heavy rain and their datacenter was flooded. along with the backup servers. No more data, no more performance problems with large databases. FIXED
Solving problems genie style!
Way to many...
- Passwords stored in plain text on the year 2014
- Not supporting HTTPS because to expensive
- Hidden admin URLS
- Databases available all over the internet
- Client Side validation
When you see a web service API accepting a SQL query in one of its JSON fields and the evil starts growing within you..
DROP ALL DATABASES
Just because you can!4
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"9
*all kinda db shizzle at work but finally done and going home. Can't see anything related to databases for the next few hours*
*gets in car and closes eyes for 5 minutes* (I'm not the driver)
*opens eyes only to look right into the center of a license plate: xx-DB-xx*
I think the universe hates me or something.2
Had to do a course on database design a couple of years ago. One exercise was about SQL queries and a bit of theory of databases.
On the night of the submission I got so drunk that I had to use both hands to control the mouse and instead of my solution I uploaded the exercise description.4
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*)
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?!
3 SQL Databases went into a NoSQL Bar.
After a while, they walked out because
They couldn't find tables there.5
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 😎3
Fuck relationships, the only relationship I can have and maintain is with my Linux or in my databases.3
"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
a dude just DROPPED the whole Fu**ing mongodb cluster. like Right Now.
multiple databases, expanding multiple projects.
fortunately in dev. but dunno how much data is recoverable.14
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
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
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
I'm the only programmer in the company. Sometimes it's exhausting doing everything. I'm currently working on 3 iOS apps, a web app, building out the APIs and managing the databases at the same time.
Full fucking stack. Every day.11
A client was talking to me all day asking about my "hacking" experience.
I taught he was going to ask for a pen test for his trampoline website. At the end of the day, he revealed he wanted me to hack the "competition's databases" so he can promote his "very unique trampoline accessory".
Guess what happened? Nothing, cause fuck legal trouble!7
Fuck mysql charset shit. Pretty easy to forgot setting charset in server side config file. And after creating several databases/tables, boom! All in latin1. That's just so convenient. are you kidding me? Why would any modern database have their default charset to be latin1??? rather than utf8? Oh, just forgot again, that's utf8fuckingmb4 on mysql land.6
When your raspberry pi is bombarded with /phpmyadmin URL attempts in all its forms and possible paths and versions 😅
Like seriously? Who in there right mind uses phpmyadmin AND has it accessible to the public.
- there's no databases on this Rpi but you keep looking.11
Today, social media databases around the world will be forced to accept billions of shitty firework photos.1
Colleague: "I'm gonna update some tables and stored procedures later"
*phone rings two hours later*
Colleague: "Hi! Just wanted to tell you I accidently dropped all our production databases. Have fun recovering them 😊"
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 mind8
If I have to draw out a normalized database on paper one more time I think I might split myself into multiple indexes3
When debugging and testing programs with huge databases, i acidentally start breaking Records in this company.
Had my biggest curl command with 5000 UUIDs (which just made my terminal crash, never happened before), my longest curl request (over an hour) and now Github ... what were your most ridiculous proportions in coding?7
At college (UK) and taking a general IT course (databases, programming, networking) a friend suggested "We should make our own network protocol." (The only language we had covered at the time was Visual Basic)4
Database tip of the day:
Spent hours on Amazon's DynamoDB and ultimately found it couldn't do what I wanted, not without a complicated workaround.
Switched to Mongo and had it working in literally under 5 minutes.
Hooray for Mongo 😀4
I quit my job at a startup because the business guys did not respect my advices in business strategy.
just saw the job post for my position where they write:
"experience with MySQL databases (for example redis and git)"
Now I know that I was wrong. These guys seems to have informations that I do not have 😎2
When ur gangsta af and dev at the same time 😎
P.D. I didn’t do it, I took the image from internet 😅1
My manager is a "you don't know shit" kinda dude.
This one time while guiding us on how to operate on databases which existed and somehow, he deleted the whole database.
Ofcourse, to save his ass at once he claimed "This is why I was telling you all this, see!? The whole database got deleted"
And yes, we had a backup of that database. And yes we weren't able to control our laughter too.
You should have seen his face.3
"WTF? These records should have been inserted into the table!"
...Hours of checking code, trying to figure out how this is possible, can't find a way to have this scenario happen...
...Add additional debug and troubleshooting code, add more verbose logging, redeploy to all the containers, reset all the tables, many apologies to the boss for the delay....
...Co-worker comes in: "oh, hey, sorry, accidently deleted some stuff from the database last night before i left."1
Pressing that “deploy to production” button when it usually consists of multiple projects and databases updating at once.
Maybe I should look at separating them one year.
So one rant reminded me of a situation I whent through like 10 years ago...
I'm not a dev but I do small programs from time to time...
One time I was hired to pass a phone book list from paper to a ms Access 97 database...
On my old laptop I could only add 3 to 5 records cause MS access doesn't clean after itself and would crash...
So I made an app (in vb6) , to easily make records, was fast, light and well tabbed.
But now I needed a form to edit the last record when I made a mistake...
Then I wanted a form to check all the records I made.
Well that gave me an idea and presented the software to the client... A cheesy price was agreed for my first freelance sell...
After a month making it perfect and knowing the problems the client would had I made a admin form to merge all the databases and check for each record if it would exist.... I knew the client would have problems to merge hundreds of databases....
When it was done... The client told me he didn't need the software anymore.... So I gave it to a friend to use as an client dabatase software... It was perfect for him.
One month later the client called me because he couldn't merge the databases...
I told him I was already working in a company. That my software was ready to solve his problem, but I got mad and deleted everything...
He had to pay almost 20 times more for a software company to make the same software but worst... Mine would merge and check all the databases in a folder... Their's had to pick one by one and didn't check for duplicates... So he had to pay even more for another program to delete duplicates...
That's why I didn't follow programming as a freelance... Lots of regrets today...
Could be working at home, instead had a burn out this week cause of overwork...
Sorry for the long rant.2
Anyone else tell their apps and databases to "behave" and "no acting up", the day before they go on vacation for a week?3
Had a meeting with a web development firm with 10+ developers on staff to discuss ways we could help them improve efficiency and they said "we don't have anyone who knows SQL or databases"...
How do you even find 10 developers who "don't know databases"?11
A colleague of mine had to debug performance problems in a foreign, proprietary application that is ancient.
To be crystal clear: Only reason that thing exists is because some old geezers fear change.
Asked me for help cause it's an _ancient_ MS SQL server that is luckily running on hardware owned by us.
Finding the credentials was already a funny task.
We had to access the vault (not joking here, we have a physical vault for storing sensitive data and critical backups), grab a folder and find the necessary data cause no one ever dares to touch that thing.
The application is btw for a sort of ERP / inventory system that is used in some ancient shops not yet migrated...
Yeah. Story speaks for itself.
Anyway, after dusting off ourselves, we were able to connect.
Was a bit ... Interesting. Everything's in german. The worst kind of german.
After looking at the first tables, I started giggling.
My colleague knew immediately that this was a sign of danger (insert Simpson meme here), raised his eyebrows and asked "How bad is it....".
Me, still giggling, "lemme take a further look, this is gold".
*long sigh from the colleague*
Well... It ended with me putting my hands in front of my eyes, turning around and saying: "I cannot look at it anymore, it hurts too much...."
- German table names
- When a table exceeded 300 plus columns, they added another table with the same plus suffix "_ddd"… where ddd is an zero filled integer sequence like 001
- To join this mess, they created views... Named "generator" - Sequence Number ... Some had the beginning of table names appended, which doesn't make it less confusing.
- the process list was listing queries running longer than 5 mins.
Which isn't at all surprising when generating carrtesian products of N tables with left join.
I've seen shit.... I've seen a lot of shit.
But that shit scared me.1
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?3
Im going to my first IT conference!
By looking at the plan i already regret not getting the "Buzzword bingo"...
Machine learning? Check
Internet of things? Check!
Chatbot/Virual Assistant? CHECK!4
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.
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 "email@example.com"1
If only I knew about the manga like that during my university times... Math could have been a piece of cake.
Manga guide series includes 40 books
Including manga guide to databases.
Closest more professional level same level friendly, would be head first series8
Using Oracle 10g for our distributed databases practical lab session, and typed many SQL queries in one sheet.
Suddenly this guy came and told shortcut 'ctrl + r' to quickly run selected query.
And the page fucking reloaded and boom, all queries were gone! His evil laugh was more disturbing. 😡😡
Supervisor has me making a web app in this badass new stack called the LAP (linux, apache, php) stack because he would he would like the app to be "simple". He's spot on though.. having a three letter acronym saves so much time.... and then we don't need to worry about a database... or querying.... or efficiency.... or even the web app itself because clearly he expects the fucking code gods to come down and turn this piece of shit web app into a fucking masterpiece if he thinks this shit can be done based on a hacked together file management system. Please save me code gods4
Our entire test environment just fucking died today, redeploys don't work, connections time out, databases suck balls
I had no other choice but to start drinking alcohol at 2 pm6
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
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
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
Woooooo! Someone ran a cleanup script that deleted all the RPM package our dev Oracle databases use. Glad I'm not that person.
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. :(
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
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
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
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
I’ve only just been able to catch up with the UK news and the government missed ~16,000 cases of COVID-19 over a 7 day period due to a “technical glitch”.
The “technical glitch” was the government using an excel spreadsheet that reached the data limit.
Who the fuck thought that was a good idea long term, that’s why databases exist!!!!10
I posted a long-winded Twitter thread describing the experience I have in software development and advertising that I’m looking for a job. It felt awkward as hell to do, but yolo. I’ve had a few people reach out as a result; here’s hoping something works out. Hilariously, absolutely forgot to talk about databases. 😅
Can we agree, a lot of people tend to pick the wrong one for the job at hand.
And just in case devRant does it's magic on the image....
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
Worst and only experience is the reason I moved away from programming...
25 years ago I was hired to copy a phone book list to a access database.
Access back then would create lots of garbage, so I would add 3 to 5 entries before access crashed (shitty p133 laptop with 32mb ram running windows 98.
So I made a visual basic program to add data and work around the problem.
I offered said program to the guy really cheap and would still make it better.
Did also a admin module since he had hired dozens of people and I knew he would have problems peasing the databases together.
And... Dude cancels the deal.
I get a job, 2 weeks later he calls me... Ohhh I don't know how to get all the databases together...
Me: I'm working now, the program I did solved said problem. I trew the code away. Deal with it.
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.
almost a year ago, i have no idea of what i was doing at work cause everything was new: coding languages, databases, clients, co-workers, etc. i had 0 experience and i am back here again on devRant after 3836382 years and i am proud to say i've learnt so much and have been promoted to Project Manager. im happy asf and i am now ready for another round of dev rants!14
Dear past me,
never ever offer a customer to rename their databases during migration.
Renaming databases in mysql is evil and will cost you more time than you think,
sincerely, my present me.
Ugh, stupid triggers and procedures >_>1
10:15-10:45: Team Meeting
11:30-Noon: New project meeting
Noon-1pm: Foster care meeting with case worker (monthly check-in)
1pm-1:30: Train co-worker on how to restore databases
2pm-3pm : Onboard new DBA
3:15-4:15: Conference with AWS partner
Yup. I think I’ll complete a perfect zero LOC tomorrow. Oh, I’m also on-call.2
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?
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
All hail database backups.
Today my worst development related nightmare happened, I managed to screw a production database at work.
Thankfully we had a backup from 2 hours ago, I’ve never been so thankful to scheduled backups.
Take it from me, do backup your databases even if it’s annoying to do.
Piece and merry Christmas ✌️1
I feel ridiculous. While learning SQL databases I ran a query that was supposed to fill up the database with test data for me to play with. The actual result?
8 GB and 330,000+ rows.
Keep in mind this database is on a remote server, so trying to delete it times out after thirty minutes. I’m submitting a ticket right now.4
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“.
Course title: Advanced Database Management
-Create a database with SQL.
-Describe data normalization of database information.
-Describe distributed database management system.
-Design databases based on Entity Relationship modeling.
-Discuss connecting to databases with server-side scripts.
-Discuss database administration and security.
-Discuss database systems
Like. Come. On.7
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
Me chatting with a bandmate who is also a developer:
Me: do you have any experience in Db?
Him: Dropbox? Databases?
Me: Sorry enharmonic confusion. I meant C#
P.S. yes, sometimes I find my comments so funny that I make new joke posts about them.2
When used properly No-SQL databases are an incredible resource but my employer keeps hammering them in problems which could better be solved by traditional SQL databases in an attempt to be more "hip" and "cool".
This causes huge PITA in making the database work properly with the ORM we're using and waste of time since we're force to emulate basic features which are already exists in almost any SQL database (i.e. relational integrity) using No-SQL storage.1
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
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
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
When the DEV and STAGE databases are down... Yay early happy hour 😝. Too bad for the database guys tho.
*Spends the day writing script to back up production nosql databases before applying sweeping schema changes.*
*Accidentally runs the script to apply sweeping changes instead of backup.*
So.. name one fucken case where your database is not a computer backed thing.
Just asking because.. why the fuck? I don't think your database server supports input of fucking math symbols? JUST USE HUMAN LANGUAGE, AS YOU HAVE TO DO ANYWAY!
It's stupid how everything needs to be expressed mathematically ffs. Not that it's hard to understand - it's just more complex than of a very simple wording.6
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
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.
At work I inherited some databases, were most of the tablecolumns are all varchar. No ID's, and everything is in one table. No relation tables no reference data. Because "we don't trust the users who fill the tables to understand relationships". And.. wtf.4
I learned basic, Visual Basic and java in high school, then one year of college studying c++. I really hate c++ and swore I would never become a programmer. After that one year of college, I spent two years out of the country with no computer usage at all. Then 4 years working at a grocery store.
Then my friend told me about an opening at his work place for a java programmer. This was 7 years since doing java and 6 years since I had programmed anything at all. But I applied and interviewed. When asked about databases, I said “I know a little Microsoft Access.” Had no idea what relational databases were, never heard of php, but by some miracle they hired me anyways. Still working for them 6 years later, now an experienced java, php, MySQL, front end developer.
Still have no idea why they saw fit to hire me.5
Well it's a bit long but worth reading, two crazy stories in one rant:
So there are 2 things to consider as being my first job. If entrepreneurship counts, when I was 16 my developer friend and I created a small local music magazine website. We had 2 editors and 12 writers, all music enthusiasts of more or less our age. We used a CMS to let them add the content. We used a non-profit organization mentorship and got us a mentor which already had his exit, and was close to his next one. The guy was purely a genius, he taught us all about business plans, advertising, SEO, no-pay model for the young journalists (we promised to give formal journalist certificates and salary when the site grows up)
We hired a designer, we hired a flash expert to make some advertising campaigns and started filling the site with content.
Due to our programming enthusiasm we added to the raw CMS some really cool automation: We scanned our country's radio charts each week using a cron job and the charts' RSS, made a bot to search the songs on youtube and posted the first search result as an embedded video using some reg-exps. This was one of the most fun coding times I've had. Doing these crazy stuff with none to little prior knowledge really proved me I can do anything with the power of will.
Then my partner travelled to work in an internship in the Netherlands and I was too lazy to continue it on my own and it closed, not so surprisingly for a 16 years old slacker boy.
Then the mentor offered my real first job. He had a huge forum (14GB of historical SQL) but it was dying, the CMS version was very old and he wanted me to upgrade it to the latest. It didn't seem hard at first, because there were very clear instructions in the CMS website on how to do that. However, the automation upgrade scripts didn't work well because the forum owners added some raw code (not MVC plugins but bad undocumented code) and some columns to the SQL tables. I didn't give up and decided to migrate between the versions without the scripts. I opened a new CMS and started learning by heart all of the database columns so I can make a script to migrate between the versions. The first tests ran forever because processing 14GB of data on a single home computer is not a task meant to be done. I didn't give up. I made an old forum and compared the table structures and code with my mentor's. I think I didn't exhaustively finish this solution, the task was too big on my shoulders and eventually I gave up. I still owe thanks for that mentor for teaching me how to bare with seemingly (and practically) impossible tasks, for learning not to fear from being a leader and an entrepreneur and also for paying me in time even though I didn't deliver anything 😂
At what point can I claim to not be a script kiddie anymore?
Like, I've built compilers, and interpreters for an excel-like syntax, I refactored a pdf-parsing library from the ground up. I managed databases and wrote protocols for communicating with hardware.
But most of my experience is with python / nodejs / golang. It is only recently that I started playing with C and rust for actual efficient system code.8
Today in Cursed Java error messages, this beauty: `java.net.MalformedURLException: no protocol: "http://knowledgebase-api.development.svc.cluster.local/..."`
Yes, no protocol. You read that right. There is in fact a protocol there.10
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
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.13
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
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
Today I found out we have 5 different Customer databases, one for each product area. We don't have access to more than 2 of them, while corp. it central has full access, but we have to beg and pay to see our own customers....
Now i'm tasked with integrating all these into a Customer db. and the way i get access is cobolt made, fixed length csv files and it's different for each db.
I'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
Deleted 5 databases out of which 3 of them contains important data. A team is working on a big feature from months on those databases. All of the data is gone.10
Am I the only one who doesn't like NoSQL? I really like relational databases.
If I cannot see the light then convince me to like NoSQL. But I think I will be forced to learn it because some companies use NoSQL. Also tech stacks like MERN, MEAN, etc.38
I'm so glad that I got a CS degree learning Data Structures, Algorithms, Operating systems, Databases, Linear Algebra, Software Engineering, Networking and many more...
How else would I have been able to center a div with CSS or change the Background color?2
Auto tuning for Azure SQL databases is cool but :
DON’T allow it to automatically drop indexes ! (My bad, I should’ve tested that before)
It dropped one of the most used indexes in the DB. Yep, just like that. 150+ timeout exceptions and customers going crazy4
After like 15 odd years using MySQL I'm about to delve into the world of document orientated databases ... Wish me luck :)5
I'm gonna kill him...no don't defend him, you lot are meant to be on my side!
IT'S FUCKING HUNTING SEASON.
I know, I know, you want context but I just can't now. I'm completely annoyed. Fuck data integrity, just duplicate rows randomly cos fuck you.
Work is about to turn into a murder mystery...without the mystery 😒
He doesn't even work here anymore, hope he forgets his password and gets locked out of everything he has.
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
Should I be excited or concerned?
Newbie dev(babydev) who just learned string vs int and the word "boolean", is SUPER into data parsing, extrapolation and recursion... without knowing what any of those terms.
2 ½ hrs later. still nothing... assuming he was confused, I set up a 'quick' call...near 3 hrs later I think he got that it was only meant so I could see if/where he didnt understand... not dive into building extensive data arch... hopefully.
So, we need some basic af PHP forms for some public-provided input into a mySQL db. I figured I'd have him look up mySQL variables/fields, teach him a bit about proper db/field setup and give him something to practice on his currently untouched linux container I just set up so he could have a static ipv4 and cli on our new block (yea... he's spoiled, but has no clue).
I asked him to list some traits of X that he thinks could be relevant. Then to essentially briefly explain the logic to deciding/returning the values/how to store in the db... essentially basic conditionals and for loops... which is also quite new to him.
I love databases; I know I'm not in the majority... I assumed he'd get a couple traits in his mind and exhaust himself breaking them down. I was wrong. He was/likely is in his sleep now, over complicating something that was just meant as a basic af.
Fyi, the company is currently weighted towards more autistics (him and myself included) than neurotypicals.
I know I was(still am) extremely abnormal, especially when it comes to things like data.
So, should I be concerned/have him focus elsewhere for a bit?... I dont want to have him burnout before he even gets to installing mySQL47
Do any of you use graph databases. If so what? I am not able to understand where they really fit in.6
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
it turns out we probably caused the downtime ourselves. I didn't know dropping 170 databases and deleting 80 entire projects at once could do that"
Gave me a hearty chuckle. Especially as the client adamantly refused to have SSDs installed for the DB to run on top.
Just imagining the poor read-write heads jerking back and forth in vain attempts to find all the data to delete... So yes, dropping 170 databases at once does in fact take a database server down to its knees, as deleting is all the drives will be doing for a while.
At least it wasn't my or my colleague's mistake this time.4
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
Recruiter bot just emailed me with some offers, let's take a look...
"Hand-on Experience with SQL and NO-SQL Databases preferably Redux"
Whew! I was worried for a second, thank god they are using a Redux database and not one of those really crappy React databases! I'll really consider applying now.
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
TIL don't rely too much on in memory databases if your client runs development and production environment on the same machine.
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
Excel literally has internal support for treating other excel workbooks as SQL databases, encouraging end-users to do that instead of using MS Access properly, and *it doesn't even work*.6
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..
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
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...
New to databases - How is it that Oracle has been around for so long, yet have terrible documentation? Their support forums consists of condescending developers who never actually answer the questions and the forums’ format is just so bad.10
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
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.3
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
Someone at work deleted my test environment's databases.
What. The. Fuck.
If its not yours, don't fucking touch it.2
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
What is the purpose of using MongoDB and then adding mongoose?
If you want schemas, relations and all the jazz mongoose offers, have you considered using a RDBMS instead of a datapile system? Most (probably all) SQL databases support schemas, relations and all the jazz you seem to need.
So, ask yourself: Do you really need the functionality of a NoSQL database or do you just want it because it's shiny and new and "everybody uses it (tm)"?4
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 not : How school make you love/hate a specific domain in Computers in general ? Like Databases, Model Driven Development, simple coding, whatever3
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
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
Everything that works on your machine, will most likely fail at scale.
Ensure that you have the right toolset. Learn more than just scripting.
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’m a full-stack Dev, but my job description restricts me to backend - app logic and databases - but the frontend Dev makes crappy markup templates and I have to keep closing unclosed tags and replacing ID css selectors with classes.7
Colleague: I'll write a stored procedure that does fully qualified database table path names to access data from the other databases and then do business logic with all of it in the same proc.
Me: That will be 600 lashings.4
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
My laptop was at 500% of course usage and ram... Wtf...
Had to stay till 1am because I was debugging a microservice system with 15 services, 3 databases and a full mail server. Freaking integration tests took all night to build and run. Don't have a remote server to run this on because the guy is sick. Arghhhhhh8
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...2
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 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
I can't be the only one who gets this:
- Visual Studio frequently crashing. Particularly when working with databases
- Slowness when working within the database designer (after every change!)
- Random "errors". Literally could change nothing in a working program and then it will be throw an error.
My experience with VS and ASP.NET has been very frustrating.1
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.
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
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..
Just got this coding task from a recruiter trying to determine what they want.
This for a front end job but we talked about api/network calls.
Are they just looking for the UI or do they want me to make the agency names dynamic through the different databases?
The recruiter is kind of clueless.
How would you approach this.11
SQL was never meant to be used in web applications. It is inherently insecure in its c&c schema. Can we please fucking stop using databases that are not designed for the web in the web? Please?
(I know, I know, we’re stuck with what we have. But for fok’s sake, I want to strangle that muthafucka who thought it’s a good idea…)22
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'm studying Databases and I'm getting confused about Foreign Key.
A Foreign Key made reference to Primary Key of another table. But what's the point? Can't I simply use a value and select requested data where TableA value is equal to TableB value?
Sorry if I didn't explain it well, I'm so confused lmao6
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...12
I'm scared of databases. What if I go to the bathroom and my dog or the Cookie Monster gets into my laptop and drops a table? How could I explain that?10
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.
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
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?9
*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.
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
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 !
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 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.
what books, resources would you recommend for improving software design philosophy as well as computer science and database design ?5
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
What is up with the 2000++ tables databases? I am supposed to build a DW from those, but that just seems impossible...2
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
Intern spent about a week trying to set up a local ruby on rails environment. Yeah, this is not really on topic, it wasn't that bad, but it's what comes to mind.
I don't know who modelled the databases I've had to work with these past months but god damn it no fucking normalization anywhere. Inconsistent data just cost me my morning.1
Definition of database table in my DBMS book :
Table is a rectangular array 😩😂😂😂
I am like why am I even studying this subject1
Recently, I launched a website to practice and perfect a lightweight Larval CMS that is forcing me to learn Databases and good sanitization practices.
Trolling Zuckerberg's Facebook for Images to make potential MeMes, I can't help but notice he has quite a ridiculous and unrealistic amount of instances in which he seems to be talking to military and government officials.
Figured I'd use the old humor as a weapon to shed light upon this.
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.
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
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!!!!
Can someone try to sell me on NoSQL? I've never seen a use case for it so I want to hear a NoSQL Fan's perspective13
We had a course on GUI and Databases as part of my bachelor's degree. It was a basic introductory course (I am a mechanical engineer) where we were expected to design some tables and build a simple front end in VB6.
But the instructor was so bad that he hardly taught any VB code at all. And as far as theory on databases was concerned, about 80 percent of the lectures involved some generic introductory statements followed by an explanation of the terms DDL, DML and DCL. I do not remember him writing even a single SQL query to explain to us how it's done.
I 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
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 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?8
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.
Fellow Spanish-speaking developer:
Don't forget the WHERE in the DELETE statement.
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
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
New job, strict devops role. I asked the devs they're painpoints, no mention of local dev stack.
Spin up a local dev stack and it's a garbage fire. No feature flags, env vars, docker. Have to be careful due to devs using staging databases for dev work.
This is going to be a problem...3
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
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
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.
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
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.
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.17
Hi all. at the moment I work in a medium-sized company, but I have enough work to do, and now we have a problem with databases and our system administrators can’t handle it, and I was instructed to find a reliable company that will either deal with what we have or it is possible that our databases can be transferred On another platform, a real specialist administrator is generally needed. thanks in advance.6
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
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
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.
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
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
I want to be more tech savvy. I love programming, am fluent in Java and have no problem in pickung up new languages from time to time. But I’m really not a tech person. I always feel like I lose my grip on things when it comes to servers, web stuff and databases.2
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
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 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
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
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
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.
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
Having a senior DBA can save hours if not days of struggle and save your back, if you do not know well enough how to do a more complicated query yet, without fucking up something.
Good guidance and experience is worth so much.
... and no I do not have the rights to drop databases.1
I understand unit testing and its value but I’m really struggling when I have to mock databases or other external resources. It’s normal or others have this annoyance?6
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.8
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?2
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?
Databases are designed to support read heavy applications. A typical read write ratio is 10:1.
Is there a database that is designed to support a write heavy application?
What some examples of write heavy applications?9
Absolutely frustrated with some people's inability to make the information in their databases consistent. Had a request to make a report based on some criteria, and couldn't find the information from tables that seemed to have most of the information. Some information was correct based on what was on the website, some was not. What the fuck.1
Client: I need to organize this data in my database, just let me create any folder, and folders inside folders. I mean, it is a database so you can create folders right?
Me: I'll see what I can do
Inner me: NO, F U, that's not easy, that's not how databases work, WTH is wrong with you4
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
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.
MySQL Innodb easily get crashed, bullshit, I just restarted my server now all databases get corrupted. F*ck you OVH3
Not a rant, but seeking advice...
Should I abandon 2 years' worth of work on migrating a personal project from SQL (M$) to a Graph database, and just stick to SQL? And only consider migrating when/if I need graph capabilities?
The project is a small social media platform. Has around ~50 monthly active users.
Why I started the migration in the first place:
• When researching databases, I read that for social media, graph is more suitable. It was, at least in terms of query structure. It was more natural, there were no "joins", and queries were much simpler than their SQL counterparts.
• In case the project got big, I didn't want to have to panic-deal with database issues that come with growth. I had some indexing issues with MSSQL, and it got me worried that at 50MAU I'm having these issues, what would happen if I get more?
• It's a personal project, and the Gremlin language and graph databases looked cool and I was motivated to learn something new.
Why I'm considering aborting the migration:
• It's taking too damn long. I'm unable to work on other features because this migration is taking up all my free time. Sunk cost fallacy is hitting me hard with this one.
• In local testing within docker, it's extremely slow. I tried various graph engines (janusgraph, official tinkerpop, orientdb), and the fastest one takes 4-6minutes to complete my server tests. SQL finishes the same tests in under 2 minutes, same docker environment. I also tried running my tests on a remote server (AWS neptune) and it was just as slow. Maybe my queries are bad, but can I afford to spend even more time fine tuning all queries?
• I now realise that "graph = no scalability issues" was naïve of me, and 100% wishful thinking. Scalability issues don't care what database I use, but about how well tuned and configured the whole system is.
• I really want to move on. My tech stack is falling behind and becoming outdated. I'm unable to maintain dependencies.
• I'm worried about losing those 50 MAU because they're essential to gaining traction once I release the platform. I keep telling them about the migration but at some point (2 years later) they're going to get bored I feel.
I guess partially it's a rant because I feel like I shouldn't stop now having spent 2 years on this, but at the same time I feel like I'm heading towards a dead end.
If you made it this far, thank you for reading:)11
In the last days, my developer was working with different kinds of databases.
He uses a database, named TimeScale DB (Timescale). This is the plugin of a famous SQL database PostgreSQL.
He imports the same data in PostgreSQL and timescale DB.
Size in Timescale DB is = 24KB
Size in Simple PostgreSQL = 166MB
This is the record of 1000000 rows, 12 columns.
Data fetching is the same on both databases, But if we fetch time-based data, (e.g 2 days, 24 hours, From Date to Date) we have a 50% to 200% difference depending on the query. python3 & elixir is also working fine with DB.
Results are also nearly the same with InfluxDB.
For a specific use-case, we have software that is handling Simple and time-series data at the same time. If anyone wants to suggest something new, Also tell us.
Hello everyone, i'd like to know which databade do you all use and what will be a good database for a beginner?7
I finally get to work on my first independent project at my internship! It’s been cooling working with my team so far but I’m excited to try things to figure out things by myself first before getting some help.
So apparently people use IDA over Ghidra still.
Either they're paying thousands a year for the privelege or they've got a cracked version. Either way, you're getting shafted. (Pirated IDA databases can't be loaded in legit copies, so forget community sharing without exporting shit, and IDA is confused by jumps in anything half the time. Pirated IDA also often has issues with plugins and mods and such.
Why are you people like this?3
Never had one of those but the teacher that was in charge of the Databases 101 course at my college was very memorable and supportive.
Got me through my graduate thesis and into a few gigs that gave me precious experience and confidence.
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.
Hi, guys. I'm looking to get into Android development (Xamarin) and to build some simple apps first.
What I have in mind is something trivia-like, with a hosted database (can't find any free & reliable public APIs).
Do you know of any free downloadable databases on the topics of:
http://www.usabledatabases.com/ seemed promising, but it's not free (or I couldn't find any free DBs, as they don't have a price filter).
Thanks in advance!
For persistence, either credentials or data, is there any best practice that prefer DATABASES over FILES? Files such as JSON or txt or whatever...
Do dbs offer better perfomance or security?💾5
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.
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.
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
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
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
I was working on a project a while back making a language system, we obviously wanted to know what language the user had set so I looked to adding it to the database.
I've seen messy code and I'm not a gold standard but fml..
I ask the other dev who wrote the code and we end up spending a while getting it sorted. I had never seen the database before... 100+ fields on the main table...
I quit not long after. Hated that job and I have many things I can rant about from it.
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.
Am I the only one who's hands start shaking when about to send "CHANGE MASTER TO" on a dev server?
Happened to me yesterday, replication got stuck after corrupting a relay log file when the database segfaulted under my hands.
I could check and recheck the positions I was about to reset it to a bilion times and I was still nervous!
Last question for today, I promise…
For my side project, I plan on saving a URL and an array of strings associated with that URL. I want to be able to search and sort the resulting DB from a frontend without needing complicated queries. Is this the use case for a key-value pair DB? Let me know if I’m not clear and thanks!14
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?
Really need help to upskill as a data engineer. Are there any free sample databases data out there with practice questions to upskill as one? I wanna learn database design, data lake and data warehousing skills... I don't know if I'm asking the right questions but if I'm not making sense, please help me out!