Learn More
Resend Email
56
DRHAX34
7y

Generating SQL scripts using Excel. That's the practice at my company.

undefined

fml

really

im doing fine

no errors at all
Favorite
Ranter
Comments
  • 0
    7y
    My colleagues do this, i template a string in python and interpolate with data :D
  • 0
    7y
    What is their reason for using Excel?
  • 0
    7y
    @Jumpshot44 ID's aren't automatic, so in Excel they save the latest ID introduced in the db, and then they insert the values of the fields. also, the excel has a page for each db table. you can imagine how much pages there are.
  • 1
    7y
    I used to build complete "apps" in excell or access, just because the company policy did not allow our department to get a server.. no even a damned database somewhere so access had to do.
  • 2
    7y
    You Won't Believe What These Programmers Did When Their Employers Wouldn't Allow Them Their Basic Tools!

    Number 8 Surprised Me!
  • 1
    7y
    Wow that's horrible. Even when I need to run a stored procedure against a bunch of tables with random names stored in the database I do so dynamically. Using excel for stuff would hurt my soul.
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment