Click here to Skip to main content
15,887,027 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionIs a separate view model relevant for Blazor server side given that we can test the whole component with bUnit? Pin
Mr Yossu25-Feb-24 5:38
Mr Yossu25-Feb-24 5:38 
AnswerRe: Is a separate view model relevant for Blazor server side given that we can test the whole component with bUnit? Pin
Gerry Schmitz25-Feb-24 10:06
mveGerry Schmitz25-Feb-24 10:06 
GeneralRe: Is a separate view model relevant for Blazor server side given that we can test the whole component with bUnit? Pin
Mr Yossu26-Feb-24 3:37
Mr Yossu26-Feb-24 3:37 
GeneralRe: Is a separate view model relevant for Blazor server side given that we can test the whole component with bUnit? Pin
Gerry Schmitz26-Feb-24 4:43
mveGerry Schmitz26-Feb-24 4:43 
GeneralRe: Is a separate view model relevant for Blazor server side given that we can test the whole component with bUnit? Pin
Mr Yossu26-Feb-24 4:49
Mr Yossu26-Feb-24 4:49 
AnswerRe: Is a separate view model relevant for Blazor server side given that we can test the whole component with bUnit? Pin
jschell26-Feb-24 12:32
jschell26-Feb-24 12:32 
AnswerRe: Oh my goodness! Pin
Dave Kreskowiak24-Feb-24 4:38
mveDave Kreskowiak24-Feb-24 4:38 
GeneralRe: Oh my goodness! Pin
Gerry Schmitz24-Feb-24 4:42
mveGerry Schmitz24-Feb-24 4:42 
GeneralRe: Oh my goodness! Pin
Dave Kreskowiak24-Feb-24 5:53
mveDave Kreskowiak24-Feb-24 5:53 
QuestionC# How to populate datagridview from a separate combobox selection Pin
mourad barsoum22-Feb-24 12:57
mourad barsoum22-Feb-24 12:57 
AnswerRe: C# How to populate datagridview from a separate combobox selection Pin
Gerry Schmitz23-Feb-24 7:40
mveGerry Schmitz23-Feb-24 7:40 
AnswerRe: C# How to populate datagridview from a separate combobox selection Pin
Vrend Top11-Apr-24 1:13
Vrend Top11-Apr-24 1:13 
GeneralRe: C# How to populate datagridview from a separate combobox selection Pin
RedDk11-Apr-24 8:11
RedDk11-Apr-24 8:11 
QuestionTop 100 algorithm Pin
mike741120-Jan-24 10:39
mike741120-Jan-24 10:39 
AnswerRe: Top 100 algorithm Pin
Richard MacCutchan29-Jan-24 4:21
mveRichard MacCutchan29-Jan-24 4:21 
AnswerRe: Top 100 algorithm Pin
Pete O'Hanlon29-Jan-24 4:34
mvePete O'Hanlon29-Jan-24 4:34 
Questionuser data system for a web-based e-mail service Pin
mike741115-Jan-24 2:04
mike741115-Jan-24 2:04 
AnswerRe: user data system for a web-based e-mail service Pin
Richard MacCutchan15-Jan-24 2:25
mveRichard MacCutchan15-Jan-24 2:25 
AnswerRe: user data system for a web-based e-mail service Pin
jschell15-Jan-24 4:12
jschell15-Jan-24 4:12 
AnswerRe: user data system for a web-based e-mail service Pin
Eddy Vluggen16-Jan-24 5:00
professionalEddy Vluggen16-Jan-24 5:00 
mike7411 wrote:
Let's say you don't want to use a SQL database, but you want to create a user data system for
I disagree with the previous answer and would like to hear why no SQL database, as that makes no sense at all.

I'm guessing that the "want" comes from a manager who considers MS SQL to be the only existing DB server and doesn't like the pricing. Well, simply use an Open Source SQL implementation. An SQL Server is not limited to the MS implementations.

They're optimized to store and retrieve (relational) data from a large store, and unless you want to implement a DAL yourself with indexing capabilities, constraints (like a primary key, alternate keys, non-empty constraints etc.), think about security and access rights, and a "Structured Query Language" to interact with your DAL, whilst free ones exist and the SQL language can be learned "for free" with books and sites dedicated to it - basically recreating a SQL server, you'd simply use the ones that already exist and cost you nothing. They will have less bugs than any new storage-layer you can come up with, and have a lot more manhours invested in them than your company can provide. Those are simply facts.

You use what is the most appropriate, effective and efficient; or would you choose to write a Operating System even, if there's an unexplained "want"?

Also, you do not store a password, you store a hashvalue of the password. Otherwise any employee with access to the system can dump a textfile with username/passwords on the internet.

mike7411 wrote:
What kind of data structure should you use?
A table in an SQL-capable DB server.

Treat your manager like a non-technical user; if they "want" something, it has a reason and it is not always to be taken literally. You as the technical person should find out what they exactly want, why and explain the real cost and possible alternatives. This is required as "wants" and "needs" are not the same thing, and involve "costs" that a non-techie might not see. Why would anyone NOT want a FREE DAL that's well tested, well documented, in favor of creating their own?

While I'm at it, one of the columns is called "alternate email address", implying that "address" isn't an "address" but an email-address. Be specific, it makes it much more clear what you mean and removes confusion. Alternate email-address are usually not stored. Also, since you mention it is for an email-server I'd expect a table with messages, referencing that little structure you mentioned using the PK (prolly username) and another table with "attachments" stored that holds a reference to which message it is part of.

Aw, and if you really must explain this to a non-tech person, then take your time to rephrase it to be less blunt than I am in this post. Good luck with your adventure Thumbs Up | :thumbsup:
Bastard Programmer from Hell Suspicious | :suss:
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: user data system for a web-based e-mail service Pin
jschell17-Jan-24 4:24
jschell17-Jan-24 4:24 
GeneralRe: user data system for a web-based e-mail service Pin
Richard MacCutchan17-Jan-24 5:33
mveRichard MacCutchan17-Jan-24 5:33 
GeneralRe: user data system for a web-based e-mail service Pin
RedDk17-Jan-24 8:24
RedDk17-Jan-24 8:24 
GeneralRe: user data system for a web-based e-mail service Pin
Richard MacCutchan17-Jan-24 22:55
mveRichard MacCutchan17-Jan-24 22:55 
GeneralRe: user data system for a web-based e-mail service Pin
RedDk18-Jan-24 8:08
RedDk18-Jan-24 8:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.