Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
Get a devDuck
Rubber duck debugging has never been so cute! Get your favorite coding language devDuckBuy Now
Search - "message in a bottle"
My biggest dev blunder. I haven't told a single soul about this, until now.
So, I was working as a full stack dev at a small consulting company. By this time I had about 3 years of experience and started to get pretty comfortable with my tools and the systems I worked with.
I was the person in charge of a system dealing with interactions between people in different roles. Some of this data could be sensitive in nature and users had a legal right to have data permanently removed from our system. In this case it meant remoting into the production database server and manually issuing DELETE statements against the db. Ugh.
As soon as my brain finishes processing the request to venture into that binary minefield and perform rocket surgery on that cursed database my sympathetic nervous system goes into high alert, palms sweaty. Mom's spaghetti.
Alright. Let's do this the safe way. I write the statements needed and do a test run on my machine. Works like a charm 😎
Time to get this over with. I remote into the server. I paste the code into Microsoft SQL Server Management Studio. I read through the code again and again and again. It's solid. I hit run.
Wait. I ran it?
With the IDs from my local run?
I stare at the confirmation message: "Nice job dude, you just deleted some stuff. Cool. See ya. - Your old pal SQL Server".
What did I just delete? What ramifications will this have? Am I sweating? My life is over. Fuck! Think, think, think.
You're a professional. Handle it like one, goddammit.
I think about doing a rollback but the server dudes are even more incompetent than me and we'd lose all the transactions that occurred after my little slip. No, that won't fly.
I do the only sensible thing: I run the statements again with the correct IDs, disconnect my remote session, and BOTTLE THAT SHIT UP FOREVER.
I tell no one. The next few days I await some kind of bug report or maybe a SWAT team. Days pass. Nothing. My anxiety slowly dissipates. That fateful day fades into oblivion and I feel confident my secret will die with me. Cool ¯\_(ツ)_/¯13
devRanters do you think this is feasible as a fun/learning devRant community side-project?
Possible community side project: 'devie Stressball Trans-OceanicTrackable Voyage': So, my idea is based on the 2,000 year old concept of a message in a bottle. In fact, bottles from the Titanic were found 100 years after it hit the iceberg.
Pseudo: we pack devie into a bottle along with maybe a Raspberry Pi,GPS module, solar battery... Hopefully, it could send pings and we could track the journey. I am more a software guy than a hardware guy but I have played a bit with Pi and I know a few devs good with Pi's.I will also talk to the folds at Adafruit.
Here is an interesting paper I found in my beginning research. http://netlab.tkk.fi/u/jo/...
Also, I have seen low cost Raspberry Pi cubesats powered in outer space by solar.
Please let me know your thoughts if you think this might be possible. Also, if some of you might be interested in taking this learning journey. If we decide to try it I will purchase the hardware. Looking forward to your thoughts. Love this community!95
Update - The 'devRant trans-oceanic 21st century message in a bottle' community project is progressing nicely.
There is terrific research being done by the team in a slack channel. It is a great fun learning experience.
We have taken the 2000 year old message in a bottle concept and are breaking new ground leveraging very cool technology. We are still in phase 1 but at a high level devRant's much coveted stress ball will cross the Atlantic Ocean in a bottle type encasing.
We will use satellite tracking and gps to track devie throughout the journey. We will use Arduino or a similar microprocessor. We may use sensors and gyros to monitor the surrounding environment for temperature and depth.
We are also studying ocean currents, shipping lanes, weather data and bottle materials to make the journey as smooth as possible.
This is an official devRant sponsored project. We encourage you and any dev friends to join the conversation. Below is a link to the original rant which has the Slack channel info.
The sun never sets on devRant and we love intriguing projects!
One time I took out a colleagues letter keys except the ones needed to spell freezer (in croatian) and left the message freezer on the keyboard, took the remaining keys, put them in a bottle which I filled with water and put them in the freezer overnight (left work the day before earlier than him).
A positive was that the keys were real clean. Negative was the rest of the keyboard was dirty :)
Was a good laugh, though.5
My current dream project is sailing a 21st Century Message in a Bottle across the Atlantic Ocean from US to Europe, satellite tracking it in apps and desktop environment and more importantly inspiring school children everywhere that anything you can imagine is possible. Fortunately, the project is rapidly becoming a reality - here's how:
- teamed with a few amazing devs virtually
- team created an effective infrastructure for communication and knowledge sharing
- researched oceanic patterns, satellite communications, sensors, material design, recovery logistics...
- developed budget and received funding sign off
- created realistic, yet aggressive project plan with deliverable dates
- built relationships with two Universities for Oceanic knowledge assistance
- developed a partnership with NOAA and will share info
Oh yeah, we did all that and are having fun in only 25 days so far! More challenges to come but we embrace the challenges!1
We had this customer that wanted a app called "Bottle message" to use it for basically everything like ordering shoes or sending money. He thought it would be practicable to just write in the "message" what you want to do and when you want to make it happen.
Remember the Stress ball's TransOceanic Trackable Voyage? (Also called Devvie in a bottle.) Well, we're finalizing the design. But if you are interested in helping us with software, hardware, launching, recovery, or anything else that might help, join us at stotv.herokuapp.com. PS, we're also looking for sponsors, so if you are or know someone who is interested in sponsoring, send a message to @sven on Slack.5