@Arantor said in Poll: Integration test database cleanup: @Benjamin-Hall fairly easy SQL query. SHOW VARIABLES LIKE 'innodb_file_per_table' If the answer is ON, you have files per table, if OFF you have the data in the ibdata monolith files. mysql> SHOW VARIABLES LIKE 'innodb_file_per_table'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | innodb_file_per_table | OFF | +-----------------------+-------+ 1 row in set (0.01 sec) Well, that's that.

@Benjamin-Hall FWIW, SQLite has stuff to work with JSON these days. (I've not used that stuff — my data model only requires storing the JSON and nothing else, as all the info I care about is in other columns — but I've read about it.) That might help you when you ingest stuff; you can put things into a table and process that to build your operational data model.

@Gąska Unless you're planning to make this into a hobby, it'll be a lot of pain for no real gain. My advice? Get a directional microphone, and a pre-amp with auto-squelch.

@PleegWat said in SQL - Updating current state to new state for complex relationships.: @dkf Don't the big engines generally also want to be consistent in case of power outages and the like? One solution which I know is used is journalling - for any write transaction: New and modified data is written to new data blocks. Changes which need to be made to existing data structures are written to the journal. The journal is committed. Changes to existing data structure are written. If the database crashes before step 3, the transaction is lost. Step 3 is atomic. If the database crashes after step 3, then on next startup the journal can be replayed, after which the transaction is retained and the database is in valid state. even if structures would have been in a corrupt half-written state due to the crash. I don't know how sqlite works though. If they keep data in memory until commit (rather than tentatively writing it to the data file) this would increase the IO load of the actual commit. My understanding is that the write-ahead log is something like this, while the old method copies the old data to a rollback journal, overwrites the main data, then discards the rollback data.

@Tsaukpaetra said in Turning a flat file into a PDF: @Unperverted-Vixen said in Turning a flat file into a PDF: @Gąska If the PDF was intended for humans to read, you’d be right. In this thread’s case, where it’s being sent directly to a printer, what’s the harm? PrInCiPlEs! cipie - Wiktionary, the free dictionary

@Bulb I've followed https://dev.to/bowmanjd/install-docker-on-windows-wsl-without-docker-desktop-34m9 and got it working. At least, at the hello world level. In my powershell session I have a function $DOCKER_DISTRO = "ubuntu" function docker { wsl -d $DOCKER_DISTRO docker -H unix:///mnt/wsl/shared-docker/docker.sock @Args } which works well enough (assuming I remembered to start the dockerd in my wsl ubuntu instance...)

@Karla said in SQL - easiest way to keep DRY: ETA: Oh you weren't asking me. I was like "Hrm, I think she's talking over me, but I'm not quite sure..."

@iKnowItsLame said in Nice charts 'cos <Enterprise> doesn't cut it?: yeah but what about Drilldown? Uh... @boomzilla said in Nice charts 'cos <Enterprise> doesn't cut it?: It definitely supports mousover / drilldown stuff. For instance: Highcharts Demos and Examples | Highcharts /and intercepting <drilldown> with <callout to someotherwebsite>? Uh...no clue. Such a thing never occurred to me. Are you just talking about linking to somewhere here?

@Gąska I figured we’d burn down JavaShite and see what we were left with in case there was something we did want to keep. Rust maybe.

For all those complaining about posting unhelpful things in a help thread: It wasn't unhelpful, since that (or equivalent) is actually something I have done in a dungeon. I consider the help request filled before that, so feel free to treat this as a regular thread.

Here's what I ended up doing: On the server side: Set up a cache in the user's session where I track the state of the document generation, started, complete or error. On the front end: Added an onclick handler that uses setTimeout to check on the status every half a second. Also, throws up a spinner so the user knows stuff is happening. When complete, just dismiss the spinner and life goes on. When there's an error, throw up the generic "An error occurred" stuff.

FWIW- you don't need the explicit string in there. The following works: Foo foo(baz_p); (std::string can be implicitly constructed from a char*.)

@MrL said in Reflection, interfaces, plugins, frustration: The worst thing about this is that exception tells you nothing, inner is exception null, etc. Reminds me of the same sort of issue in Java, where I once got a class cast exception saying that class couldn't be cast to itself (because of library instance confusion). I don't have that sort of problem any more (mostly because it was such a common problem that there's standard ways to work around it now, especially including the provided library scope of Maven and the use of careful examination of the version graph) but it was horrible the first time. I have no idea whether any of that rambling can really carry over into the C# world.

@dkf said in Solved: Android: Shell to Camera for WebView file upload: I bet you'll find that {Java.IO.File.Separator} is consistently /. Using the other way of doing it is verbosity for the sake of verbosity, given that this is definitely going to be running on Android (or an emulator) and not Windows directly. The extra verbosity obscures what might be going wrong. I seem to recall even windows accepts / as a directory deparator in most (though perhaps not all) contexts.

@Tsaukpaetra said in Dell Service Tag API bullocks (TechDirect?) (depreciated?): Fucking Dell, this shit is so old can it not be assumed the owner won't care it's no longer in their posession? Shit. Apparently not. Whelp, I guess this is end of line for my ability to help, I don't have any other dell products I can try registering with.

@Rhywden said in Appointment slots, DST, and me.: @Zecc Could also do: "Seconds since start of year" or something. Woof, not for most scheduleables unless you work for NASA. Bear close attention to dates relative to month-end vs start.

You had to do something like migrate a corrupt SVN repo into GitHub. A disgusting task which we would rather not admit, as an industry, still exists. The blagosphere has no use for a blagpost so sad, so hideous, or so fundamentally disquieting to a pure-modernist neophyte. Please detail this here.

@boomzilla said in Help with prepared statements: I admit that I haven't looked super closely here. Is the problem that _ is treated as a single character wildcard in LIKE? When I ran the select part of the query as SELECT CONSTRAINT_NAME FROM information_schema.table_constraints WHERE CONSTRAINT_NAME LIKE '%fk_overrides_status' I got back the __fk_overrides_status result I expected.

@Tsaukpaetra said in SQL Server and SSAS: Pretty sure everyone just uses the sa for that There's a bunch of levels of maturity here. Most don't need to go whole hog, but maturity level 0 will bite you in the ass, which was the point of bringing up this little factoid in the first place. Maturity Level 0 - Too many people are in the sysadmins role, and random people simply run SSMS and make jobs. Every time there's employee turnover, things seem to randomly break. These organizations probably assume the problems are due to sabotage. Maturity Level 1 - sa has an easy password that everyone knows. Everyone manages SQL Server by running SSMS and logging in as sa. Maturity Level 2 - sa has a complex password that is unique to that server and is regularly changed. People administer the server by running SSMS as sa via a privileged account management tool. Maturity Level 3 - sa is disabled and people have dedicated admin accounts. Only the admin accounts have sysadmin to the SQL Servers. This practice re-introduces the problem of needing to assign jobs to a system account. Maturity Level 4 - Jobs are built on non-production server, and scripted. The scripts are checked into a source code repository and some DevOps process runs the scripts in production.

@topspin said in Mismatched Windows SDK versions: you have to call delete/free on the same side you called new/malloc That's a very very good rule to have. You can usually get away without following it on non-Windows, but not always and it's not a good plan ever to break the rule. On Windows, it's absolutely critical that you follow the rule because having multiple heaps is more common there (due to the somewhat different way that memory allocation responsibility is distributed between the libraries in question).

@Benjamin-Hall your team owns your own databases???

Well, shit. So, my plan to just "compile DLLs on the Mac and set up Windows to consume them as a reference per configuration" did work in the IDE, but at build time, it calls codesign to replace existing signatures in the DLL and fails with a permission denied error. Looking online, the only suggestions I can find don't help. "Use automatic provisioning" didn't work. Most are talking about some framework called Flutter (which isn't what we're using). So, fall back to the Mac, and try it again, this time using the direct project reference, and it somehow also fails due to the same error but on the other framework file. I'm not sure how my testing app has it working for building on a device and now in the simulator without codesign issues but my actual production app project just don't work, even when effectively lifting the working project's csproj file over the production project's csproj file.

Thanks for the help everyone!

@Gribnit said in Too many pumps: Although many frameworks do drain the input stream surprisingly early Yeah. Maybe. I forget what I eventually resulted to.

@topspin said in Fantastic User Scripts and how to write them: I mean, even in a world that has a Chief Warlock of the Wizengamot they'd look at you like a lunatic if you called people a Scrum Master. Scrum Masters are Hookers. In rugby.

@dkf Yeah, AFAIK no multi-threading or anything like it in PHP. We use two workarounds in limited places: For dashboarding, each widget is fetched in a separate request from the browser. And graph rendering is done by shellouts to librsvg, which can be parallelised. No, we do not support browser-side svg rasterising yet.

But all this time it was actually a left Reebok Pump sneaker.

@loopback0 said in Building an SQL query to update a bunch of tables using data from each row of a separate table: I'd do it in SQL. Even MySQL 5.1 supports UPDATE with JOIN. This.

@Zenith said in What certificate(s) will help me land a decent programming job in 2021?: some sort of spam list that's called LinkedIn.

As Gribnit, Bernie, and topspin have pointed out, the best solution to this problem is a circular buffer (or a List<T> if you want to stick with the standard libraries and not have to write implementations yourself). I should point out that List<T> isn't a linked list at all - its backing storage (in the .NET Core implementation, at least, no guarantees about Mono) is an ordinary array that's dynamically resized when needed. If you don't want to roll your own implementation, it's probably better to use a List<T> and call .RemoveAt whenever the list is too large, rather than using a stack and undermining the JIT compiler's ability to understand what you're doing. If you want to avoid the overhead of .RemoveAt and dynamically resizing the backing array, I just wrote this implementation of a circular buffer in C#, to see how hard it would be. It uses a fixed-size array, and supports both stack and queue operations.

@remi said in GPL v3 for test code: I'm now trying to get the GPL app working (i.e. checking that it can actually achieve what I would like it to achieve) and if it does, up to the lawyers it is! An update to give some closure: I did manage to get the app working on my test data, which took a bit more work as expected as it claims to be fully compatible with industry-standard app, but of course when you dig into the details there are a few bits here and there that aren't the same. And most errors cause the program to coredump with no information Though to be fair, first I wasn't really expecting otherwise (I mean, if an open-source app was able to fully duplicate in a couple of years something that took several decades of development by teams of world-renowned specialists, and that costs hundreds of thousands of $/yr, that app would be way more popular than it is!); second it would be a tall ask to support everything when the manual for the other app is (I just checked) just under 3000 pages, and that's excluding all theoretical discussions (that part is another 1000 pages) or file formats (a measly 100 pages); and third the open-source app has a pretty comprehensive manual (well it's "only" 2000 pages, so you can tell there are some missing bits...) covering what they support and what they don't so at least I had something to look at. So yeah, it was a bit annoying, but I've seen worse. Up it went to the lawyers, and it seems all they really care about is having an entry in their list-of-approved-software, because as soon as I told them that I was not going to use the source code of the app itself in any way (i.e. modify it, or link with it), they waved me away saying they didn't care (I'm rephrasing, but that's the feeling I got).

@Vault_Dweller It's easier than you think. I do not know if any version of the Report Manager has the feature you are looking for, but the simple alternative is to render and deliver the report with a script. Here is an example: https://kohera.be/sql-server/emailing-ssrs-reports-on-a-scheduled-basis-without-using-subscriptions-or-attachments/

@Jaloopa said in ApplePay on the web not completing: @error said in ApplePay on the web not completing: @Jaloopa said in ApplePay on the web not completing: I'm developing on windows so apple pay isn't possible This is completely deliberate and completely artificial, and it's exactly the type of bullshit that made me abandon all things Apple. The API is built in to Safari. There are polyfills around but the small amount of effort I put into getting one to work didn't come to anything @Developer_Dude, can we get a sadboat option?

@xaade For an orchestrating unit like a top-level business service it can make sense to verify that it makes some specific calls. For a confined-scope unit like a controller it can make sense to verify even that it does not make other than certain calls. For other code behavioral testing gets useless sooner. In-out testing is the default for pure functions, not all units are pure functions. Your manager does not understand this better than you, unfortunately.

@boomzilla said in Aggregating data from unrelated tables in SQL: @Benjamin-Hall uh...going back and rereading your requirements...I'm not entire sure what you're looking for. What do you want the end result to look like? The question you asked was about having two different lists, but I think we're in the middle assuming some implementation as opposed to looking at what you actually need. Having said that, I might be able to give you the Oracle answer, but I think that would end up using some Oracle specific SQL that wouldn't help you. It seems that doing the following works: Define $subquery as SELECT user_id FROM blah where blah UNION SELECT ... Run SELECT COUNT(*) from ($subquery) AS fake_name --> This gives me an aggregate count, deduplicated. Then run a variant of $subquery with the table names in there and selecting COUNT(DISTINCT user_id) to print the individuals. Edit: I'm not so worried about peak performance since this is a 1x/week query on a relatively small data set, run manually.

@hungrier surprised there's not a plugin for that

@Zerosquare TIL, thanks. I'm a bit surprised that across the years MS didn't find any resources to fix that, but as Chen says, "the minus 100 points deficit" is a very apt image for how priorities go, so maybe not so surprising in the end. The Powershell at the end is interesting. If I ever find that I truly need to use zip (rather than tar.gz), I can always replace my invocation of tar by that one, so thanks also.

@bobjanova said in Call a function based on its type?: without requiring people to tightly follow an XSD which can be a pain. XSDs are as tight or as loose as you write them to be. Filed under: But actually producing them is a PITA.

@Carnage said in A critical look at Marvel vs. Capcom....: culling the idiots Definition of CULL to select from a group : choose… See the full definition 2 : to reduce or control the size of (something, such as a herd) by removal (as by hunting or slaughter) of especially weak or sick individuals also : to hunt or kill (individuals) for culling

@izzion said in List marker alignment - CSS: @boomzilla said in List marker alignment - CSS: @error or tell users to live with it. Always my preferred response to CSS bugs features Well whaddaya know, that's the CSS committee's favorite too!

TV Tropes said in https://tvtropes.org/pmwiki/pmwiki.php/Main/LampshadeHanging : ­Lampshade Hanging ­The Order of the Stick hangs a lampshade on Lampshade Hanging with a literal lampshade.Sir Toby Belch: Is it possible? Fabian: If this were played upon a stage now, I could condemn it as an improbable fiction. ­— Shakespeare, Twelfth Night, Act 3, Scene IV ­Lampshade Hanging (or, more informally, "Lampshading") is the writers' trick of dealing with any element of the story that threatens the audience's Willing Suspension of Disbelief, whether a very implausible plot development, or a particularly blatant use of a trope, by calling attention to it and simply moving on. ­This assures the audience that the author is aware of the implausible plot development that just happened, and that they aren't trying to slip something past the audience. It also assures the audience that the world of the story is like Real Life: what's implausible for you or me is just as implausible for these characters, and just as likely to provoke an incredulous response. ­The creators are using the tactic of self-deprecatingly pointing out their own flaws themselves, thus depriving critics and opponents of their ammunition. The Turkey City Lexicon refers to this flavor of Lampshade Hanging as a "Signal from Freud", and reminds the author that if your characters are complaining about how stupid the latest plot development is, maybe your subconscious is trying to tell you something. ­On the other hand, Lampshade Hanging done well can make for an entertaining piece of Medium Awareness or momentary lack of Genre Blindness. It can also be used to take care of Fridge Logic, without having to actually do anything. For this reason, it can either be seen as making a bad movie even worse or as adding clever writing and humour. ­This practice is also known as "hanging a clock on it", "hanging a lantern on it", or "spotlighting it". In the film industry it's sometimes called "hanging a red flag" on something, after the screenwriting adage, "To hang a red flag on something takes the curse off of it," meaning that to lampshade something decreases the negative effects it might otherwise have. Teodolinda Barolini referred to this as "the Geryon Principle" in reference to how Dante narrates how unbelievable his "true" story is the more fantastical it gets. We went with our title because it's the one used in the Mutant Enemy bullpen. ­Can also be combined with a Hand Wave, sometimes invoking an unreveal, to make explaining a plot inconsistency unnecessary. When breaking internal consistency is deliberate this trope can be used to show that, yes, it is deliberate instead of a plot hole. Can also be combined with an active attempt to avoid the trope, in which case the Lampshade Hanging turns into a Defied Trope. ­Commonly seen in the self-aware shows that make up the Deconstructor Fleet; rarely used in the presence of a Drop-In Character. If large numbers of lampshades are hung, then the writers believe lampshades are Better Than a Bare Bulb, this trope's Logical Extreme. ­Hypocrisy Nod and Inspiration Nod are specific types of this. Meta Guy is the fellow who does this all the time. Sometimes takes the form of This Is the Part Where.... Compare Discussed Trope, Postmodernism and Playing with a Trope. No Fourth Wall happens when characters not only discuss tropes, but the writers as well. ­Not to be confused with Lampshade Wearing. ­Once again, Lampshade Hanging is when attention is drawn to something that is so strange it threatens to break the Willing Suspension of Disbelief. Leaning on the Fourth Wall is for things which make sense in the story but also have a second meaning outside of the story. Try not to get these confused.(via https://tvtropes.org/pmwiki/elastic_search_result.php?new_search=true&q=lampshade+hanging&page_type=all)

@dkf said in Amazon Athena Source Control: @dangeRuss said in Amazon Athena Source Control: it doesn't recognize what is a view vs table If you're just querying it, why do you care? (Updates would be something else, but mapping them back to the datasources would be crazy-hard so I expect them to be not supported.) I would like to edit it sometimes. Maybe even version control it.

@hungrier said in Html outline formatting: quite simple This is CSS we're talking about here.

@boomzilla said in Inner width on iOS: But using Safari as a search term I found this: iOS return bad value for window.innerHeight/Width I'm using window.innerHeight and window.innerWidth instructions to get the browser's available window size. It's working with firefox, safari (on a mac) and android but I get strange results in iO... I'm told that this works on Safari Safari but that on other browsers things like scrollbars mess it up.

@sockpuppet7 said in Can I trust the order of parameter execution in C# function calls?: @Watson said in Can I trust the order of parameter execution in C# function calls?: and the overhead of unwrapping the thunk would count toward the timing If you need to measure something to the nanosecond, you probably want to execute it many times in a loop I didn't say it was a big problem...

@Zenith said in PowerShell parameter passing with named parameters?: @TheCPUWizard said in PowerShell parameter passing with named parameters?: requires a change in mind set That's great but I can neither control which version of PowerShell launches by default nor install any other way to read that Excel spreadsheet. I was referring to a change in how YOU think. What is considered "Good" (and what is now), among many other things... It is hard (trust me, I know) to put aside years/decades (a Quadragenarian career of thoughts)... But when changing context (another place where this is true is moving from .Net 4.x to.Net 5.0) it can enable many things, and a failure to do so can inhibit them.

@dkf you can separate the pointer to the member function from the instance pointer and use it on different instances. If you have a whole bunch of instances to apply it to, you only need one pointer. Also, it’s just a thin, leaking abstraction over its C implementation, treating the this parameter as if it was explicit. If you want a bound pointer, you can build it from that, but not the other way around.

@HardwareGeek OP's problem is solved, trolling is okay now. But why do you think that telling people Java sucks is trolling? You're just stating the facts

Thanks for the advice. I ended up adding a special rate limit for the login API and a different rate limit for the rest. If the request comes from a logged in user then the limit is per session otherwise it's per IP.

@Jaime said in &#x60;docker-compose up&#x60; vs. &#x60;docker compose up&#x60; with environment variables: Of course the answer is "yes". I think you were looking for