terrible programmers: my god, it's full of chars

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > terrible programmers: my god, it's full of chars

«‹›1446 »

Shaggar: Apr 26, 2006

MALE SHOEGAZE posted:

is there a mysql gui for osx that is a) decent and b) lets me like, bookmark a bunch of tables because we have like 960 tables in our DB and i'm only interested in about 80 of them and having to scroll between them all the time is annoying

i know the answer is 'get good at a command line sql tool' but i'm not a database developer and i mostly just need access to the schema quickly and easily

no one uses command line sql tools. idk if they make sqlyog for Linux but that's the best MySQL gui. really you should just install windows and use mssql.

# ? Apr 25, 2015 22:50

Adbot: ADBOT LOVES YOU

# ? May 13, 2024 19:50

jesus WEP: Oct 17, 2004

Shaggar posted:

no one uses command line sql tools.

No one should but lots of people i work with use putty + sqlplus exclusively

# ? Apr 25, 2015 22:53

Shaggar: Apr 26, 2006

that's disgusting

# ? Apr 25, 2015 22:53

DONT THREAD ON ME: Oct 1, 2002; by Nyc_Tattoo; Floss Finder

Shaggar posted:

no one uses command line sql tools. idk if they make sqlyog for Linux but that's the best MySQL gui. really you should just install windows and use mssql.

a lot of people here seem to which is confusing to me because the number 1 thing i want to be able to do with a sql tool is display schema in a way that makes it easy for me to visually understand the schema and relationship between tables, and the sql command line is basically completely useless for that from what i've seen. like it cant even format columns nicely. wtf. I can see how someone who is a database engineer might not really care about that but as a developer it's definitely all i care about

# ? Apr 25, 2015 22:54

Shaggar: Apr 26, 2006

that assumes they have all the key relationships setup correctly which if they're using MySQL idk how likely that is.

# ? Apr 25, 2015 22:55

DONT THREAD ON ME: Oct 1, 2002; by Nyc_Tattoo; Floss Finder

how can there really not be any good graphical tools for sql? it's like the one thing every program uses

# ? Apr 25, 2015 22:56

Valeyard: Mar 30, 2012; Grimey Drawer

during bank internship my days were largely filled with using isql on the command line

# ? Apr 25, 2015 22:58

Shaggar: Apr 26, 2006

MALE SHOEGAZE posted:

how can there really not be any good graphical tools for sql? it's like the one thing every program uses

there are, just not for your distro.

# ? Apr 25, 2015 23:00

kitten emergency: Jan 13, 2008; get meow this wack-ass crystal prison

iirc isn't there one called sequel or w/e

# ? Apr 25, 2015 23:03

coffeetable: Feb 5, 2006; TELL ME AGAIN HOW GREAT BRITAIN WOULD BE IF IT WAS RULED BY THE MERCILESS JACKBOOT OF PRINCE CHARLES

YES I DO TALK TO PLANTS ACTUALLY

i have spent the past year being paid to write tens of thousands of lines of uncommented, untested python. i am the terrible programmer

(98% of it is thrown away and i comment and test the 2% that escapes)

# ? Apr 25, 2015 23:04

Valeyard: Mar 30, 2012; Grimey Drawer

welcome back to the fold

# ? Apr 25, 2015 23:06

wolffenstein: Aug 2, 2002; Pork Pro

MALE SHOEGAZE posted:

how can there really not be any good graphical tools for sql? it's like the one thing every program uses

my jet brains ide includes sql ui stuff in it thats good enough for me plus i can use it for coding other things and languages.

# ? Apr 25, 2015 23:07

DONT THREAD ON ME: Oct 1, 2002; by Nyc_Tattoo; Floss Finder

jet brains more like hair brains

being able to use the table filter thing with a regex would be enough. that's all i need and apparently neither sql workbench or sequel pro can handle this. sequel pro even forces you to enter the database name lmao

# ? Apr 25, 2015 23:08

Valeyard: Mar 30, 2012; Grimey Drawer

what really constitutes a "good graphical" tool for SQL though

what is the best hypothetical tool you can describe

# ? Apr 25, 2015 23:08

coffeetable: Feb 5, 2006; TELL ME AGAIN HOW GREAT BRITAIN WOULD BE IF IT WAS RULED BY THE MERCILESS JACKBOOT OF PRINCE CHARLES

YES I DO TALK TO PLANTS ACTUALLY

fun machine learning fact: algorithms that are designed to find a signal in noise are inherently robust vs certain kinds of bugs. instead of failing outright, they will be subtly wrong for months in production

# ? Apr 25, 2015 23:09

DONT THREAD ON ME: Oct 1, 2002; by Nyc_Tattoo; Floss Finder

Valeyard posted:

what really constitutes a "good graphical" tool for SQL though

what is the best hypothetical tool you can describe

i dont know but sequel pro is open source so i'm forking this poo poo

# ? Apr 25, 2015 23:18

Asshole Masonanie: Oct 27, 2009; by vyelkin

i want something that is like max/msp except for databases

# ? Apr 25, 2015 23:40

compuserved: Mar 20, 2006; Nap Ghost

dbeaver?

# ? Apr 25, 2015 23:52

Powerful Two-Hander: Mar 10, 2004; Mods please change my name to "Tooter Skeleton" TIA.

Valeyard posted:

during bank internship my days were largely filled with using isql on the command line

This is literally how i first learned sql because nobody could figure out if we needed a license for a proper management tool. Oh except i was getting paid.

# ? Apr 25, 2015 23:53

fritz: Jul 26, 2003

coffeetable posted:

fun machine learning fact: algorithms that are designed to find a signal in noise are inherently robust vs certain kinds of bugs. instead of failing outright, they will be subtly wrong for months in production

# ? Apr 26, 2015 00:11

DONT THREAD ON ME: Oct 1, 2002; by Nyc_Tattoo; Floss Finder

compuserved posted:

dbeaver?

oh my god what is this

this lets me do what i want. but is it worth it??

DONT THREAD ON ME fucked around with this message at 00:20 on Apr 26, 2015

# ? Apr 26, 2015 00:11

gonadic io: Feb 16, 2011; >>=

coffeetable posted:

fun machine learning fact: algorithms that are designed to find a signal in noise are inherently robust vs certain kinds of bugs. instead of failing outright, they will be subtly wrong for months in production

wb, i looked at the mean salary for f# devs in London and now i'm working ni f#

# ? Apr 26, 2015 00:24

leftist heap: Feb 28, 2013; Fun Shoe

aren't all the fp jobs at financial firms?

speaking of which i've spent a shameful amount of time janitoring my emacs/haskell/haskell-mode/etc. setup today.

# ? Apr 26, 2015 00:36

compuserved: Mar 20, 2006; Nap Ghost

MALE SHOEGAZE posted:

oh my god what is this

this lets me do what i want. but is it worth it??

it's free and needs suiting imo

# ? Apr 26, 2015 00:45

leftist heap: Feb 28, 2013; Fun Shoe

the lesson i've learned today is to just not try to upgrade cabal or ghc at all

# ? Apr 26, 2015 01:33

Notorious b.s.d.: Jan 25, 2003; by Reene

Valeyard posted:

what really constitutes a "good graphical" tool for SQL though

what is the best hypothetical tool you can describe

visio had a great database visualization tool that would import from anything that you have an odbc adapter for. ugly catch: it crashed on big schemas

so basically i want that, without the crashing

# ? Apr 26, 2015 03:34

more like dICK: Feb 15, 2010; This is inevitable.

MononcQc posted:

bits of this keynote might be relevant to people calling themselves terrible in here and believing it 100%:

https://www.youtube.com/watch?v=hIJdFxYlEKE

I was in the audience for this. It's pretty loving lovely that a white man repackaged the work that marginalized people have been doing and claimed it as his own. He's part of the problem in a big way but he still gets standing ovations because this industry is a toxic pit.

# ? Apr 26, 2015 04:21

MeruFM: Jul 27, 2010

if you're literally only using MySQL, sequel pro is a good app

but then you're using only mysql

# ? Apr 26, 2015 04:26

more like dICK: Feb 15, 2010; This is inevitable.

i wonder how many other articles by shanley will get standing loving ovations instead of rape threats when they come from a man

# ? Apr 26, 2015 04:26

brap: Aug 23, 2004; Grimey Drawer

what

# ? Apr 26, 2015 04:30

Luigi Thirty: Apr 30, 2006; Emergency confection port.

I have a programming question. I'm currently torturing myself doing 6502 assembly for a dinky Nintendo project. Right now I'm trying to draw 9 lines of text to the screen. Because of CPU limitations, I need to draw one line of text per frame. This means that I'm doing a lot of this garbage:

code:

DrawPayouts:
	LDA payoutLinesDrawn ;this is incremented before we get here
	CMP #1
	BEQ DrawPayouts1
	CMP #2
	BEQ DrawPayouts2
	CMP #3
	BEQ DrawPayouts3
	CMP #4
	BEQ DrawPayouts4
	CMP #5
	BEQ DrawPayouts5
	CMP #6
	BEQ DrawPayouts6
	CMP #7
	BEQ DrawPayouts7
	CMP #8
	BEQ DrawPayouts8
	CMP #9
	BEQ DrawPayouts9
	
	JMP LoopForever

And now I have nine of these blocks that load two 16-bit pointers into four memory addresses:

code:

DrawPayouts1:
	LDA #$20 ;different value for each of the nine blocks
	STA textDestinationHigh
	LDA #$20 ;different value for each of the nine blocks
	STA textDestinationLow
	LDA #HIGH(textPayoutsRoyalFlush) ;different value for each of the nine blocks
	STA textPointerHigh
	LDA #LOW(textPayoutsRoyalFlush) ;different value for each of the nine blocks
	STA textPointerLow
	JSR DrawString
	JMP LoopForever

Which means the branches at the top are out of range of the last few blocks. I'm pretty sure this isn't the ideal way of doing this. I can't do a JSR off of a compare without spaghetti short jumps to an intermediary subroutine. How should I be doing this?

# ? Apr 26, 2015 05:30

Jabor: Jul 16, 2010; #1 Loser at SpaceChem

Luigi Thirty posted:

Which means the branches at the top are out of range of the last few blocks. I'm pretty sure this isn't the ideal way of doing this. I can't do a JSR off of a compare without spaghetti short jumps to an intermediary subroutine. How should I be doing this?

The easy way of doing a conditional jump to an address you can only reach by an absolute jump is to just do a tiny branch for the jump:

code:

	BNE CarryOn
	JMP WhereYouWantToGo
CarryOn:

There might be a more convenient way to specify it in your assembler.

Jabor fucked around with this message at 05:43 on Apr 26, 2015

# ? Apr 26, 2015 05:36

eschaton: Mar 7, 2007; Don't you just hate when you wind up in a store with people who are in a socioeconomic class that is pretty obviously about two levels lower than your own?

Luigi Thirty posted:

I have a programming question. I'm currently torturing myself doing 6502 assembly for a dinky Nintendo project. Right now I'm trying to draw 9 lines of text to the screen. Because of CPU limitations, I need to draw one line of text per frame. This means that I'm doing a lot of this garbage:

Which means the branches at the top are out of range of the last few blocks. I'm pretty sure this isn't the ideal way of doing this. I can't do a JSR off of a compare without spaghetti short jumps to an intermediary subroutine. How should I be doing this?

Back in the day this is the kind of thing you might do with self-modifying code, partly due to code size and partly because people considered that sort of thing perfectly OK.

# ? Apr 26, 2015 05:38

BattleMaster: Aug 14, 2000

eschaton posted:

Back in the day this is the kind of thing you might do with self-modifying code, partly due to code size and partly because people considered that sort of thing perfectly OK.

not sure how viable that is because code is typically stored in ROM in NES games and also because of the system's 2KB RAM

however if you don't need the memory and/or you're using a mapper that adds PRG RAM it isn't so bad

# ? Apr 26, 2015 05:46

Jabor: Jul 16, 2010; #1 Loser at SpaceChem

also you're probably better off using a computed jump into a jump table (or even directly to the relevant code if you're feeling sufficiently Real Programmer) rather than a big ladder of compares and branches

# ? Apr 26, 2015 05:46

eschaton: Mar 7, 2007; Don't you just hate when you wind up in a store with people who are in a socioeconomic class that is pretty obviously about two levels lower than your own?

BattleMaster posted:

not sure how viable that is because code is typically stored in ROM in NES games and also because of the system's 2KB RAM

however if you don't need the memory and/or you're using a mapper that adds PRG RAM it isn't so bad

Yeah, I was thinking more about the Apple II than the NES (or the 2600 before it).

# ? Apr 26, 2015 06:20

coffeetable: Feb 5, 2006; TELL ME AGAIN HOW GREAT BRITAIN WOULD BE IF IT WAS RULED BY THE MERCILESS JACKBOOT OF PRINCE CHARLES

YES I DO TALK TO PLANTS ACTUALLY

gonadic io posted:

wb, i looked at the mean salary for f# devs in London and now i'm working ni f#

not just london

http://stackoverflow.com/research/developer-survey-2015#work-complang

second table

# ? Apr 26, 2015 07:13

coffeetable: Feb 5, 2006; TELL ME AGAIN HOW GREAT BRITAIN WOULD BE IF IT WAS RULED BY THE MERCILESS JACKBOOT OF PRINCE CHARLES

YES I DO TALK TO PLANTS ACTUALLY

also everyone should read that survey

# ? Apr 26, 2015 07:18