VBA Rubberducking

Duga

00:00

[Cardshifter/Cardshifter] 10 commits.

[retailcoder/Rubberduck] 1 opened issue. 1 closed issue. 5 issue comments.

[Zomis/Fighting] 3 commits. 1 opened issue.

Mat's Mug

00:59

1>Building COM .NET Interop information for components
1>Searching project for extract-at-build components...
1>Extracting COM data from 2 component(s)
1>ISEXP : warning : -4354: The build was unable to extract COM information from the file C:\Users\Mathieu\Source\Repos\Rubberduck\RetailCoder.VBE\bin\Release64\Rubberduck.dll in component Rubberduck.Primary_output1. Please ensure that the file is self-registering and verify that the self-registration process does not fail.
1>New Registry Entries (48) dynamically acquired for component Rubberduck.tlb

Simon André Forsberg

01:12

Have I ever said how awesome unit tests is?

Mat's Mug

in VBA?

lol

I wish unit tests made COM registration on x64 a freakin' breeze

Simon André Forsberg

@Mat'sMug you really think I would code VBA?

still having x64 problems?

Mat's Mug

yeah

it's not funny anymore

Simon André Forsberg

has such problems ever been funny?

Mat's Mug

when they're caused by a typo, they can be

Simon André Forsberg

01:21

true that

Mat's Mug

Simon André Forsberg

gotta love the informative error messages

Mat's Mug

it's a registration issue

but I don't know what's wrong with it

Simon André Forsberg

did you say that you got the debug version to work?

RubberDuck

@Mat'sMug that looks like the output properties to me. No time right now though.

Mat's Mug

01:31

:(

@SimonAndréForsberg yes!!

@RubberDuck output properties?

Simon André Forsberg

@Mat'sMug so something is different from the debug version and the release version. List all those things, what is different?

Mat's Mug

the way the dll gets registered...

Simon André Forsberg

anything else? (quack quack)

Mat's Mug

hi @Jeeped!

Jeeped

@Mat'sMug - hi back. just poking my head in to see what's up of late.

Mat's Mug

01:39

eh, wasted 2-3 days trying to get a x64 Rubberduck installer to work... still not working.

Mat's Mug

02:02

uh, wtf?

I borked regasm.exe???

#FML

#WhyMe

Duga

02:20

[retailcoder/Rubberduck] retailcoder commented on issue #305: No additional AddIn was found after installing Rubberduck 1.2.

> I can get Office 2010 x64 to run through the VS2013 debugger, but no luck getting it to work off an installer. The minute I get an installer to correctly register Rubberduck, 1.21 x64 gets released. @ckuhn203 as much as I'd like to release both x86 and x64 at the same time, I'm starting to think the x86 build should be released ASAP; we shouldn't penalize 32-bit Office users because we're (I'm) struggling with the x64 build...

Duga

02:43

[retailcoder/Rubberduck] retailcoder commented on issue #315: Excel 2013 crashes and re-opens after attempting to close Excel

> I have a solid repro on this one. From the output window (debug/x64): A first chance exception of type 'Rubberduck.VBA.WalkerCancelledException' occurred in Rubberduck.dll A first chance exception of type 'Rubberduck.VBA.WalkerCancelledException' occurred in Rubberduck.dll A first chance exception of type 'Rubberduck.VBA.WalkerCancelledException' occurred in Rubberduck.dll The thread 0x16a8 has exited with code 259 (0x103). The thread 0x3e0 has exited with code 259 (0x103). The thread...

0x104c has exited with code 259 (0x103). The thread 0x1754 has exited with code 259 (0x103). The thread 0x140c has exited with code 259 (0x103). The program '[3792] EXCEL.EXE' has exited with code -1073741819 (0xc0000005) 'Access violation'.

Mat's Mug

02:57

Fed up. regasm.exe works from admin cmd prompt, but not from post-build events. Better: I can run x64 off the Debug configuration, no need for a Debug64, and no need to even run regasm.exe on x64 debug build - it just works. But then the installer just doesn't want to hear it. Off to bed.

Stack Exchange

07:32

0

Q: Need help in optimizing my code

Can anyone help me optimize the current VBA code below. It is taking 20 seconds currently to collect,store, check and validate 1000 data's. Option Explicit Public s, c, r2, r, i, j, k, i3, i1, i2, r1, j1, j2, i4, r3, sum As Long Public wh As String Public ws, wd As Worksheet Public Declare Funct...

vba

RubberDuck

09:14

You need to worry about making your code maintainable before you worry about making it fast. — RubberDuck 46 secs ago

Simon André Forsberg

10:19

@Mat'sMug Last resort: Stack Overflow ?

2

Mat's Mug

11:33

Irony: .

We got

....64 downloads

2

@SimonAndréForsberg Likely

RubberDuck

Monking Mug. Sorry I went MIA yesterday.

@Mat'sMug Yeah. The output file's properties. It looks like the com data isn't being extracted.

It's also possible that we should be using the 32 bit version of libgit2 regardless of the bitness of Office.

Poor soul @ticker.

-2

Q: How to Compile Visual Basic 6 code in Visual Studio

I have a project of Visual Basic 6.0, in that I have some code changes. for that I need Old Visual Basic 6.0 IDE that I don't have. So anybody can me tell me that, Is that possible to compile that VB 6.0 code in Visual Studio 2010 and later and how. Or Where i can get the Visual Basic 6.0 IDE ...

visual-studio-2010 visual-studio vba vb6

Mat's Mug

12:03

The VB6 IDE is available through an MSDN subscription. — Hans Passant 11 mins ago

Yeah. So you get it for free after spending $12K on a MSDN subscription

@RubberDuck From the output/logs, it seems so. But whatever I do doesn't fix it..

RubberDuck

Do you actually see it say "Extracting COM data from 2 components" when you build?

Mat's Mug

Yes, and I see one fail to do so

RubberDuck

Ahhhhh. That's a good start. Do you know what fails?

Wait.... I think you posted it earlier.

11 hours ago, by Mat's Mug

1>Building COM .NET Interop information for components
1>Searching project for extract-at-build components...
1>Extracting COM data from 2 component(s)
1>ISEXP : warning : -4354: The build was unable to extract COM information from the file C:\Users\Mathieu\Source\Repos\Rubberduck\RetailCoder.VBE\bin\Release64\Rubberduck.dll in component Rubberduck.Primary_output1. Please ensure that the file is self-registering and verify that the self-registration process does not fail.
1>New Registry Entries (48) dynamically acquired for component Rubberduck.tlb

Mat's Mug

Yeah that

RubberDuck

Hmmm...

And the properties look just like that ^?

Yeah. I know I know. I"ve asked that 3 times...

Mat's Mug

12:10

Yup

RubberDuck

Just rubberducking here.

Well..... shite....

Okay. I'm gonna take a shot at it at lunch and email you the setup.exe.

Mat's Mug

@RubberDuck 32-bit?

RubberDuck

64

Mat's Mug

ok

RubberDuck

I can build it. I've just no way to test it.

Mat's Mug

12:43

@RubberDuck If that build works...

RubberDuck

@Mat'sMug Cross your fingers.

Mat's Mug

I even ran regasm /regfile and imported the .reg into the installer.. not cutting it.

but then, I couldn't get the installer to NOT try to register it itself

RubberDuck

13:31

@StackExchange I am actually offended by that code.

Mat's Mug

13:43

I have a vested interest, but I suggest you check out rubberduck-vba.com, download the latest version (1.21 is on its way), and run code inspections (and apply quick-fixes), and then use the extract method refactoring to address all the method extractions @RubberDuck is suggesting in his answer. Note that both he & I are devs on that open-source project. — Mat's Mug 1 min ago

JLILI Amen

14:01

Good afternoon Duck!

Bon après-midi Mug!

Mat's Mug

bonjour/hi!

JLILI Amen

Comment ça va?

Mat's Mug

ça irait mieux si j'avais réussi à faire fonctionner le setup installer pour Rubberduck 1.21 x64 cette fin de semaine

:(

JLILI Amen

Quel hazard! Je viens de le télécharger sur cette machine.

Mat's Mug

> 65 downloads

youppi!

JLILI Amen

14:06

Au bout de 5 à 10 ans, tout le monde se mettera à utiliser le x64. x86 sera de l'histoire.

Mat's Mug

pas si Microsoft continue de rendre impossible le déploiement d'applications x64...

est-ce que Rubberduck fonctionne sur ta machine?

JLILI Amen

Attends, l'installation n'est pas finalisée.

Mat's Mug

c'est quoi ton environnement?

JLILI Amen

Windows 7 Pro, 32-bits

Je bosse que avec des windows.

Mat's Mug

cool, 32-bit devrait fonctionner nickel

JLILI Amen

14:11

Ouep

Mat's Mug

(à part les bogues qu'on corrige dans 1.21)

(et ceux qu'on n'a pas encore corrigé) .. ;)

JLILI Amen

C'est chargé automatiquement depuis le démarrage

Mat's Mug

j'ai tellement hâte de déployer 1.21...

si tu voyais comment le Code Explorer a évolué!

JLILI Amen

Prenez-moi pour un débutant

Mat's Mug

perhaps we should switch to English, only @Phrancis can understand the chat right now :)

JLILI Amen

14:14

vous devez obligatoirement avoir une documentation qui accompagne l'installation

Yeah sure

Mat's Mug

like a user manual?

JLILI Amen

I'm a polyglot. No worries ;)

Sure. A user manual for the novices.

Mat's Mug

we put a lot of effort in our wiki

github.com/retailcoder/Rubberduck/wiki/Features

all code inspections are documented separately: github.com/retailcoder/Rubberduck/wiki/Code-Inspections

but yeah a PDF document would be nice, too

note taken... for v1.3

JLILI Amen

Well. That's great. All the software companies have this convention of giving the installing user the option of taking a walk-through tutorial just the first install.

Something like checkbox (First-timer? Would you like us to take through the first steps of using Rubber Duck) control in the last step of the installation.

Mat's Mug

or we could do it à la ReSharper and have a "Quick Tips" dialog

JLILI Amen

14:21

Quick Tips dialog is something for an everyday use. I'm talking about someone who has never used Rubberduck and who is starting out to learn VBA.

cheezsteak

@JLILIAmen A complete freshman should just sit down and read the wiki. Integrating step by step instructions into the rubber duck program is too much

I would say an image pointing to where Rubberduck is on the menu bar and a link to the GitHub wiki should be enough for now.

Mat's Mug

the Rubberduck menu should be noticeable just before the "Window" menu

JLILI Amen

Hm. A Walkthrough should never be comprehensive otherwise there is no point in github wiki.

Mat's Mug

but I like the idea of packaging a PDF user guide

our users may land onto our download page and never venture into the depths of our github repo

cheezsteak

Link to the wiki from the installer?

JLILI Amen

14:28

I think Mug's idea is cool.

Mat's Mug

@cheezsteak yeah, on the "Installation complete" page. and then add a link in the start menu, too

Phrancis

Monking

Mat's Mug

@RubberDuck ^^

hey

cheezsteak

I might be able to help with the PDF user guide.

Phrancis

This was just posted by a coworker of mine: stackoverflow.com/questions/29079316/…

JLILI Amen

14:30

@cheezsteak: do you ever consider the possibility of people installing rubberduck offline?

RubberDuck

Holy carp. 46 messages while I was gone.

cheezsteak

@JLILIAmen rare but possible.

They would need a internet connection to get rubberduck.

JLILI Amen

Rubberduck is now portable!

cheezsteak

but many people stuck with VBA might be websensed'

RubberDuck

@Mat'sMug Yeah. I like that. Link to the wiki from the installer completed. Maybe in the "About" dialog too Mug.

Mat's Mug

14:33

good idea

RubberDuck

@JLILIAmen That's a really good point. Makes me think we should package a PDF with the installer.

JLILI Amen

Exactly.

Mat's Mug

@RubberDuck that gives us a good reason to add a "Rubberduck" folder in the users' start menu :)

RubberDuck

Anybody writing this down, I actually really need to work today.

JLILI Amen

Where do I write it?

lol

cheezsteak

14:37

Github issue

Should the PDF documentation be separate from the wiki or a translation?

Duga

[retailcoder/Rubberduck] retailcoder added label support to issue #317: Package a PDF user manual along with the installer

Mat's Mug

done

Duga

[retailcoder/Rubberduck] retailcoder added label wiki to issue #317: Package a PDF user manual along with the installer

[retailcoder/Rubberduck] retailcoder added label installer to issue #317: Package a PDF user manual along with the installer

[retailcoder/Rubberduck] retailcoder added label meta to issue #317: Package a PDF user manual along with the installer

JLILI Amen

Separate. Put it to a vote! @cheezsteak

Duga

[retailcoder/Rubberduck] retailcoder opened issue #317: Package a PDF user manual along with the installer

> Not everyone downloading Rubberduck may venture into the depths of our GitHub repository, or even have Internet access on the computer they installed it on (use case: download setup.exe, copy to USB key, install on no-internet computer).

- [ ] Write a user manual
- [ ] Package it with the install, in PDF format
- [ ] Add shortcut to it in the start menu, under a "Rubberduck VBA" folder
- [ ] While we're at it, add a shortcut to http://www.rubberduck-vba.com next to it

[retailcoder/Rubberduck] mwolfe02 commented on issue #292: Double-click on Code Explorer module-level node opens that module

> @retailcoder That looks good. I haven't had time to get the project set up locally to build from source, so I'll wait for the next release to check it out. Thanks for incorporating my feedback!

2

RubberDuck

14:40

@Duga Okay okay. I'll get a new installer done today...

Duga

[retailcoder/Rubberduck] ckuhn203 commented on issue #292: Double-click on Code Explorer module-level node opens that module

> @mwolfe02 1.21 is done. We just need to build & package the installer. We will announce on rubberduck-vba.com/news.html once it's realeased. Thanks again for the great feedback.

JLILI Amen

@Mat'sMug: Is there a French translation for Rubberduck?

Mat's Mug

oh good point.

JLILI Amen

My VBA IDE is in French so...

It confuses me a lot.

You can add a language check of the office (Not the Windows) to the Installer.

Mat's Mug

there's more than that that needs to be done to localize the app

JLILI Amen

14:46

I think it's can be done if you can retrieve registry keys.

There must be something there about the installed office suite language.

Duga

[retailcoder/Rubberduck] retailcoder opened issue #318: Localize!

> Rubberduck is currently {en-US}, often with hard-coded strings.

Let's prepare Rubberduck for localization, and MOVE ALL THE STRINGS to resource files.

Then we can translate these strings and have Rubberduck be displayed in the same language as our users' IDE.

[retailcoder/Rubberduck] retailcoder added label enhancement to issue #318: Localize!

[retailcoder/Rubberduck] retailcoder added label user-interface to issue #318: Localize!

[retailcoder/Rubberduck] retailcoder added label support to issue #318: Localize!

JLILI Amen

It's all in UTF-16, right?

Mat's Mug

JLILI Amen

Lovely.

Mat's Mug

^^ Japanese here

JLILI Amen

14:48

I'll be more happy to provide you with the Spanish and the Arabic translation.

3

Mat's Mug

awesome!!

Phrancis

JLILI Amen

No problem, pas de problème, sin problema, من غير مشكل

Phrancis

^^ Related to colleague's issues (from the result set) looks almost like it's filtering dates as alpha ...?

JLILI Amen

You should consider an artistic career. Your WTF graffiti shows a lot of talent.

2

Mat's Mug

14:51

@Phrancis is an artist! :D

JLILI Amen

lol

Phrancis

@JLILIAmen Très drôle / Very funny :p

JLILI Amen

Je sais.

;)

RubberDuck

@JLILIAmen Gonna hold you to that.

JLILI Amen

Hold me?

I don't like hugs.

Duga

14:59

[retailcoder/Rubberduck] ckuhn203 commented on issue #318: Localize!

> 1.3 might be a bit ambitious. I don't think the free version of install shield we're using can handle this. So, this will not only require a significant re-factoring, but we'll also need to move to a WiX installer. I'm not ruling it out for that version or arguing against it. Just hedging my bets on the timeline.

Mat's Mug

@RubberDuck it's much easier than that. The installer might be all-english, but the app itself can easily detect and adjust to the user's environment.

And with R# you can just right-click any string and select "move to resource file" ;)

JLILI Amen

I think the installer has its localisation already sorted out.

Mat's Mug

Does it??

JLILI Amen

When I installed it, I think the installer was in French.

Right? InstallShield detects the locale language.

Mat's Mug

interesting

JLILI Amen

15:05

I said, I think.

Mat's Mug

lol

if it supports it, I can make a French version

JLILI Amen

No. I'm wrong.

Mat's Mug

worst-case, {en-US} installer and localized Rubberduck!

JLILI Amen

But this is a very basic feature, surely Installshield has it somewhere.

I understand you mug. Moreover, I agree with you.

Mat's Mug

BTW, I am NOT translating the GPL3 license ;)

JLILI Amen

15:08

hahaha

I think there are translations out there in the web, we can use one.

Better make your own license. That'll be neat.

Mat's Mug

nope. we have to use GPL3. legalese stuff that can bite us in the butt if we don't comply ;)

JLILI Amen

Yea. Since no one here is well-rounded in law, GPL3 would be great.

Phrancis

SELECT DateTest
FROM Table1
WHERE DateTest>=#3/1/2015# And DateTest<#3/8/2015#
ORDER BY DateTest ASC

^^ No repro the date error using Access SQL... may be a weird VBA type conversion issue?

RubberDuck

Umm yes and no. I guess we could package them all into the same app. I thought best practice was to add optional language packs???

JLILI Amen

Phrancis? Check your quotes and your connection string?

Here's a very stupid question and fundamental question? How do you open the code explorer window?

Mat's Mug

15:15

@RubberDuck add > project output > Rubberduck.dll > Localized resources

that will create folders for each supported language under the install folder

RubberDuck

Okay. I must have been mistaken then.

Mat's Mug

Duga

[retailcoder/Rubberduck] retailcoder commented on issue #318: Localize!

> i.imgflip.com/iwsr8.jpg

JLILI Amen

how did u create that?

Mat's Mug

imgflip.com/memegenerator

JLILI Amen

15:24

I love this guy

Duga

[retailcoder/Rubberduck] ckuhn203 commented on issue #317: Package a PDF user manual along with the installer

> Perhaps this is cheating, but can we just PDF the wiki? I can merge the individual files into one big PDF to distribute.

Mat's Mug

@RubberDuck if you know how to do that, ...sure!

JLILI Amen

Mat's Mug

lol

RubberDuck

@Mat'sMug Nice thought, but it prints the whole web page obviously.

Mat's Mug

15:29

I'd rather make PDF out of a clean Word document :)

...and update the wiki by copy/pasting from that .docx

RubberDuck

Can't. The wiki is in markdown.

Formatting would be foobar. I think the best thing to do is link to it in the About window.

Mat's Mug

ugh

RubberDuck

Do we really want to maintain two copies of the docs?

Mat's Mug

no

didn't anyone write a VBA macro for MS-Word to take a document and format it in markdown?

(not really asking)

but the docs would be cleaner in a Word document /PDF than in markdown on the wiki

Phrancis

> EDIT: Answered. My friend pointed out that the source column was setup as Text and not DateTime, which I assumed it was, because I thought past-me was not an idiot. Thanks for the help, those of you who replied.

2

^^ Hehehe, his columns were set up as Text

RubberDuck

15:36

> because I thought past-me was not an idiot.

Mat's Mug

> because I thought past-me was not an idiot.

lol

RubberDuck

Well..... there's your mistake.

lol

I always assume past me was an idiot who wrote terrible code.

Mat's Mug

@Phrancis Excel's "Format as Text" should be labelled "Screw up your data"

Phrancis

YES

JLILI Amen

Format as Text is the truth to me.

lol

see you guys don't like the truth

Phrancis

15:40

Access does weird things too, I tried to copy a Date column from Excel and paste into Access and it converted the data to... decimal numbers...

Mat's Mug

awesome.

but MS calls it a feature

JLILI Amen

Goodbye.

Mat's Mug

later!

RubberDuck

Ugh. I hate waiting.

Hate hate hate waiting.

Mat's Mug

> your call is important to us

Duga

15:52

[retailcoder/Rubberduck] retailcoder commented on issue #318: Localize!

> The installer can remain {en-US} if it can't be localized.. that shouldn't stop us from localizing Rubberduck itself :)

Mat's Mug

I hit 5K on SO this weekend

2

RubberDuck

@Mat'sMug grats!

Mat's Mug

:)

RubberDuck

I'm actually waiting for the global publisher queue to clear so I can check to make sure this fix worked. 20 minutes.... agony.

ugh... maybe it'll be done by time I'm back from lunch.

Mat's Mug

16:22

<lunch>

Duga

16:44

[retailcoder/Rubberduck] ptwales commented on issue #317: Package a PDF user manual along with the installer

> Depending on what format the wiki source files are in, you can use pandoc to easily translate the wiki to a PDF through LaTeX. I have used it before and might be able to write a script to translate the wiki files to PDF.

2

RubberDuck

@Duga Thank you @cheezsteak!

cheezsteak

@RubberDuck I might give it a look see at lunch

RubberDuck

Looks like it supports github markdown flavor and docx, so it might be a winner.

Mat's Mug

17:12

</lunch>

RubberDuck

This POS still hasn't republished.

RubberDuck

17:26

YES IT HAS

Damn IE was holding onto a cache...

Mat's Mug

POS means "point of sale" in my mind

RubberDuck

LOL. Yeah... most of the time in mine too.

RubberDuck

17:45

But I don't want another job building ETL packages...... =(

I'd like to get just one call from someone looking for a .Net dev.

cheezsteak

17:57

@RubberDuck I can translate the markdown to docx at work. The links still goto github.com though. A script will need to replace those. Also need a way to order the files.

RubberDuck

@cheezsteak Really? Okay.. I think that's all doable.

Mat's Mug

@cheezsteak the bulk of the job is grabbing the content, right? if there's a way to generate the .docx without having to re-type all the content, I'm all for it. Can you email the .docx to rubberduckvba @ gmail?

cheezsteak

18:12

@Mat'sMug content is there. There must be some edits but it works.

Mat's Mug

nice

cheezsteak

91% ram usage....

Damn Haskell

Mat's Mug

wow

cheezsteak

I am also running win7 with only 3 ram and an too many apps.

I don't think it is entirely Haskell's fault. It is taking minutes to run tough..

Mat's Mug

sounds like my dev laptop (a whole 4GB RAM though)

cheezsteak

18:16

Its all good as long as you don't run out.

cheezsteak

18:27

This is taking entirely too long to run. I will need to run it on my desktop at home and see if it goes faster.

It could just be a windows/shtty machine issue.

Mat's Mug

18:47

thanks @cheezsteak! will check it out tonight! :)

cheezsteak

19:00

@Mat'sMug I sent a two file test. The full test still hasn't completed. Idk why.

Mat's Mug

@cheezsteak saw that? ^^

that's just a draft though

RubberDuck

19:15

@Mat'sMug Do you have any idea how long it took me to figure out that @Michal is @vba4all?

Mat's Mug

@RubberDuck probably as long as it took me ;)

cheezsteak

I suspected the they were the same because of the pictures and I had read his name before but it still took me a day or two

@Mat'sMug guess that means I should get off my ass and actually do something other than watching and commenting.

RubberDuck

Lol. At least it wasn't just me.

Mat's Mug

@cheezsteak lol it means thanks for watching and commenting and supporting! but you're welcome to get off your ass and actively contribute with code :)

RubberDuck

All jokes aside, we appreciate you @cheezsteak.

Mat's Mug

19:24

@RubberDuck SSIS question: I have my source on the left (66,873 rows), and my existing records on the right (163,840 rows). Does it makes sense to use a full outer join "Merge Join" component to sort out "NewOrExisting" vs "Deleted" rows? I'm at 423,948 rows in the join output, and it's still running....

> something's not right

it seemed to work fine for smaller data sets... have I completely fucked up my ETL?

RubberDuck

You would get much better performance with a few Where Exists / Where Not Exists me thinks.

Full outer joins are.............................................................................‌.................................................................................‌............................................. slow.

Mat's Mug

ok so I included a WHERE NOT EXISTS in my source... but now I need 3 separate data flows - one for inserts, one for updates, and one for deletions?

RubberDuck

@Mat'sMug Most likely. But that's not necessarily bad. You could probably run them in parallel.

Mat's Mug

right

RubberDuck

Issues might come if you could potentially get dupes. In that case, you might want to union them.

Mat's Mug

19:38

I don't think that can happen.. the NK is fairly simple: OrderHeaderId + OrderLineNumber

Phrancis

You should try.................................................
................................................
................................................ ................................................ cross joins.

RubberDuck

Ahhhhh good old Cartesian products.

Mat's Mug

@Phrancis that was the idea

Phrancis

> If you think you need a cross join ... you probably don't need a cross join.

2

Mat's Mug

worked pretty well on that simple one

RubberDuck

19:41

Is that 2012? jealous

Mat's Mug

2013

RubberDuck

Even more jealous

Mat's Mug

lol

@RubberDuck you just earned me a follower on Twitter!

RubberDuck

=;)-

I've been trying to coax him into writing a RD review.

Mat's Mug

he's following us

Simon André Forsberg

19:47

@Phrancis Has anyone ever needed crossjoins?

RubberDuck

I have. It was a legitimate need due to a bad schema design.

Phrancis

I've used them once or twice, mostly just for generating a whole bunch of data for benchmarking. Never actually "needed" cross joins :)

RubberDuck

Did I say bad schema design? I mean god awful third party vendor schema design...

2

Simon André Forsberg

If a schema is so bad it needs crossjoins, it really must be horrible.

Mat's Mug

well it occurred to me that if I made a cross join with the incoming against the existing data, I could kill 3 birds with 1 stone and use a simple conditional split to determine new, existing/modified and existing/deleted rows.

instead of using costy lookups

RubberDuck

19:52

I can't even say that really @SimonAndréForsberg. It was actually a pretty clever design. But ya know.. clever... 'nuff said.

Mat's Mug

turns out it doesn't work very well when you have 100K incoming rows

@SimonAndréForsberg but... it's an ETL process!

Simon André Forsberg

@Mat'sMug ETL?

Mat's Mug

Extract-Transform-Load

Simon André Forsberg

@RubberDuck clever as in overengineered?

aha

Mat's Mug

building a data warehouse...

RubberDuck

19:58

@SimonAndréForsberg I don't know if I'd call it over engineered. Just clever and not so obvious. Something I might have done for internal use, but never in an API I'm handing out to customers.

Hey @Chrismas007!

Chrismas007

@RubberDuck Damn... So much for being sneaky

3

:P

Mat's Mug

lol

hi @Chrismas007

@rbu

bleh

@RubberDuck so I have the "inserts" one, with WHERE NOT EXISTS

Simon André Forsberg

@RubberDuck erhm.... perhaps something I would make. skiwi is telling me that Cardshifter is not obvious and hard to make mods for and stuff.... (seriously though, making a really moddable TCG is hard stuff)

Transcript for