|
Dijkstracula posted:yes and all the components can be of different types (except for another quaterinon) ah so we can alternately nest list, quaternion, list, quaternion
|
# ? Dec 3, 2022 03:53 |
|
|
# ? Apr 26, 2024 21:02 |
|
cinci zoo sniper posted:… did it have quaternion data type it has to because it works by dragging solid object vertices around and you can script motion and stuff
|
# ? Dec 3, 2022 03:55 |
|
Dijkstracula posted:yes and all the components can be of different types (except for another quaterinon) i fully believed you until i went back and checked the wiki lol
|
# ? Dec 3, 2022 04:16 |
|
abraham linksys posted:i fully believed you until i went back and checked the wiki lol
|
# ? Dec 3, 2022 04:21 |
|
abraham linksys posted:i have a friend who still plays second life in 2022 (apparently it's like the metaverse but with less brands but somehow more capitalism) and it has its own scripting language called LSL and you can probably guess how a scripting language second life added in 2004 went. via https://wiki.secondlife.com/wiki/Category:LSL_List#Comparing_Lists: this would be a good reason to have a transpiler
|
# ? Dec 3, 2022 04:31 |
Dijkstracula posted:yes and all the components can be of different types (except for another quaterinon) really not enjoying getting this right away
|
|
# ? Dec 3, 2022 04:44 |
|
Powerful Two-Hander posted:oh my god somewhere there is a ticket with our useless tooling team to provide a copy of the Poor Man's SQL Formatter after they took away our ability to install whatever we liked on our machines (those were the days!) it drives me loving insane that the sql server data tools team will do nothing at all to improve sql server data tools. SSMS is still on like vs 2012 or something and is still mostly 32bit and most of the stuff cant handle theming. plugin support is rear end. They have no plans to ever add any kind of version control to sql server like they should. its just poo poo. And their excuse is we should use sql projects in VS (also part of SSDT) and that poo poo sucks so much loving rear end and will completely choke on anything more than a dozen objects in your schema. but even w/ poor mans sql formatter it cant format things the way i like which is SQL code:
|
# ? Dec 3, 2022 04:58 |
|
it's because they prefer to put their limited resources into adding useless features that no one cares about into sql server itself. graph storage and processing? embedding python and the jvm? s3 storage? no one gives a poo poo except for some marketing dweeb the most shocking thing about sql server 2022 is that they actually invested in both the language and the query processor
|
# ? Dec 3, 2022 11:49 |
|
a million years ago, some of the real sql server greybeards compiled a list of a bunch of bugs with the merge statement. i would bet money that most of them are still outstanding, like a decade later
|
# ? Dec 3, 2022 11:51 |
|
Shaggar posted:it drives me loving insane that the sql server data tools team will do nothing at all to improve sql server data tools. Try dbeaver. Not as good as ssms for script debugging and database maintenance, but wayyyy better for data querying, editing, and ETL. I use both but dbeaver is the one I go for 95% of the time.
|
# ? Dec 3, 2022 11:59 |
|
Shaggar posted:it drives me loving insane that the sql server data tools team will do nothing at all to improve sql server data tools. SSMS is still on like vs 2012 or something and is still mostly 32bit and most of the stuff cant handle theming. plugin support is rear end. They have no plans to ever add any kind of version control to sql server like they should. its just poo poo. this is my SQL style as well I swear some people think that a high vertical query size is somehow bad and seem committed to massive run on horizontal statements also completely agree on vs sql projects being poo poo. Last time I tried one it was so slow to do anything I just gave up, though that was probably vs 2016 e: I would newline and indent the where and else conditionals though
|
# ? Dec 3, 2022 12:01 |
|
https://github.com/Joshua-Ashton/riscv-vscript
|
# ? Dec 3, 2022 12:58 |
|
tef!
|
# ? Dec 3, 2022 17:50 |
|
According to Luke from Floatplane, OpenAI just releases their GPT3 beta, and it’s impressive. Ask anything in text form, being aware the training set is 2 years old. Writing stories about anything, writing short programs, finding and fixing security bugs, recipes, mending things, etc. https://chat.openai.com/ Sign up and go back to this chat URL for thread mode, in this mode you can ask more questions and refine the answers until you “reset thread” via the menu. Also, it has content filters but they are apparently easy to bypass. If you find something it doesn’t know you can train it in a thread and it can then answer. quote:Write a program to render “420” with THREE.js quote:Have the scene slowly rotate on the z-axis Also, it apparently does rather well at Advent of Code. MrMoo fucked around with this message at 14:21 on Dec 4, 2022 |
# ? Dec 4, 2022 13:30 |
|
The d3p1 record was 10s thanks to it
|
# ? Dec 4, 2022 14:40 |
the science has gone too far
|
|
# ? Dec 4, 2022 16:14 |
|
there's clearly room for improvement if that's the worst this model can do
|
# ? Dec 4, 2022 16:37 |
|
cinci zoo sniper posted:the science has gone too far that is not even close to the worst lmao e: I'm 100% gonna try this for solving stupid problems
|
# ? Dec 4, 2022 17:18 |
Deep Dish Fuckfest posted:there's clearly room for improvement if that's the worst this model can do Powerful Two-Hander posted:that is not even close to the worst lmao i really tried to get it to self-reference a cross join product or some other cursed poo poo, but it either does gorillion parentheses or writes giant WHERE clauses using only OR. rarer it'll do stuff like WHERE 'John Doe' = name, but overall i think it simply doesn't have that much SQL to draw inspiration from
|
|
# ? Dec 4, 2022 17:49 |
|
cinci zoo sniper posted:i really tried to get it to self-reference a cross join product or some other cursed poo poo, but it either does gorillion parentheses or writes giant WHERE clauses using only OR. rarer it'll do stuff like WHERE 'John Doe' = name, but overall i think it simply doesn't have that much SQL to draw inspiration from is there a way I can upload some absolute poo poo to it to ruin things for future generations?
|
# ? Dec 4, 2022 18:29 |
|
try giving it a specific dialect of sql so it can make horrors that are db platform specific
|
# ? Dec 4, 2022 18:30 |
|
i asked it to write me a bad fizzbuzz and it gave me a normal one and said it wasn't good because it didn't check for 3 and 5 (it did) and that it only went up to 100. then i asked it to write me a good fizzbuzz and it gave me the same code and said it was good because it checked for 3 and 5 and went up to 100.
|
# ? Dec 4, 2022 18:32 |
|
lol i also asked it a question from my daughter's 4th grade math homework and, well common core math
|
# ? Dec 4, 2022 18:36 |
Corla Plankun posted:try giving it a specific dialect of sql so it can make horrors that are db platform specific
|
|
# ? Dec 4, 2022 18:50 |
|
at least add a trigger warning before posting this kind of thing, jfc
|
# ? Dec 4, 2022 18:54 |
|
Sagacity posted:at least add a trigger warning before posting this kind of thing, jfc oh good point, adding some triggers would make this query even gnarlier
|
# ? Dec 4, 2022 18:57 |
|
yeah ask it to write "the worst t-sql trigger possible", let's see if we can reach the apex of "triggers exist primarily to gently caress yourself up in future"
|
# ? Dec 4, 2022 19:16 |
|
triggers are litterrally code landmines
|
# ? Dec 4, 2022 19:22 |
|
sounds about right. deploy them strategically and you can prevent any other programmer from setting foot on your turf or dislodge you from your position
|
# ? Dec 4, 2022 19:40 |
mother of god
|
|
# ? Dec 4, 2022 19:49 |
|
lmao
|
# ? Dec 4, 2022 19:51 |
|
cinci zoo sniper posted:mother of god
|
# ? Dec 4, 2022 19:54 |
|
i'm less concerned about chatgpt putting programmers out of jobs than i am for comedy writers
|
# ? Dec 4, 2022 19:59 |
|
cinci zoo sniper posted:mother of god loving lmao it's perfect
|
# ? Dec 4, 2022 20:32 |
Powerful Two-Hander posted:loving lmao it's perfect yeah ikr, you genuinely cannot write a worse trigger other than like something that’s going to randomly increments arbitrary subset of integer records by 1 on upsert
|
|
# ? Dec 4, 2022 20:41 |
|
Don't forget to add a comment at the top with a date ten years ago and the initials of someone who has never worked at the company
|
# ? Dec 4, 2022 20:46 |
|
My worst trigger would just silently change random data sometimes instead of being this noisy.
|
# ? Dec 4, 2022 20:59 |
|
cinci zoo sniper posted:mother of god This right here is the first time I've been absolutely floored by any of these AI systems.
|
# ? Dec 4, 2022 21:31 |
|
1. it's assuming you only want to return a single column when that wasn't specified in the prompt 2. it's assuming the column is definitely an integer even though it doesn't have a schema definition nor was one specified in the prompt 3. it's assuming the query should not be hard-coded when that has no bearing on how good the script is. if the script reused the same value in multiple places then assigning it first to a variable would be better but if it's only used in one place it probably doesn't matter. given that it's a script and not a procedure or a function how would you even change the value without changing the script? 4. the example table name is a reserved word 5. the example table name is missing the schema prefix. while this will execute if the table exists in the default schema, it could be incorrect and performs very very very slightly less well than specifying the schema even if default.
|
# ? Dec 4, 2022 21:55 |
|
|
# ? Apr 26, 2024 21:02 |
|
Antigravitas posted:My worst trigger would just silently change random data sometimes instead of being this noisy. also yeah this is way worse and closer to poo poo i've seen in real life lol. nuking the table would be incredibly obvious and would also fail if there were any foreign keys referencing it and cascading deletes were turned off.
|
# ? Dec 4, 2022 21:56 |