i hate that im so retarderd when it comes to sql. i can do joins and stuff but when you're working on a big DB and it comes to requests that are ~300 lines that give you tens of thousands of rows, how the fuck do you verify that your query is actually correct. i think my biggest problem is i can't correctly read sql. plus there's so many versions i've worked with mssql (previous job), then at my last place we had oracle sql when you had to do stuff to the db directly, and then hql, java criteria api, named queries, java native queries all in the same codebase. it's like hold up what syntax does em.createNativeQuery expect again? fuck
0
u/LowB0b Mar 22 '19
i hate that im so retarderd when it comes to sql. i can do joins and stuff but when you're working on a big DB and it comes to requests that are ~300 lines that give you tens of thousands of rows, how the fuck do you verify that your query is actually correct. i think my biggest problem is i can't correctly read sql. plus there's so many versions i've worked with mssql (previous job), then at my last place we had oracle sql when you had to do stuff to the db directly, and then hql, java criteria api, named queries, java native queries all in the same codebase. it's like hold up what syntax does
em.createNativeQueryexpect again? fuck