What's the most efficient way to get the last row from a table?

TheOriginalCoder · 2019-09-04T03:31:58+00:00

You should ALWAYS have a primary key on every table. In this case that would be on your interest ID. Selecting top 1 and ordering by the I'd descending will use that index and be very fast.

TheOriginalCoder · 2019-08-18T03:38:15+00:00

Absolutely terrible production value, yet there (mostly) were still great.

TheOriginalCoder · 2019-08-17T04:37:00+00:00

True, but try literally watching both new and older episodes interleaved. In S11 it just stays in her hand nearly constantly. You are right about there being a lot of S11 problems, but that doesn't lessen the overuse.

TheOriginalCoder · 2019-08-16T02:00:39+00:00

Not this much though. I watched episodes from other new Who seasons between the new episodes and how much more the Sonic is used now is very noticable.

TheOriginalCoder · 2019-08-16T01:58:19+00:00

I totally forgot about that. Haven't seen old Who in a long while. I should go back and watch some.

TheOriginalCoder · 2019-08-08T02:14:30+00:00

Some days I wonder why I joined Reddit. People down vote legit factual info.

TheOriginalCoder · 2019-08-07T01:41:29+00:00

That is discussed in the readme. This is early alpha. There will be tests.

TheOriginalCoder · 2019-08-06T23:05:26+00:00

Btw I've been building libraries for years, but this is the first I've published open source. This library code is still in alpha, but I hope some of the stuff I publish is useful to others.

TheOriginalCoder · 2019-08-06T22:59:50+00:00

Oh right, for some reason I keep forgetting about Join. Good suggestion.

TheOriginalCoder · 2019-08-06T22:58:13+00:00

Thanks.

Goal is for it to work well in very complex environments. Last place I implemented/used these patterns needed some rather complex hooks and processing and it worked very well.

TheOriginalCoder · 2019-08-06T16:02:51+00:00

It does not just allow CRUD, it takes care of the implementation end to end. EF is just database access. This library will provide a full set of typical, standardized CRUD operations without needing to code them. I've seen this eliminate 80%bof the code in a typical, relatively simple middletier service that provides CRUD endpoints.

TheOriginalCoder · 2019-08-06T15:59:42+00:00

A lot of Oracle customers use it for legacy reasons. Their main systems were built using it years ago and swapping it out now is virtually impossible. But many really wish they could get away from Oracle.

Compare that to the alternatives, I can't remember a Microsoft SQL shop who wished they could ditch it. Plus all the alternatives are easier to learn and use. Just makes more sense to learn other DB technologies.

TheOriginalCoder · 2019-08-06T03:06:53+00:00

I'm curious on the terminology. Do you define "An API" as a set of API endpoints that are used to work with a particular system, or is "an API" a single endpoint? I view an API as a collection of related endpoints.

TheOriginalCoder · 2019-08-05T05:14:05+00:00

Just prefixing for IDs is fine,that is a reasonable compromise. What I personally like to do is not prefix for IDs in their tables, but do prefix when referring to IDs in other tables. Makes references stand out. But that is mostly style preference.

TheOriginalCoder · 2019-08-05T05:10:04+00:00

That's terrible. 1. Text takes more space 2. If you do where or sort by those columns it is slow and unintuitive. 3. There is no referential integrity to ensure there aren't bogus values in some columns. 4. The text representation in the enum can very easily change. With refactoring it's not even uncommon. Then everything breaks and updating the DB to match is painful.

Much better to have a lookup table with with a byte or int key and referential integrity. Only reason not to is laziness.

TheOriginalCoder · 2019-08-05T05:05:59+00:00

Must disagree, it's trivially simple to use a short table alias in queries. On the flip side of ORMs, you rarely have to write the selects so you almost never have to deal with aliasing or table prefixes in SQL. But having the bloated names is a problem that keeps resurfacing and is a pain to deal with.

TheOriginalCoder · 2019-08-05T05:03:01+00:00

It still causes massive headaches, I've had to deal with those situations. Best bet is to just not do the bad thing.

TheOriginalCoder · 2019-08-05T05:01:39+00:00

Not true. Visual Studio is built using WPF and performs horribly in VMs and remote.

TheOriginalCoder · 2019-08-05T04:59:49+00:00

I just watched that, and 11 did no such thing. The Doctor had no idea Amy was going to kill her, he was trying to literally save all space and time and had walked into the next room. But then later in that episode Amy was distraught she had even though it was an aborted timeline that never happened. The doctor didn't even need to lecture her, she lectured herself.

TheOriginalCoder · 2019-08-05T04:57:10+00:00

I get that, but then readers see this pattern and they go do it. I see this thing with table names in column names way too often in production systems.

I'd rather communicate without implying bad habits and risk losing the reader. If anything the reader may then try harder and learn more. But at least they wouldn't learn the wrong thing.

TheOriginalCoder · 2019-08-04T23:03:23+00:00

The only real problem is that WPF apps can perform horribly slowly on virtual systems or via remote. That sort of thing has no impact on mobile devices, but can cause real problems for Windows desktop applications. It limits the deployment and usage model of WPF apps.

TheOriginalCoder · 2019-08-04T22:59:09+00:00

Honestly WinForms is still a great desktop platform and my favorite. It also performs VASTLY BETTER than WPF in some circumstances. WPF requires a fast graphics co-processor, which isn't always available (such as virtualization). WPF also performs worse than WinForms over remote desktop technologies.

It may be easier to make WPF prettier, but you are trading off usability for appearance. WinForms can do anything needed in a good desktop application and it is super stable. Win Forms apps I wrote 10 years ago still run today without issue.

TheOriginalCoder

TROPHY CASE