|
Jonny 290 posted:hey cool so i learned how to do sql queries today it isn't but you shouldn't be writing them
|
# ? Jul 23, 2012 21:26 |
|
|
# ? May 9, 2024 20:34 |
|
Jonny 290 posted:hey cool so i learned how to do sql queries today
|
# ? Jul 23, 2012 21:27 |
|
is this where all that orm poo poo comes in or something
|
# ? Jul 23, 2012 21:28 |
|
yah in an ideal situation you shouldn't be typing raw sql in your code
|
# ? Jul 23, 2012 21:29 |
|
Jonny 290 posted:hey cool so i learned how to do sql queries today
|
# ? Jul 23, 2012 21:33 |
|
ive only been a dev proper for like 5 weeks this ship moves SLOW
|
# ? Jul 23, 2012 21:34 |
|
select * from employees where billablehours >= 40 (0 rows(s) affected)
|
# ? Jul 23, 2012 21:35 |
|
Jonny 290 posted:ive only been a dev proper for like 5 weeks some people never learn sql sql is fine. for some reason, people would rather write queries in chained object notation, translate them to some crack addled sql
|
# ? Jul 23, 2012 21:36 |
|
tef posted:some people never learn sql big strings of sql in the middle of a different language are ugly and stored procedures are make-work for the local DBA union
|
# ? Jul 23, 2012 21:38 |
|
BonzoESC posted:big strings of sql in the middle of a different language are ugly and stored procedures are make-work for the local DBA union in the same way html templates are make-work for the local web union?
|
# ? Jul 23, 2012 21:42 |
|
regular expressions in a language? sure queries in a language OH GOD WHAT ARE YOU DOING THAT'S UGLY most languages have other little languages embedded inside of them, frequently regular expressions and string formatting rules
|
# ? Jul 23, 2012 21:44 |
|
i dunno if its just me or what but most non trivial queries i write in an ORM are translated to hideous poo poo when im tracing my db
|
# ? Jul 23, 2012 21:50 |
|
tinselt0wn posted:i write...hideous poo poo
|
# ? Jul 23, 2012 21:51 |
|
stored procs are ftw and a good dba is worth more than 10000 web "developers".
|
# ? Jul 23, 2012 21:52 |
|
gently caress it, just do it all with tie::file::hashify
|
# ? Jul 23, 2012 21:53 |
|
i wish sql natural joins had mainstream support then devs would quit bitching about how much work it is to write a query and dumb devs would start using foreign keys like they already should be also linq does it right and let's you define things in the one true order - tables first then the rest and lastly columns orms are good but you still gotta normalize your tables and i've seen a lot of "code first" projects with absolute poo poo design in the db so i say make your tables, map to them with your orm, and optimize the bottlenecks with raw sql (preferably sprocs imho) tef posted:sql is fine. for some reason, people would rather write queries in chained object notation, translate them to some crack addled sql chained object notation? like Table1.Child1.AllItems(x=>x.Something=='foo')? tef posted:regular expressions in a language? sure true i think lots of sql hate is b/c devs don't like magic strings with potential bugs that aren't caught until runtime. less of an issue if you automate all your testing though i like linq it's expressive but translates pretty much 1:1 to good sql, maybe i should give entity framework the ol' college try it uses linq instead of some awful HQL-alike
|
# ? Jul 23, 2012 21:56 |
|
Arnold Yabenson posted:
this but statement mapping instead of object mapping
|
# ? Jul 23, 2012 21:57 |
|
Arnold Yabenson posted:chained object notation? like Table1.Child1.AllItems(x=>x.Something=='foo')? current_user.messages.limit(5) # => SELECT "messages".* from "messages" WHERE "messages"."user_id" = 888 LIMIT 5 Post.joins(:user).where(thread_id: 3481275).limit(40).offset(120) # => SELECT "posts".* FROM "posts" INNER JOIN "users" ON "users"."id" = "posts"."user_id" WHERE "posts"."thread_id" = 3481275 LIMIT 40 OFFSET 120 This does neat little tricks like allowing partial queries to be composed and built up: code:
tef posted:in the same way html templates are make-work for the local web union? tef posted:regular expressions in a language? sure How would you adapt LINQ to Cassandra? Neo4j? There's only one kind of string, there are many kinds of database.
|
# ? Jul 23, 2012 23:09 |
|
BonzoESC posted:This does neat little tricks like allowing partial queries to be composed and built quote:HTML slicers don't cost much money to hire and don't pay union dues to Oracle. quote:Strings are seen as a primitive data type in good languages, so why not include a language to query them and a language to build them? * Do not add SQL query literals, SQL is an awful language. I long for datalog.
|
# ? Jul 23, 2012 23:30 |
|
Zombywuf posted:That's nice, how do you do pivots and window functions? Dunno, never done OLAP but i presume ORMs are bad at it.
|
# ? Jul 23, 2012 23:38 |
|
|
# ? Jul 23, 2012 23:40 |
|
can someone explain to me why javascript is the base language of the web, how did this happen and why didn't someone write something more like a bytecode for the web instead tia
|
# ? Jul 23, 2012 23:48 |
|
Sweeper posted:can someone explain to me why javascript is the base language of the web, how did this happen and why didn't someone write something more like a bytecode for the web instead tia netscape
|
# ? Jul 23, 2012 23:50 |
|
Sweeper posted:can someone explain to me why javascript is the base language of the web, how did this happen and why didn't someone write something more like a bytecode for the web instead tia because the web was basically never intended to do anything more complicated than show you a page of information and links to other pages with information on them and everything that we do now is based on layers of hacks also see: computing in general
|
# ? Jul 23, 2012 23:51 |
|
orms are an attempt to solve an unsolvable problem. use the most lightweight implementation of activerecord for your language you can find and write your own drat sql for anything complicated. sql is easy, sql that doesn't make the server poo poo its pants under load is less so
|
# ? Jul 23, 2012 23:58 |
|
Sweeper posted:can someone explain to me why javascript is the base language of the web, how did this happen and why didn't someone write something more like a bytecode for the web instead tia microsoft stopped innovating on the web after ie6 and it allowed podunk shitbrowsers to encourage bad developers to abuse javascript to do more than it was designed for. open sores cant make good things, they can only steal existing ideas so instead of writing a good standard they piled crap onto html/js xaml is the current peak of UI development tech and html/js will probably get there in another 10 years
|
# ? Jul 24, 2012 00:00 |
|
There's only 2 rules of sql. Don't grab more than 1000 at a time. Don't do sql "calculus", conversely join only on indexes. Also javascript is a fine language. It has everything you need to write good programs from scratch. The trouble comes in when your base is coming from someone else who probably never wrote a line of any other language in their life. This problem is shared with others, but javascript wades into the domain of Normals much more than the spergier languages. MeruFM fucked around with this message at 00:12 on Jul 24, 2012 |
# ? Jul 24, 2012 00:08 |
|
Sweeper posted:can someone explain to me why javascript is the base language of the web, how did this happen and why didn't someone write something more like a bytecode for the web instead tia
|
# ? Jul 24, 2012 00:21 |
|
this thread is so bad
|
# ? Jul 24, 2012 00:24 |
|
dazjw posted:i hear rakuten's nice although rumour has it you need a good TOEIC score these days. ganbatte. just shot tea out my nose onto my laptop. i'll be sending you the bill.
|
# ? Jul 24, 2012 00:28 |
|
The best part of SQL is that if you experience significant growth, what once was good SQL becomes bad SQL. It's like a can of spam under a radiator, fine for months but then suddenly rancid. I also nominate dazjw for a medal of honor for that post!
|
# ? Jul 24, 2012 00:51 |
|
Meiwaku posted:The best part of SQL is that if you experience significant growth, what once was good SQL becomes bad SQL. It's like a can of spam under a radiator, fine for months but then suddenly rancid. uh same prob with any poorly written code that isn't written to scale up if u have this problem a lot maybe your idea of good sql is wrong???
|
# ? Jul 24, 2012 01:12 |
|
procs come in super handy when you realize ur data design has a prob cause you can swap the design around and not change any application code cause the proc signature doesnt change
|
# ? Jul 24, 2012 01:19 |
|
this is why perl owns http://www.gnaa.eu/browser/trollforge/unsorted/jenk/Time/Cubic.pm?rev=606
|
# ? Jul 24, 2012 01:22 |
Jonny 290 posted:this is why perl owns return JEWS;
|
|
# ? Jul 24, 2012 01:27 |
|
I keep thinking that one of these days there'll be an OOP anti-fad and we can all get that nonsense behind us but nope, 30 years in and here we are. Still, we are at least kinda sorta coming around to the idea that C++ is a Bad Programming Language, so there may be some hope yet.
|
# ? Jul 24, 2012 16:21 |
|
Eight years later, Luciani has finally landed an interview—and a very public one at that. She is one of four applicants-cum-contestants vying for a blue badge on Be the Next Microsoft Employee, a new reality show that is seeking a SQL Server expert to join Microsoft IT. The first episode premiers today, and the online series will run for the next four weeks. In each episode, contestants face a technical challenge based on Microsoft Certification exams. The winner of the show—and the next Microsoft employee—will be revealed August 21 during the finale. "The concept is more or less 'Top Chef' for geeks," said Mark Protus, senior audience marketing manager for Microsoft Learning and creator of Be the Next. Protus came up with the idea as he pondered ways to show the impact that training and certification can have on a career.
|
# ? Jul 24, 2012 17:52 |
|
im the cum-contestant
|
# ? Jul 24, 2012 18:54 |
|
ive been playing about with clojure recently and am wondering about using compojure to make websites. it seems fairly decent. however the only reasonable* way to deploy a compujure site into production seems to be to make a war using leiningen and use something like jetty or tomcat. this strikes me as some horrific enterprise level java horseshit. is this really the price i pay for using compojure or is there a better way. or is the current state of java servlets and things not as bad as i remember? * ie not some poo poo that wont even survive a reboot, jesus christ some of the blogs ive read over the last couple of days,
|
# ? Jul 24, 2012 19:05 |
|
|
# ? May 9, 2024 20:34 |
|
servlets have always been awesome and tomcat is fantastic. the only people who think otherwise are complete morons
|
# ? Jul 24, 2012 19:06 |