Click here to Skip to main content
15,075,806 members
Home / Discussions / Database
   

Database

 
QuestionWHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 5:00
Memberremiki13-Sep-21 5:00 
AnswerRe: WHERE NOT EXIST QUERRY Pin
Richard Deeming13-Sep-21 5:58
mveRichard Deeming13-Sep-21 5:58 
AnswerRe: WHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 6:02
Memberremiki13-Sep-21 6:02 
QuestionDatabase programming Pin
Member 153534049-Sep-21 23:54
MemberMember 153534049-Sep-21 23:54 
AnswerRe: Database programming Pin
Richard MacCutchan10-Sep-21 0:27
mveRichard MacCutchan10-Sep-21 0:27 
QuestionHow to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Member 146377867-Sep-21 0:43
MemberMember 146377867-Sep-21 0:43 
Rant[REPOST] How to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Richard Deeming7-Sep-21 1:00
mveRichard Deeming7-Sep-21 1:00 
QuestionWhy not to use NoSQL instead of RMDBS? (not Mongo) Pin
Hopeless Idealist14-Aug-21 1:21
MemberHopeless Idealist14-Aug-21 1:21 
I can't understand why would you like to be forced to create another table for relations if you can just use smth like references in most languages. What is the point of such complexity?
I would rather type:
C#
companies.First(cmpn=>cmpn.Name="Netflix").Employees.Avg(empl=>empl.Sal)

then use relations:
SQL
select * from companies join company_employess on ... join ... group by.. avg

I found some NoSQL DBs like Couchbase and other alternatives but all the companies demand SQL-devs.
Why is it the way it is?
(I'm using ASP.NET 6 + Blazor)
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
Mycroft Holmes14-Aug-21 12:36
professionalMycroft Holmes14-Aug-21 12:36 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
jschell5-Sep-21 9:07
Memberjschell5-Sep-21 9:07 
QuestionSql query , comparing a table field to a list of values , condition (MS SQL) Pin
zira178929-Jul-21 15:32
Memberzira178929-Jul-21 15:32 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Richard MacCutchan29-Jul-21 21:15
mveRichard MacCutchan29-Jul-21 21:15 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Anand RB 20218-Aug-21 18:16
MemberAnand RB 20218-Aug-21 18:16 
GeneralRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
CHill609-Aug-21 23:23
mveCHill609-Aug-21 23:23 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
RedDk10-Aug-21 7:57
MemberRedDk10-Aug-21 7:57 
QuestionLooking for advice on key/value storage options Pin
Chris Maunder16-Jul-21 6:21
cofounderChris Maunder16-Jul-21 6:21 
AnswerRe: Looking for advice on key/value storage options Pin
Mycroft Holmes16-Jul-21 12:23
professionalMycroft Holmes16-Jul-21 12:23 
GeneralRe: Looking for advice on key/value storage options Pin
Chris Maunder16-Jul-21 16:11
cofounderChris Maunder16-Jul-21 16:11 
AnswerRe: Looking for advice on key/value storage options Pin
k505416-Jul-21 14:21
mvek505416-Jul-21 14:21 
GeneralRe: Looking for advice on key/value storage options Pin
Chris Maunder16-Jul-21 16:19
cofounderChris Maunder16-Jul-21 16:19 
AnswerRe: Looking for advice on key/value storage options Pin
Gerry Schmitz9-Aug-21 6:04
mveGerry Schmitz9-Aug-21 6:04 
GeneralRe: Looking for advice on key/value storage options Pin
Chris Maunder9-Aug-21 6:22
cofounderChris Maunder9-Aug-21 6:22 
QuestionOpen Office Database Pin
Bram van Kampen1-Jul-21 14:26
MemberBram van Kampen1-Jul-21 14:26 
AnswerRe: Open Office Database Pin
Richard MacCutchan1-Jul-21 21:04
mveRichard MacCutchan1-Jul-21 21:04 
GeneralRe: Open Office Database Pin
Bram van Kampen2-Jul-21 14:54
MemberBram van Kampen2-Jul-21 14:54 

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.