The Official Status Thread
-
@Zenith said in The Official Status Thread:
People that write their entire app in SQL without a good reason should also have their hands sawed off.
Oh, that song! I know all the lyrics!
It lets us use the same logic in different applications -- even though there's only ever one application, usually named "Excel"
It's more secure since you can only make changes through authenticated, secured calls to known procedures -- except we don't actually enforce that, and it'd be equally insecure with a front end in front of it, not that we use role-based security or even integrated authentication anyway...
It's more betterer because changes must go through the Sacred Order of Database Administrators, rather than the Pontificate Order of Programmers. Praise be to the process.
That's "the way enterprise development is done". Which ... it isn't. Not without a bunch of other stuff.
-
@TwelveBaud said in The Official Status Thread:
Some of the worst code Xiph ever wrote.
Speaking of, I'm writing my own shitty ORM in PHP to replace a more copy-pastad set of hand-written PHP ORM from someone else.
I'm sure there will be no bugs.
-
@Tsaukpaetra is ORM really necessary? Is it really going to save any time over just sending raw queries?
-
@Gąska said in The Official Status Thread:
@Tsaukpaetra is ORM really necessary? Is it really going to save any time over just sending raw queries?
I'm already starting with a homebrew ORM that manually maintains an index table instead of actually using indexes, I think even if I break even the headache of troubleshooting things to the tune of "why can't I find this record" will be worth it.
-
@Tsaukpaetra said in The Official Status Thread:
manually maintains an index table instead of actually using indexes
butwhy.avi
-
@Gąska said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
manually maintains an index table instead of actually using indexes
butwhy.avi
Yeah I just locked my PC and went to bed when I discovered that.
-
@Gąska said in The Official Status Thread:
is ORM really necessary?
If you're schema-first (as you would be in any application where the database exists first) then the only real benefit to ORM is not having to write the gunk for converting a row of a result set into an application-side record. Alas, most ORMs assume that must match a concrete table. (Going the other way is mostly less of a problem.)
Admittedly, ORMs do more work for you when you're application-first (i.e., where they do the schema generation and migration) but that's more than a bit horrible if you've already got data. But I'd rather tell people to man up and learn SQL; the language isn't that hard. (Understanding your data model in the first place — which is a prerequisite whatever development model you follow — now that's the difficult bit!)
Migrating between SQL dialects is only a theoretical benefit. You're not gonna do that lightly, often because databases have many tricky aspects that are not captured by the ORM's mapping. If you ever do real migration of data, the project to do that will be big enough that you'll have plenty of time to learn the dialect differences.
-
@dkf said in The Official Status Thread:
the only real benefit to ORM is not having to write the gunk for converting a row of a result set into an application-side record.
Yeah, I've half done that already, and the application makes no assumptions about what object types there are anyways (it's written before classes were a thing in PHP).
-
@Gąska said in The Official Status Thread:
Status: Watching Psychonauts 2 speedrun. I finished this game on PC before, but this run is on PS5. And the loading screens are significantly longer than I remember. What was that about faster SSD?
Fuh fuh not fully utilizing PS5 fuh fuh port fuh comphleshon fuh, not UE5 fuh.
Yes, Sqny (and Xbox, too, but less), Tencent Timmy, greedy lying storage fucks and their streamer/"reviewer" gasbag friends have pulled so much wool over people's eyes that there should be a global wool shortage.
Observe:
Ramdisk (3600 CL16 CR1):
PCI-E 3.0 low-end:
6 years old U.2:
Guess three times from which device most games load more quickly.
-
@Applied-Mediocrity said in The Official Status Thread:
Guess three times from which device most games load more quickly.
The U.2, obviously.
Also, my RAMDISK must be broken, it's often just as slow as the slowest disk in the pagefile rotation for some reason...
-
@Tsaukpaetra said in The Official Status Thread:
Yeah, I've half done that already,
Alright, wrote 300 lines that should encompass a really basic concept of what a column is, what an index is, and describe a table such that it can automagically create it from collections of the preceeding. Oh, and should be able to create, update, and delete rows for the table, assuming you provided data in a sufficient way.
And in theory it should write to the
error_log
output if something goes wrong with any of that.Tomorrow I'll test it by attempting to run it....
-
@Tsaukpaetra said in The Official Status Thread:
The U.2, obviously.
Good call, but from what I have observed so far, within 10% margin of error, they're the same picture. Well, U.2 does sit on
ungimpedunpatched Krabby Lake...Also, my RAMDISK must be broken
the pagefile rotation
The what now?
-
STATUS I really can't do life today. Zero energy. I suspect I've caught some kind of ancient one lurgy.
On the bright side someone new and unexpected has something important to tell me!
-
@dkf said in The Official Status Thread:
But I'd rather tell people to man up and learn SQL; the language isn't that hard.
Hope you don't have to interview between now and retirement because every fucking place demands absolute and single-minded devotion to the Holy Entity Framework.
-
@Zenith said in The Official Status Thread:
every fucking place demands absolute and single-minded devotion to the Holy Entity Framework
Only the C# jobs will be like that. If you're dealing with Java, it's Hibernate and/or Spring.
-
@dkf said in The Official Status Thread:
If you're dealing with Java, it's Hibernate and/or Spring.
I'd rather hibernate until Spring than deal with Java.
-
Status: I've just been in the shop. Standing in the aisle for cosmetic products looking for shaving cream, I notice that it strongly smells like deodorant. Someone must have tested some bottles. Then I see a young boy, maybe 12 or early teen, walking up to me. Without a shopping cart/bag or carrying anything. He stands there, grabs a bottle and sprays himself top to bottom. Waits a second, seems not yet satisfied, and does it again. Then he puts the deodorant back on the shelf and just walks off.
I'm not sure how I feel about this. I think... impressed.
-
@Zenith said in The Official Status Thread:
@dkf said in The Official Status Thread:
But I'd rather tell people to man up and learn SQL; the language isn't that hard.
Hope you don't have to interview between now and retirement because every fucking place demands absolute and single-minded devotion to the Holy Entity Framework.
You should find NHibernate more to your liking.
-
@MrL Or Petapoco.
-
@TwelveBaud said in The Official Status Thread:
@MrL Or Petapoco.
He'll probably need pepto bismol soon.
status people are mixing and matching Java versions again.
-
@Tsaukpaetra said in The Official Status Thread:
I'm already starting with a homebrew ORM that manually maintains an index table instead of actually using indexes, I think even if I break even the headache of troubleshooting things to the tune of "why can't I find this record" will be worth it.
Was the index table at least indexed, by the way?
-
Yes, I know...
-
status Updating VS2019 from 16.11.4 to 16.11.5. Only 410M. But it's downloading at well under 100KB/sec. This is gonna take a while...
-
@dcon Using the Milwaukee mirror is it?
-
@Zecc said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
I'm already starting with a homebrew ORM that manually maintains an index table instead of actually using indexes, I think even if I break even the headache of troubleshooting things to the tune of "why can't I find this record" will be worth it.
Was the index table at least indexed, by the way?
Technically yes, by dint of the ID and Key columns being the primary key and the Value column getting an index as well.
-
@Applied-Mediocrity said in The Official Status Thread:
the pagefile rotation
The what now?
You know, that thing that gets put on the spinning rust. It spins and you read or write the bits of memory as you need it.
-
@MrL Why? What's different? Entity has alot of stupid problems.
-
@Zenith Entity is very Opinionated, which causes a few real problems as well as probably whatever you're thinking is stupid about it. NHibernate gets in your way a lot less, though it provides significantly fewer features as a result. Petapoco is basically "run this SQL query and deserialize objects of this type" with no LINQ and very few frills, which is why I think you'd like it -- it does exactly what you tell it to and no more.
-
@Tsaukpaetra said in The Official Status Thread:
You know, that thing that gets put on the spinning rust. It spins and you read or write the bits of memory as you need it.
Keeping the page file larger than the minimum required for crash dumps in this day and age should be a crime.
-
@Zenith said in The Official Status Thread:
@MrL Why? What's different? Entity has alot of stupid problems.
A lot more control, many ways of doing the same thing, etc.
@TwelveBaud said in The Official Status Thread:
NHibernate gets in your way a lot less, though it provides significantly fewer features as a result.
Huh? My experience with both of them is - Entity: "does most things in one way, just works", NHibernate: "does everything, tons of options, steep learning curve".
-
@Applied-Mediocrity said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
You know, that thing that gets put on the spinning rust. It spins and you read or write the bits of memory as you need it.
Keeping the page file larger than the minimum required for crash dumps in this day and age should be a crime.
But Windows wants mmooooorrreeee!!!!
Funny enough it is using the shittier SSD for the pagefile.
I'll fix all of this when I update to Windows 11 through a clean install...
-
@Tsaukpaetra said in The Official Status Thread:
I'll fix all of this when I update to Windows 11 through a clean install...
Famous last words.
-
@TwelveBaud said in The Official Status Thread:
As an alternative to the worst code Nullsoft ever wrote, also in 1998.
I'm not sure what the context is, but what did Nullsoft write that was so bad? As far as I'm aware they had two products:
- Nullsoft installer, which seemed to work ok
- Winamp, a masterpiece of software so perfect that after a couple decades without any updates, it's still the best music player for Windows
-
@Gąska said in The Official Status Thread:
What was that about faster SSD?
Remind me, what's that thing about believing anything Sony says about upcoming hardware?
-
@Tsaukpaetra said in The Official Status Thread:
@Applied-Mediocrity said in The Official Status Thread:
the pagefile rotation
The what now?
You know, that thing that gets put on the spinning rust. It spins and you read or write the bits of memory as you need it.
Are you that much of a technology masochist that, in the year of our Lord 2021, you put your page file on a spinning hard disk?
-
@hungrier said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@Applied-Mediocrity said in The Official Status Thread:
the pagefile rotation
The what now?
You know, that thing that gets put on the spinning rust. It spins and you read or write the bits of memory as you need it.
Are you that much of a technology masochist that, in the year of our Lord 2021, you put your page file on a spinning hard disk?
It's faster than the fucking S
SD-to-IDE adapter...
-
@Tsaukpaetra said in The Official Status Thread:
IDE
-
@hungrier said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
IDE
I'd be more than happy to use SATA but these laptops just don't feel like it.
You know what they also don't feel like? Physical Address Extension. Or No-Execute Bit. Apparently these are Mission Critical Features that Windows absolutely requires in order to even attempt to function.
-
@Tsaukpaetra said in The Official Status Thread:
IDE
@Tsaukpaetra said in The Official Status Thread:
Windows 11
-
@loopback0 said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
IDE
@Tsaukpaetra said in The Official Status Thread:
Windows 11
It's gonna work, I swear it's gonna work! It's gonna work just fine, you'll see...
-
@Tsaukpaetra if I ever see a report of someone robbing computer museums of ancient hardware, I’ll have a prime suspect.
-
@topspin said in The Official Status Thread:
@Tsaukpaetra if I ever see a report of someone robbing computer museums of ancient hardware, I’ll have a prime suspect.
The kind of computers that are in museums don't like me....
-
@Tsaukpaetra said in The Official Status Thread:
@topspin said in The Official Status Thread:
@Tsaukpaetra if I ever see a report of someone robbing computer museums of ancient hardware, I’ll have a prime suspect.
The kind of computers that are in museums don't like me....
Wait...there are computers that do like you? That's news to me.
-
@Tsaukpaetra said in The Official Status Thread:
@topspin said in The Official Status Thread:
@Tsaukpaetra if I ever see a report of someone robbing computer museums of ancient hardware, I’ll have a prime suspect.
The kind of computers that are in museums don't like me....
That’s a vacuous truth.
Fake edit: , of course.
-
@Benjamin-Hall said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@topspin said in The Official Status Thread:
@Tsaukpaetra if I ever see a report of someone robbing computer museums of ancient hardware, I’ll have a prime suspect.
The kind of computers that are in museums don't like me....
Wait...there are computers that do like you? That's news to me.
The ones I fuck with the most eventually come around...
-
@Tsaukpaetra said in The Official Status Thread:
Tomorrow I'll test it by attempting to run it....
Inital "Does simply loading the file" test done. Only 2 errors, and 7 forgotten
;
s. The first was a function that PHP removed (get_magic_quotes_gpc()
) and the other was a "you declared an abtract method in the class, but the class isn't marked abstract. You sure about that?"Now to see if it actually did anything (i.e. make the table)...
-
@Tsaukpaetra said in The Official Status Thread:
Now to see if it actually did anything (i.e. make the table)...
Aaannnddd... Aside from some MySQL syntax pebkacs with how I was generating the syntax (Apparently you MUST NOT specify the storage type of generated columns like NULL or NOT NULL?) it... worked just fine?
I'm pondering if I should continue under the assumption that things continue to be so bright and cheerful....
-
@Tsaukpaetra said in The Official Status Thread:
I'm pondering if I should continue under the assumption that things continue to be so bright and cheerful....
Yes
-
@MrL said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
I'm pondering if I should continue under the assumption that things continue to be so bright and cheerful....
Yes
I appreciate the vote of confidence. 😘
-
@Tsaukpaetra said in The Official Status Thread:
@MrL said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
I'm pondering if I should continue under the assumption that things continue to be so bright and cheerful....
Yes
I appreciate the vote of confidence. 😘
Yes... that's exactly what I meant.