|
Yeah, still wondering if anyone has had success with web dev.
|
|
|
|
|
How about a web-based, IBM PC emulator with an EARLY Norton Utilities release (back when it was good!).
Be sure to check out what's on drives C: and D:. Very interesting.
Norton Utilities 2.00 | PCjs Machines[^]
|
|
|
|
|
|
I want to step back in time to the days when:
- I thought politicians were honest
- I thought the Government knew what it was doing
But I don't think my parents would want me.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
It would be no different. Because you thought politicians were honest and you thought the Government knew what it was doing.
|
|
|
|
|
But then I was young and innocent and had all of my life before me. Now I'm not so young, definitely not innocent, and most of my life is behind me.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Wordle 700 4/6
🟨🟩🟩⬛⬛
⬛🟩🟩⬛🟨
⬛🟩🟩🟩⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 700 6/6
🟨⬜⬜⬜⬜
⬜🟨🟨⬜⬜
🟨⬜🟩🟨⬜
⬜🟩🟩🟩⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 700 4/6
⬛⬛🟩⬛⬛
🟨⬛🟩⬛⬛
🟩🟩🟩🟩⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 700 4/6*
🟨⬜⬜🟩⬜
⬜🟩🟩🟩⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
⬜⬜🟩⬜⬜
⬜⬜🟩⬜🟨
🟨⬜🟩⬜🟨
⬜🟩🟩🟩⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 700 5/6
🟨🟩⬛⬛⬛
⬛🟩🟩🟩⬛
⬛🟩🟩🟩⬛
⬛🟩🟩🟩⬛
🟩🟩🟩🟩🟩
Ok, I have had my coffee, so you can all come out now!
|
|
|
|
|
Wordle 700 4/6
⬜⬜⬜🟩⬜
⬜⬜🟩🟩⬜
⬜🟩🟩🟩⬜
🟩🟩🟩🟩🟩
crept up on it
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
SQL is the simply best language... for those situations it's suited for.
But when a situation requires another technique, SQL is simply the worst language.
Yup, I'm gonna have to use C# for this in hopes that it can handle this transform more betterishly.
|
|
|
|
|
Indeed. I wrote a project here called Reggie that generates matching code for TEXT and NTEXT data such that you can use regular expressions with your database inputs.
The generated code is awful in terms of what it has to make SQL do. Encoding ASCII or 16-bit Unicode into UTF-32 to work with the generated regex engine - plus just the nastiness of returning results (as rowsets of course). It's not navigable code - at least not for mortals.
To err is human. Fortune favors the monsters.
|
|
|
|
|
I wrote CLR functions for doing security several different things including Regular Expressions.
Never try to do string manipulation in SQL.
modified 20-May-23 10:00am.
|
|
|
|
|
I did it to demonstrate an extreme use case for a templated based regex code generator I wrote.
It wasn't really meant to be practical, but illustrative, in that if you could make it generate SQL code, you could make it generate just about anything.
To err is human. Fortune favors the monsters.
|
|
|
|
|
honey the codewitch wrote: I did it Why does it not surprise me?
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
honey the codewitch wrote: It wasn't really meant to be practical, but illustrative, in that if you could make it generate SQL code, you could make it generate just about anything.
Ah, can it generate TECO?
|
|
|
|
|
What is TECO?
To err is human. Fortune favors the monsters.
|
|
|
|
|
I've noticed that many people and/or companies think that SQL is somehow easier than programming.
I've even worked for a company where you were automatically a "SQL consultant" if you didn't know how to code.
Recently, I picked up a project for a company with 10K(!) procedures mostly written by a guy who didn't know how optional parameters work.
The result is that I've found plenty of simple front-ends with "SQL back-ends".
Basically a simple web app that just executes stored procedures on GET and POST requests.
The stored procedures are usually written by "IT professionals", "consultants" and managers.
The problem with working like this, SSMS is not an easy tool that formats your code (format is always terrible!), where you can search and debug or where you easily implement DevOps practices.
Completely unmaintainble.
|
|
|
|
|
Ah, yes, the "everything must be in a procedure" crew.
Also watch out for the "only DBAs can write SQL" crew.
|
|
|
|
|
PIEBALDconsult wrote: Also watch out for the "only DBAs can write SQL" crew.
Well in my experience it tends to lean way in the other direction. Without someone with some database experience they will not even attempt anything in the database except simple CRUD. Which of course ends up producing some really inefficient code.
|
|
|
|
|
jschell wrote: CRUD
PTUI. Don't even use that term around me. No one with proper database skills thinks in such limited terms.
My best experiences were where I would write the SQL and a DBA would point out improvements which could be made.
|
|
|
|
|
Sander Rossel wrote: companies think that SQL is somehow easier than programming
Well 'technically' that is true.
For the most part, especially the way companies use it the vast majority of time ANSI SQL is not that difficult.
However PL/SQL, TSQL, etc are not in fact ANSI SQL.
Nor for that matter is database design, optimization, etc.
Sander Rossel wrote: The problem with working like this,
Not sure where you are going with this.
Bad code is just back code. Bad designs are just bad designs.
The language is not the problem for either of those.
And ignorance of those problems certainly is not the fault of the language.
Sander Rossel wrote: Basically a simple web app that just executes stored procedures on GET and POST requests....The stored procedures are usually written by "IT professionals", "consultants" and managers.
But for most businesses, most of the code should in fact be simple. It should not require much more than that. It is pointless that everyone be a database DBA because there is generally no need for the expertise all of the time. So there will be some stored procs because that is all that is actually needed.
|
|
|
|