VBA Rubberducking

« first day (2054 days earlier) ← previous day next day → last day (1126 days later) »

Mathieu Guindon

9:05 PM

ugh, PK violation was throwing off the execution times... 10 minutes and counting...

Vogel612

9:16 PM

@Hosch250 nothing really comes to mind ...

Hosch250

OK.

I just got Postgre figured out on the commandline.

And now I need to figure out how to reprogram my Windows key to show all apps instead of all open ones :)

Phrancis

SQL fun I see

in Coding Projects and Twitter Heaven :), 3 mins ago, by Phrancis

Serious question for @ all who code: How often is object serialization (i.e. writing an object's current state to disk/database for later read) actually used in real life, business applications?

Anyone got an opinion? ^^ Specifically I'm in C#/.NET but in general too

Hosch250

Object serialization is used incredibly often, but not in the way you are thinking :)

I've seen it used most often in the bodies of web requests.

Also for Mongo DBs.

Both of those (usually) handle the serialization/deserialization automatically.

In a way, pretty much everything being sent through the network or saved on the disk is serialized or deserialized in some manner at least once--from the .NET POCO to binary and back.

Mathieu Guindon

@Phrancis does in-memory count?

Hosch250

But it's often it'll go to some other format before it goes to binary too.

Phrancis

9:25 PM

I suppose maybe I asked the wrong question. This series of exercises in Head First C# has me using System.Runtime.Serialization.Formatters.Binary; then writing it to disk in a .dat and that just seems like... why are we even doing this

Mathieu Guindon

so you know it's there when you need it

Hosch250

That ^

I've never been in a situation where I've used binary, but I wouldn't be surprised some day. I've used XML, JSON, and Base64.

Mathieu Guindon

RD uses XML serialization for settings

FreeMan

@Phrancis I need to get back to my copy... What edition are you using?

Hosch250

Overall, I recommend JSON most. It has the best support.

Phrancis

9:27 PM

@FreeMan 3rd

Hosch250

If you need flexible structure and are stuck with a SQL DB, use XML--most of them have a specific type for that and understand it pretty well.

I like the concept of YAML, but it's mainly used in the dev-ops world.

Phrancis

@Hosch250 Yuck, but agreed

(I've spent way more time with XML-SQL than I'd like to admit)

Hosch250

@Phrancis BTDT. Needed what amounted to metadata on a column, and XML worked well.

FreeMan

@Phrancis Same as what I've got. thx

Hosch250

It was only used for presentation, though--only the C# would ever use it.

FreeMan

9:29 PM

TTFN!

Hosch250

All DB-useful logic was pulled out into structured data.

Arguably it would need to be queried sometime, but I did my best. And I could always write a console app to query it if needed.

Phrancis

@Hosch250 Lucky. I had to use XQuery and hated it.

Hosch250

Yeah, I wouldn't do it normally.

base64 is mostly used for "hidden" URI parameters.

Where it's not a huge deal if someone opens it up, but it keeps the opportunistic attackers out and/or changes the structure so the server can understand the request properly.

Phrancis

So, in short—Serialization is used all the time, but usually not in binary?

Hosch250

Correct.

And in some places, it is used heavily in binary.

Mostly older systems.

Phrancis

9:42 PM

OK. Thanks for the splainer, really helps :)

Hosch250

9:55 PM

I feel like I'm really beginning to find my way around Linux. I guess having to configure all the things helps.

@Vogel612 Is there anyway to "dual-boot" desktop managers?

I'm curious to see what others offer, but I don't want to lose all my Gnome changes.

Vogel612

there should be, yes, but ...

I haven't tried

Hosch250

LOL, OK.

You run Cinnamon?

Vogel612

nah.

I run kde over sddm on arch

soo ... quite different

Hosch250

OK. I thought I heard you ran Cinnamon. Guess I was wrong.

Quack Exchange

Q: SQL to Excel then to CSV file for Data Upload

Before we get started I need to let you know a critical piece of information: Due to permissions within an offsite database I am NOT allowed to create tables even temporary ones within the database that I am getting the data from. With that being said: All of the code below works as expected, ...