Click here to Skip to main content
15,307,555 members

Welcome to the Lounge


For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 7:02
mvahoney the codewitch1-Nov-21 7:02 
GeneralRe: Bless SQL Pin
#realJSOP1-Nov-21 2:41
mva#realJSOP1-Nov-21 2:41 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 3:42
mvahoney the codewitch1-Nov-21 3:42 
GeneralRe: Bless SQL Pin
Greg Utas31-Oct-21 15:36
mveGreg Utas31-Oct-21 15:36 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 16:31
mvahoney the codewitch31-Oct-21 16:31 
GeneralRe: Bless SQL Pin
Jon McKee31-Oct-21 15:41
professionalJon McKee31-Oct-21 15:41 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 16:33
mvahoney the codewitch31-Oct-21 16:33 
GeneralRe: Bless SQL Pin
NeverJustHere31-Oct-21 16:42
MemberNeverJustHere31-Oct-21 16:42 
It's a shame you're targeting MS SQL, it is weak in many areas compared to other SQL offerings. Postgres supports regex natively, as well as having a bunch more capability with string manipulation functions.

Is there an option for you to use .Net assemblies in MS SQL, or perhaps the R or Python environments? It seems MS is ignoring extending the base SQL capability, but offering these extensions.

Regardless, kudos for the tenacity required to do what your doing.

How are you finding the performance of the regex proc's in SQL?

Also, remember SQL is designed way back, before syntax highlighting/intellisense and many other modern expectations that would influence its design were around.

It's time to create SQLNext, and I've seen the odd concept put forward, but it would be really hard to shift the masses now.

Perhaps it'd best be done with a translation from SQLNext to the various SQL variants.

But ideally would have to exist closer to the database than the client application and eventually become a native database feature. Unfortunately, would be easiest to place in the client application - I'd hate to get into any DB Driver level stuff. Remember ODBC - yuck.
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 17:34
mvahoney the codewitch31-Oct-21 17:34 
GeneralRe: Bless SQL Pin
honey the codewitch31-Oct-21 17:40
mvahoney the codewitch31-Oct-21 17:40 
GeneralRe: Bless SQL Pin
#realJSOP2-Nov-21 0:32
mva#realJSOP2-Nov-21 0:32 
GeneralRe: Bless SQL Pin
NeverJustHere2-Nov-21 17:58
MemberNeverJustHere2-Nov-21 17:58 
GeneralRe: Bless SQL Pin
#realJSOP2-Nov-21 23:55
mva#realJSOP2-Nov-21 23:55 
PraiseRe: Bless SQL Pin
Kornfeld Eliyahu Peter31-Oct-21 20:19
professionalKornfeld Eliyahu Peter31-Oct-21 20:19 
GeneralRe: Bless SQL Pin
Member 153296131-Nov-21 1:19
MemberMember 153296131-Nov-21 1:19 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 3:44
mvahoney the codewitch1-Nov-21 3:44 
GeneralRe: Bless SQL Pin
Mike Hankey1-Nov-21 3:14
professionalMike Hankey1-Nov-21 3:14 
GeneralRe: Bless SQL Pin
Gerry Schmitz1-Nov-21 7:12
mveGerry Schmitz1-Nov-21 7:12 
GeneralRe: Bless SQL Pin
honey the codewitch1-Nov-21 7:45
mvahoney the codewitch1-Nov-21 7:45 
GeneralRe: Bless SQL Pin
#realJSOP2-Nov-21 0:37
mva#realJSOP2-Nov-21 0:37 
GeneralRe: Bless SQL Pin
honey the codewitch2-Nov-21 6:59
mvahoney the codewitch2-Nov-21 6:59 
GeneralVS2022 confusion Pin
Super Lloyd31-Oct-21 14:52
MemberSuper Lloyd31-Oct-21 14:52 
GeneralRe: VS2022 confusion Pin
honey the codewitch31-Oct-21 14:53
mvahoney the codewitch31-Oct-21 14:53 
GeneralRe: VS2022 confusion Pin
Super Lloyd31-Oct-21 14:59
MemberSuper Lloyd31-Oct-21 14:59 
GeneralRe: VS2022 confusion Pin
BryanFazekas2-Nov-21 2:07
MemberBryanFazekas2-Nov-21 2:07 

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.

Straw Poll

How important is naming to you in your code?
There are 2 hard problems in Computer Science: caching, naming and off-by-one errors
  Results   67 votes