[DiscordArchive] not seeing anywhere for a suggestion. do you want me to open it as an issue?
[DiscordArchive] not seeing anywhere for a suggestion. do you want me to open it as an issue?
Original source
not seeing anywhere for a suggestion. do you want me to open it as an issue?
rektbyfaith
11-10-2020, 08:46 PM #1Archived author: DrtyByt • Posted: 2020-11-10T20:46:23.246000+00:00
Original source
not seeing anywhere for a suggestion. do you want me to open it as an issue?
Original source
ye
rektbyfaith
11-10-2020, 08:46 PM #2Archived author: Barbz • Posted: 2020-11-10T20:46:31.288000+00:00
Original source
ye
Original source
there isoption
rektbyfaith
11-10-2020, 08:46 PM #3Archived author: Barbz • Posted: 2020-11-10T20:46:36.914000+00:00
Original source
there isoption
Original source
btw there are also so many times we needto do select join
ex, find name of creature guid 999 (need to join creature_templte)
i always felt like we could have "views" (not really used any before myself though) to avoid rewriting the query over and over, dunno if possble
rektbyfaith
11-10-2020, 08:47 PM #4Archived author: Barbz • Posted: 2020-11-10T20:47:27.512000+00:00
Original source
btw there are also so many times we needto do select join
ex, find name of creature guid 999 (need to join creature_templte)
i always felt like we could have "views" (not really used any before myself though) to avoid rewriting the query over and over, dunno if possble
Original source
yeah, that's a good way to do things like that, if it's simple data return views work. but most of the time if you are creating a semantic layer then you want to use stored procedures. The reason for this is complex rules can be added to a stored procedure, but a view always has to return the same "columns" of data
rektbyfaith
11-10-2020, 08:49 PM #5Archived author: DrtyByt • Posted: 2020-11-10T20:49:21.289000+00:00
Original source
yeah, that's a good way to do things like that, if it's simple data return views work. but most of the time if you are creating a semantic layer then you want to use stored procedures. The reason for this is complex rules can be added to a stored procedure, but a view always has to return the same "columns" of data
Original source
it really just comes down to what you really need whether to use a view or a sproc
rektbyfaith
11-10-2020, 08:50 PM #6Archived author: DrtyByt • Posted: 2020-11-10T20:50:55.358000+00:00
Original source
it really just comes down to what you really need whether to use a view or a sproc
Original source
gonna create a label "refactor" lol
rektbyfaith
11-10-2020, 08:52 PM #7Archived author: Barbz • Posted: 2020-11-10T20:52:01.064000+00:00
Original source
gonna create a label "refactor" lol
Original source
cause we need it
rektbyfaith
11-10-2020, 08:52 PM #8Archived author: Barbz • Posted: 2020-11-10T20:52:03.762000+00:00
Original source
cause we need it
Original source
still not finding anywhere to make a suggestion on either the wiki or the github, only thing coming up is to create issues or a PR
rektbyfaith
11-10-2020, 09:05 PM #9Archived author: DrtyByt • Posted: 2020-11-10T21:05:35.463000+00:00
Original source
still not finding anywhere to make a suggestion on either the wiki or the github, only thing coming up is to create issues or a PR
Original source
yes
rektbyfaith
11-10-2020, 09:06 PM #10Archived author: Barbz • Posted: 2020-11-10T21:06:07.504000+00:00
Original source
yes