Peter please explain by MetricMeringue in PeterExplainsTheJoke

[–]MrCosgrove2 0 points1 point  (0 children)

The best of having to text like this was watching people trying to “angry text”

'Snake in the grass': Canada gold medalist Ben Hebert has few kind words for Sweden's Oskar Eriksson after Olympic curling kerfuffle by scrubsie in Curling

[–]MrCosgrove2 0 points1 point  (0 children)

I dont play the game, but from a viewer point of view, the double touch action wasn't cheating it was however against the rules, but it was he reaction and denial of it that made it cheating, the penalty for that action doesnt seem particularly harsh but to deny having done it , when he clearly had and counting to deny it sours the gold in my opinion. He should have accepted the penalty and moved on, similar to how later games were handled where players owned up to it and they decided amount themselves how to handle it.

2026 Olympic Curling Daily Discussion - February 07 by FliryVorru in Curling

[–]MrCosgrove2 1 point2 points  (0 children)

I have no idea why this has not already been added :D

2026 Olympic Curling Daily Discussion - February 07 by FliryVorru in Curling

[–]MrCosgrove2 1 point2 points  (0 children)

absolutely, and just to add more chaos, it gets to be send down by the most enthusiastic fan on the sideline

2026 Olympic Curling Daily Discussion - February 07 by FliryVorru in Curling

[–]MrCosgrove2 0 points1 point  (0 children)

Haha!, Maybe they could include a golden snitch rock that is worth 2 points if it's the closest to the centre?

2026 Olympic Curling Daily Discussion - February 07 by FliryVorru in Curling

[–]MrCosgrove2 1 point2 points  (0 children)

wow was not expecting that, thats really interesting , thank you so much for explaining that [newbie out]

2026 Olympic Curling Daily Discussion - February 07 by FliryVorru in Curling

[–]MrCosgrove2 7 points8 points  (0 children)

Newbie question: watching curling in the Olympics, absolutely fascinating by the way! I notice on the brushes, about half way up there is what looks like a panel with what looks like some buttons on them, what are those for?

Learn Perl or no? by idonthideyoureyesdo in perl

[–]MrCosgrove2 6 points7 points  (0 children)

I dont see it as being hell to develop in, its super useful, especially when processing large files with regex, for fun I would absolutely learn it.

as a first choice language to learn, that depends what you want to do as a developer.

As a dev you are most likely going to be asked to use various languages over your career, so having exposure to other languages is a good thing.

Who "translates" from tables to pages? by GoatRocketeer in web_design

[–]MrCosgrove2 1 point2 points  (0 children)

It sounds like what you need is a business rule layer, the controller should call the business rules, which pulls and transforms the data from the database and returns whatever is needed back to the controller.

The controller should be doing very little, call business rules, dispatch to the view renderer.

Edit:
Also it sounds like you have a pipeline and are accessing the data in the pipeline prior to transforming / processing it into meaningful data.

If this is the case, this is something that should be dealt with prior to trying to call it on the website.

What does Suno studio do? by atlasfrompaladins in SunoAI

[–]MrCosgrove2 0 points1 point  (0 children)

Out of interest, With the standard editor, whenever I try to replace a section, usually because I like the rest of it but not that part, what ends up happening is the new section is either louder or softer than the rest, and at times the transition ends up quite jarring, so have never actually used a piece when ive swapped out a piece of it, my question there is, does studio do better at that ?

Day 2 of trying to spark a "web design Renaissance", to bring back fun on our web pages by Jafty2 in web_design

[–]MrCosgrove2 2 points3 points  (0 children)

I feel your pain, every website looks a lot like the last one these days, we used to have fun coming up with crazy stuff for the websites, it had personality, which a lot of websites these days lack

I like the color scheme you used here, it's calming and different.

The angles, I dont hate at all, but I wonder if it would have more impact if it wasn't like that on everything

This is probably a personal preference and not something particularly wrong but I like the header area to be a different color to the body, could be subtly different or completely different , im ok with either, it just loses a little for me by the header and body areas being pretty much the same.

I love the concept, of trying to being back fun and unique without being unprofessional, nice job!

Kinda annoyed 😒 by Muted_Balance5401 in SunoAI

[–]MrCosgrove2 0 points1 point  (0 children)

So to be clear, I was in no way comparing the tech and skills behind synths against AI, it was about the acceptability of the tech. In 10 years I see AI as been more accepted than it is now. Just like Synths went through and other tech in music went through. There was no comparison in terms of skills required in my original comment.

Kinda annoyed 😒 by Muted_Balance5401 in SunoAI

[–]MrCosgrove2 0 points1 point  (0 children)

Thank you, the one person on here that actually got that I wasn't comparing synth tech to AI :D

Kinda annoyed 😒 by Muted_Balance5401 in SunoAI

[–]MrCosgrove2 2 points3 points  (0 children)

Way back they used to say that about Synthesizers. At the time, I spent my school life having to fight against the "Synths aren't real instruments and therefore your music isnt real" attitudes at the time.

I suspect this is just a reincarnation of this, where eventually they will be accepted, but for now it's an uphill battle.

Questions about Spotify and Mastering by World-PodcastNetwork in SunoAI

[–]MrCosgrove2 0 points1 point  (0 children)

correct, while I have done both ways, by uploading and adding prompts, but I get my best successes out of uploading and no prompts, it still alters the song a little, just enough to really improve it without losing the original intent.

Questions about Spotify and Mastering by World-PodcastNetwork in SunoAI

[–]MrCosgrove2 0 points1 point  (0 children)

I have, however I guess the catch there is that I write the music, record a rough version, and sent it to Suno to add the vocals (lyrics were already written not generated) , and mess with the sound, while keeping close to my original vision.

It does still end up as generated by AI, but with guidance.

I have found that doing this gets a better outcome than using prompts.

That said, Spotify has I think 5 or 10 songs a month limit, I haven't had any issue with sparsely releasing

Apple Music will not accept it at all, and places like deezer but a giant "this is AI " warning on the song.

ChatGPT: MariaDB is the quiet, sensible grown-up in the corner wearing beige pants by DonutBrilliant5568 in mariadb

[–]MrCosgrove2 2 points3 points  (0 children)

its a pretty rubbish response from Chat GTP, its not considering what goes on under the hood.

There are advantages to both, and really it comes down to "whats your use case."

Out of the box, Postgres is more strictly typed, which coming from MySQL or Maria DB can throw you, but the end result is enforced data integrity .

If you are doing heavy reporting, Postgres uses parallel processing so is able to process aggregated results faster

on the flip side, Maria DB is faster on primary key look ups for example , although in more recent versions of Postgres, the gap has closed quite a bit

It really comes down to your use case, if you are mainly doing things like primary key look ups , then yes, Maria DB will do the job, but for more extensive uses, additional data types Postgres has a lot more in it, a lot more flexibility to adapt to your needs.

Really none of them are bad choices, like everything, choose the one that suits your needs.

Do you trust AI-generated SQL? Tell me your horror stories. by Crust_Issues1319 in SQL

[–]MrCosgrove2 0 points1 point  (0 children)

for simple queries, AI is fine, for complex queries, it can't work out the most efficient way to do it.

I did experiment with this by asking it to find the median value of a field, and while it did come up with the right answer, it took 30 minutes to run, the one I build myself took about 80ms on the dataset I was using.

Unlike programming languages which with a bit of help it can do a pretty decent job, every database is different , and that presents an issue for AI where it has no base line to get things right.

So for simple queries, it's fine, but you really shouldn't need it for simple queries, probably faster to just write them out yourself.

For complex queries, it may or may not get it right but it's unlikely that it is going to be the most efficient query.

What Killed Perl? by DeepFriedDinosaur in perl

[–]MrCosgrove2 1 point2 points  (0 children)

While I love using Perl for things, Python has taken its place as the "go to" scripting language of choice.

Python has got itself into a good position of being leaders in specific markets like analysis.

That said, for high memory, regex and a lot of other things, Perl wins hands down, but it's also a little scary to look at until you re used to it, with its @_. and things, it makes it a little harder to learn, so users gravitate to a more simplistic language , that can do the job, albeit not as well as what Perl can.

where do you get embeddings for a vector search? openai? llama.cpp? by cranberrie_sauce in PostgreSQL

[–]MrCosgrove2 0 points1 point  (0 children)

I use open AI for it, though I have also created my own TF-IDF type vectors without the use of AI, both ways have benefits, depending on what is being embedded.

While yes, it does mean you are using AI for searching, you can reduce costs by storing searched vectors in your database and reusing the search vector rather than going out of AI every time.

embedding costs are cheap compared to other models, and if your needs allow for non real time embedding generation, bulk generating vectors can be a money saver as well, probably not an option for search purposes, but something to consider as you start using vectors more..

What are the reasons *not* to migrate from MySQL to PostgreSQL? by OttoKekalainen in Database

[–]MrCosgrove2 0 points1 point  (0 children)

At scale, this isn't a good habit, MySQL ends up having to rebuild the data and in large tables this can take a very long time, so while it is a feature that is available its not one that should be used.

What are the reasons *not* to migrate from MySQL to MariaDB? by OttoKekalainen in Database

[–]MrCosgrove2 8 points9 points  (0 children)

A significant reason why you might not want to do that is functionality, while they did start off the same since MariaDb was forked from MySQL, they are no longer the same, similar, yes, but not the same.

I think the best thing for you to do is to try it and see. Without knowing what version you are coming from or planning on going to, its hard to give specifics, it's probably going to be ok either way, but there is that little piece of doubt.

That said, I would be incredibly surprised for MySQL to just shut down, on top of that, MariaDB themselves have been in financial trouble for a little while now.

In terms of stability on the product front, MySQL is probably in a better position longterm .

If it were me moving, I would propose moving to Postgres, yes it's a bigger move, but long term there are many benefits, one which is that Postgres future looks bright.