|
yes, follow the advice of an idiot programmer
|
# ? Jul 20, 2013 20:41 |
|
|
# ? Jun 5, 2024 03:23 |
|
He's not wrong about statement mappings
|
# ? Jul 20, 2013 20:45 |
|
same, except do everything using stored procs and transparently bind them to Java interfaces using proxy objects maybe also use SQL views and some limited WHERE and ORDER BY generation to sort and filter those if you need a sortable and filterable report table thing every now and again
|
# ? Jul 20, 2013 20:55 |
|
developers are idiots who can't be trusted running queries against a db so you should always provide nice padded views for them to bang their head against
|
# ? Jul 20, 2013 20:57 |
|
if your data is at all useable by base tables either its trivial or you aren't normalized properly
|
# ? Jul 20, 2013 20:58 |
|
Just use excel you dringus
|
# ? Jul 20, 2013 21:10 |
|
just store everything in memory as a hash table or array or linked list or whatever
|
# ? Jul 20, 2013 21:12 |
|
Plus bits of stored procs are super easy to copy and paste into other stored procs when you need to compose parts of queries that share the same logic.
|
# ? Jul 20, 2013 22:09 |
|
polpotpi posted:if your data is at all useable by base tables either its trivial or you aren't normalized properly time to masturbate endlessly over third normal form "Hentai website running at optimal performance" says Miku-chan, my database monitoring script tells me sexily
|
# ? Jul 21, 2013 01:00 |
|
Socracheese posted:in django i make my db be compatible with the orm and i use it when its easy like that's like super scrub because you don't know how to use the orm, which is pretty easy to use.
|
# ? Jul 21, 2013 01:14 |
|
orm's that don't let you write your own sql are cool
|
# ? Jul 21, 2013 02:11 |
|
most of the orms I know let you write your own sql if you really wanna.
|
# ? Jul 21, 2013 03:33 |
|
writing your own sql is as stupid as writing your own encryption/hashing
|
# ? Jul 21, 2013 03:36 |
|
chumpchous posted:writing your own sql is as stupid as writing your own encryption/hashing lol what is best in life to see your orm do stuff for you, but write sql when you need it
|
# ? Jul 21, 2013 03:40 |
|
orms write bad sql so you don't have to
|
# ? Jul 21, 2013 04:25 |
|
chumpchous posted:writing your own sql is as stupid as writing your own encryption/hashing but less stupid than the number of people who think this unironically
|
# ? Jul 21, 2013 04:42 |
|
What if we could learn what orms are doing internally and then leverage them only when they provide benefit Whoa
|
# ? Jul 21, 2013 05:07 |
|
Gazpacho posted:What if we could learn That's a pretty impossible task right there for your average developer
|
# ? Jul 21, 2013 05:23 |
|
Shaggar posted:orms write bad sql so you don't have to shaggar was right
|
# ? Jul 21, 2013 06:59 |
|
Shaggar posted:orms write bad sql so you don't have to ain't no sql wizard can improve SELECT * FROM poo poo WHERE gloppiness = 'NOTMUCH'
|
# ? Jul 21, 2013 07:54 |
programming is dumb and a waste of time and the less work you have to do to get it over with the better who cares about efficiency, just throw more hardware at it
|
|
# ? Jul 21, 2013 08:53 |
|
gucci void main posted:programming is dumb and a waste of time and the less work you have to do to get it over with the better i would love to throw hardware at you
|
# ? Jul 21, 2013 09:27 |
|
Shaggar posted:orms write bad sql so you don't have to i just faced up to the fact that i'm gonna be writing bad sql no matter what. might as well do it in 1/8 as many keystrokes
|
# ? Jul 21, 2013 09:34 |
|
chumpchous posted:i just faced up to the fact that i'm gonna be writing bad sql no matter what. might as well do it in 1/8 as many keystrokes this
|
# ? Jul 21, 2013 09:41 |
|
Stringent posted:i would love to throw hardware at you
|
# ? Jul 21, 2013 10:21 |
|
How do I ORM a window function?
|
# ? Jul 21, 2013 11:10 |
|
Java code:
|
# ? Jul 22, 2013 04:17 |
|
HORATIO HORNBLOWER posted:
the other day i ran into some code that used singletons for all of its exceptions
|
# ? Jul 22, 2013 04:22 |
|
here's another fun oneJava code:
|
# ? Jul 22, 2013 19:39 |
|
lol
|
# ? Jul 22, 2013 19:45 |
|
Stringent posted:i would love to throw hardware at you lol
|
# ? Jul 22, 2013 20:07 |
|
HORATIO HORNBLOWER posted:here's another fun one I've seen that poo poo sandwich before Unfortunately I think it's the only way to do it without re-factoring the entire method, and since no one wants to do it they just keep piling on more poo poo in the stupid exception handler
|
# ? Jul 22, 2013 20:09 |
|
this practice of programming book is v. good. thank you
|
# ? Jul 23, 2013 00:56 |
|
Hard NOP Life posted:I've seen that poo poo sandwich before at the very least pass thrown into the new lovely exception so you don't suppress all the useful information about what actually went wrong jesus christ
|
# ? Jul 23, 2013 05:04 |
|
HORATIO HORNBLOWER posted:here's another fun one if only java had checked exceptions this never would have happened
|
# ? Jul 23, 2013 06:32 |
|
chumpchous posted:this practice of programming book is v. good. thank you
|
# ? Jul 23, 2013 09:42 |
|
yaoi prophet posted:the other day i ran into some code that used singletons for all of its exceptions I bet they prevent stale stacktraces from being logged by always calling fillInStackTrace() right before throwing their exception
|
# ? Jul 23, 2013 12:30 |
|
yaoi prophet posted:the other day i ran into some code that used singletons for all of its exceptions this is acceptable if you're using them for non-local return (although Im not sure how threadsafe that is?)
|
# ? Jul 23, 2013 16:28 |
|
Sang- posted:this is acceptable if you're using them for non-local return (although Im not sure how threadsafe that is?) who cares you already hosed the dog by throwing an exception to jump up the stack
|
# ? Jul 23, 2013 16:35 |
|
|
# ? Jun 5, 2024 03:23 |
|
chumpchous posted:this practice of programming book is v. good. thank you yeah, just finished reading through it last night. a few parts of it are humorously dated, one or two things I disagree with (e.g. their recommendation to use cross-platform graphics frameworks, ala java or tcl/tk, to make your program portable - though that's also probably in the 'dated' bucket), but most of it is really good solid programtips. v. smart dog, commendable.
|
# ? Jul 23, 2013 17:01 |