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
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
If drinking coffee doesn't wake you up in the morning, try deleting a table in the production database.
Verified, it worked.4 -
Everyone has their stress balls, cubes, pillows, spinners etc.
Only what I have is my stress table
(╯°□°）╯︵ ┻━┻4 -
Having an english conversation with a russian client.
"What do you want the info to be?"
"I want the name, adress and etc."
"Etc?"
"Yes! I attached you a picture with everything...as you can see..."
<the picture is a huge table in russian>
"But the table is in russian"
"Yes"3 -
-How persistent are you on achieving the goals?
-I saw the end of the Excel table
-The job is yours1 -
$search = $_GET ['search'];
$table = $_GET ['table'];
$query= mysqli_query ("$search FROM $Table");
😲😲😢😢8 -
Imagine a database table where dates were saved as strings from raw user input. Then do migration to other database with table where dates are datetime.
Yep. That's me. 😶
I hate humans. 😧🔫
Especially those who try to be original like:
11|Sept.|2016 or 13;Juni;17
There are rules in this world, damn. 😥9 -
F***ing windows, spent ages repairing a database table only for windows to bloody BSOD at 97% complete 😡1
-
I just almost shat myself.
I altered the wrong database table column...truncated data we are required to keep for government compliance.
Luckily I had exported that table earlier today and was able to recover it all. I'm in need of a very strong drink right about now.12 -
To all you devs still wet behind the ears ranting about css - you have no clue just how good you have it.
Most designs used to be table based (table-ception) and to give something a border with round corners or a "drop shadow" you would literally create a table to hold you content with an border of cells containing a background image of a corner / border.
Now you use border-radius or box-shadow as a 1 liner. Stop bitching about centering things and figure out how to hack it like we did.
If you remember this whats your least missed 20th century hack?15 -
Worst coding mistake would be me dropping an entire table of customer names because I forgot to double check the table name in the script. I felt my soul leave my body.4
-
I build a 10 by 20 RGB LED-Table out of an 15€ IKEA table.
It has several effects and you can also play games like Tetris or Snake on it by using an Android App. It uses a Rasperry Pi Zero W under the hood for a WiFi and Bluetooth connection.
By using homeassistant I can now control the table by using "Ok Google, turn Table blue." - that's so strange to say.
All in all it was ~50 hours of soldering/building and ~90 hours of programming
Software of this project is open source but without building instructions.
https://github.com/Gurkengewuerz/...
10 -
Did you know that
console.table(arr);
will let you print whole JavaScript arrays in table form in console?10 -
We have this weird db naming convention requirement by the client all table names should be of 4 letters. And guess what somebody thought of naming a table 'ANUS'6
-
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"5 -
"So... what about Bitcoins, huh?"
Did that question come up at every Christmas dinner table this year? 😂4 -
Accidently deleted user table on production database and some backups where broken. Had to deploy a 4 days old backup...6
-
Was developing WordPress plugin. On the last step, i need to check if the remove DB table functionality when user uninstall the plugin is work. uninstalling plugin, check phpMyAdmin, and yes the table is gone. Also the plugin, which i dont have any backup. I need to drink....7
-
MySQL should have a recycle bin. I just deleted whole "user" table by mistake... Forgot to add where clause properly... Had to restore 2 days old backup copy. I just hope no accounts were created or someone changed their password in last 2 days....7
-
Using AI to draw me a table that will look good in my small kitchen corner, just wanted to see some ideas slightly different from basic ones:
"a small table, big enough for only 2 chairs. The table sits in the corner of a room."
.....
*sigh...edit
"the table has only 4 legs!"
...
*sigh...edit
"the chairs are not physically attached to the table"
...
...
...edit
"The table legs do not go through the table and in to the ceiling"
...fuck it.. I'm off to ikea1 -
iMac tiny keyboard + my fat fingers + Command+Q when I meant Command+A = Table Flipping Extravaganza!6
-
DELETE FROM TABLE invoices.
The next week was spent inputing the data by hand because:
Who needs database back-ups?2 -
A : "The log tables of the licenses is broken, fix it"
Me : "But who ever made this didn't make a relation between master log table and the detailed one. I can't get anything from details table"
A : "There is a relation .. "
Me : "What ?"
A : "The date entry of each record"
Me : "I Quit" -
Rails console:
> `ModelOne.joins("ModelTwo")`
# => ActiveRecord::StatementInvalid (Mysql2::Error: Unknown table 'database_name.model_ones')
MariaDB:
> `select count(*) from database_name.model_ones`
# => 13274641
It's right there, ffs4 -
Imagine saving Integers and Floats in a MySQL table as strings containing locale based thousand sepatators...
man... fickt das hart!
Wait, there's more!
Imagine storing a field containing list of object data as a CSV in a single table column instead of using JSON format or a separate DB table.... and later parsing it by splitting the CSV string on ";"...7 -
I need bleach...
Lot of bleach.
When you think that not using a JS framework is bad...
Ever saw a Frankenstein of a HTML, PHP and JQuery? Full rewrite of an old project with more than enough time allowed....
Just... That was not awful enough.
*sobs* so the dev added bootstrap onto this pile of garbage... Instead of rewrite....
Think I missed CSS or included it in HTML? Lol. No.
No CSS. Inline. HTML 4 Tags.
?>
<table width=40 class="table table-striped">
<?php
foreach( $table as $row ) {
....
<input onkeyup="..." onkeydown="..." class="form-control"
...
To give you a basic example of how worse it is...
But the best. The lead developer does not understand why I was speechless.
i need more beer. And bleach. Filth and disgust must get out of my system2 -
Overworked team spends 2 months hacking together a Codecademy clone in record time: avoiding best practices, conflating paradigms, throwing shit at the wall until it stuck.
But today I submit a small UI fix that used a table instead of `display: table`...
1 -
* Ctrl+Shift+F to find all "assert" in solution...
Matching lines: 0 Matching files: 0 Total files searched: 1504
* Bang head on table
* Flip Table
* Start writing unit tests -
Let's say you have a MySQL database table for jobs. Each job has 1 associated ticket. You want to keep track if the ticket is closed or not. Every sane person creates jobs table, tickets table, keeps bool value for ticket state and relationship between them.
But because our database is designed by a half braindead amoeba, we have one table only, so each job has to be updated individually with a new ticket number and its state. Beacuse it sooo much faster to update (daily!) 13k jobs than just 100 tickets.
As a bonus - if the ticked is closed, the column "ticket_closed" is "No", if it's still open the value is "FALSE". Yes, both as varchar/strings.7 -
New web devs don't know the struggle of using spacer.gif, nested table layouts, and vibrant "web friendly" colors out of requirement.5
-
from the same guy that altered a table without warning: deleted a stored procedure without telling anyone14
-
!rant
<curious>
How do you guys format data like this? Using js framework? Or pure HTML tags?
html labels? invisible table?
</curious>
14 -
There was a kid in my programming class that was convinced that in the next 10 years ai would become self aware and seek for the destruction of its creators.
I wasted 20 minutes of my life trying to explain down how ai sentience would have to be an intentional decision by the group creating the ai
Of course, he spun around and tried to explain how secret government organizations are already working on general intelligence that would run on quantum computers to shut down enemy governments.
Maybe with people willing to believe anything the world is doomed after all :/10 -
Conversations with SQL Server:
Me: TRUNCATE TABLE users;
SQLServer: Okie dokie, Command(s) completed successfully
Me: WTF SQL, u didn't even ask for confirmation
SQLServer: Well, you did type 'TRUNCATE' then 'TABLE' then 'users' didn't you. I mean how much confirmation do you need you prick.2 -
Downloaded SQL assigment
Scroll fown to find the tables and the data
A table with the worst font to use
1 -
Woke up super late (evening), was planning to work on my personal project, but didn't have a table where I can comfortably code and sketch out my ideas.
Hence, dressed up immediately and went to a furniture shop.
Getting table, chair and a bed (which I was planning for a long time) tomorrow.
Gonna just sit and code whole day tomorrow...2 -
-click-
MySQL: 'the table does not exist'
I just fucking made the temp table dude, that's what you literally do in step 1 .... how could it not....
-click-
MySQL 'Records: 1 Duplicates: 0 Warnings: 0'
Me: "Oh there we g---"
-click-
MySQL: 'the table does not exist'
Me: "Hey you just worked!"
-click-
MySQL: 'the table does not exist'
GOD DAMN IT
-click-
-click-
-click-
-click-
-click-
-click-
MySQL 'Records: 1 Duplicates: 0 Warnings: 0'
Me: Uh you're working now?
-click-
MySQL 'Records: 1 Duplicates: 0 Warnings: 0'
-click-
MySQL 'Records: 1 Duplicates: 0 Warnings: 0'
-click-
MySQL 'Records: 1 Duplicates: 0 Warnings: 0'
Guess that API just needed breaking in....3 -
Promised to stay late to run a large deploy.
Now waiting for a large schema migration on a 7M row table.
4 -
!rant
I'm so happy with my full stack basic test web application made with: raspberrypi, uwsgi,nginx,python3,flask,sqlite3,render_template,html
I have 2 pages:
/users where I can see the whole users table and filter by id
/insertuser (in the image) where I can add an user to the table users
4 -
At my last job, I created a Google Map for a client, where you could click on any department from France, and it would tell you about all the antennas (think "outpost") of his society. I used a Google Fusion Table where I registered everything: the datas to display, the coordinates for every departments and for every region.
I then wrote a 15-pages long document to tell how to maintain that, since I used my personal Google account to create the map. Anyone having a full access to the website should be able to recreate the map from nothing and witout writing a single line of code.
Then I switched project, the company kind of fucked me over, and I just received a mail saying that Google Fusion Table will be put down in a year.
I just hope they didn't receive the mail. -
Our production database has tables that exist only to be recompiled into a single table. Like, one record across 4 tables. Each record is only for one other record in the other 3 tables.
I LOST 2 HOURS DEBUGGING IT BECAUSE IT COULD NOT RECOMPILE THIS FUCKING TABLE. FUCK! -
I just found a vulnerability in my companies software.
Anyone who can edit a specific config file could implant some SQL there, which would later be executed by another (unknowing) user from within the software.
The software in question is B2B and has a server-client model, but with the client directly connecting to the database for most operations - but what you can do should be regulated by the software. With this cute little exploit I managed to drop a table from my test environment - or worse: I could manipulate data, so when you realize it it's too late to simply restore a DB backup because there might have been small changes for who knows how long. If someone was to use this maliciously the damages could be easily several million Euros for some of our customers (think about a few hundred thousand orders per day being deleted/changed).
It could also potentially be used for data exfiltration by changing protection flags, though if we're talking industry espionage they would probably find other ways and exploit the OS or DB directly, given that this attack requires specific knowledge of the software. Also we don't promise to safely store your crabby patty recipe (or other super secret secrets).
The good thing is that an attack would only possible for someone with both write access to that file and insider knowledge (though that can be gained by user of the software fairly easily with some knowledge of SQL).
Well, so much for logging off early on Friday.5 -
Got asked: Could you add more columns to this Word document?
Me: *Checks* *Sees it's all tabbed, not a table* Um. No. -
WHY THE FUCK ISN'T THERE AN OPTION TO QUICKLY JUST FUCKING PRINT A TABLE IN PHP???!!!!
I DON'T WANT TO SIT AND WRITE 50 MORE LINES FOR YOU TO DO SUCH A SIMPLE TASK.
I WANT TO JUST "SELECT * FROM BLABAL" AND PRINT THAT FUCKER IS IT THAT HARD EH?26 -
When your supposedly Senior PHP developer argues with you that an HTML table can't be nested inside another HTML table 😱2
-
If having a coffee in the morning doesn't wake you up, try deleting a collection or table in a production database instead.4
-
Needed to update one column in table A with data from table B (huge table).
Created awesome update query with join between the two tables.
A few hours later realized all data in table A is already being imported from table B in a query executed earlier in the process... -
Yesterday I helped in a college final project. To be done using PHP and MySQL.
- they were taught to create a login page and when submitted just check the values against username and password from DB table and redirect to a dashboard page. No session created.
- in the dashboard, session is not checked. Shows links to other pages.
- each page is a separate php file
- the app allows users to issue books to customers. They were taught to delete the book from book table and save all the info in issue table, when a book is issued
- when a book is returned, book info is saved in a return table and also saved to book table again and deleted from issue table
I asked this student to change it to the right way, to use sessions and includes. He said that then the lecturer would know, he didn't do the project. It's a diploma level course.2 -
STOOOOP TELLING ME THE TABLE DOESN'T EXIST. YOU'RE FUCKING SUPPOSED TO CREATE THE DAMN TABLE NOT TELL ME IT DOESN'T EXIST! YOU FUCKING DID IT AT HOME ON MY DESKTOP SO WHY DO YOU DO THIS TO MEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEeeAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
5 -
What keeps programmers interested in programming? Does solving new problems always stimulate your dev soul as much as it used to, or are we all doomed to find our jobs uninteresting after a short while?7
-
Share your desk!
This is 80% of time my desk, besides this kitchen (also living room) table.
I can sit here for eight hours straight without standing up. No, I don't have any back issues or smth.
I wonder how your workplace looks like
47 -
I was minding my own business, fixing merge conflicts for my project lead when it struck.
There, in the middle of a React.js component, was a table, used not for displaying data, no, but for styling a form, which was not a form, but a series of table rows.
I feel sick -
When you get to work with the Analytics side if the warehouse and one of the guys wants you to learn d3. Js to take a csv to make a html site.
Me: hell Yeah can't wait to make crazy circle graphs and line graphs for everyone in analytics
Analytics: Oh, we just need you to take the csv files and copy the same excel format to a html site. So, table, table, table, table.
Me: so...... No visualization graph
Analytics: No.
4 -
A full 4 level page table on x86_64 is over around 687 GB in size. Allocating it fixed size obviously won't work...
So now when allocating virtual memory pages for an address space I sooner or later have to allocate one page to hold a new page table... which has to be referenced by the global page table for me to use... where there isn't any more space... which is exactly the reason we allocated a new page in the first place... so I'm fucked basically8 -
My boss thinks database = table
I hope it doesn't bring problems in the long run.
Any "web dev for CEOs" material you recommend?5 -
Oh no.
CalDAV server and client use the same DB table. Server expects a column to be called uri, client expects column to be called url.
FFFFUUUUUU9 -
Accidentally drop a column of a table and without realising that take is in production,..... luckily I have backup....
-
I've just bought a new table, I think that's the best thing anyone without a proper table can do.
25 € and solid wood, I hope it lasts forever.8 -
3 Database SQL walked into a NOSQL bar.
A little while later, they walked out...
Because they couldn't find a table.1 -
Manager tweaks with some data on the production server and accidentally deletes some rows.
*flip table* *rage*2 -
We have a three bedroom house that fits us perfectly, or did anyway. In the upstairs there is a master bedroom which my wife and I share, and two smaller bedrooms. One is my son's room and was his nursery when he was smaller, and the other is currently being used as my office.
We had a second child-- a little girl --in October. As she is still very small, she sleeps in a bassinet in our bedroom, but those days are numbered. She will need her own room within a couple months, for naps and for her to sleep all night on her own. That means my office will soon have a crib, dresser, and changing table in it, and I will be unable to use my computer after the wife and kids are in bed.
For this eventuality, I've been preparing what I call my, "table kit." Costco sells these really nice collapsible plastic crates. I have filled one with computer things, with the intention being that when my office is not available to me, I have a crate with everything I need in it, and can quickly set up at the dinner table. When I'm done, I can quickly tear down and pack everything up into that collapsible crate, so none of my equipment will "live" at the table.
My question is: what would you put in your table kit? I currently have a System76 Oryx Pro, a 23" LED display, displayport cable, power cables, mouse, keyboard, microUSB, and type-C cable, Bluetooth headphones, and I'm trying to decide whether I'll need a laptop stand. What would you pack?5 -
RESTful API Question
Let's say when a user do an action, I need to insert a record into a table and then update a record in different table.
Should I write two API routes (PUT, POST) or one route (POST) ?18 -
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.7 -
So here I am trying to understand the database schema in order to write a REST interface. Then I find that one of the tables contains an id and a name columns but the name is Integer not a string!
I contacted the developer who gladly explained that it was easier for them to store the ids in the database but the actual names strings were hard coded in the source files so they can handle translations!
-
Him: i get this error when i insert into table, ForeignKey_contraint failed, what can i do?
Me: you have to obey the constraint, make sure it exists in the other table first
Him: ok i did that but i still get ForeignKey constraint error
Me: yeah that table has a couple foreign keys
Him: could you give me a very specific example how to insert into this table
Me: ........ here is a command to remove constraints on the table
Him: thanks, that fixed it!
I am helping a programmer who works with Costco integrate to software my company sells. I don't have source code, just an understanding of the database and what the software does. If he is getting paid more than me, then I should get a job there and ask for double, I could easily work 10 times faster than this buffoon. -
man, those hours.... some god, please kill the bastard responsible for this shit...
(
in the picture is like:
weight: beautician
occupation: "" --empty string
)
1 -
If having a coffee in the morning doesn't wake you up, try deleting a table in a production database instead.1
-
I’m either going crazy or someone just dropped a table from a database I’m actively working in. I don’t have a drop script for any tables in my code, not anywhere. One moment it’s right there, the next it’s gone? Luckily it’s pretty much empty, only generic data. On my way to check permissions.6
-
Today, carrying my dinner to a table in our universities cafeteria, I passed by the table of a professor. He had a book on his table titled "Hacking Handbook". It contains chapters on httrack, ping, port scans and the like (I checked that on Amazon).
The professor drank a coffee, then got up to get some food. His table was directly next to the wall separating the food corner from the tables. He stayed away from his computer for two or three minutes. Both table and computer where totally out of his field of vision during that time. His computer was not locked and Outlook was open.
The professor teaches IT security.5 -
TIFU by running DELETE-INSERT on a live server and losing thousands of rows from a separate table. 🤤
TIL If you delete data from indexed table, it will affect any linked tables. I think. Fml. 🤕
At least it was a learning experience for all of us. Hopefully if I keep repeating it enough it will become true...3 -
<b>Issue #19: Kicker Table physics engine</b>
CEO: Physics engine is weird, please fix
Me: *levels table* Physics engine calibrated, needs further testing. -
I do a lot of linguistic side projects, and got tired of rebuilding the languages table, so I did a bit of looking around today and put together a MySQL table dump with all of the the codes from ISO 639-1, 2, and 3.
If anyone's interested, here's the link. Enjoy!
https://github.com/Kaji01/... -
We all have height adjustable table at work. So we decided to raise a coworkers table, and install an airhorn under the table to go off as soon he would lower the table. Lets just say he did need coffee that morning!
-
How to destroy all table data:
* Get a database;
* Add the first table;
* Add the second table;
* Create a foreign key in second table that delete a record where there is a delete in the first table;
* Update all data in the first table with a REPLACE command.
Miracle: all data is lost5 -
Truncated a database of around 14 million records today... Had 2 minutes of silence after it with my buddies @hahaha1234 and @papierbouwer1
-
When updating nuget packages takes longer than cloning, configuring and compiling the Linux kernel...
while(true)
bang(head, table);3 -
Took over a project where a dev created a table with no primary key and enforce a unique constraint in code. Wtf? He also always selected top 1 so if you added a record directly in the table it completely fucked the expected data.
So, when I took this piece of shit over I didn't realize what the table was and when I tried to convert it to EF it barfed since there was no PK. Was a complete PITA and had to create all new tables.
Some people shouldn't develop software!!!!!!!!! -
So in Ruby, everything is passed to functions by value. However, when you manipulate objects, you're actually manipulating references. A simple example:
```
a = [3]
b = a
c = a
b.push(2)
print a
print b
print c
# => [3, 2][3, 2][3, 2]
```
Here's a more complicated example from the problem I was solving:
```
table = Array.new(5) { Array.new() }
1.upto(5 - 1) do |i|
1.upto(5 - 1) do |j|
table[i] = table[j]
end
table[i] << rand(1..6)
end
```
I have been running around in circles this morning because I forgot that. This makes C++ for example, more clear than Ruby since C++ explicitly shows the intent to the programmer.5 -
Something very interesting today
I worked on an API feature and it was approved and merge to the stable copy of the project. But then comes the demo.
Now we used Heroku(this devil)
The database uses sqlite. I can register an account on the web application. But the user table has only the admin account even though i have successfully managed to register.
I dont know what sorcery this was!
I simply went with the saying "it is working on my local machine"
Only to realise minutes to the demo the build pack was not done well at the beginning...
What is life... -
Styling Newsletters is like time travel..time travel in a retarded past that doesnt knew what beauty modern css is, also fuck your sincerly MS Outlook for being a propritary cunt.
display:block will not work for MS Outlook, cause, well reasons.3 -
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 -
Lately in school...
I was on devRant and saw that someone posted he had a table drop during prod. And at that time I didn't know what a table drop was so I assumed he dropped his laptop. Then a friend of mine corrected me. Facepalm of my life. -
When a junior develops an API call which return the user information and there is session_key and password encrypted in it too.
Dude! do you even know some basic security ! Please don't just Select * From table join table only !3 -
When your project manager promised to give you a script generator for the big database migration and came back with an Excel sheet where you have to copy-paste every table name and fields to get the table specific part of the script.
Damn copy-pasting programmation ... -
Just got a new laptop table with a cooling fan. Now watching an Isaac Arthur video before drifting off to sleep, with cozy pillows, a nice blanket, and the laptop on the aforementioned table above my legs.
I feel like a Metapod.
:)
1 -
Legacy app using jQuery to attach event listeners to table rows just to change the background color. That's gross, even for legacy.
-
when you view the source of a page and you see the whole damn content stuffed in a <table>...
WHY?!!5 -
I thought I had seen some poorly named fields in tables. Then I discovered this Microsoft documentation for a table in SharePoint: https://msdn.microsoft.com/en-us/...1
-
Mfw the CREATE TABLE statements in the SQLite database handler of my latest android app run perfectly first time
-
Our company going full magento, and i fucking hate that shit... My table is besides the window and I'm gonna use it3
-
I sit right behind the board games table. While it was nice that my company provides games and doesn't mind us playing for destressing, my colleagues played and laughed so loud at the table that sometimes they distracted my work discussions with the other colleagues. Usually when this happens I'll just join them.
-
He said that table structure is not final and it may change.. So I start thinking possible solutions for tables with dynamic columns. A week later, he comes and tell me how they decided to change structure so i have to **add these 3 rows** on table.
Well............. -
The logic in a method reflected a truth table not obvious to understand. The first time I implemented tests for coverage as I didn't trust anybody to remember and understand the logic after a few weeks.1
-
Tutorial for a great Excel export function for your Webapp:
1. Search a Javascript enhanced html table control which supports exports to Excel
2. Use that Control and fill in every Request Data into it
3. Hide the entire Table except the Export Button -
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
-
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 *. -
Today I have practically learned the concept of geometric progression. A db table of 5 Gb now it's 500 Mb.3
-
Pulled into a meeting because a search didn't create a new table record for any result NOT found. Apparently, the user wanted dummy results to fill the table if what he searched for wasn't found.... And it was suppose to have nearly every column say "RECORD NOT FOUND". Just.... Why....
-
Today we trunkated a table with 15 milion keywords for our search engine. It did feel very scary... With @Jappe and @hahaha1234
-
Let's play Russian roulette Developer version?
Let's write a PHP script to randomly drop a table in your database.... Hahahahahw2 -
Apparently, while SQLite will happily let you write recursive common table expressions, it won't let you write MUTUALLY recursive common table expressions. This doesn't seem to be documented although I suppose you could infer it from the section I didn't read on how they work internally. Such a shame that I can't do this good and useful thing which I have good applications for.2
-
I thought the web standards finally are a bit okay to work with. Just learnt that writing responsive HTML email templates really really feels like writing code which we did in the previous century. Tables. Tables everywhere. It's worse than table inception5
-
Saw another post about a receipt with an exception and it reminded me of this...
"Yes, I'm sitting at Table 0"
-
Logic of my company:
Why have an auto incremental ID for the table when you can have another table where you have to retrieve the last registered id, add 1 to it, then update the register of the last ID, then retrieve the id and finally create the register you intended.
Justification: “It’s a good practice”
FML1 -
Tried installing Arch the whole day... Always crashing at the booting sequence due to nouveau failure. "Pointer to TDMS table invalid" and "Pointer to flat panel table invalid"... Can't even login into the shell.
Fuck this shit... Has anyone tried Devuan? -
I'm going to be making a table library (think DataTables)
So for those web dev gurus, should I render the data to a basic <table> or should I use CSS grids?
IE compatibility is not a consideration.
The table will also support grouping (pivot table) so something like rowspan will be a must11 -
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 -
I always forget it's a bad idea to run queries in an "edit table" view in SSMS. Just blew up my table cause it decided to add an unwanted cross join in my update statement.
Ran it in a fresh query window and it worked fine. -
If you edit a column in a table in SQL Developer GUI you can loose your primary key in that table, even if you didnt touch the primary key column.
How fun is that?2 -
Hey guys, need help from some web devs. I have few stores and I coded a php/html table for reporting purposes. I don't like that table, also its not responsive on mobile phone. Any advice how could I change the layout up?
14 -
What do you think of the Database design of Drupal/WordPress? They use 2 tables for 85% of the data!! Product, pages, whatever are all stored in the same 2 tables. Does that work out better than having each content type in separate tables?
I'm thinking of making an ERP. Would that table structure work there?2 -
The bugs that make you think are the best/worst.
Had a ghost foreign key constraint from a dropped table. Cant drop it from a non existant table.
Turns out the dev copied a file for the new table and since you can technically name those foreign keys anything you want, there were no errors when he ran it.
Also sloppy/overworked dev teammates are the worst...
Also I'm pretty sure rule 2 of programming is "Never Copy and Paste" -
Angular test for a company: they are asking me to implement a filter on a table using rxjs. Me, no real rxjs experience, set up complete new page, new table with angular material and a working filter. Lol, ductape solution successful!3
-
MySQL tables named haphazardly, table column names in mixed cases, redundant columns and tables, the horror
-
String sql = "DELETE FROM TABLE ";
conn.ExecUpd(sql + request.getParameter("recordNumberParam"), true); -
Today, I saw a table mean to store tags designed horizontally, each column store a tag with value 1 or 0. 🤦🏻♂️
-
Not really a programming rant, but how fucking hard is it to spell someone's name in an email correctly. There is no single key for 'ph' and if there were it would be no where near the letter 'V'. But then again I'm just trying to help you out with your simple SQL script which you can't find out why you're not inserting data and you're only the director of informatics. And your script is horrendous with multiple joins which are unnecessary. Create one source table instead of 4 inserts from one table and use one insert from one table ya idiot.
-
For the IT guy, the desktop is the monitor, the coffee table is the system unit, and the keyboard is the dining room table.👩🍳
-
Fvck! I can't add primary not null autoincrement in existing table on sqlite! Waste hours trying! Damn.1
-
Unity Controller Support:
Why are controllers awful, it seems like I have to custom each different controller manually to the game. Why can't the the A button on one controller be A on all controllers.
Why can't there be a universal built in controller script that would convert all of the different types controller inputs into a generic controller input that can be translated by just one script instead of writing a script for every common controller... 😠3 -
have you ever experienced this in postgresql? Remove unique constraint in table, end up remove all data on table. My friend experience this issue this morning. Is it possible? or due my friend clumsiness?4
-
oh dear the stocktaking i did (maybe am still doing? don't know whether it's done yet🤷) with my dad for his little shop😩
his pc/office skills had begun with microsoft excel (he taught me how to use a pc all together) ... and have stopped there. Excel for almost everything. To be fair, he uses PCs like a normal user and isn't of that metier, ok fine🤷.
but when i saw the table he uses, which he copied over the years from the previous versions (still ok), i quickly found out that his table entries were written by him FOR HIM. it was very hard for me to help him (he tells me the article he sees in his storage, i have to include, so i look it up in the table and do stuff) as he had nicknames for his articles that only he associated with😐.
next he prints out a list a company has given to him where he buys some products from, which is ordered by id number ... my dad works with the correspnding names instead so of course all product names are random😑, so every time i need a price for an article he has to scan every list item. you've guessed it, n² search😪😒.
i tell him multiple times to call the company and send him a list in alphabetical order but he refuses as "we've almost finished" ... 🙄 (i'm not allowed to ask for him, as the company will only talk with the responsible one😑)
so I'm tied to a pc, talking to my dad over phone, who has to walk around and has to help me very often to find the article he's meaning to, at the end, do a n² search to add all the prices....😩
I absolutely want to help him automate things for sanity's sake🤔😅
install databases, connect via internet, connect to companies databases for up-to-date prices etc., make some desktop/web app/i don't know for fast access and boom...
and i don't even know where to start and where to find the time for it and whether it's even all possible😅🤔😐🤷 -
Before each release of Exoplayer, the developers sit at a round table and randomly pick at least 50 APIs to deprecate.
-
I know the ascii table values of lowercase and uppercase alphabet letters. I don't know whether to be proud or ashamed.
-
Having trouble getting CSS to apply to a table in react. Thought I'd ask here. You guys are probably better than SO. Please and thank you
https://stackoverflow.com/questions...7 -
Hey database experts. MySql question:
I have a table with houses, there is the location, color, etc. Shall I make a column for the owner or make a separate table HouseToOwner - where I connect the id's? I have no idea why is it good practice but saw it in few cases. I have the same with the things inside like I would just make a boolean column for a TV-like haveTV - true/false. Tell me why to not fill everything in one table. thx17 -
I have table assets with field person of contact and table contacts with all fields related where I want to extract Join the [First Name] and [Last Name] and Capture as [Person of Contact] from [ID] related to each customer I want to list the person of contacts! I am so new into this world teach me <SQL>
Top Tags
Weekly Rant
View