Why is the solution to housing always tiny dense condos!
Direct queries and ORM. A stored procedure doesn't provide much value as a unit of abstraction that couldn't just exist in the code.
If anything, it separates code from the data more as far as I can tell, so maybe I’m missing something?
Stored procedures are code -- so you're putting code in the database. How do you test that code? How do you source control that code? How do you roll back that code to the previous version or compare it to a previous version? How to know the history of that code? If that procedure is designed to work in together with application changes, how to test and deploy those together? This is all not impossible but it's certainly more difficult and creates more potential failure points.
Also, if something is somewhat data driven and there’s a bug, you simply alter a procedure versus doing a build and deploy of the entire application.
That's the problem. You write like that like it's an advantage but you're literally editing code live in production.
The performance advantages of stored procedures are unsupported. Most database engines do not treat stored procedures any differently than regular queries. And it's not that stored procedures aren't optimized, it's that queries are equally optimized.
Fortune 250 on down has used stored procedures with applications and it seems extremely clean and performance-oriented.
A lot of these companies also still use COBOL on mainframes (something I've actually worked on and don't recommend either). Stored procedures made a lot more sense historically when SQL might actually have more expressive power than your programming language and when database interfaces were much complicated and non-standard.
I use Windows 11 -- mildly modified -- StartAllBack for a proper start menu and taskbar experience. I have it pretty much exactly as I want it without any annoyances.
I'm perfectly comfortable with Linux but I feel the same as you about using it on the desktop for all the same reasons.
This my hot take: Do not use stored procedures with applications. Keep your data separate from your code.
CNN reported on it: https://www.cnn.com/2023/02/10/tech/twitter-top-advertiser-decline/index.html
Exceptions are fancy returns. Everything else is fancy goto, including returns...
Canada is not going to be able to create a whole semiconductor industry out of nothing. We should probably focus on obtainable goals.
They have hundreds of mobile developers and can't make a decent app or features anyone wants -- I'm going to guess that whatever executive pet project that one is won't ever see any reasonable output either.
You know that the Australian law doesn't even apply to smaller medias right? It's unsurprising that a law basically written by Rupert Murdoch would include requirements that media companies have to be a certain size in order to eligible.
If all that is needed to happen is that media companies withhold their content for Meta to capitulate then they could have done that. We don't need a law for that.
Ok. So Facebook doesn't care and the media companies don't care. I guess we'll see who blinks first.
People forget that there wasn't even a mass exodus from Digg. Although we can pinpoint the exact day that Digg killed itself, it actually took a long time for everyone to eventually leave. People hedged their bets between platforms -- just as many people are doing now between Reddit and all the new alternatives.
This week on Lemmy actually feels very different from last week. There's some sort of critical mass that has been hit even if it's just some minuscule tiny fraction of the total traffic of Reddit.
Reddit basically had a monopoly -- given how quickly things are moving on Lemmy and other sites -- I think that monopoly is over. It's still a bit too chaotic here for a major mass move but there's now so much more interesting content. People will eventually figure out how to make these sites competitive now that there is so much interest.
It's at that point that things will really change.
The problem is the government has been protecting/supporting one group for a long time to the point that everything is now "too big to fail". Government continue to create investment materials that can't fail -- and anything that can't fail will create a bubble and destroy everything else. That investment in Canada was housing. Now it's like over half our GDP is housing investment. And why invest in anything else? Nothing else is as risk free.
I feel like the collapse is never going to come.
The comment section is for Internet arguments!
The destruction of the web… As if the web was social medias
Social media is just as part of the web as anything. Trying to carve out some exception for Facebook because you don't like them is not a logical argument. What about Wikipedia? Reddit? Lemmy? Digg? Google?
Go check how much time people spend on each item on their feed on Facebook and how much time they spend on average on a web page vs just on Facebook every day and tell me again how Facebook is bringing traffic to traditional media!
Please provide the receipts, then.
If people have to pay for links, how is that going to provide more traffic to traditional media? Isn't that the whole point of links... to provide traffic.
Facebook thinks people will spend just as much time on Facebook without news links. This whole law is pointless. It's trying to create a market for "links" that doesn't exist. Again, if media companies don't want to provide summaries and images to Facebook they can do that. Instead, all the major news papers in Canada put tags specifically for Facebook to use with their content. They want those links. So makes it valuable to them, not the other way around.
If all you just want to take money from Facebook and give it Canadian media companies, why not just make a law that does that.
"Is Lemmy also morally responsible to pay media companies because there is a link to this article with a summary? " If it becomes profitable for the instance’s owner then yes.
You're arguing for the destruction of the web at this point. Freely linking to content is the backbone of the whole thing.
It doesn’t because without social media you would still need to check articles on their website instead of just scanning a summary and some pictures in 5 seconds.
You're basically saying that actual journalism itself has no value -- if a 2 line summary and single picture is the entire value to someone then why is anyone paying for this? An AI can make that for free. I could be a journalist if all the value is a summary and picture. You're making such a twisted argument with this whole idea that people just read the summary, never click the article, and somehow somebody needs to make money from the article that nobody reads. Media companies provide the summary and pictures to Facebook so that they'll click on the article in the first place.
So Meta would pay for the service media companies provide then, glad we agree, don’t know why you’re arguing then.
Media companies should pay Meta for the service they provide. It's literally advertising. Media companies post this material themselves. But if media companies are providing a service that's worth paying for then they should simply withhold that service until Meta pays. That's how the free market works. Tim Hortons doesn't give out free donuts and then go to the government and force you to pay for them if you take one. No, you just buy the damn donut if it's worth buying.
The government is forcing the arrangement, the companies decided to just pull out if they had to pay their fair share.
If Meta benefited from this arrangement they'd pay. Is Lemmy also morally responsible to pay media companies because there is a link to this article with a summary?
Media companies lost traffic because of social media but they bring traffic to social media.
Media companies lost traffic because the Internet invalidates their business model. Linking is the only thing they have left -- they should be thankful for it.
You realise you’re defending companies that together make trillions yet pay next to nothing in taxes in their own country (and pay nothing in Canada)?
Just because someone is an asshole doesn't mean they're entitled to less justice. If something is wrong, it's wrong for everyone.