|
Impromptu Flip posted:going through projects to find things i want is getting cumbersome, there's got to be a better way!!! iirc dash was originally good and then the pay thing made it garbage but idk if you wanted the super cheap and lazy route you could private gist everything
|
#
?
Sep 17, 2013 15:05
|
|
|
|
| # ? May 10, 2024 17:44 |
|
|
actually thats a p decent idea, an app where you can submit gists and throw flags on them with an @ sign or something then query all related gists based on the title. the github api would support it afaik
|
|
#
?
Sep 17, 2013 15:07
|
|
|
you can also use text expander to shortcut useful things like this: steve jobs = SJ = salty jizz = cum = ball gunk = BG = bill gates ? coincidence ? as "jobs=gates" to include in code, emails, or anything else!
|
|
#
?
Sep 17, 2013 15:11
|
|
|
I cant think of any snippets I'd want to reuse that aren't just part of a library already. altho both eclipse and vs let u save ur own snippets
|
|
#
?
Sep 17, 2013 15:14
|
|
|
Impromptu Flip posted:that sounds p ghetto but the toc is a good idea yeah it's hell of ghetto but i'm a lovely p-langer so i feel it's appropriate
|
|
#
?
Sep 17, 2013 15:15
|
|
|
i email snippets to my coworkers and go ask them to email me snippets back when i need them. this gives me an excuse to waste hours a day hovering around people's cubicles drinking coffee
|
|
#
?
Sep 17, 2013 15:25
|
|
|
prefect posted:are orms a good idea if you're working on something where the database performance becomes important? any individual case where you might run into that problem you can replace the ORM with a sproc
|
|
#
?
Sep 18, 2013 04:07
|
|
|
aka every orm use case
|
|
#
?
Sep 18, 2013 04:09
|
|
|
shaggar's avatar someone help please
|
|
#
?
Sep 18, 2013 04:11
|
|
|
BONGHITZ posted:shaggar's avatar someone help please 
|
|
#
?
Sep 18, 2013 04:14
|
|
|
Shaggar posted:aka every orm use case shaggar was... wrong??? (aka when you want to do a SELECT blah FROM t1 INNER JOIN t2 ON t1.t2id = t2.id where t1.name = 'buttes' there's nothing wrong with letting Entity Framework generate that busywork for you)
|
|
#
?
Sep 18, 2013 04:30
|
|
|
entity framework blows. also orms suck cause your application model and your data model can and likely will be different and trying to cram them together sucks and having to translate from orm data objects to application model objects sucks. use stored procs to translate from db to application so you don't have to deal with crappy orm middlemen
|
|
#
?
Sep 18, 2013 04:32
|
|
|
boy I sure love debugging lovely sql you cannot defeat me now shaggar; I am on US timezone
|
|
#
?
Sep 18, 2013 04:55
|
|
|
its easier to debug sql that is written in sql than it is to debug sql written in whatever garbage intermediate your orm has
|
|
#
?
Sep 18, 2013 04:56
|
|
|
Shaggar posted:its easier to debug sql that is written in sql than it is to debug sql written in whatever garbage intermediate your orm has hate to appeal to authority but we have this huge product with a million sprocs and funcs that call other sprocs and funcs and it loving sucks compared to some C# you can actually attach a debugger and step through
|
|
#
?
Sep 18, 2013 05:01
|
|
|
i'm also struggling to think of a time when an ORM has written some truly buggy as opposed to just plain old inefficient SQL (i've only used LINQ to SQL, nHibernate and EF though)
|
|
#
?
Sep 18, 2013 05:05
|
|
|
I've figured out my next rounds of dev for @Fayettevillains -Web interface (django learnin' project) --gmaps display with crimes overlaid --adjustable slider to show a time range, default to 'last 4 hours to now' or something --Later on I want to add a function where you click a spot on the map, specify a radius, enter your email or SMS and it will notify you if a dispatch occurs in that radius -DB rework --Break out all the addresses into a separate table, with fields for phys address, lat, long, and business name --Background job to basically i'm-feeling-lucky all of the addresses that I dont have a business name for --Ennumerate crimes that are dispatched, and break those out into a separate table with inbound call ('ASSIST/CITIZEN, MOTORIST') and prettified output ('Non-Emergency Assistance'). that would break my main DB down to just be a timestamp, a crime ID and an address ID.
|
|
#
?
Sep 18, 2013 18:22
|
|
|
what are stored procedures and how do i learn more about databasing
|
|
#
?
Sep 18, 2013 18:29
|
|
|
normally i think normalization is way overboard for side projects the volume of crimes you are dealing with necessitates it in this case
|
|
#
?
Sep 18, 2013 18:29
|
|
|
Bloody posted:what are stored procedures and how do i learn more about databasing stored procedures are like methods for your database
|
|
#
?
Sep 18, 2013 18:29
|
|
|
i checked out a mysql book from the library and ordered that ~python for kids~ book because i'm literally a dumb babby. i really need to come up with an interesting project to do now.
|
|
#
?
Sep 18, 2013 18:34
|
|
|
Bloody posted:what are stored procedures and how do i learn more about databasing stored procedures are a way to parameterize a query and store it in the database. this has the benefits of better security (since theres no direct object access), reusability, and abstraction (u can change what the proc does internally and as long as the inputs and outputs are the same ur code doesn't care). it will also generally allow you to make better performing sql over an ORM cause most people will return gobs of crap they don't need when using an ORM and most people design procs to return only what you need.
|
|
#
?
Sep 18, 2013 18:35
|
|
|
git clone trooper posted:normally i think normalization is way overboard for side projects the volume of crimes you are dealing with necessitates it in this case always normalize your data cause theres never a reason not to.
|
|
#
?
Sep 18, 2013 18:36
|
|
|
Bloody posted:what are stored procedures and how do i learn more about databasing stored procedures are a way to add extra overhead and effort to writing and deploying your software in order to appease the DBA union and provide work for people who shell out five figures for oracle certification
|
|
#
?
Sep 18, 2013 18:41
|
|
|
~Coxy posted:i'm also struggling to think of a time when an ORM has written some truly buggy as opposed to just plain old inefficient SQL if your orm can write inefficient sql get a database with a better query optimizer sprocs and requiring a DBA's magic touch are the DBA guild trying to stop progress to further their employment
|
|
#
?
Sep 18, 2013 18:43
|
|
|
Shaggar posted:always normalize your data cause theres never a reason not to. anything client facing yes, most personal projects no
|
|
#
?
Sep 18, 2013 18:43
|
|
|
People who don't use stored procs don't care that their data sucks and their poo poo is slow.
|
|
#
?
Sep 18, 2013 18:45
|
|
|
hey guys did you know crappy ORM practices perform worse than Ideal SQL practices????
|
|
#
?
Sep 18, 2013 18:45
|
|
|
git clone trooper posted:anything client facing yes, most personal projects no It's like maybe 5 extra minutes of thinking. Tbh I don't think I could design a non-normalized db w/out effort.
|
|
#
?
Sep 18, 2013 18:46
|
|
|
uG posted:hey guys did you know ORMs perform worse than SQL???? yeah if you just want to pull up userid=2 then fine use an ORM but anything past that don't.
|
|
#
?
Sep 18, 2013 18:46
|
|
|
uG posted:hey guys did you know crappy ORM practices perform worse than Ideal SQL practices???? Crappy orm practices are standard orm practices.
|
|
#
?
Sep 18, 2013 18:46
|
|
|
Shaggar posted:It's like maybe 5 extra minutes of thinking. Tbh I don't think I could design a non-normalized db w/out effort. effort is what you need to make a denormalized db, because unless you know what queries you're gonna run you'll denormalize it wrong
|
|
#
?
Sep 18, 2013 18:47
|
|
|
Shaggar posted:It's like maybe 5 extra minutes of thinking. Tbh I don't think I could design a non-normalized db w/out effort. if i have a csv of data that I'm trying to throw up into a website ASAP ill just .sqlite import mycsv and call it a day. if I'm dealing with 10ks of rows ill normalize poo poo
|
|
#
?
Sep 18, 2013 18:48
|
|
|
if you are using an ORM to pull poo poo like userid=10 you are an idiot
|
|
#
?
Sep 18, 2013 18:49
|
|
|
git clone trooper posted:if i have a csv of data that I'm trying to throw up into a website ASAP ill just .sqlite import mycsv and call it a day. it's easiest to normalize it after you've imported it too
|
|
#
?
Sep 18, 2013 18:49
|
|
|
uG posted:if you are using an ORM to pull poo poo like userid=10 you are an idiot lol User.find 10 SELECT * FROM users WHERE id = 10 yeah one of those is idiotic
|
|
#
?
Sep 18, 2013 18:50
|
|
|
if thats all im doing im not gonna drag the ORM into the hell that is my source code
|
|
#
?
Sep 18, 2013 18:51
|
|
|
what is normalization
|
|
#
?
Sep 18, 2013 18:51
|
|
|
Cocoa Crispies posted:lol they're both retarded cause user.find 10 is probably orming and writes the same sql
|
|
#
?
Sep 18, 2013 18:52
|
|
|
|
| # ? May 10, 2024 17:44 |
|
|
"orming"
|
|
#
?
Sep 18, 2013 18:53
|
|
