VBA Rubberducking

Duga

12:00 AM

RELOAD!

[Minesweeper] New Users: 8, Games Played: 71, Bombs Used: 40, Moves Performed: 8306

Duga

12:47 AM

[rubberduck203/VBEX] vipulkarkar starred us

2

Duga

2:41 AM

[rubberduck-vba/Rubberduck] Rovever starred us

2

FreeMan

11:07 AM

@mansellan very nice

Duga

2:18 PM

[rubberduck-vba/Rubberduck] revans611 opened issue #5551: JSON

> Ever thought about adding JSON support to Rubberduck? After all, C# makes all things possible. Right?

[rubberduck-vba/Rubberduck] revans611 added label enhancement to issue #5551: JSON

Duga

2:32 PM

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #5551: JSON

> In what ways do you envision using "JSON support" in Rubberduck? What does that mean to you?

(BTW- there are new issue templates for requesting features that have some basic questions that will help guide the questions to provide the data needed to evaluate a new feature request.)

Duga

3:17 PM

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #5551: JSON

> Earlier versions (like, a year or two ago) shipped an experimental COM API that ended up dropped for lack of attention, and today Rubberduck ships with `Rubberduck.tlb` which can be referenced by VBA projects to early-bind the unit testing API.

Technically nothing(1) prevents us from building some COM-visible library that VBA projects could reference and consume, and indeed expose functionality such as a JSON serializer that could be given an object and spits out a JSON string, but then we'

[rubberduck-vba/Rubberduck] retailcoder closed issue #5551: JSON

[rubberduck-vba/Rubberduck] retailcoder reopened issue #5551: JSON

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #5551: JSON

> Earlier versions (like, a year or two ago) shipped an experimental COM API that ended up dropped for lack of attention, and today Rubberduck ships with `Rubberduck.tlb` which can be referenced by VBA projects to early-bind the unit testing API.

Technically nothing(1) prevents us from building some COM-visible library that VBA projects could reference and consume, and indeed expose functionality such as a JSON serializer that could be given an object and spits out a JSON string, but then we'

Mathieu Guindon

json = Rubberduck.Framework.Json.Serialize(thing)

gotta admit that could be slick

lots of work though, and probably better off as its own project/repo

this

^ creating a VBA framework library is something completely different from a VBIDE tool

I kind of see why Microsoft decided to bundle .NET like that.

mansellan

3:38 PM

Yeah there's all kinds of cool stuff we could do with a VBA/6 framework (REST endpoints anyone?), but it's not really RDs core mission IMO

this

but the distribution alone is a big setback.

"hey, run my cool spreadsheet. uh, and you'll need this DLL, too"

FreeMan

If a SELECT TOP 1000 x, y, z FROM table takes minutes, either there is a massive amount of data, or there are no indicies on the WHERE clause columns.

I'm guessing it's the latter.

this

without any ORDER BY?

FreeMan

our EDW (as graciou$ly ho$ted for u$ by M$) is retardedly slow...

Nope, no ORDER BY

this

if you do a TOP with no ORDER BY, it should be fairly quick since it's basically "gimme the first 1000 records you found"

FreeMan

3:41 PM

2 minutes, 37 seconds to return 30 rows.

this

wtf

you probably are capped, more likely

FreeMan

SELECT TOP 1000 x, y, z FROM <myview>.database.windows.net WHERE...

like a really old rented mule

AFAIK, the View is just the table w/o Write/Update privs. (don't ask why...)

this

to clarify, the view only contains 30 rows in total?

FreeMan

No, the query returned 30 rows.

Which sounds horribly wrong...

this

and it's still returning more rows, right?

FreeMan

3:46 PM

no, actually, it should be 32 rows - somewhere I'm excluding 2 extra.

it's completed.

this

for all i know, the view might be doing something completely insane like joining 100 tables on expressions.

FreeMan

I used the select top 1000 to quickly get the basis of my query.

I really, really don't think it is.

a couple of months back, they had all the privileges on the views screwed up so we were instructed to SELECT x FROM domain.TableNameBASE instead of SELECT x FROM domain.TableName where TableName is the view name.

All I did was remove BASE from the query string to make it work with the view...

I really think it's CREATE VIEW TableName AS SELECT * from TableNameBASE

I think our DW is being run by a bunch of nincompoops who have as much qualification as I do to be paid DBAs

Mathieu Guindon

@this "wut you don't have Rubberduck? how can you get anything done! get that library, yesterday!"

FreeMan

SELECT Distinct x FROM TableName WHERE <same conditions> returned the same 30 rows in 2 seconds.

#BlameCaching

Mathieu Guindon

(i.e. If you're not a de-facto essential framework, act like one until people think you are)

this

3:53 PM

#Todo: Make a PATRIOTIC propaganda for the duck

"If you don't quack, you're a quack!"

BigBen

lololol

this

"Say No to freetext. Only winners quack."

"I want YOU for Rubberduck Corps!"

Mathieu Guindon

wtaf muricah

> Americans are dying after drinking hand sanitizer, CDC says

this

O_o source?

BigBen

#naturalselection

Mathieu Guindon

3:58 PM

ctvnews.ca/mobile/health/…

FreeMan

@MathieuGuindon Well, you gotta have something to wash down the Tide pods...

I was encouraging people to tap into the Mtn Dew stored up in the front of their car, but I don't think I had any takers.

BigBen

wow that took a dark turn

FreeMan

4:12 PM

I'm a little fed up with the mass stupidity that seems to be all the rage, world wide, right now.

FreeMan

5:10 PM

well... that hasn't happened in forever... I've got a ghost MSAccess.exe process...

this

who ya gonna call?

seriously, I've had it but I hadn't time to research why it's ghosting and blamed myself (I have another experimental add-in which might be a cause which is why I didn't report)

FreeMan

Yeah. I didn't even bother looking in the RD log.

It's been soooo long since the last one, and this wasn't the first run with a new build, so I'm chalking it up to the new Windows build they pushed last night/random chance/sunspots/#BlameMicrosoft

BigBen

5:26 PM

random chance/sunspots/comets/all manner of astrological phenomena

FreeMan

They got us all the way up to version 1909, not bad!

Last spring they updated one version newer than the one that was about to lose support...