Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Get a devDuck
Rubber duck debugging has never been so cute! Get your favorite coding language devDuck
Buy Now
-
Manager: "we need an SQL database"
Dev: dude does he even know what he's talking about
Dev: "so which color?"
Manager: "idk well I think a blockchain has the most RAM"10 -
Even if Gitlab deleting part of their database is a sad costly mistake, I still, and even only with that, trust them FAR MORE than most other services out there. Why?
The fucking transparency. They didn't said some stupid shit like "we're experiencing problems" or whatever. They clearly said "we fucked up" and gave a detailed report on how they actually fucked up, why and how they got away and fixed all this. I prefer to know what happens, even if it's problematic than not knowing anything on the situation at all. So, good call Gitlab. (made that into a rant because fuck it)20 -
When i open a 2 gigabyte wordlist text file and forgot that my defaults text editor is GUI based.
17 -
Client A: "so we using cloud-based server? is it safe? will raining cause data leak? you know rain water is from cloud? how you guys manage to control it???"
Me: "??????"
20 -
Hey everyone,
This coming Sunday (Feb 4), at about 12AM EST, devRant will be going down for scheduled maintenance (database server maintenance). The maintenance shouldn’t take more than about 15 minutes.
Feel free to let me know if you have any questions and apologies for the inconvenience!39 -
Friend: Dude, css is so cool and amazing. I love it
Me: Erm ye, okay...
Friend: I think, im gonna make a css program to save data to database. That would make it even cooler!
Me: ye, okay. Wait what?! Hahahahaha
Friend: ??? Why u laughing14 -
I always like to approach a new coding project by concentrating on the data model first. I've seen a lot of projects built on extremely convoluted database structures and it really hurts because it makes it hard to add new features to the project.
So I look at the requirements of the new project and try to come up with a basic data model. Then I like to think about what logical future additions to the project could be. And using those, I try to see if the data model is flexible enough to be able to handle those additions fairly easily or if complex migrations or hacks would be needed to account for new use cases and features.
I think once you have a solid data structure and database technology, planning out an API or rest of the software is pretty straight forward. I like to create reusable pieces of middleware early on in the project which makes it easy to apply consistent functionality with ease to different API endpoints.10 -
Please be gentle, first rant here.
I'm a hobby .NET Developer, so nothing serious, but when a "close" friend asked me if i could help him, i saw my opportunity to show my skills.
Said "close" friend is working for a non profit agency and deals with a lot of people, so he asked for a database with some extras. The task was fairly easy and i needed 2 weeks (besides my real Job), to get what he wants.
The big day comes and I show him my work. He was very pleased with it, and also I did it for free, he paid me actually really good money for it. I designed that DB as idiot proof as possible, but i should have known better.
2 month went by without a single crash or any other Problems, but yesterday i received a call..
Him: Your Update broke everything!! fix it asap!!
Me: What happend, I did not push an update for 2 month.
Him: You A**hole, its all your fault!!
After like 5 mins of swearing, I agreed to come over and have a look.
Oh boii, you would'nt believe how stupid some people can be..
Let me tell you, he got 2 files "ProgrammName.exe" and "ProgrammName_Database" and this idiot of a Person thought "hmm my PC ist getting kinda slow, let me delete some junk, so he goes ahead and deletes the whole Database and calls me stupid names, because he lost all his data, and no, MR.I GOT 20 TOOL-BARS INSTALLED AND I DELETE SOME JUNK ASS FILES, I DONT HAVE A BACKUP OF YOUR STUFF!!
So now you know why i called him "close" friend..20 -
Hey everyone - tonight we performed a database upgrade and unfortunately there were a few "surprise" breaking changes to the query language we use that weren't caught during testing. Once they were discovered after the upgrade. The queries were corrected within a few minutes. You might have noticed some issues with commenting, voting, etc.
On this note, please let me know if you notice anything suspicious like errors when trying to perform normal actions, or anything at all. I appreciate any reports since it's a bit tricky for us to cover every last part of the app alone, though I think we went through most of it. Thanks and please let me know if you have any questions!22 -
Story time:
I was once working on a project that dealt with incredibly sensitive financial data.
We needed a client’s database to do a migration.
They wouldn’t send it over the internet because it was too big and they didn’t think it would be secure.
They opt to send it in the post on an encrypted usb drive.
(Fair enough thinks I)
USB drive arrives.
Is indeed encrypted.
MFW there’s a post it note in the envelope with the password on.
MFW this is a billion dollar multinational petrochem company.
MFW this same company’s ‘sysadmin’ and ‘dba’ once complained because a SQL script I sent them didn’t work - they’d pasted it twice and couldn’t work this out from the fucking “table already created” error message management studio was throwing at them.3 -
I am currently working for a client who have all their data in Google Sheets and Drive. I had to write code to fetch that data and it's painful to query that data.
I can definitely relate with this.
PS: Their last year revenue was over US$2 Bn and one of their sibling company is among Top IT companies in the country.
9 -
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 hate backups!
I hate backups! Backups are waste of space and processing power.
2 hours later:
Bugged server app accidently drops whole database.
Me: O.O I love backups!4 -
Went with a cousin to hospital for vaccination .I took a pen and wrote: "Anti-Virus database updated 09.01.2017" . Now I am not allowed to stay with my cousin :(
-
NEVER NEVER NEVER NEVER NEVER NEVER NEVER trust a backup that wasn't made by you!!!
F*ck!
Background: I leave my job last year, so my "boss" replace me with a junior support guy instead of a sys admin.
Few months later a client contract me directly because the support guy almost destroyed the server.
The server remain failing, so we buy a new server. Today the old server does not boot anymore. So we was importing the data base backup to the new server and the backup doesn't work!
The client lost almost a month of data! Now I'm the bad guy who doesn't backup properly.
F*ck!9 -
You know your week starts great, when you receive a call, that the whole shop database of a company is not working anymore.
Turns out MS Fucking SQL decided to drop all tables, just because the harddisk was full.
A SERIOUS FUCK YOU TO MICROSCHROTT!
It's not a lot of fun, when 15 people have to wait for you about 1 hour, until it is restored.
Why does this have to happen on a monday?14 -
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*)
🤔8 -
We've built a web app and now a client wants a VPN acces to the database of web app. When asked why, they said they want to occasionally pull some data out. 😱
We said no, and this is what they wrote:
"We’ve got live VPN access to every other web database we work with – why is this different?"
Well because maybe we know that we can build you an export of whatever you want, prepare you API calls for getting data to your CRM, but hell I'm not giving you access to the production DB.5 -
Worst part of being a database dev:
It is arguably the least sexist dev job out there.
Don't think anyone is going to be interested in how you 'reduced the runtime of a query from 30 minutes to 5 minutes for a front-end app used by an important client' or 'used the data dictionary to better handle resource management for important transactions.'12 -
Today I inserted a single row into a table which triggered four triggers which inserted 5 rows each to different tables triggering 9 triggers inserting 3 rows which triggered more triggers... Nothing about this is ok.6
-
As a programmer I never expected to become a detective.
My today's task: Find out the cause of the spikes, fix it!
9 -
"So, what do you do in life?"
Me : I work on enterprise level mobile, web and server applications. Basically programming and database stuff...
"Sweet! So you can fix my PC right? It's getting slow I don't know why..."
Me : mmm well, ugh... yea kinda, I guess... sure. I could take a look 😑2 -
Arrived today, hyped!
I have real-world experience with MongoDB, MySQL, Firebase, and caching with Redis.
A colleague in ops recommended this book a while back and I thought I'd give it a whirl to better understand what other options I have available.
9 -
"please use a secure password*"
* But don't make it too secure, 20 Charakters is enough.
Why would you fucking do this? The only reason I can think about is a scenario like this:
"How do we store the passwords in the database?"
"Just like anything else?"
"So I create a VARCHAR(20)?"
"Yeah why not? It's good enough for a name, and you shouldn't use your or anyone else's name as a password, so it should be perfect"10 -
Its such a elating feeling when you implement multithreading perfectly.
I had a task where I read data from one table, searched on it and added the searched data to another table. The table had 0.22 million records.
On single thread it took entire night to do half of the job.
I divided it into 8 thread jobs, and pushed my quadcore to 100% and voila, its done in 2.5Hrs.
Just like Hannibal would have said, "I love it when a plan comes together"7 -
Teacher: From today on, we will start working with ms access 😊.
Me: Please die and let my life in peace ☹️ and learn with something useful (MySQL) instead.8 -
Working on a database priorly designed and maintained by some private agency.
The fuck I'm dealing with!
Boolean values stored as 'TRUE'/'FALSE'. It's varchar, my dudes.
There are no FK relations. Just the values of IDs in a column.
There are no indexes, all on just the PKs, nothing else. Nothing.
Null, what's that? I'm dealing with 'N/A', my dudes.
Unique key, what's that? The table which stores users has all the fields nullable. Email is not unique ( even though that's the required behaviour).
ALL the numeric values are stored as varchar. Varchar, my dudes. Varchar. '1', '1.1'
And finally, the good ole, 1 table to rule them all. Normalisation, fuck that.
And what's the root cause of all this? My PM used to hand them Excel sheets she maintains on her local system. FTW. I don't have a enough explanations.7 -
HOW FUCKING HARD CAN IT BE TO NOT STORE PASSWORDS IN CLEARTEXT AND THEN PROCEED TO SEND ME AN UNENCRYPTED EMAIL WITH THE PASSWORD IN IT??? THE SITE HAS A PREMIUM FUCKING SSL AND SAFETY CERTIFICATES YET THEY STILL DON'T COMPLY TO THIS? FUCK YOU! IF IT WASN'T FOR THAT I HAD TO ORDER A NEW SCREEN FOR MY BROKEN PHONE, YOU COULD'VE SUCKED BETTER THAN ME + VACUUM CLEANER.
Sorry abt that. But for real, mytrendphone stores passwords in plain texts and waves a fucking safety certificate in your face...15 -
Today, social media databases around the world will be forced to accept billions of shitty firework photos.2
-
Ok, I just have had wasted 30 mins of my life trying to figure out why one of the stupids grids of the shitty project of my company is missing one element....
...please, always sanitize the data before insert in the db... please....
5 -
Rant, but also want to know, how the fuck do you accidentally drop a database link. In production. On the most important database. Housing our biggest applications.8
-
Yesterday a colleague of mine told me that another colleague has done this in his web application for a subject:
For checking user and password, he did not query a database, but instead he checked information in a HIDDEN DIV in the html page.
Reason: "this way I don't lose my precious time".
I think of that and I'd like to punch him. People like him are the reason websites in Italy suck and my University web infrastructure sucks (he worked as intern on that).
My. God.7 -
I think every programmer goes through this time every day....
#Don't wait for inspiration, become it. #balls
-
I recently got a Sysadmin/Devops job at an Uber-like local startup.
After a few days in and with a 20% increase in daily API calls, we started getting "502 gateway error" for like half of the requests which was insane!
I double checked nginx, php-fpm, mysql, etc and in the end turns out that they log every app login session in a 680K row table in a mysql database and run a query every time to find out if the client was logged in or not!
°__°2 -
OMFG I don't even know where to start..
Probably should start with last week (as this is the first time I had to deal with this problem directly)..
Also please note that all packages, procedure/function names, tables etc have fictional names, so every similarity between this story and reality is just a coincidence!!
Here it goes..
Lat week we implemented a new feature for the customer on production, everything was working fine.. After a day or two, the customer notices the audit logs are not complete aka missing user_id or have the wrong user_id inserted.
Hm.. ok.. I check logs (disk + database).. WTF, parameters are being sent in as they should, meaning they are there, so no idea what is with the missing ids.
OK, logs look fine, but I notice user_id have some weird values (I already memorized most frequent users and their ids). So I go check what is happening in the code, as the procedures/functions are called ok.
Wow, boy was I surprised.. many many times..
In the code, we actually check for user in this apps db or in case of using SSO (which we were) in the main db schema..
The user gets returned & logged ok, but that is it. Used only for authentication. When sending stuff to the db to log, old user Id is used, meaning that ofc userid was missing or wrong.
Anyhow, I fix that crap, take care of some other audit logs, so that proper user id was sent in. Test locally, cool. Works. Update customer's test servers. Works. Cool..
I still notice something off.. even though I fixed the audit_dbtable_2, audit_dbtable_1 still doesn't show proper user ids.. This was last week. I left it as is, as I had more urgent tasks waiting for me..
Anyhow, now it came the time for this fuckup to be fixed. Ok, I think to myself I can do this with a bit more hacking, but it leaves the original database and all other apps as is, so they won't break.
I crate another pck for api alone copy the calls, add user_id as param and from that on, I call other standard functions like usual, just leave out the user_id I am now explicitly sending with every call.
Ok this might work.
I prepare package, add user_id param to the calls.. great, time to test this code and my knowledge..
I made changes for api to incude the current user id (+ log it in the disk logs + audit_dbtable_1), test it, and check db..
Disk logs fine, debugging fine (user_id has proper value) but audit_dbtable_1 still userid = 0.
WTF?! I go check the code, where I forgot to include user id.. noup, it's all there. OK, I go check the logging, maybe I fucked up some parameters on db level. Nope, user is there in the friggin description ON THE SAME FUCKING TABLE!!
Just not in the column user_id...
WTF..Ok, cig break to let me think..
I come back and check the original auditing procedure on the db.. It is usually used/called with null as the user id. OK, I have replaced those with actual user ids I sent in the procedures/functions. Recheck every call!! TWICE!! Great.. no fuckups. Let's test it again!
OFC nothing changes, value in the db is still 0. WTF?! HOW!?
So I open the auditing pck, to look the insides of that bloody procedure.. WHAT THE ACTUAL FUCK?!
Instead of logging the p_user_sth_sth that is sent to that procedure, it just inserts the variable declared in the main package..
WHAT THE ACTUAL FUCK?! Did the 'new guy' made changes to this because he couldn't figure out what is wrong?! Nope, not him. I asked the CEO if he knows anything.. Noup.. I checked all customers dbs (different customers).. ALL HAD THIS HARDOCED IN!!! FORM THE FREAKING YEAR 2016!!! O.o
Unfuckin believable.. How did this ever work?!
Looks like at the begining, someone tried to implement this, but gave up mid implementation.. Decided it is enough to log current user id into BLABLA variable on some pck..
Which might have been ok 10+ years ago, but not today, not when you use connection pooling.. FFS!!
So yeah, I found easter eggs from years ago.. Almost went crazy when trying to figure out where I fucked this up. It was such a plan, simple, straight-forward solution to auditing..
If only the original procedure was working as it should.. bloddy hell!!11 -
Oh boy. Gotta love having a team member (For a School project) be in charge of the Database functionality/design, who has almost no communication skills and basically no clue about how to store data in a data base.
Im talking dates stored as varchar(5), column sizes being way way to small, overall table design being rather terrible, no primary/foreign keys, pretty much... Actually no, everything was being stored as a varchar.
Not only that, but there was a hell lot of data that needed to be stored that wasn't even accounted for in the DB design. He made some code that could be used by our team members for queries, creating tables, inserting data (etc), almost 2,000 lines of it.... And basically nothing was fucking documented at all. I'm talking comments like "Insert data into cities table" and nothing else. More complicated functions had as much, or less documentation. Complete mess.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
-
After a week of trying to figure out why my Android Studio project wasn't connecting to my db I finally realized that I was using the wrong URL3
-
Oh man.
I imagine the face of the guy who deleted Gitlab production database when he realized what he had done.6 -
Completely got my localhost and live database confused and dropped the whole live server. And there was a power outage so the last backup is from Friday. Luckily not completely live, but still having a stream of people walking in. Also pretty obvious that they are talking about me especially since there's no other shes in the department.6
-
Manager: let's use elasticsearch for performing relational queries. PostgreSQL performance is not great.
Me: Say what? 👿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.
Thanks MySQL.1 -
Please use normalization. Don't store more than is intended in one field and use special characters to separate things. It would make future developers job easy.
7 -
Top 10 database engines on db-engine... I never knew the top 3 were so far ahead of the game, if that site is anything to go by.
16 -
Brain storming with senior lead developer. We try to add new tables in our database. But the Google spreadsheet goes wrong
4 -
I'm migrating data from an old software to a new one I wrote.
Old database it's in Access (yeah, fuck). When I opened one table, the VM hung up and I opened the task manager on MADE
What.The.Fuck.Are.You.Doing?
8 -
Me: deployment exploded, the database has to be restored.
C: yeah, the latest backup we have is is from Q1 2016
Me: wat? We have almost weekly changes of the database layout, let alone the content.
C: yeah, you have to execute somewhat 60 sql files ... Have fun
* Sitting in a corner and staring apathecally at the wall*5 -
The worst mistake I made was using json files as a simple database.
The project was to be delivered the day before it was even ordered, so I had to take shortcuts.
I totally underestimated the popularity of the project, so all that file reading and writing made the server slow and sluggish. It also being submitted on a shared host, made it even worse.
In the end the host shut it down. I don't recall, but I guess I had to add that database support after all, the project being that popular...4 -
Me: What filters would you like on this report?
VP: Here's the logic for the filter I want.
Me: Great! Anything else?
VP: Nope!
... Days of DB, ETL, and Report refactoring later ...
Me: Here's the updated report!
VP: Can we add this other filter?
Me: (You're welcome...) -
Today I got my first Dev job (I'm still a student). I got to develop a database and an app. It feels good to have a student job related to your field!!
I have a lot of freedom in the way to do it, I can use the tool I want.
Anyone has any advice?12 -
From Gitlab: "So in other words, out of 5 backup/replication techniques deployed none are working reliably or set up in the first place."2
-
Least favorite enterprise software: MongoDB...
"Ensure all writes" is still a suggestion that sometimes works.8 -
Bpost (Belgian post) are such a bunch of assholes... Mailman can't fucking wait for 5 fucking minutes to deliver a fucking package! But wait, there's more!
Just now I went through the goddamn snow to get that damned package, and when I arrived I realized that I forgot the little paper that they left in my mailbox. Thought to myself, probably they can find it in the database on my name or something.
Except they couldn't... Apparently their clerks prefer to have me waste 40 fucking minutes to receive that damn piece of paper instead of searching 30 SECONDS through their meager 100 entry database for my package 😒
"yeah our database doesn't support searching packages by anything but barcodes"
BULLSHIT!
If you can link a package sent to my address to a barcode, you better link its other information as well. Otherwise anyone could go receive my packages, which isn't exactly the case either.
Either way, if I can manage a database with a million entries, 100 entries shouldn't be too hard. Heck, one can even manually sift through such a small database in 2 fucking minutes.
Clerk replies: well if you're such a great sysadmin to manage databases like this, why don't you come work here and implement these search functions to find your own packages eh..
AS IF I WANT TO, YOU BRAINDEAD FUCKWIT!!11 -
I need to find a good backup solution for my company.
Currently we run 2 16 core EC2 instances, the important code is in github....but I need backups for databases and media.....so I was thinking of spinning up an S3 bucket and using the api to create a script to push media and database backups to every night....
Anyone have any better ideas or suggestions for backups?6 -
Possibly the start of a very bad adventure: I'm helping my brother-in-law set up a website for a business he'd beginning with his wife. I'll be needing to provide him a simple cms & shopping cart that he can manage. No payments as we want to just use PayPal so as to avoid having to actually manage user data & credit card information.
Wish me well....
Also advices appreciated cause otherwise, I'm gonna use a simple Drupal or WordPress site with like 1 theme and 0 plug ins.4 -
JSON: "Ok fine you can use our syntax and everything else but make sure you change the name of the format so people know there is a difference"
MongoDB : "K"3 -
PM asked me to develop an application to fetch data from the customer's DB, which would require an access security token provided by the customer. To get the token, I would have to travel to Germany (I live in Portugal) to get it personally (it's not possible to have someone else pick it up for me).
It turns out the security token is a completely closed environment, with its own OS, without the possibility of installing any application or communicating with the exterior. The laptop itself would boot from the token's OS.
It was concluded I would have to hack the security token, which is completely non compliant. So the PM decided not to go forward with it.
But now, I have to go Germany anyway to pick up the security tokens because they forgot to order them for these other guys who would be using them to access the customer's DB manually and they don't want to delay the project anymore.
Oh, and the security tokens cost the project 500€/month each...4 -
Me: "can you please send my credentials for the database?"
Hosting provider: "Yea sure... We will set it up on our servers in no time"
*5 mins later: provider sends mail to me*
Me: *looks at mail*
Also me: *NOTHING TO DO HERE*
Congrats to jweiland.net for not being able to support their customers.
2 -
Project requirements include a database. I don't have permissions to create a new database on the server, so I go to the person that spins up new servers and deals with group policy. They rustle some papers around, looking aggravated, throws up hands and says, "I guess I'm the DBA now..." Well, what the fuck am I supposed to do shithead? Ask the web team to do it? We don't have a DBA. My boss has been gone all week and, really, this isn't a hard task. You check a fucking box.
Whatever, I'll remember this when they need a favor from me.6 -
Me: *asks for sample data for all tables to test database transactions*
Team member: *gives over 45000 records only for city*
🤔 😐 -
Why would anyone use -1 for true and 0 for false in a database.
Booleans people!!! FFS
Making migration of old project a real PITA4 -
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
-
For the backend PHP developers: would there be any usefulness, future benefits of storing webite page data (like title, description, body) in the database vs just building pages statically? Outside of being able to create a page in a web interface admin area (like Magento's CMS pages).
Or should I build my page templates with the data hard coded in them instead of storing in database?
Performance-wise, I will probably take a hit storing the page data in the database versus say hard coded. But is there benefits to storing the page data in the database if like the User isn't going to build his own page?
Or should I only store the data that the users are going to directly manipulate?41 -
Boss at the start of a new project: "We could hire an intern to gatter some data in an excel list... You can easily implement that in the application later - right? So can you get us a excel list to fill out? "
No... Just no...
You tell me what you wanna see and how you wanna interact with the application!
In the process we will figure out which data is necessary, I will build some tables in the database for that data and then, !!! not a second sooner !!! , I'll be able to give you an suitable excel list, which includes a complete list of columns for the necessary data in a form I can work with it.
It's not my job to know what data a application needs to make YOUR JOB easier! I'm not a magician! I just love programming stuff!3 -
I was out sick the day an urgent ETL job I was building would be due, so it got reassigned. When I return, I find most of my code commented out and replaced.
The first step was rewritten, with a comment that reads "Made changes to run faster." What used to be a single execution lasting 30 seconds was now a 4 step process taking 5 minutes, and yielding identical results.
Being a one-time execution (not a recurring job), I'm left wondering why they thought execution speed was even an issue, let alone what about their redesign they felt was an improvement...2 -
Database is being slow AF again. Team lead is investigating. This is happening more often lately and affects both production and dev because everything is just in one gigantic database. So clients are calling support being angry about the speed they get and us devs get to twiddle our thumbs while waiting for our own data to load.8
-
Bad: Delete your production database
Good: Have a backup
Bad: Can't reimport it because your backup procedure uses scheme that are no longer supported for import by your cloud provider
Good: Backup are plaintext and somehow easy to parse
Bad: Spending the rest of the day writing scripts to reinsert everything.
End of the story: everything is up and running, 8hours of efforts1 -
You know when you are suddenly push to a new position that you are not familiar with?
Well I just became a server database/cloud expert. Fuck me.
Been Googling for a while now. If anyone has any advice, I'll appreciate it.
Anything free and open source, even better.8 -
Building an interface for a client between industrial power quality meters and a database that serves a webapp of data.
Client had heard of a way of sending data between meter and raspberry. From some manager in a big firm.
Currently we where using modus to connect the meter to a raspberry. This method was tested and proofen to work. Both devices could talk to each other in modbus.
Client kept demaning to use mbus, and was nog listening to any reason because the firm suggested it. In the end we end up going modbus to mbus to send it to the raspberry. There the mbus was converted back modbus. Because the meter could not communicate in mbus.
Really weird experience to program something so useless. But protesting about it was going nowhere and taking more time than the changes would take to implant.2 -
One of the devs at my internship company decided to have a client's website load all of it's pages from the website's Database.
That's right, a PAGE as a database row!
And I don't mean having it get some of the info from the columns and putting it into the page's html with php or some shit. No, I mean an actual html file copy pasted and added into the database.
This company scares me sometimes.1 -
At the product backlog refinement the product owner told us (the devs) how the database model must be designed! He said he knows it best, because he knows all the requirements. 🙈4
-
YES!
Finished a complete version upgrade with vastly improved scalability and maintenance in just 3 weeks!
NO!
I forgot to do the database migrations as I went along. Ok... no problem.. I'll just use some kind of database comparing software, I'm sure they exist...
<googles...>
...fuck... is there not any for free?
Ok fine whatever i'll manually compare the tables and columns, fuck it. Sure there's like 50 tables and like 20 columns per... whatever...
should take like a day or so, with testing...
YES!
Finished my new version upgrade after just 6 weeks of coding!
....fuck sakes...1 -
When your company expects you to manually change information in the production db by saying "hey, client Billy wants his stuff moved back to where it was"3
-
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 -
3 Database SQL walked into a NOSQL bar.
A little while later, they walked out...
Because they couldn't find a table.1 -
Working at a local seo sweat-shop as "whatever the lead dev does't feel like doing" guy.
Inherit their linux "server".
- Over 500 security updates
- Everything in /var/www is chmod to 777
- Everything in /var/www is owned by a random user that isn't apache
- Every single database is owned by root sql user
- Password for sudo user and mysql root user same as wifi password given to everyone at company.
- Custom spaghetti code dashboard with over 400 files in one directory, db/ api logins spread throughout these files, passwords in plain text.
- Dashboard doesn't have passwords, just usernames to login
- Dashboard database has all customer information including credit card stored in plain text
- Company wifi is shared by other businesses in the area
I suggest that I should try to fix some of these things.
Lead Developer / Tech Director : We're an SEO company, not a security company . . .10 -
Why. Why is it that so many websites out there still specify a maximum password length.
If your "secure password" solution was all that secure, then why would the database care if I use a 8 char password or a fucking 500k one? It all gets hashed into a string of a fixed length anyway!
But, it might just be that all these "secure services" store their passwords in fucking plain text. Then the database would indeed care. So much for security I guess...6 -
Occasionally, some guys send badly written SQL to the database and drained most of the resources, then complain the db and apps using the db are not working.
-
When I think my teachers can get any worse after sending me snippets of several Java classes in a single txt, one of them sent me SQL code of a full database dump in a Word document. 8 pages of SQL in its full glory!
I guess using the proper file extension/format or a service like PasteBin or GitHub Gist is way too advanced for them. -
working against a database over a bugged VPN connection, which gives you periodically timeouts, after the request takes 15 minutes 😑
-
I just tried to updated mySQL on my development server, the mysql.user table is corrupted, all passwords got expired and i cant set new passwords because as i said, the user table is corrupted.4
-
I've never really had a project "blow up", however one that I'm quite proud of is fairly popular (almost 500 monthly downloads if NPM's (limited) stats are to be believed.
It's a connector for Redis for Node, which uses ES6 Proxys in order to make basic interactions with objects in the db easier.
It's actually based off of an existing project that does the same sort of thing, but I noticed a couple of things that it did that I found a bit annoying.
1. When creating new nested objects, it didnt create a tree, meaning you had to do that manually.
2. It stored everything in a single hash, which does makes it easier to interface with, but it's a bit weird for people who didn't expect it to work that way.
3. It supports array methods with getting objects, but they don't mutate the array in the database, which was one of the main reasons I decided to make my own thing.
It took a while to get it working properly, mostly due to getting some weird ass errors, but in the end I finally got it working as I wanted.
I never really expected a lot of attention for it, but it makes itnjust that little bit sweeter to know that other people use it. And even if no one else uses it, it makes life just a bit easier for myself. -
I want to cry... Fuck it.. shiit. .. :( :( ;(
Wasted half of the Weekend to Setup MySQL on my vServer which uses ssl encryption, have specific User and so on.
Thought: well, the User mysql is not so good as a Name. Drop it, you don't need it.
What did I? Instead of Drop User mysql , I typed Drop Database mysql.
Fuck that fucking Shit. I'm so sad right now. Broked the complete MySQL Database. Nothing is working anymore. And the server is new, I've Just made One Backup. Deleted this a few hours ago.. also accidently.
Help me :( Shit :( so sad :( Now, I don't have Motivation anymore to work with the vServer :(3 -
Error reporting was flooded with failed database connection connections with me being baffled what was causing it.
Yeah, fucking network operator didn't tell us anything about maintenance work. Fuck you, too. -
Do you know how MySQL got it's name? Well, it's a really interesting thing one should know. Atleast, I find it really amusing.
~Michael "Monty" Widenius is one of the founder of MySQL and one of his daughter's name is My(after whom MySQL was named).~8 -
I was asked to update the whole confidential, financial database by exporting it as excel, and using Macros to edit its content. Much akin to adding one extra attribute per row.
The truth is, the table originally had 6.3k records. After updating and putting the data back to NoSQL database again, I realized I ended up creating 7k rows of data. Yet it works just perfect !
*HAILS TO ALMIGHTY FOR THE MIRACLE*
Sometimes, I still wonder where did those effin 700 rows come from, even after I skipped an excel while uploading2 -
$rant = false;
Let say you guys are working in a team of 3 and need to share a database. All of you are in different locations.
I am currently hosting my database on online server, which is kind of slow for me because I have poor Internet in my country. How do you guys do it?8 -
SO , i just ran into this database called ArangoDB and it claims to single handedly beat Mongo,Neo4j,Postgres and claims to be capable of handling any use case you can throw at it.
If anyone could verify this claim , such an ideal database just makes me question it's existence.5 -
I can't convince my team that a good database model promotes a good API design and a good UI/UX experience.
Instead, I have to work with a ridiculous table setup.
Imagine, if you will, a table (table B) that references another table (table A) via a foreign key. The FK is a string in both tables. And table A only has one column, which is labeled as "name".
The schema i have to look at it kind of like this:
Table parent
Name varchar(10) primary key
Table child
Name varchar (10),
parent_name varchar(10),
Foreign key (parent_name) references parent (name)
Sorry if the syntax is wrong, a little frustrated having to look at it...
Am I crazy to want to change this table design? Am I missing something? I feel like I'm taking crazy pills, because this is just scratching the surface of the problems I have to deal with.8 -
Arrg, need to also make a database for an application, because client doesn't want to give access to their own db. fookin Brian3
-
This story was related to me while I was in university.
So a long time ago, (in a galaxy far far away). This student was working as an intern at some tech company. He was running some queries, everything was fine. He decides that's good enough and heads for lunch.
When he comes back the query does not work. He notices the others around him start to stand up asking if anyone has a connection.
Turns out that an intern, at another building, basically deleted everything. I'm guessing they did not add this internship to their resume. -
I just don't get people designing database tables using VARCHAR/VARCHAR2 for columns that have numeric values in them, then use them as row identifiers.
I simply don't.
5 -
What happens when you give a database design to your boss as per what he wants done, he sees it is not impressed, scolds you, curses you out and claims you are 'fraud'. Then you tell him you can do better to redeem yourself...you submit the work better than the first time
And then he terminates you due to 'lack of proficiency'.3 -
FUCK YOU EMOJIS! FUCK YOU AND YOUR EVER FUCKING GOD DAMN SPECIAL WAY OF BEING HANDLED.
Now that I have that part out...
I really fucking hate emoji at this time. Currently I'm working on one of my projects that has markdown support. One of the things I'm extendending the parser with is github style emoji (eg. :smile:) now this part works great. The problem however is getting that short code into a unicode char for HTML. And at the same time I have to take any unicode emoji inserted into the text box by phones and stuff and convert them into the shortcode (My database does support emoji but it's much nicer to store all emoji with the same standard)
All of this has taken 5 hours of research (needed a database of unicode -> short names) and several hours of converting the data from someone elses json into something I can use. (AKA Shrinking the damn file to only what I need) and now I've spent 5 more hours working on the actual code. And I still don't have it working properly.4 -
When testing things..
Product Description: Expensive Imported Turkish Pen
Product Image: A bag of Snickers
The "asdfghsjgllhdk" text doesn't look very appealing. -
Rant and opinions wanted. Its a long one.
I have been working on a project for a month and a half. For the first week I was requesting designs that I got about 2 of out of 15. For the next week and a half the designer was on holiday so I couldn't do anything but delivered a few more designs once he got back.
This takes us 2 weeks in already. I have other things to do as well so at the same time I work on support tickets and some bespoke development coming in.
I get given 2 or 3 more designs and can't get anything else out of the designer after waiting a week so I have to design everything myself as I go and build it. Something I have never done before.
We are now 3 and a half weeks in. My boss randomly tells my pm it needs to be demo ready the next day. I work furiously to hack something together. It works but key functionality is missing.
I move house and work from home for a week and a half. I do my best but the project is full of bugs and the CSS is horrible because I didn't know what I was making at any stage. It is therefore CSS rules repeated in IDs everywhere.
My colleagues join me on the project because my boss has decided to try and sell it tomorrow.
They run through it and find all the bugs left from me working furiously to get things done quickly. Things like no search pagination and missing validation.
My boss is now pisses at me because the project is not finished, my colleagues are now all working on it. Throughout it all he knew the designer was not delivering me anything and that I was struggling.
Am I in the wrong for writing shit code that came about because I was coding with no idea of what the finished project should look like? Is he in the wrong for dumping this on me and just letting me get on with it even though he knew there were no designs?
Btw I am just finishing a 1 year internship and before this have never done web dev before.
Discuss.7 -
Soo, lets talk about deadlines and how often I come in trouble when there is one near. This week I have (had) three. So I had a lot of problems this week.
But, after all today was a really good day.
I deleted an production database, fucked up my laravel migrations and tomorrow we have to deploy another application. The app is still in development and the site isn´t finished yet.
Friday I need to launch another webapplication. Because I don't want to deploy webapps and apps on friday and I go snowboarding next week, I somehow convinced my client to launch it next week. He agreed with me, so that's a burden off my shoulder. And I'll have an extra day for fixing the last bugs.
Today I worked really hard and almost finished the last application. So I think after all I'll somehow manage it.1 -
That feeling when you are asked to export data with columns that have never existed in the database...😞
-
This one time last year a colleague found out that some data went missing and suggested to recover the data from a backup. When trying to create a new database instance in the Google Cloud Platform (if everything works it's amazing!) it failed.
Not knowing why this happened, I tried to revert that backup to the production database, after creating a backup using the GCP. Needless to say that failed as well, resulting in a corrupted database instance where I couldn't access the created backups anymore.
This all went at around 10pm and the only users of our product are currently in the same timezone and use it from around 7.30AM until 6PM so no one besides our team knew the server was down.
After a long night chatting Google's support team the database was successfully recovered and the only harm done was sleep depravation for me and a colleague.
Apparently there was a bug in the GCP. It was resolved in two hours and the last time a breaking bug was in that piece was more than seventy days earlier.
I did at least learn to create local backups as well, instead of relying on the tools of the same product...
Best: the moment I saw the corrupted database spin up again and not losing my job because of it. -
Designing with "real" data
In Interaction Design Uni i've got this assignment to design a prototype for an "Ebay for used books". A requirement is that we have use "real" Data and not lorem ipsum for our design prototype tools. Which is a fair point but....
It's about 50 book categories (crime, history, romance) we have to cover, and for every category the prof wants at least 2 Books.
I've don't have the time to type in the (meta)data for 100 books at 30 JSON properties by hand. What would be your advice?
Do you maybe know a easy to use online bookshop API? (remember I'm a tech savy designer not a dev)
Or do you know someone in a low income country who does data entry? Or any experience with hiring someone on fiverr?
Thank you for your help. :)
11 -
installing oracle 11gr2 database via docker is so easy and quick rather installing to the system
Totally saved my time, now I can have more time for learnig1 -
Found out the database was missing a record from the parent table. The app hummed along perfectly, pulling all the data from child records.
TL;DR: This app uses the worst possible database form if everything you need is duplicated into all the child records every time.4 -
Investigating volt db right now. Anyone has any opinion on this one before I jump onto the hype train?
I'm afraid I'll be posting a lot of rants in the near future.1 -
Hey all, can you guys recommend some great books on database theory and design. Something aimed towards intermediate towards advanced. It doesn't have to be sql, I just want to learn how to make a kick a#@ db.
Thanks!!!!!!!
7 -
Turns out Chrome really dislike to parse, save in indexedDB, query some things, and draw a graph of some JSON file.
Or, you know, maybe, an average response size of 5Mb is a bit too much.2 -
!rant
Is making a class just for opening and closing a database connection taking Single Responsibility to far?4 -
It's Saturday and instead of being home or going out I'm stuck in college with this two trying to learn procedures because of an assignment that I have due tomorrow. What a great way to spend my weekend!
3 -
*looking over an Excel sheet*
Me: now there are 2 rows that represent the same data, with the same description
Them: I'll just 0 out the one, and we'll ignore it.
Me: I'm never letting you near any of my databases. -
I fucking HATE ORMs. Fuck this bullshit, they always have some use case that is stupidly difficult or obscure that no one knows how to deal with because the creators didn't think of the one thing I want to fucking do.
Screw this bullshit, homebrew SQL is ALWAYS the way to go; I've never encountered an ORM that didn't turn in to a troubleshooting, dialect-learning timesink.5 -
Spent 2 days optimizing SQL queries, and then I learned a valuable lesson.
If your database size is bigger than the RAM of the machine it’s running on, every query will take 5+ seconds ☹️4 -
Spent 4 hours working with a buddy before realizing our failing code stemmed back to using sqlite3 Npm package, which is asynchronous. Switched to better-sqlite3, a synchronous sqlite package, and alls good.
What's the purpose of an async DB anyway? Seemed like it made storing and retrieving data a huge hassle. -
Postgresql kept shutting down at odd times. Then it became predictable. I googled, went through mailing lists, archives, old threads, Stack overflow, friends, family, my bosses, my old colleagues, forums, chat groups and paid redhat support.
Apparently, I'm the only one and the first on this planet to have this problem. And it's scary.6 -
So we have a website on our server fir company related things and I wanted to build a projectplanner so my boss told me I should use serialized arrays since we already have a database with all the projects and the id. So I told my boss that I want to make a new database since serialized arrays are bad and slow and he said just do it anyway. So I did and after I did it I told him its slow and he told me do it with a new databse. And I was like LOL but I didnt mind since I learned a lot rebuilding it + its much faster now and I didnt have to do anything anyways so it was a win win :)1
-
I so hate working with legacy db code! I wish I could migrate all to entity framework but the migration is a pain in the ass and would take hours which the client wouldn't like.
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.. -
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..
2 -
#include <helpme>
Ok guys I kinda need your help. I have to write a python project for my school in 3 days and instead of saving everything in files I want to have a database. So my question is can you suggest the most simplest and easiest db to create and connect to Python for a few simple tables. Also the easiest to set up on another computer since my professor will probably want to try it at home.
Also I have to learn Python in 3 days, since I already know a couple of languages, I'm confident I can pull it off. Why I'm asking for help is I need to document it all, that will probably take a chunk out of these 3 days.5 -
Quick and dirty job to get some data into a DB wasted my entire evening.
Created table with few columns, tried writing to it from NodeJS app and it kept complaining I wasn't providing values for columns that didn't even exist. After ages pissing about decided that the DB gods had cursed this particular table so created a second one with same DDL. Now it worked first fucking time. Then it finally dawned on me, I'd managed to pick a reserved table name and the RDBMS didn't think to give me a warning when I created it. Not only did it not warn me but it kept going as it nothing was the matter and didn't report the extra columns on a SELECT *. -
- A while ago l designed a single user Point of Sale app for a pharmacy.
- Now the client wants to be able to make data entry at his home PC too.
-It means having export and import humongous amounts of data between his shop and his home PC.
(I designed it using electronJS, AngularJS and a MySQL client for nodeJS)
How do I approach this? I have been thinking about SQLITE but I'm not quite sure about it.4 -
So one of our teacher gets a mail from her personal email id on her college id, saying, "Hi this is me". Goes to google and searches, " Hi this is me mail on gmail".
*face palm*
Fatuity is unreal. -
Mfw the CREATE TABLE statements in the SQLite database handler of my latest android app run perfectly first time
-
Intelligent Development class (yeah, that's how it's titled), teacher leaves us as first task to develop our own Database, because later we will make it a fuzzy database.
She gave us three days. Three (counting me) in the team. I began working on Interfaces (Java development) and so on, using GitHub for VCS and documenting each method.
This assholes didn't even ask what was missing or what should they do. One day before date, I told them "Hey, I think I can nail the underlying file management tonight, so, work on the language parser, please"
Stood awake until 1 A.M., waiting for their reply, but there wasn't any.
Next day, I'm the only one of the team and I tried to decline the presentation of my work, but a friend encouraged me, because it was my work and I worked hard.
Presentation went better than expected.
After the class, I have another with one of my team members, he asks "How did you do?", "Us? You meant me, because the other prick didn't go".
And that's all, not another single question nor explaining why did he didn't answered the DM's I sent.
Fuck those guys, fucking team of shit, I hate it when you can't pick your team, but I guess that's just a common place for all of us here, isn't it?3 -
Another question for Database-Gurus:
Is a MySQL table with 4 columns and about 42000+ rows considered 'big' or should the table be split in smaller pieces?5 -
That feeling when you were sick as shh and almost good now after eating good pepperoni sausages and wine, suddenly getting energy and reminiscing about : (1. Biggest priority)
1. Am I really going to play with code side project it's Saturday
2. Nah I'm still going to play Dota or wow or idk
3. Laying in bed devranting and telling to myself am I that tired and lazy to do the above ones? Nah it's just socializing
4. Laying in the bed turning the phone display down ?
Yeah tough choices probably get some wine and do some music idk man -
self refrencing tables awesome concept but it pisses me off that mysql doesnt support "select with" query i had to think about writing recusive functions that builds a tree of n level i must say im kinda proud :p
2 -
And now the boss want to have a user table in the db where I can change the id of the user (primary key) when ever HE wants... And all the other table are connect to the user trough the id...2
-
Arg. I messed up bad today. Updated 17k records in database by mistake and had to rollback and apologize...
I won't rush on a task for rest of the day1 -
Storing de-normalized data in NoSql when used to relational data feels like I am vomiting on the database
-
I feel bad for trying to implement emoji support in our web application, but yeah #2017..
And damn, php + mysql + emojis.. What a pain in the ass.
"Just change your table charset, they said, it will work, they said" FML4 -
Took a Database exam today and tell me this, WHO THE HELL MAKES 40% OF AN EXAM MULTIPLE CHOICE? LIKE WHY?4
-
Y'know, there are some things that are timeless. Like bug severity arguments. We don't have a "likeliness of occurrence" parameter in the bug database. We just have "severity if it occurs". You have to classify it as such. The bug database IS NOT FOR RISK MITIGATION ACTIVITIES IT'S FOR FIXING THE FUCKING SOFTWARE!!! STOP MAKING THESE DAMN MEETINGS TAKE 30 YEARS BY QUESTIONING THE SYSTEM THAT WAS ESTABLISHED IN THE BEFORE TIMES BY PEOPLE WHO ARE ABOVE YOUR PAY GRADE!!! TINDER BOX!!! MATCH!!! GODS DAMMIT!!!
-
3 database-admins are walking into a bar. Shortly the leave without ordering or even sit down for one sinple reason: they couldn't find a table.1
-
I was writing a db on sql and I accidentally fucked up the key column.(as you can see in the pic) No, I didnt used AUTO_INCREMENT.
Is there a wei to make this right, other than doing it one by one?
3 -
Had to do a school project with PostgreSQL and absoluted hated it.
>>fast foward 5 months>>
New job, new project. After one week of trying to connect to a local database with MySql, Xammp and Wampp without sucess guess wich database worked...
We are now best friends. -
I needed to migrate one DB to another with one sql suite but instead I fucked up and suddenly disconnected both DBs, without being able to reconnect them again
I waisted a whole day for debugging, but found nothing
And guess which magic fixed all issues? On and Off a service of an app
On and Off!!!
The fun thing is that restarting the server didn't help, but the only service helped1 -
Me, trying to access an old mysql database on a Linux server, the root user gets rejected. Out of frustration I delete mysql entirely and try to start again.
I was not using sudo to access the root user...
In the bright side, the deleted mysql version was actually an old one, the database is actually fine.1 -
Neo4j vs Mongo vs SQL
Which one would you choose for a high density scalable database?
Please comment with your ideas about speed and scalability.15 -
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.3 -
stdclass arrays of php are a good solution to work with data from the database but sometimes they can be a pain in the ass...8
-
Anyone familiar with Wordpress site migration?
I'm trying to move a client site from my dev server to theirs, seem to do so fine, but all urls still point to my dev domain.
A search and replace plugin was recommended but it doesn't seem to be updating the database references correctly...or at all.
Not sure if anyone would mind lending some insight so I don't have to essentially redo the whole website over :p9 -
Found this book in a garage sale in our country. It costs 1USD
This type of book or any modern related programming book is rare in our country.
3 -
I am in need of a good web host for my personal website... the one I use now is free and therefore sucks. I can't even get external access to the MySQL database and their SQL client sucks.9
-
Question for database gurus:
I need to save the openig hours of my clients in a database. Each day should have different opening hours and also the possibility for 2 breaks during the opening hours. There should also be an option for different local holidays for each client.
How to I acomplish this in a clean/performant/scalable way? Thank you for your answers!10 -
Devs are divided on gitlab blunder, some appreciate their honesty and transparency while other are either cursing them or grateful that they didn't use it. But think like this :
You own a MacBook and you love it like your baby, if someone drops it, there is good probability it won't break but it will sure give you a fucking heart attack. You won't ever let that person touch your MacBook.
Gitlab just did that. They scared the hell out of the developers.
I hope everyone learns from this and it doesn't happen to anyone in future.4 -
So I have spent the entire morning trying to fix null values in the database, because they keep fucking up my code.
I hate the fucking person who made the database at the place I work, dude has not heard of a thing called NOT NULL!!! -
"Once you eliminate the impossible, whatever remains, no matter how improbable, must be the truth"
The reason why I implement my own DAO in Android -
My team leader said to implement some dynamic tables so in the future we dont need to program anymore.1
-
So much ambiguity in the way knowledge is delivered >.< I should have gone to lecture. so much regret 😵
Does anyone know linear hashing algorithm and when the split pointer should do a split on its current bucket? -
Started adding image urls to my database fixture.json for my django project... 57 done... 352 to go.... for the first of 3 different models
why isn't there any consistency in their urls? thank god, there are substances to suffer these parts of development...
so fine, I do what I have to do, for a hopfully thankful community -
Asked to map the old database into a diagram. Looks like someone threw up spaghetti. It is so full of tables named "obsolete" I don't understand!
-
Why do you fucking retards make the tinyint column nullable AGAIN and use 'null' as false instead of setting fucking false!
-
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 -
Hi there I just started learning Android studio and I'm stuck in the part where you make DB for your app. What should I use in my app Firebase or Realm and why?3
-
Currently working on a conversion of a tool we use to keep track of our working hours (like how much time did we spend on that task, that project etc.), because the old version of that language sucks ass and the database system sucks even more ass.
Besides the other stuff that's freaking horrible in that fucking shit tool (crashes when entering wrong input, etc.) - the genius that created that peace of crap (1997!) decided that he wants to use a fucking timestamp as a PK-column on some tables.
Why the fuck would you that?! Jesus fuckin' christ.
And of course, the fuckin apprentice has to deal with this shit and has to be finished yesterday x)3 -
Sometimes I think the relational model is a disservice to humanity.
Sometimes I love it.
But mostly I hate it.1 -
We have a form for order entry, where the colleague have to put the VAT number of the customer, bc the customer might not be encoded in pur db. After a while I checked the inserted record, and saw strange numbers, that resemble customer ID. After pointing out at colleague I receive this answer: "well, few of those have an ID, and I didn't want to look after VAT number. I think it's the same, no?"
... I think I need yoga in my life... -
Spent yesterday writing a ghetto join algorithm thingy for rethinkDB, only realizing at 11 that night after nothing worked that reql had joins. Duh.
I feel dumb.
Here is a link to my late night code for laughs.
http://lijo.pw/theHorror4 -
Thoughts on Apache Cassandra? Seems awesome, but are there any gotchas we should know about before diving in? Currently we use Postgresql for most things.3
-
Things I say at work:
"...and the words 'ghetto' and 'database architecture' don't ever belong in the same sentence." -
Hey guys I just wanna start to know about the networking and connections from the beginning, 'cause I've got some information about them but there aren't complete enough. Could you plz suggest me some sources or paths to start studying about'em...?!1
-
When the vendor did a search page but retrieve all the records from the database and paginate them with js, and the load test crashes with 20 concurrent users!!!
-
Proccess hangs after my integration tests run because of a database connection that isnt being closed somewhere >.<... node doesnt make it any either to debug either. Fml.
Top Tags
Weekly Rant
View