|
cinci zoo sniper posted:idgi then, visual studio code is pretty nice (especially compared to alternatives) i like it but when i open a file in it i never have any idea what window/project it is going to open it in
|
# ¿ Aug 5, 2018 08:08 |
|
|
# ¿ Nov 4, 2024 11:36 |
|
cinci zoo sniper posted:it was mentioned by a fellow thread poster a few pages back first, so i'm toying with it. right now i agree that it is like the T bit in ETL. I've had à look at this and still don't really get it. It seems like most of syntax benefits already exist in you just use views and ctes, and while the templating stuff could be useful how often are you actually able to reuse sql across schemas?
|
# ¿ Aug 11, 2018 20:41 |
|
im gonna fake my own death, move to
|
# ¿ Aug 29, 2018 11:33 |
|
Slurps Mad Rips posted:Nice? probably somewhere near Marseille so that we can get direct trains back to london, not sure yet. Depends a bit on my gfs family. Ive been doing the sums and the reduced CoL and the fact that we currently live off about 2/3 our combined pay means it really does look like this will happen. On job sites there seem to be plenty of suitable remote positions (although some are probably US only but don't mention it). I really need to talk to a good agent/recruiter but have so little trust in them.
|
# ¿ Aug 30, 2018 07:08 |
|
Bloody posted:how do you do code generation well adults solve it with massive strings of boilerplate sql that you concatenate other massive strings of sql into afaict
|
# ¿ Aug 30, 2018 07:10 |
|
creating/altering/deleting sprocs at runtime can help improve code organisation and performance!
|
# ¿ Aug 30, 2018 07:12 |
|
the superior vcs (hg) solves the rewrite issue but marking commits as unpublished or published. As long as you don't push your history you can rewrite it but after that it's much more restrictive. (there's also a 3rd "don't push this commit" state to make it easy to manage wip stuff)
|
# ¿ Sep 7, 2018 10:27 |
|
the main thing that prevents me getting really bad imposter system from SA and random blog posts are seeing big companies we work with constantly gently caress stuff up
|
# ¿ Sep 10, 2018 19:28 |
|
the talent deficit posted:Thread has like the worst instincts ever: phd? c++?? gamedev??? thats why its the terrible programmer thread
|
# ¿ Sep 11, 2018 07:44 |
|
I made (started)a game once. It was meant to be a roguelike, but in space. Got to the point where you could move your ship and shoot (with a cool animation!) and there were asteroids and enemies with different ais. It was fun and easier than I expected but I'm sure if I did it as a job it would quickly become like any other job
|
# ¿ Sep 11, 2018 20:08 |
|
carry on then posted:lol if the school u went to didn't lock the computers down so hard all .exes had to be on an allowed list to even run yeah you had to rename .exes to notepad.exe or they wouldn't work.
|
# ¿ Sep 17, 2018 14:44 |
|
CRIP EATIN BREAD posted:wrap your domain objects in view models. sure it's duplicate effort but it at last they are splitting concerns. woah this is neat.
|
# ¿ Sep 18, 2018 18:34 |
|
Fiedler posted:i think we've misunderstood each other. i'm suggesting that you use a sql server database project, which does *not* involve storing sequential alter scripts. What happens if you have non-.net users of the database. Or users accessing the db directly from their own sql. This sort of thing is great if you have a super structured and locked down development process, but for some (a lot?) of places the dbs are designed first for an unknown number of eventual consumers and it would just me much better if ssms /sql server supported that use case with versions, tracing, object reference paths etc. You can roll your own versions of some of those but it would be so much nicer if they were built in
|
# ¿ Sep 20, 2018 06:27 |
|
surely you're using the projects in your. Net solutions though, otherwise what's the point of splitting them up into n^2 different projects?
|
# ¿ Sep 20, 2018 07:04 |
|
DELETE CASCADE posted:uh i'm pretty sure the sane world is the exact opposite of this. the app doesn't own the database, and the data in it is far more important than whatever stupid hack the app team wants this sprint Yeah letting the applications control the data structures is a surefire way to end up with a lovely db, loads of duplication and misrecs everywhere
|
# ¿ Nov 2, 2018 10:59 |
|
If your app needs a different data shape you can write a sproc to give it to you
|
# ¿ Nov 2, 2018 11:00 |
|
cinci zoo sniper posted:on 80% of our web projects a database level not null condition on a field is technically impossible, because the php orm used shits it’s bed immediately curse of the orm strikes again
|
# ¿ Nov 2, 2018 11:48 |
|
Bulgakov posted:fired fired fired fired fired fired You seem to have fired yourself which is definitely going to break something
|
# ¿ Nov 2, 2018 12:43 |
|
Finster Dexter posted:lmao ezpz. as a backend dev I just store everything as UTC and make the frontend dopes worry about time zone conversions idk if you're joking but this doesn't work with e.g. dst
|
# ¿ Nov 7, 2018 19:24 |
|
Chalks posted:As long as the front end is always sending you data in UTC or with time zone information attached you're fine, yeah? You need to know the timezone if you want to calculate time between two values, 1 hour before a time, bucket events into 5 min bins, calculate sales by month etc correctly. Idk maybe your application is fine and you do no operations on the timezones on the backend but it's really hard to get things right from a business logic perspective without timezone information E: sorry you said with timezone information. In that case you're fine I think
|
# ¿ Nov 8, 2018 11:30 |
|
Corla Plankun posted:i know that feel Or the vendor stuck a disclaimer in the last line lol
|
# ¿ Nov 11, 2018 18:08 |
|
TheFluff posted:there were many things that drove people to make everything a webapp but one of them is that native apps are only really native on one platform. writing good crossplatform gui apps that actually look and feel native on the supported platforms is a pain in the rear end. javascript is bad but so is wxwidgets. Of course, web apps don't look or feel native either (they look and feel like rear end) so it isn't a very good reason
|
# ¿ Nov 23, 2018 14:40 |
|
Do a string concatenation then a substring index
|
# ¿ Nov 28, 2018 11:33 |
|
Maybe I'm a moron but boy do I hate Spring. Java is a perfectly good language but using spring you don't get to write any, just gently caress around with endless combinations of hard to debug attributes and configuration.
|
# ¿ Dec 8, 2018 15:05 |
|
PierreTheMime posted:i support a team that uses Spring to setup their database connection, but never bothered to configure the possibility of a connection failure, so in all envs it will occasionally throw an ugly JDBC trace and then “succeed” after doing gently caress all with their data for a while and offer no useful logs. their answer to my question of “why don’t you add custom error handling” is “yes but we use spring and can’t change it” which is the dumbest poo poo I don't get why you would use it just for database access, it's like 1000x harder to get working than a normal connection string E: http://samatkinson.com/why-i-hate-spring/ I agree 100% distortion park fucked around with this message at 17:05 on Dec 8, 2018 |
# ¿ Dec 8, 2018 17:00 |
|
PierreTheMime posted:they do a lot of etl work and from the looks of it it’s helpful there, but I’m not sure of their specifics. I just get to see the crap that breaks and is externally accessible I do a lot of etl work and it seems awful. Trying to debug a spring app that someone else wrote is hard enough, but of the problem is with types not lining up in one of the magic steps you're just straight up screwed
|
# ¿ Dec 8, 2018 17:35 |
|
My experience with kubernetes (well openshift) is that writing the configuration sucks hard but is still better than all the previous deployment processes. Openshift can do CI as well which is cool
|
# ¿ Dec 13, 2018 12:30 |
|
TheFluff posted:the most obvious use case for lateral joins (which is pretty much exaclly what i had going on in this case) is when you need a regular inner join with a complex condition that usually looks something like "join only the first three rows of the right hand table ordered by some criteria". if you are selecting only one column from one row from the right hand table, you can do this with a subquery instead (or with an aggregation, like max()/GROUP BY), but if you want something more complex than that, then a lateral join is usually the way to go. If I understood this correctly I think this is similar to a t sql window function?
|
# ¿ Dec 19, 2018 22:40 |
|
redleader posted:the tsql equivalent is CROSS/OUTER APPLY You're right. I've always joined then done row_number to achieve this and have no idea why
|
# ¿ Dec 20, 2018 07:07 |
|
my experience with ES is that it's good at what it does but it's really hard to use as a primary data store. As long as you can recreate the indexes from a more reliable source it's fine
|
# ¿ Dec 27, 2018 17:28 |
|
galenanorth posted:They told me that whether I need a Home Occupation License would depend on how much money the business makes. I said "I have no idea" and they said they needed an estimate but redirected me toward a customer service desk for public works which connects to a bunch of permit offices, since I'd need a permit if I'm working from home, before I could answer. In all likelihood, yes, I need a permit for working at home even working from a computer, since they didn't have a favorable reaction when I told them the business essentially sells data in spreadsheet form. It's really annoying and I'd wish I'd known I'd need apartment manager permission at the outset That's hosed up.
|
# ¿ Apr 11, 2019 05:35 |
|
dick traceroute posted:ctps: turns out you shouldn't create hundreds of thousands of instances of HttpClient in a tight loop It implements IDisposable but that's a trick, disposing it doesn't help!!!! SqlConnection on the other hand is fine with doing this e: "fine"
|
# ¿ Apr 16, 2019 12:00 |
|
animist posted:does anybody actually use self-documenting features of REST apis? github's api has a million extra annotations on every message and they seem pretty pointless to me I've used it to scrape data off apis backing website frontends
|
# ¿ May 22, 2019 17:40 |
|
eschaton posted:remember how one of the promises of SOAP was that enterprise middleware would be created to work with services in a completely content agnostic manner lol
|
# ¿ May 23, 2019 06:41 |
|
Aramoro posted:I mean getting contractors to gently caress up your services is very much in the Uber ethos. once the refactor is finished (lol) you won't need them anymore
|
# ¿ May 29, 2019 13:17 |
|
CRIP EATIN BREAD posted:i mean i dont call someone a "loving idiot" but i will often come up with "what the gently caress were you thinking?" or "gently caress why did you do that?" both seem kind of aggressive to me although i suppose it depends on the context and tone.
|
# ¿ Jun 3, 2019 14:44 |
|
DONT THREAD ON ME posted:im not really opposed to open offices in theory, because in theory i like my coworkers and we’re working on something we care about and the serious collaboration ive done has always been my best work. If they aren't used to reduce space used per employee and have plenty of soft furnishings etc they can be OK but that's like 1 in 100
|
# ¿ Jun 3, 2019 19:10 |
|
animist posted:someone just needs to add some tiny syntax change to maven so that you can write your xml in a thing that looks like gradle and then all the flighty aesthetic devs will come back how about a groovy script which generates the xml then runs maven
|
# ¿ Jun 9, 2019 20:01 |
|
idk if this would work in your case, but if it's an internal site you might be able to get away with displaying top 50 in client on their initial search, then streaming the rest to the client in the background so that you don't have to do any caching serverside. 110k rows might be small enough that you can the just do all the sorting etc clientside.
|
# ¿ Jun 18, 2019 12:13 |
|
|
# ¿ Nov 4, 2024 11:36 |
|
Bloody posted:.net core 1 seemed super rushed and half-baked tbh the whole thing sucked. they briefly had some lovely json project/reference file thing as well. fortunately they fixed that with the new xml one.
|
# ¿ Jun 20, 2019 12:11 |