New around here? Register your SA Forums Account here!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $10! We charge money because it costs us money per month for bills alone, and since we don't believe in shady internet advertising, we try to make the money back through forum registrations.
 
  • Post
  • Reply
cowboy beepboop
Feb 24, 2001

SpaceAceJase posted:

Yo, what's a good ETL/workflow engine for parsing CSV files, and doing stuff like error trapping at certain steps?

Js or PHP options please. I'm a terrible proframmer

i don't know what ETL means but I used https://github.com/box/spout the other day it worked OK for some CSV parsing
edit I looked up ETL and hey I do this poo poo all the time. drat.

cowboy beepboop fucked around with this message at 07:51 on Aug 7, 2018

Adbot
ADBOT LOVES YOU

cowboy beepboop
Feb 24, 2001

Main Paineframe posted:

it's when a company wants to create a little internal website for the company intranet, but wants to spend as little effort on it as possible and doesn't care if it's actually useful or even usable

hm we use confluence for this. it's like perl where it's write only and no one reads it

cowboy beepboop
Feb 24, 2001

Maximum Leader posted:

i have a basic parent/child relationship in a database where i need to perform a basic join, problem is that the database is turbofucked by horrible decisions. the parent has fields parent/child relationship 1 through 12 containing a reference to the child instead of just putting the reference to the parent on the child. im at a loss with this, any advice guys?

gross

cowboy beepboop
Feb 24, 2001

ynohtna posted:

congrats on the arrival of new columns child13...child99

cowboy beepboop
Feb 24, 2001

containers are also good for making your devs not do lazy stateful poo poo on the filesystem and dockerfiles are an ok way of ensuring you can build your app again without the special snowflake server set up by guy who left 6 years ago

cowboy beepboop
Feb 24, 2001

DONT THREAD ON ME posted:

the only php i know is from people posting bad php and i have a lot of questions about the language

i hope this helps
http://news.php.net/php.internals/70691

cowboy beepboop
Feb 24, 2001

Krankenstyle posted:

i aint no ops guy, I'm too old for that poo poo

treat docker like a make file that produces a static binary image you can run in the cloud. so if you can build it on your dev machine you can run it where you need

cowboy beepboop
Feb 24, 2001

like java promised I guess

cowboy beepboop
Feb 24, 2001

ya i like docker. the worst part of it is trying to run your own k8s and fighting with the weird container networking. they should have just used ipv6 instead of NAT :(

cowboy beepboop
Feb 24, 2001

eschaton posted:

hasn’t systemd supplanted cron though

kinda? you need to make a service for every 'cron job', and then a timer. is that what you mean? then you can do systemctl list-timers to get a nice overview of what didn't work or bizarrely never even tried to start

cowboy beepboop
Feb 24, 2001

abigserve posted:

Putting your config files in SCM and having them automatically deploy is basic bitch stuff and should be in all your environments. You want em in Dev/test/qa to make sure those environments don't drift too far from prod accidentally.

what tools do you use

cowboy beepboop
Feb 24, 2001

ty that's cool

cowboy beepboop
Feb 24, 2001

DELETE CASCADE posted:

the database people have to trust the filesystem people though, since they rely on the filesystem for things like "cache this page" or "sync to disk". well postgres does anyway, oracle not so much

didn't postgrs only recently fix up their sync() issue where you have to call it twice (?) on linux for it to work

edit https://www.percona.com/blog/2019/02/22/postgresql-fsync-failure-fixed-minor-versions-released-feb-14-2019/#FSYNC-ERRORS-ARE-NOW-DETECTED

cowboy beepboop fucked around with this message at 07:17 on Dec 4, 2019

cowboy beepboop
Feb 24, 2001

abigserve posted:

A lot of poo poo that goes wrong in cloud and containerization is caused by people trying to re-invent networking fundamentals and crashing into the realization that you cant really gently caress with layer 3.

Azure networking is a good example where it's just a total shitshow because some brain surgeon decided that the concept of a "subnet" is dumb, what would you need that for, what a dumb dumb poo poo baby idea

give every container an ipv6 address change my mind

cowboy beepboop
Feb 24, 2001

Ploft-shell crab posted:

just hear me out fellas, what if we gave every process its own IP

yes we can get rid of ports

cowboy beepboop
Feb 24, 2001

redleader posted:

and crud apps are a solved problem so you might as well make them interesting somehow

whats the best way to crud these days

cowboy beepboop
Feb 24, 2001

today I asked for a wsdl and was given an xsd and a pdf. is that good

cowboy beepboop
Feb 24, 2001

FalseNegative posted:

For my toy projects I've been using Phoenix LiveView. The last project was minesweeper and it was a joy compared to my old stack of php/angular.

Essentially it's SSR with normal Phoenix templates with a small JavaScript process added on. As you bind elements with things like phx-click it sends a websocket request to the backed. This is just a call back that returns a new template. The JavaScript gets this and hot swaps the DOM.

Theres two lines in my App.js, it's wonderful.

I did something similar with django and something called "pjax" back in the day

cowboy beepboop
Feb 24, 2001

The Fool posted:

hang ops is good

slack is no forum replacement though :(

cowboy beepboop
Feb 24, 2001

Bored Online posted:

how do i do systems programming? c++ and rust seems kewl but university only taught me to make lovely microservice apps and i cant think for myself

for rust you just write clone() when the compiler yells at you

cowboy beepboop
Feb 24, 2001

Spazmo posted:

typical python bullshit. what does this function take? is it a string? or list or char? or some kind of opaque byte sequence type? haha who knows man it's all good we'll find out at runtime in production at 4 am if you correctly handled every conceivable type. i'm sure the exception you end up dying with will be extremely informative.

this is my python experience too. luckily at work we use php so instead of the site crashing something more exciting might happen instead

cowboy beepboop
Feb 24, 2001

Bloody posted:

public virtual object DoWork(params object[] args){...}

if you do this good news you are writing php

cowboy beepboop
Feb 24, 2001

Shaggar posted:

every jetbrains thing ive used has sucked

phpstorm is excellent and saved me from text editing code maybe spaces can save us from slack + jira + arsekana

cowboy beepboop
Feb 24, 2001

eschaton posted:

brendan eich ruined the web by just going ahead with JavaScript rather than pushing back forcefully on the security implications of running code (rather than declarative markup) in web pages

it wouldn’t have prevented the Java and ActiveX and Shockwave plug-ins but it likely would have prevented VBScript and also most developers wouldn’t depend on those plug-ins being present

the other people to put on trial would be the Microsoft IE and Outlook Web folks who made XMLHTTPRequest since

without JavaScript and XMLHTTPRequest modern web pages would still easily work on hardware from when the web was invented and we wouldn’t have people pretending web pages are desktop apps

without js we would be stuck with silverlight or flash

cowboy beepboop
Feb 24, 2001

Nomnom Cookie posted:

"gently caress you, follow the style guide" was go's best idea. static linking was the other good idea. shame about the rest of the language but what can you do

rust tried to copy 'go fmt' and then let you define your own style rules :rolleyes:

cowboy beepboop
Feb 24, 2001

Shaggar posted:

ulaw fuckin sucks but carriers are all lovely so they're never gonna give up their 30 year old hardware

yes, all our stuff supports nice modern high bandwidth codecs but what's the point as soon as it hits the PSTN or mobile network it's compressed to poo poo and we're just adding latency for no reason

cowboy beepboop fucked around with this message at 09:46 on Feb 26, 2021

cowboy beepboop
Feb 24, 2001

12 rats tied together posted:

the downside is that the prometheus query language could not be any more hostile without becoming an actual parody language

i hate hte prometheus query language so much. i feel it is designed to be hard to use so you don't run too many complicated queries on the database so they can pretend it performs extremely well. also the documentation is terse and extremely devoid of useful examples or common use cases.

my terrible programmer moment today involved loving up writing records multiple times during the same 'hour' when the clocks rolled back for daylight savings ending. oh well i have at least a year to fix the problem now

cowboy beepboop
Feb 24, 2001

Carthag Tuek posted:

ya know when you write a bunch of semi-complicated code + unit tests and everything just works?

that cant be right. there must be a mistake somewhere but damned if i can find it :confused:

every time this has happened to me there is some tiny corner case that is broken in a very weird way and i don't find out until 8 weeks later when I have entirely forgotten everything about the code

cowboy beepboop
Feb 24, 2001

re plang chat, python is embarrassingly slow compared to php these days and weirdly php has far better maintainability if you're writing from scratch. obviously don't use python or php for anything new unless you're forced to though.

cowboy beepboop
Feb 24, 2001

i love that instead of fixing php's switch loose comparison bs they introduced match

cowboy beepboop
Feb 24, 2001

jesus WEP posted:

doing it in the where clause is the Oracle way which tells you all you need to know

i interned at a place that was all in on sun + oracle. they even got some kind of monthly magazine just dedicated to working with oracle dbs?? did I dream that last part

cowboy beepboop
Feb 24, 2001

lol if your language doesn't include that regex in it's source code
https://github.com/php/php-src/blob/master/ext/filter/logical_filters.c

cowboy beepboop
Feb 24, 2001

what's the best way to poke around a rest endpoint where you can easily do crud stuff to it
using insomnia but it's not nice, very manual. lots of copying ids and writing json by hand. maybe I am holding it wrong.

cowboy beepboop
Feb 24, 2001

thanks. I think postman is similar to insomnia. might try the client generation thing next.

cowboy beepboop
Feb 24, 2001

DrPossum posted:

terrible programming: what the gently caress are you typing into your ide that would make this happen to you

cowboy beepboop
Feb 24, 2001

DoomTrainPhD posted:

Django > Spring. If you aren’t inheriting a Spring project there is no reason to choose it over Django unless you like pain.

django is a nice project but still suffers from way too many runtime errors like all python programs

cowboy beepboop
Feb 24, 2001

Blinkz0rz posted:

you joke (and also isn't that basically sharepoint?) but at a previous job a guy i worked with came up with a programmatic solution for serializing an entire access database to an insanely optimized binary format so we could sync a bunch of dbs at site offices in regions with poor internet connectivity

similarly active directory can sync over SMTP I believe

cowboy beepboop
Feb 24, 2001

must be a few good back doors in that huge patch

cowboy beepboop
Feb 24, 2001

Soricidus posted:

google dgaf about search quality any more. helping you find technical information doesn’t make number go up

i use kagi now. it's good.

Adbot
ADBOT LOVES YOU

cowboy beepboop
Feb 24, 2001

Shaggar posted:

we had service definition files that actually worked 20 years ago and we're just now getting around to swagger/openapi docs being somewhat normal, even if not always useful. i cannot believe what these web "developers" have taken from us.

every swagger/openapi thing I've seen has been wrong and generated broken poo poo

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply