|
if it interfaces with the db, it is db code. put the entire application in the database
|
# ? Nov 21, 2014 17:45 |
|
|
# ? May 10, 2024 01:00 |
|
i don't know anything about stored procedures
|
# ? Nov 21, 2014 17:54 |
|
our databases don't appear to have any though??
|
# ? Nov 21, 2014 18:02 |
|
Object Relational Manager's ftw
|
# ? Nov 21, 2014 18:08 |
|
it's just a sql query that you save and then instead of writing "select * from Butts" you can call it like "getAllButts" obv you usually do this with slightly more complex queries and pass in parameters just like a function call
|
# ? Nov 21, 2014 18:09 |
|
because it is part of the database schema, not part of your application.
|
# ? Nov 21, 2014 18:17 |
|
Elder Postsman posted:our databases don't appear to have any though?? fail
|
# ? Nov 21, 2014 18:17 |
|
stored procs are a translation layer between your application and the database. they are dependent on the database, not on the application so they belong in the database.
|
# ? Nov 21, 2014 18:18 |
|
Django handles it really well
|
# ? Nov 21, 2014 18:21 |
|
Bloody posted:getting them into and out of the database is such a mess *gentle chuckle* Shaggar posted:database code belongs in the database, not in your application. yeah but if it's code that generates an object for your application it's not purely database code and doesn't necessarily belong only in the database
|
# ? Nov 21, 2014 18:21 |
|
yes it does because it cant exist outside the database. like you cant move the sql to another db server and have it work unless all the other schema comes with it.
|
# ? Nov 21, 2014 18:28 |
|
Plastic Snake posted:it's just a sql query that you save and then instead of writing "select * from Butts" you can call it like "getAllButts" thanks for this helpful and informative post.
|
# ? Nov 21, 2014 18:57 |
|
Shaggar posted:fail we are moving away from mysql to sqlserver and uh either mongo (ugh) or cassandra (???) so that will prob change
|
# ? Nov 21, 2014 18:58 |
|
procs arent common in mysql cause amateur databases breed amateur designs
|
# ? Nov 21, 2014 19:00 |
|
Elder Postsman posted:mongo lol
|
# ? Nov 21, 2014 19:07 |
|
I started reading RFC1855 on Netiquitte instead of writing bad code. it's amazing "A good rule of thumb: be conservative in what you send and liberal in what you receive. You should not send heated messages (we call these "flames") even if you are provoked. On the other hand, you shouldn't be surprised if you get flamed and it's not prudent to respond to flames. In general, most people who use the Internet don't have time to answer general questions about the Internet and its workings. Don't send unsolicited mail asking for information to people whose names you might have seen in RFCs or on mailing lists.
|
# ? Nov 21, 2014 20:12 |
|
Wait overnight to send emotional responses to messages. If you really have strong feelings about a subject, indicate it via FLAME ON/OFF enclosures. FLAME ON
|
# ? Nov 21, 2014 20:15 |
|
today i learnt that regular expressions are not actually regular in most cases
|
# ? Nov 21, 2014 21:04 |
|
i give all my expressions metamucil
|
# ? Nov 21, 2014 21:08 |
|
yase at last someone was impressed by my internet hat resume and wants code samples and they're not an hour away everything's coming up milhouse
|
# ? Nov 21, 2014 22:06 |
|
pointsofdata posted:today i learnt that regular expressions are not actually regular in most cases with recursion and groups and stuff etc you can parse xml with them
|
# ? Nov 21, 2014 22:08 |
|
Luigi Thirty posted:internet hat resume ??? ?!?!?
|
# ? Nov 21, 2014 22:10 |
|
Elder Postsman posted:we are moving away from mysql to sqlserver and uh either mongo (ugh) or cassandra (???) so that will prob change ok, sqlserver is actually a legit sql db use cassandra, lmao @ mongo
|
# ? Nov 21, 2014 22:13 |
|
Luigi Thirty posted:yase at last someone was impressed by my internet hat resume and wants code samples and they're not an hour away everything's coming up milhouse
|
# ? Nov 21, 2014 22:13 |
|
VLADIMIR GLUTEN posted:??? I don't have work experience so my resume is all projects I've done and one of them was that Internet hats site that got a million hits in 2 years
|
# ? Nov 21, 2014 22:13 |
|
ohhhh right, that makes sense
|
# ? Nov 21, 2014 22:28 |
|
godspeed luigi
|
# ? Nov 21, 2014 22:32 |
|
pointsofdata posted:today i learnt that regular expressions are not actually regular in most cases i friggin hate regex but it is Really Useful
|
# ? Nov 21, 2014 22:38 |
|
im sorry for this terrible code,code:
|
# ? Nov 21, 2014 22:45 |
|
Elder Postsman posted:i friggin hate regex but it is Really Useful it spices things up a bit for sure
|
# ? Nov 21, 2014 22:53 |
|
Valeyard posted:fst(s) also do '(s, d) <- sizeDeclsZipped' rather than using fst and snd
|
# ? Nov 21, 2014 23:02 |
|
also you've consistently done no error checking whatsoever, are you just assuming for the purposes of the assignment that all fortran code is valid?
|
# ? Nov 21, 2014 23:04 |
|
AlsoD posted:also you've consistently done no error checking whatsoever, are you just assuming for the purposes of the assignment that all fortran code is valid? yup! and i can also luckily assume that the attributes in the fortran variable declarations follow a strict order AlsoD posted:
ok that makes more sense, thanks e: lectuer said this exercise is going to be marked purely by how many unit tests it passes, and I am pretty sure thats because he knows he is going to get a pile of unreadable mess Valeyard fucked around with this message at 23:52 on Nov 21, 2014 |
# ? Nov 21, 2014 23:16 |
|
what are good resources for learning how to database. something more in depth than just SQLzoo. something where I'd work with postgre, or with theory so I wouldn't even need a specific SQL implementation
|
# ? Nov 21, 2014 23:41 |
|
i thought the one we used in my db class was p good but i cant for the life of me remember what its called
|
# ? Nov 21, 2014 23:52 |
|
a very helpful post if i do say so myself
|
# ? Nov 21, 2014 23:52 |
|
Snapchat A Titty posted:a very helpful post if i do say so myself well now I know a helpful resource exists, so your post has given me the most important thing: *~hope~*
|
# ? Nov 21, 2014 23:59 |
|
Lord Of Texas posted:I guess part of it depends on your setup - if you as a developer have full control over your database AND it rarely changes AND your codebase is small, then just do whatever. Where I'm at, due to decisions out of my control my app is sharing a database which changes frequently so maintaining hundreds of stored procs that change frequently via Liquibase as opposed to in SVN would be a loving nightmare. What in the heck is liquibase
|
# ? Nov 22, 2014 00:00 |
|
I remember in high school we used this computer based oracle training system that was all flash animations
|
# ? Nov 22, 2014 00:04 |
|
|
# ? May 10, 2024 01:00 |
|
Deacon of Delicious posted:well now I know a helpful resource exists, so your post has given me the most important thing: *~hope~*
|
# ? Nov 22, 2014 00:07 |