« first day (2126 days earlier)      last day (61 days later) » 

12:01 AM
RELOAD!
[AndaraCodes/FleetCommand] 1 commit. 1 addition. 1 deletion.
[AndaraCodes/FleetCommandMapEditor] 1 commit. 8 additions. 4 deletions.
[Minesweeper] New Users: 28, Games Played: 177, Bombs Used: 98, Moves Performed: 19062
RELOAD!
[rubberduck-vba/Rubberduck] 14 commits. 7267 additions. 1310 deletions. 2 issues closed. 4 issue comments
 
 
2 hours later…
2:03 AM
Today I've learned a lesson: PageBreaks in Excel are not pleasant.
You weren't kidding Mug.
 
Sorry! =)
 
2:34 AM
More frustrating than anything. You were honest and warned me.
 
TBH, I think Office screwed the pooch when it comes to printing. I've never had a good experience with any Office product and printing.
And for that reason, I dream of a world where nobody has heard of "printer".
 
3:23 AM
> Yeah.... About those calculations we had you do. We found an error in the file. If you could run it again thanks mkay.
:sigh:
This do be why I have started building tools for any request. And programming to an abstraction and checking if that abstraction is valid.
Present-Iven takes longer to get it done. Future-Iven is happy that he does.
 
 
5 hours later…
8:10 AM
 
 
4 hours later…
11:45 AM
@IvenBach weird, I don't recall having had any significant issues with it.
Getting my functional source code from my Dev Access project into my Prod Access project and getting it to work. That's a different level of Hades.
No idea why this is fighting me so hard
 
 
1 hour later…
12:47 PM
Whew! Finally got the correct code into prod and it ran like a charm. Now, what the heck was I gonna work on yesterday morning when this production issue came up and prevented me from getting started?
 
 
1 hour later…
2:15 PM
sProc design question: I need to get 2 related counts from 2 different tables. As far as I can think at this time, I'll always need to get both of them at the same time (i.e., I don't think I'd need one without the other). Does it make sense to write 1 sProc that returns both numbers in order to minimize round trips to the DB, or does it violate the S in SOLID to have the sProc gather 2 different numbers that way?
Question still stands, but is now purely theoretical. A smidgen of investigation reveals that I do need to get the numbers independently, so I'll write 2 sProcs. Curious for future reference, though.
 
3:12 PM
SOLID doesn't really apply to the same extent to the realm of SQL and data querying. What are good ideas in imperative programming aren't necessarily so in declarative programming.
 
declarative programming...which focuses on what the program should accomplish without specifying how the program should achieve the result
Isn't that also true of imperative programming at some level?
Or is the distinction more complex than the intro paragraph of a wiki article?
 
3:41 PM
so you're saying, @this, that combining the 2 different fetches into one sProc is a reasonable thing to do?
 
3:56 PM
Hey... Is SE finally listening to the user base????
it's not all that dark, but it's certainly better!
 
4:17 PM
@theVBE-it'srightforme imperative is "do this the way I told you to do"
With FileOpen(FilePath)
  For i = 0 To File.Lines.Count
    Line = Files.Lines(i)
    If Line Like "*<foo>*" Then
       Do
         Print File.Lines(i)
         i = i + 1
       Loop Until Line Like "*</foo>*"
    End If
  Next
End With
Contrast to declarative, which can be executed imperatively:
Print XQuery.SelectAllNodes("//foo")
note that you put in an essentially magical string ("//foo") to execute the query. Same way with SQL.
@FreeMan #ItDepends but it is possible.
 
doesn't it always? :)
 
Better way to think about it is that you want to provide an API for your database. It doesn't necessarily mean letting them go in the guts and do whatever they want but rather present a model that meets the application's needs and allow the database to do the actual work of modifying the data, which could be spread across several tables.
 
huh... hadn't really thought about it that way, but it makes sense
 
There are essentially two approaches -- "thin database" or "fat database"
(they may have other terms)
with thin database it's just a dumb old data store. All the logic is in the middle layer somewhere.
with fat database, the middle layer (or even the client layer in 2-tiered architecture) is just calling the stored procedures and views (AKA the "API" of the database) and letting the database do the work via the stored procedures.
The thin database model will not work with a 2 layer architecture and absolutely requires a n-tiered architecture in order to abstract away the API.
But it does mean you can easily swap out one database engine for other since it's basically a CRUD thing
For me personally, I'd rather use fat database because that means we can rely on the guarantees that are provided in the databases itself (e.g. foreign key constraints, check constraints, whatever) to protect data integrity and it works with both 2-tiered and n-tiered architecture but that's just me.
 
"thick database" sounds much more PC. I prefer "fat database"
OK, yeah, I remember you saying something about this a few years back.
At this point, I'm klnda transitioning from thin to fat
not necessarily in a well thought out, coherent API kind of way, but starting to put more of the logic into sprocs to enforce it there. (For example, when I pull survey responses, they have to be from a given appointment date range, and completed within 10 days of the end of that range. The sproc accepts the appointment date range, but computes the max completed date on its own so I don't forget that part of it.
 
4:52 PM
Well I just updated Issue #5442 because it's only happening on one of my PCs. Now I'm completely stumped as to what is causing RD to fail to produce Code Inspections. Why would this only happen on some computers?
Parsing completes, the toolbar says "Ready". The code inspection window has the spinning ducks, never shows results. Access is hammering the CPU with 50% usage continuously. I've let it run for a long time. It never finishes
Plus, it only happens on big projects. RD works fine on smaller code bases....
Such a strange issue.
It's better today, in the newer version. I can at least close Access with the close button. I don't need to force quit
Any ideas for how I could peek in to what is happening here?
Ok, I'm running ProcMon and capturing a parse
It's kinda crazy to watch, if you've never done this
wow, when the parse completes I see it write the final entries in the log and then the whole thing gets quiet. The CPU is cranking but Access isn't actually doing much
There is a shockingly high volume of registry activity towards the end of a parse. Is that something RD does or is Access just doing that?
 
5:24 PM
registry?
example?
could be for the add/remove references but hopefully not at every parse...
 
5:55 PM
@FreeMan DarkReader browser addin has been amazing for me.
 
@this Looks like Access just hammers the registry all the time. I don't think it's RD
 
@IvenBach oh yes. I've been using that for quite some time. I'm pretty sure it was someone here (maybe you?) who mentioned it. I quite love it, actually! (slows down browsing on occasion, but it's better than burning out my eyeballs!)
It's just nice to see SE actually bringing about changes people have been asking for. Even if it's too little, too late.
 
6:13 PM
SE worker1: We're hemorrhaging users. What do we do?
SE worker2: How 'bout add a  feature?
SE worker3: Yeah. Users love features. Look at Facebook!
SE worker1: Thus we have solved problems with ---DarkMode--- DorkMode.
:derp: markdown morkdown doesn't work with code blocks...
 
one of the advantages drawbacks of code blocks. ;)
 
7:06 PM
@IvenBach I like dark modes thank you xD
I don't trust SO the company at all anymore, but imo they seem to actually be doing a good job for whichever kind of person is still on the fence.
Teresa seems to be doing better than could be hoped even though (I expect based on history) that she'll eventually be kneecapped or her efforts will be abandoned/forgotten.
I'm currently waiting for codidact to get rolling, they're going to need awhile.
@IvenBach It's no surprise, but I did learn a lot more about not only async/await but also Task.Run(() => YourMethodHere) after I last talked to you, and feel confident that I have the basics down on when you should use async programming vs when you should delegate tasks to the thread pool, please feel free to hit me up about those topics if you ever get to use C# at work.
 
@puzzlepiece87 has codidact lost steam or going strong or what?
 
7:26 PM
@BigBen As far as I can tell it's doing just fine, just takes a lot of effort to get things off the ground. I stopped following day to day progress a few weeks ago, but when I last checked they were working hard on user authentication. There's been a lot of unavoidable spinup work. It's different from a project like this that basically started as Mat and RD and grew from there. They had a ton of contributors from the start, so they needed to sort out things like conventions, and to ...
... have group conversations about what off the shelf pieces they'd be using to put it all together, etc.
It's just a big big project.
 
yeah sounds like it
 
8:03 PM
@this Thin database for me. With whatever constraints are possble (difficult with KVP tables though), and sprocs only where they add significant perf.
There's some very interesting stuff happening in the middle-tier, actor model looks very promising. I'm just waiting on dapr to get to v1...
 
@puzzlepiece87 I’ll never be using c# for work. They are adamant about staying with Excel/VBA. Will keep you in mind for RD use or if I get an offer from a new place.
 
@IvenBach "they are adamant about staying with Excel/VBA" - yikes
 
8:19 PM
It's what they have used and know. The ability to update ad-hoc is viewed as a strength.
They don't realize it's a sarlacc pit.
 

« first day (2126 days earlier)      last day (61 days later) »