TIL (about the Dark Arts of HTML)
-
TIL: a 13.1KB query is just too much for my reporting server. Access violation while preparing.
-
@boomzilla You are using MongoDB, aren't you ?
-
@TimeBandit LOL. It's Oracle, which handles the query find when I run it in SqlDeveloper. But somewhere in the report software, I suspect it's allocating a buffer of fixed size.
Though I also noticed that it's still using the v11 client against the v12 DB, so I'm hoping that upgrading the client (in process now) will solve this.
-
@boomzilla said in TIL (about the Dark Arts of HTML):
a buffer of fixed size
Sounds like Oracle alright.
-
@dkf said in TIL (about the Dark Arts of HTML):
Sounds like Oracle
Pretty sure it's not Oracle this time. I did determine that 4,607 characters is the maximum being passed to Oracle. So...time to stuff that all into a stored function.
-
I've fed oracle queries which were significantly larger than 12kb via the C OCI. Our schema population query is a file with several tens of kilobytes of SQL in one anonymous pl/sql block, and has always worked fine. And I wouldn't be surprised if some of our autogenerated queries were even larger.
-
@PleegWat Yeah, I was fairly certain that it was not an Oracle bug. I confirmed it at the oddly unspecific size of 4607 characters. The stored procedure is now working quite well. It's just more of a PITA to modify later.
-
@boomzilla Yeah, that is a weird limit. 4000 and 32kib are the magic ones in oracle. And whatever the limit of a lob field is - 4gib?
-
-
@loopback0 said in TIL (about the Dark Arts of HTML):
Yup, max LOB is 4 Gigglebytes.
Which means they've not upgraded their code to use the 64-bit file handle API.
-
@dkf said in TIL (about the Dark Arts of HTML):
Which means they've not upgraded their code to use the 64-bit file handle API.
In hindsight, the 4GB might just be 10g which is 10 years old.
edit: 10gR2 has a limit of between 8TB and 128TB, depending on block size.
-
@loopback0 8–128TB? OK, that means they've updated. Phew. (128TB for one
fileLOB doesn't bother me. That's a lot of data, enough that you'll also want to think very carefully about your network architecture if moving that around frequently.)
-
TIL in addition to the two crappy Zelda games for the CD-i with the terrible animations, there was a third one with live action recordings:
https://www.youtube.com/watch?v=3O_ZPR2q7cg
I wonder what the budget for this was?
-
@anonymous234 STEREO!
-
-
TIL Postgres by default inserts the value
'null'
which is different fromNULL
into a JSON column when you do an insert without specifying a value for that column.
that difference made me loss more time than i'm willing to admiy
-
TIL a company sued Warner Bros, claiming trademark infringiment, because they had a program called "Clean Slate", and in one of the Batman movies there was also a different (and entirely fictional) program with the same name.
-
@anonymous234 CD-i: the only gaming system more shitty than the Sega CD.
-
@boomzilla said in 🔥 Computer says no guacamole:
Like I've said many times, you have no ability to see things from other points of view.
Learned about this just this week:
edit: y u no onebox?
-
@blakeyrat said in TIL (about the Dark Arts of HTML):
CD-i: the only gaming system more shitty than the Sega CD.
Well, to be fair to them, it wasn't initially intended as a gaming system, AFAIK. But Phillips had those Nintendo licences from the botched SNES CD addon deal, and damn it, they were gonna use them!
-
TIL https://blogs.msdn.microsoft.com/oldnewthing runs WordPress
-
@ben_lubar What happened to "eat you own dog food" ?
-
@TimeBandit They needed some dog food… hence WordPress!
-
@dkf Also note the fact that it's served from a Linux machine (on Akamai).
Microsoft : we are smart enough to not use our product.
-
-
TIL Android has these two useful API calls: isUserAMonkey() and isUserAGoat().
-
@anonymous234 said in TIL (about the Dark Arts of HTML):
"Used to determine whether the user making this call is subject to teleportations."
Wait, what?
-
-
-
@anonymous234 said in TIL (about the Dark Arts of HTML):
isUserAGoat()
But can it tell you which door the user is behind???
-
@Onyx said in TIL (about the Dark Arts of HTML):
But can it tell you which door the user is behind???
No. That's what you use
isUserAMonkey()
for.
-
@Onyx Since the user is subject to teleportations, probably not.
-
@anotherusername said in TIL (about the Dark Arts of HTML):
"Used to determine whether the user making this call is subject to teleportations."
Filed under: Welcome to modern forum software
-
@aliceif Custard yam?
-
Instead of that old hack:
Array.apply(ignore_this, array_like)
I can do this:
[... array_like]
-
TIL that nginx is meant to be pronounced "engine X". Which is stupid and I never would have worked out myself. I've been misreading it for ages and always see it as "en gee nix". Either way, it's an awful name
-
@Jaloopa It seems like a reasonable pronunciation to me. I could also see "n-jinx", but you'd have to transpose the
in
to get "nix".
-
@anotherusername said in TIL (about the Dark Arts of HTML):
but you'd have to transpose the in to get "nix".
yeah, like I said I was misreading it. I still doubt more than a few percent of people read it as engine x just from seeing it written down
-
@Jaloopa said in TIL (about the Dark Arts of HTML):
I still doubt more than a few percent of people read it as engine x just from seeing it written down
Or thought it'd be spelled 'nginx' when hearing "engine x"...
-
@Jaloopa said in TIL (about the Dark Arts of HTML):
TIL that nginx is meant to be pronounced "engine X". Which is stupid and I never would have worked out myself. I've been misreading it for ages and always see it as "en gee nix". Either way, it's an awful name
Huh. I've been reading it as the one syllable, like a Vietnamese minx.
-
@Jaloopa said in TIL (about the Dark Arts of HTML):
Which is stupid and I never would have worked out myself. I've been misreading it for ages and always see it as "en gee nix
I've always assumed "en jinx." Which always struck me as a bad name.
-
-
TIL: ZZ Top's only beardless member is named Frank Beard.
-
Last night I learned about air casters (tl;dr: "cargo pallets with built-in hovercraft")
https://www.youtube.com/watch?v=uRql1fjZQf0
Apparently these exists since the 1960's, but I completely missed them until yesterday.
-
@anonymous234 said in TIL (about the Dark Arts of HTML):
TIL why nuclear fusion is "always 30 years away"
Basically because the serious money has moved on.
-
@Jaloopa said in TIL (about the Dark Arts of HTML):
TIL that nginx is meant to be pronounced "engine X". Which is stupid and I never would have worked out myself. I've been misreading it for ages and always see it as "en gee nix". Either way, it's an awful name
It's even more stupid for us non-english speaking people. These odd abbreviations always whoosh most of us.
-
@flabdablet That chart is missing hydro-electric power.
-
@TimeBandit said in TIL (about the Dark Arts of HTML):
missing hydro-electric power
Apparently that's not renewable. For raisins.
-
@dkf well duuuh. Water can't flow uphill back to the lake!
-
@dkf said in TIL (about the Dark Arts of HTML):
Apparently that's not renewable. For raisins.
If you use the water to grow raisins, then it's not available for generating power. Duh.